Information Structure

The following information is provided about database tables. Items appear only when relevant to the database column, and are suppressed where they do not apply. Two of these items (shown bold) are columns in the following pages, and the remainder are displayed within the Details.
Item Comment
Database Column

The name of the column in the SQL table.

Type

The data type of the contents of the database column.

Size

For types that have a maximum capacity, the upper limit is provided in parentheses.

Key

The word “Key” appears when a column is a unique key field within the table. It is possible for several database columns to be part of the key, so that this indicator may appear for several columns in a table.

Generated ID

This indicates that a numeric ID is assigned by the database.

Nullable

If this indicator is present, the database column permits nulls.

Computed

This indicator appears for columns that are automatically computed by the database.

Default

If a column has a default value declared in the schema, this is specified at the end of the first set of details for the column.

Details

Describes the data stored in the database column, including many of the indicators described above.