Schema PUBLIC

Table CONTEXT

Column Summary
Name SqlType Length Precision Scale Nullable Unique
CONTEXT_ID integer 255 19 2 false false
CONTEXT_NM VARCHAR(100) 255 19 2 false false
CONTEXT_DC VARCHAR(255) 255 19 2 true false
CONTEXT_IS_DEFAULT VARCHAR(1) 255 19 2 true false
CONTEXT_SURVEY_ORDER DOUBLE 255 19 2 true false
CONTEXT_TAXON_DISPLAY DOUBLE 255 19 2 true false
CONTEXT_INIT_POP_ORDER DOUBLE 255 19 2 true false
CONTEXT_PLUG_ZONE DECIMAL(38,7) 255 19 2 true false
CONTEXT_CREATION_DT TIMESTAMP 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
STATUS_CD VARCHAR(40) 255 19 2 false false
MAP_PROJECT_ID integer 255 19 2 true false
QUSER_ID integer 255 19 2 true false
ORDER_ITEM_TYPE_CD VARCHAR(40) 255 19 2 true false
Primary Key
Name Columns
CONTEXTPK CONTEXT_ID
Foreign Keys
Name Referenced Table Columns
CONTEXT_STATUS_CDC STATUS STATUS_CD
CONTEXT_MAP_PROJECT_IDC MAP_PROJECT MAP_PROJECT_ID
CONTEXT_QUSER_IDC QUSER QUSER_ID
CONTEXT_ORDER_ITEM_TYPE_CDC ORDER_ITEM_TYPE ORDER_ITEM_TYPE_CD

Column Detail

CONTEXT_ID

CONTEXT_NM

CONTEXT_DC

CONTEXT_IS_DEFAULT

CONTEXT_SURVEY_ORDER

CONTEXT_TAXON_DISPLAY

CONTEXT_INIT_POP_ORDER

CONTEXT_PLUG_ZONE

CONTEXT_CREATION_DT

UPDATE_DT

STATUS_CD

MAP_PROJECT_ID

QUSER_ID

ORDER_ITEM_TYPE_CD