Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| compound_id | INT | 10 | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
||
| compound_name | VARCHAR | 255 | null |
|
|
Compound full name. |
||
| compound_description | VARCHAR | 255 | √ | null |
|
|
Full description of the compound. This should contain enough infomation to accurately identify the compound and how it was recorded. |
|
| unit_id | INT | 10 | √ | 0 |
|
|
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_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. |
|
| unit_abbreviation | CHAR | 10 | √ | null |
|
|
This should be the unit abbreviation. |
|
| synonyms | JSON | 1073741824 | √ | null |
|
|
The synonyms as a json array. |
|
| count | BIGINT | 19 | √ | null |
|
|