Hibernate Mappings - Table Info

Schema PUBLIC

Table EXTRACT_FILTER

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
EXTRACT_FILTER_ID	integer	255	19	2	false	false
EXTRACT_FILTER_NM	VARCHAR(100)	255	19	2	false	false
EXTRACT_FILTER_IN_SITU	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_QUALIF	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_JAN	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_FEB	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_MAR	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_APR	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_MAY	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_JUN	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_JUL	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_AUG	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_SEP	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_OCT	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_NOV	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_IS_DEC	VARCHAR(1)	255	19	2	true	false
EXTRACT_FILTER_MIN_X	DECIMAL(38,7)	255	19	2	true	false
EXTRACT_FILTER_MIN_Y	DECIMAL(38,7)	255	19	2	true	false
EXTRACT_FILTER_MAX_X	DECIMAL(38,7)	255	19	2	true	false
EXTRACT_FILTER_MAX_Y	DECIMAL(38,7)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	true	false
EXTRACT_TABLE_TYPE_CD	VARCHAR(40)	255	19	2	true	false
EXTRACT_AGREG_LEVEL_CD	VARCHAR(40)	255	19	2	true	false
PROJ_SYSTEM_CD	VARCHAR(40)	255	19	2	true	false
QUSER_ID	integer	255	19	2	true	false

Primary Key
Name	Columns
EXTRACT_FILTEPK	EXTRACT_FILTER_ID

Foreign Keys
Name	Referenced Table	Columns
EXTRACT_FILTER_EXTRACT_TABLE_C	EXTRACT_TABLE_TYPE	EXTRACT_TABLE_TYPE_CD
EXTRACT_FILTER_EXTRACT_AGREG_C	EXTRACT_AGREGATION_LEVEL	EXTRACT_AGREG_LEVEL_CD
EXTRACT_FILTER_PROJ_SYSTEM_CDC	PROJECTION_SYSTEM	PROJ_SYSTEM_CD
EXTRACT_FILTER_QUSER_IDC	QUSER	QUSER_ID

Column Detail

EXTRACT_FILTER_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

EXTRACT_FILTER_NM

Type: VARCHAR(100)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

EXTRACT_FILTER_IN_SITU

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_QUALIF

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_JAN

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_FEB

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_MAR

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_APR

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_MAY

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_JUN

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_JUL

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_AUG

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_SEP

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_OCT

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_NOV

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_IS_DEC

Type: VARCHAR(1)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_MIN_X

Type: DECIMAL(38,7)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_MIN_Y

Type: DECIMAL(38,7)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_MAX_X

Type: DECIMAL(38,7)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_FILTER_MAX_Y

Type: DECIMAL(38,7)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

UPDATE_DT

Type: TIMESTAMP
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_TABLE_TYPE_CD

Type: VARCHAR(40)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

EXTRACT_AGREG_LEVEL_CD

Type: VARCHAR(40)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

PROJ_SYSTEM_CD

Type: VARCHAR(40)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

QUSER_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment: