Schema PUBLIC

Table INITIAL_POPULATION

Column Summary
Name SqlType Length Precision Scale Nullable Unique
INIT_POP_ID integer 255 19 2 false false
INIT_POP_NM VARCHAR(100) 255 19 2 false false
INIT_POP_LB VARCHAR(50) 255 19 2 false false
INIT_POP_CM VARCHAR(2000) 255 19 2 true false
INIT_POP_QUALIF_DT TIMESTAMP 255 19 2 true false
INIT_POP_QUALIF_CM VARCHAR(2000) 255 19 2 true false
INIT_POP_VALID_DT TIMESTAMP 255 19 2 true false
INIT_POP_CONTROL_DT TIMESTAMP 255 19 2 true false
INIT_POP_START_DT TIMESTAMP 255 19 2 false false
INIT_POP_BIOMETRIC_INDIV_NB INTEGER 255 19 2 false false
UPDATE_DT TIMESTAMP 255 19 2 true false
REMOTE_ID integer 255 19 2 true false
PLOIDY_ID integer 255 19 2 true false
QUAL_FLAG_CD VARCHAR(40) 255 19 2 false false
REF_TAXON_ID integer 255 19 2 false false
AGE_GROUP_CD VARCHAR(40) 255 19 2 false false
Primary Key
Name Columns
INITIAL_POPULPK INIT_POP_ID
Foreign Keys
Name Referenced Table Columns
INITIAL_POPULATION_PLOIDY_IDC PLOIDY PLOIDY_ID
INITIAL_POPULATION_QUAL_FLAG_C QUALITY_FLAG QUAL_FLAG_CD
INITIAL_POPULATION_REF_TAXON_C REFERENCE_TAXON REF_TAXON_ID
INITIAL_POPULATION_AGE_GROUP_C AGE_GROUP AGE_GROUP_CD

Column Detail

INIT_POP_ID

INIT_POP_NM

INIT_POP_LB

INIT_POP_CM

INIT_POP_QUALIF_DT

INIT_POP_QUALIF_CM

INIT_POP_VALID_DT

INIT_POP_CONTROL_DT

INIT_POP_START_DT

INIT_POP_BIOMETRIC_INDIV_NB

UPDATE_DT

REMOTE_ID

PLOIDY_ID

QUAL_FLAG_CD

REF_TAXON_ID

AGE_GROUP_CD