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