Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
Primary id for this table. This uniquely identifies the row. |
|||||||
| unit_name | VARCHAR | 255 |
|
|
The name of the unit. This should be the name of the unit in full. |
|||||||||
| unit_abbreviation | CHAR | 10 | √ | null |
|
|
This should be the unit abbreviation. |
|||||||
| unit_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
A description of the unit. If the unit is not a standard SI unit then it is beneficial to have a description which explains what the unit it, how it is derived and any other information which would help identifiy it. |
|||||||
| created_on | DATETIME | 26 | √ | CURRENT_TIMESTAMP |
|
|
When the record was created. |
|||||||
| updated_on | TIMESTAMP | 26 | √ | CURRENT_TIMESTAMP |
|
|
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |