| Column Summary | ||||||
|---|---|---|---|---|---|---|
| Name | SqlType | Length | Precision | Scale | Nullable | Unique |
| TAXON_NAME_HIST_ID | NUMBER(18) | 255 | 19 | 2 | false | false |
| TAXON_NAME_HIST_NM | VARCHAR2(255) | 255 | 19 | 2 | true | false |
| TAXON_NAME_HIST_CM | VARCHAR2(2000) | 255 | 19 | 2 | true | false |
| TAXON_NAME_HIST_UPPER_RK | NUMBER(12) | 255 | 19 | 2 | true | false |
| TAXON_NAME_HIST_IS_REFER | VARCHAR2(1) | 255 | 19 | 2 | true | false |
| TAXON_NAME_HIST_IS_VIRTUAL | VARCHAR2(1) | 255 | 19 | 2 | true | false |
| TAXON_NAME_HIST_OBSOL | VARCHAR2(1) | 255 | 19 | 2 | true | false |
| TAXON_NAME_HIST_TEMPOR | VARCHAR2(1) | 255 | 19 | 2 | true | false |
| UPDATE_DT | TIMESTAMP | 255 | 19 | 2 | false | false |
| CIT_ID | NUMBER(18) | 255 | 19 | 2 | true | false |
| PARENT_TAXON_NAME_ID | NUMBER(18) | 255 | 19 | 2 | true | false |
| TAXON_NAME_ID | NUMBER(18) | 255 | 19 | 2 | true | false |
| Primary Key | |
|---|---|
| Name | Columns |
| TAXON_NAME_HIPK | TAXON_NAME_HIST_ID |
| Foreign Keys | ||
|---|---|---|
| Name | Referenced Table | Columns |
| TAXON_NAME_HISTORY_CIT_IDC | CITATION | CIT_ID |
| TAXON_NAME_HISTORY_PARENT_TAXC | TAXON_NAME | PARENT_TAXON_NAME_ID |
| TAXON_NAME_HISTORY_TAXON_NAMEC | TAXON_NAME | TAXON_NAME_ID |
Column Detail