Schema PUBLIC

Table SAMPLING_EQUIPMENT

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
SAMPLING_EQUIPMENT_CM VARCHAR(2000) 255 19 2 true false
CREATION_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

SAMPLING_EQUIPMENT_ID

SAMPLING_EQUIPMENT_NM

SAMPLING_EQUIPMENT_DC

SAMPLING_EQUIPMENT_SIZE

UPDATE_DT

SAMPLING_EQUIPMENT_CM

CREATION_DT

STATUS_CD

UNIT_ID