Hibernate Mappings - Table Info

Schema Q2DBA

Table EXTRACT_FIELD

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
EXTRACT_FIELD_ID	NUMBER(18)	255	19	2	false	false
EXTRACT_FIELD_NM	VARCHAR2(100)	255	19	2	false	false
EXTRACT_FIELD_RANK	NUMBER(12)	255	19	2	false	false
EXTRACT_FIELD_SORT_TYPE	VARCHAR2(4)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	false	false
OBJECT_TYPE_CD	VARCHAR2(40)	255	19	2	false	false
EXTRACT_FILTER_ID	NUMBER(18)	255	19	2	false	false

Primary Key
Name	Columns
EXTRACT_FIELDPK	EXTRACT_FIELD_ID

Foreign Keys
Name	Referenced Table	Columns
EXTRACT_FIELD_OBJECT_TYPE_CDC	OBJECT_TYPE	OBJECT_TYPE_CD
EXTRACT_FIELD_EXTRACT_FILTER_C	EXTRACT_FILTER	EXTRACT_FILTER_ID

Column Detail

EXTRACT_FIELD_ID

Type: NUMBER(18)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

EXTRACT_FIELD_NM

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

EXTRACT_FIELD_RANK

Type: NUMBER(12)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

EXTRACT_FIELD_SORT_TYPE

Type: VARCHAR2(4)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

UPDATE_DT

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

OBJECT_TYPE_CD

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

EXTRACT_FILTER_ID

Type: NUMBER(18)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment: