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