Column Summary | ||||||
---|---|---|---|---|---|---|
Name | SqlType | Length | Precision | Scale | Nullable | Unique |
TAXON_NAME_ID | integer | 255 | 19 | 2 | false | false |
TAXON_NAME_NM | VARCHAR(255) | 255 | 19 | 2 | true | false |
TAXON_NAME_COMPLETE_NM | VARCHAR(255) | 255 | 19 | 2 | true | false |
TAXON_NAME_IS_NAMING | BIT(1) | 255 | 19 | 2 | true | false |
TAXON_NAME_CM | VARCHAR(2000) | 255 | 19 | 2 | true | false |
TAXON_NAME_UPPER_RK | INTEGER | 255 | 19 | 2 | true | false |
TAXON_NAME_IS_REFER | BIT(1) | 255 | 19 | 2 | true | false |
TAXON_NAME_IS_VIRTUAL | BIT(1) | 255 | 19 | 2 | true | false |
TAXON_NAME_OBSOL | BIT(1) | 255 | 19 | 2 | true | false |
TAXON_NAME_TEMPOR | BIT(1) | 255 | 19 | 2 | true | false |
TAXON_NAME_CREATION_DT | TIMESTAMP | 255 | 19 | 2 | true | false |
UPDATE_DT | TIMESTAMP | 255 | 19 | 2 | true | false |
TAXON_START_DT | TIMESTAMP | 255 | 19 | 2 | true | false |
TAXON_END_DT | TIMESTAMP | 255 | 19 | 2 | true | false |
CIT_ID | integer | 255 | 19 | 2 | true | false |
PARENT_TAXON_NAME_ID | integer | 255 | 19 | 2 | true | false |
TAX_LEVEL_CD | VARCHAR(40) | 255 | 19 | 2 | false | false |
REF_TAXON_ID | integer | 255 | 19 | 2 | false | false |
Primary Key | |
---|---|
Name | Columns |
TAXON_NAMEPK | TAXON_NAME_ID |
Foreign Keys | ||
---|---|---|
Name | Referenced Table | Columns |
TAXON_NAME_CIT_IDC | CITATION | CIT_ID |
TAXON_NAME_PARENT_TAXON_NAME_C | TAXON_NAME | PARENT_TAXON_NAME_ID |
TAXON_NAME_TAX_LEVEL_CDC | TAXONOMIC_LEVEL | TAX_LEVEL_CD |
TAXON_NAME_REF_TAXON_IDC | REFERENCE_TAXON | REF_TAXON_ID |
Column Detail