Information Structure
| 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. |