Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IDENTIFIER | BIGINT | 19 | null |
|
|
|||||||||||||||
SITE_ID | BIGINT | 19 | √ | null |
|
|
||||||||||||||
TEMPERATURE | DOUBLE | 22 | √ | null |
|
|
||||||||||||||
STORAGE_TYPE_ID | BIGINT | 19 | √ | null |
|
|
||||||||||||||
ONE_DIMENSION_LABELLING_SCHEME | VARCHAR | 50 | √ | Numbers |
|
|
||||||||||||||
TWO_DIMENSION_LABELLING_SCHEME | VARCHAR | 50 | √ | Numbers |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | IDENTIFIER |
FK28429D01A7F77D13 | Performance | Asc | SITE_ID |