| Column Summary | ||||||
|---|---|---|---|---|---|---|
| Name | SqlType | Length | Precision | Scale | Nullable | Unique |
| HIST_ACCOUNT_ID | NUMBER(18) | 255 | 19 | 2 | false | false |
| HIST_ACCOUNT_START_DT | DATE | 255 | 19 | 2 | false | false |
| HIST_ACCOUNT_END_DT | DATE | 255 | 19 | 2 | false | false |
| HIST_ACCOUNT_CM | VARCHAR2(2000) | 255 | 19 | 2 | true | false |
| UPDATE_DT | TIMESTAMP | 255 | 19 | 2 | false | false |
| BREEDING_PHASE_TYPE_CD | VARCHAR2(40) | 255 | 19 | 2 | false | false |
| DEP_ID | NUMBER(18) | 255 | 19 | 2 | true | false |
| INIT_POP_ID | NUMBER(18) | 255 | 19 | 2 | false | false |
| PROD_SECTOR_ID | NUMBER(18) | 255 | 19 | 2 | true | false |
| BREEDING_STRUCT_CD | VARCHAR2(40) | 255 | 19 | 2 | false | false |
| MON_LOC_ID | NUMBER(18) | 255 | 19 | 2 | true | false |
| BREEDING_SYSTEM_CD | VARCHAR2(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