Schema PUBLIC

Table TAXON_NAME_HISTORY

Column Summary
Name SqlType Length Precision Scale Nullable Unique
TAXON_NAME_HIST_ID integer 255 19 2 false false
TAXON_NAME_HIST_NM VARCHAR(255) 255 19 2 true false
TAXON_NAME_HIST_CM VARCHAR(2000) 255 19 2 true false
TAXON_NAME_HIST_UPPER_RK INTEGER 255 19 2 true false
TAXON_NAME_HIST_IS_REFER VARCHAR(1) 255 19 2 true false
TAXON_NAME_HIST_IS_VIRTUAL VARCHAR(1) 255 19 2 true false
TAXON_NAME_HIST_OBSOL VARCHAR(1) 255 19 2 true false
TAXON_NAME_HIST_TEMPOR VARCHAR(1) 255 19 2 true false
UPDATE_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
TAXON_NAME_ID integer 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

TAXON_NAME_HIST_ID

TAXON_NAME_HIST_NM

TAXON_NAME_HIST_CM

TAXON_NAME_HIST_UPPER_RK

TAXON_NAME_HIST_IS_REFER

TAXON_NAME_HIST_IS_VIRTUAL

TAXON_NAME_HIST_OBSOL

TAXON_NAME_HIST_TEMPOR

UPDATE_DT

CIT_ID

PARENT_TAXON_NAME_ID

TAXON_NAME_ID