Hibernate Mappings - Table Info

Schema Q2DBA

Table AUTHOR

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
AUTHOR_ID	NUMBER(18)	255	19	2	false	false
AUTHOR_NM	VARCHAR2(100)	255	19	2	true	false
AUTHOR_LOCAL	VARCHAR2(255)	255	19	2	true	false
AUTHOR_CM	VARCHAR2(2000)	255	19	2	true	false
AUTHOR_CREATION_DT	DATE	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	false	false
STATUS_CD	VARCHAR2(40)	255	19	2	false	false

Primary Key
Name	Columns
AUTHORPK	AUTHOR_ID

Foreign Keys
Name	Referenced Table	Columns
AUTHOR_STATUS_CDC	STATUS	STATUS_CD

Column Detail

AUTHOR_ID

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

AUTHOR_NM

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

AUTHOR_LOCAL

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

AUTHOR_CM

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

AUTHOR_CREATION_DT

Type: DATE
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:

STATUS_CD

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