Column Summary | ||||||
---|---|---|---|---|---|---|
Name | SqlType | Length | Precision | Scale | Nullable | Unique |
SAMPLING_EQUIPMENT_ID | integer | 255 | 19 | 2 | false | false |
SAMPLING_EQUIPMENT_NM | VARCHAR(100) | 255 | 19 | 2 | false | false |
SAMPLING_EQUIPMENT_DC | VARCHAR(255) | 255 | 19 | 2 | true | false |
SAMPLING_EQUIPMENT_SIZE | DECIMAL(38,7) | 255 | 19 | 2 | true | false |
UPDATE_DT | TIMESTAMP | 255 | 19 | 2 | true | false |
STATUS_CD | VARCHAR(40) | 255 | 19 | 2 | false | false |
UNIT_ID | integer | 255 | 19 | 2 | true | false |
Primary Key | |
---|---|
Name | Columns |
SAMPLING_EQUIPK | SAMPLING_EQUIPMENT_ID |
Foreign Keys | ||
---|---|---|
Name | Referenced Table | Columns |
SAMPLING_EQUIPMENT_STATUS_CDC | STATUS | STATUS_CD |
SAMPLING_EQUIPMENT_UNIT_IDC | UNIT | UNIT_ID |
Column Detail