Schema PUBLIC

Table BATCH

Column Summary
Name SqlType Length Precision Scale Nullable Unique
BATCH_ID integer 255 19 2 false false
BATCH_NM VARCHAR(100) 255 19 2 false false
BATCH_LB VARCHAR(50) 255 19 2 false false
BATCH_EXPER_COND VARCHAR(2000) 255 19 2 true false
BATCH_BREEDING_STRUCTUR_UNIT integer 255 19 2 true false
BATCH_BREEDING_SYSTEM_UNIT integer 255 19 2 true false
BATCH_CM VARCHAR(2000) 255 19 2 true false
BATCH_CONTROL_DT TIMESTAMP 255 19 2 true false
BATCH_VALID_DT TIMESTAMP 255 19 2 true false
BATCH_QUALIF_DT TIMESTAMP 255 19 2 true false
BATCH_QUALIF_CM VARCHAR(2000) 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
REMOTE_ID integer 255 19 2 true false
MON_LOC_ID integer 255 19 2 false false
BREEDING_SYSTEM_CD VARCHAR(40) 255 19 2 false false
BREEDING_STRUCT_CD VARCHAR(40) 255 19 2 false false
DEPTH_LEVEL_ID integer 255 19 2 true false
INIT_POP_ID integer 255 19 2 false false
QUAL_FLAG_CD VARCHAR(40) 255 19 2 false false
Primary Key
Name Columns
BATCHPK BATCH_ID
Foreign Keys
Name Referenced Table Columns
BATCH_MON_LOC_IDC MONITORING_LOCATION MON_LOC_ID
BATCH_BREEDING_SYSTEM_CDC BREEDING_SYSTEM BREEDING_SYSTEM_CD
BATCH_BREEDING_STRUCT_CDC BREEDING_STRUCTURE BREEDING_STRUCT_CD
BATCH_DEPTH_LEVEL_IDC DEPTH_LEVEL DEPTH_LEVEL_ID
BATCH_INIT_POP_IDC INITIAL_POPULATION INIT_POP_ID
BATCH_QUAL_FLAG_CDC QUALITY_FLAG QUAL_FLAG_CD

Column Detail

BATCH_ID

BATCH_NM

BATCH_LB

BATCH_EXPER_COND

BATCH_BREEDING_STRUCTUR_UNIT

BATCH_BREEDING_SYSTEM_UNIT

BATCH_CM

BATCH_CONTROL_DT

BATCH_VALID_DT

BATCH_QUALIF_DT

BATCH_QUALIF_CM

UPDATE_DT

REMOTE_ID

MON_LOC_ID

BREEDING_SYSTEM_CD

BREEDING_STRUCT_CD

DEPTH_LEVEL_ID

INIT_POP_ID

QUAL_FLAG_CD