Schema PUBLIC

Table HISTORICAL_ACCOUNT

Column Summary
Name SqlType Length Precision Scale Nullable Unique
HIST_ACCOUNT_ID integer 255 19 2 false false
HIST_ACCOUNT_START_DT TIMESTAMP 255 19 2 false false
HIST_ACCOUNT_END_DT TIMESTAMP 255 19 2 false false
HIST_ACCOUNT_CM VARCHAR(2000) 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
REMOTE_ID integer 255 19 2 true false
BREEDING_PHASE_TYPE_CD VARCHAR(40) 255 19 2 false false
DEP_ID integer 255 19 2 true false
INIT_POP_ID integer 255 19 2 false false
PROD_SECTOR_ID integer 255 19 2 true false
BREEDING_STRUCT_CD VARCHAR(40) 255 19 2 false false
MON_LOC_ID integer 255 19 2 true false
BREEDING_SYSTEM_CD VARCHAR(40) 255 19 2 false false
Primary Key
Name Columns
HISTORICAL_ACPK HIST_ACCOUNT_ID
Foreign Keys
Name Referenced Table Columns
HISTORICAL_ACCOUNT_BREEDING_PC BREEDING_PHASE_TYPE BREEDING_PHASE_TYPE_CD
HISTORICAL_ACCOUNT_DEP_IDC DEPARTMENT DEP_ID
HISTORICAL_ACCOUNT_INIT_POP_IC INITIAL_POPULATION INIT_POP_ID
HISTORICAL_ACCOUNT_PROD_SECTOC PRODUCTION_SECTOR PROD_SECTOR_ID
HISTORICAL_ACCOUNT_BREEDING_SC BREEDING_STRUCTURE BREEDING_STRUCT_CD
HISTORICAL_ACCOUNT_MON_LOC_IDC MONITORING_LOCATION MON_LOC_ID
HISTORICAL_ACCOUNT_BREEDING_S_ BREEDING_SYSTEM BREEDING_SYSTEM_CD

Column Detail

HIST_ACCOUNT_ID

HIST_ACCOUNT_START_DT

HIST_ACCOUNT_END_DT

HIST_ACCOUNT_CM

UPDATE_DT

REMOTE_ID

BREEDING_PHASE_TYPE_CD

DEP_ID

INIT_POP_ID

PROD_SECTOR_ID

BREEDING_STRUCT_CD

MON_LOC_ID

BREEDING_SYSTEM_CD