Hibernate Mappings - Table Info

Schema Q2DBA

Table DELETED_ITEM_HISTORY

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
DEL_ITEM_HIST_ID	NUMBER(18)	255	19	2	false	false
OBJECT_ID	NUMBER(19)	255	19	2	true	false
OBJECT_CD	VARCHAR2(40)	255	19	2	true	false
DEL_ITEM_HIST_CM	VARCHAR2(2000)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	false	false
OBJECT_TYPE_CD	VARCHAR2(40)	255	19	2	false	false
REC_DEP_ID	NUMBER(18)	255	19	2	true	false
REC_QUSER_ID	NUMBER(18)	255	19	2	true	false

Primary Key
Name	Columns
DELETED_ITEM_PK	DEL_ITEM_HIST_ID

Foreign Keys
Name	Referenced Table	Columns
DELETED_ITEM_HISTORY_OBJECT_TC	OBJECT_TYPE	OBJECT_TYPE_CD
DELETED_ITEM_HISTORY_REC_DEP_C	DEPARTMENT	REC_DEP_ID
DELETED_ITEM_HISTORY_REC_QUSEC	QUSER	REC_QUSER_ID

Column Detail

DEL_ITEM_HIST_ID

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

OBJECT_ID

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

OBJECT_CD

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

DEL_ITEM_HIST_CM

Type: VARCHAR2(2000)
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:

REC_DEP_ID

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

REC_QUSER_ID

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