Schema PUBLIC

Table FILTER

Column Summary
Name SqlType Length Precision Scale Nullable Unique
FILTER_ID integer 255 19 2 false false
FILTER_NM VARCHAR(50) 255 19 2 true false
FILTER_IS_DEFAULT VARCHAR(1) 255 19 2 true false
FILTER_IS_EXTRACT VARCHAR(1) 255 19 2 true false
FILTER_MIN_X DECIMAL(38,7) 255 19 2 true false
FILTER_MIN_Y DECIMAL(38,7) 255 19 2 true false
FILTER_MAX_X DECIMAL(38,7) 255 19 2 true false
FILTER_MAX_Y DECIMAL(38,7) 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
DEP_ID integer 255 19 2 true false
QUSER_ID integer 255 19 2 false false
FILTER_TYPE_ID integer 255 19 2 false false
EXTRACT_FILTER_ID integer 255 19 2 true false
Primary Key
Name Columns
FILTERPK FILTER_ID
Foreign Keys
Name Referenced Table Columns
FILTER_DEP_IDC DEPARTMENT DEP_ID
FILTER_QUSER_IDC QUSER QUSER_ID
FILTER_FILTER_TYPE_IDC FILTER_TYPE FILTER_TYPE_ID
FILTER_EXTRACT_FILTER_IDC EXTRACT_FILTER EXTRACT_FILTER_ID

Column Detail

FILTER_ID

FILTER_NM

FILTER_IS_DEFAULT

FILTER_IS_EXTRACT

FILTER_MIN_X

FILTER_MIN_Y

FILTER_MAX_X

FILTER_MAX_Y

UPDATE_DT

DEP_ID

QUSER_ID

FILTER_TYPE_ID

EXTRACT_FILTER_ID