Hibernate Mappings - Table Info

Schema Q2DBA

Table PHOTO

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
PHOTO_ID	NUMBER(18)	255	19	2	false	false
OBJECT_ID	NUMBER(18)	255	19	2	false	false
PHOTO_NM	VARCHAR2(100)	255	19	2	true	false
PHOTO_DIR_DC	VARCHAR2(255)	255	19	2	true	false
PHOTO_CM	VARCHAR2(2000)	255	19	2	true	false
PHOTO_LK	VARCHAR2(255)	255	19	2	true	false
PHOTO_DT	DATE	255	19	2	true	false
PHOTO_VALID_DT	DATE	255	19	2	true	false
PHOTO_QUALIF_DT	DATE	255	19	2	true	false
PHOTO_QUALIF_CM	VARCHAR2(2000)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	false	false
PHOTO_TYPE_CD	VARCHAR2(40)	255	19	2	true	false
QUAL_FLAG_CD	VARCHAR2(40)	255	19	2	true	false
OBJECT_TYPE_CD	VARCHAR2(40)	255	19	2	false	false
REC_DEP_ID	NUMBER(18)	255	19	2	false	false

Primary Key
Name	Columns
PHOTOPK	PHOTO_ID

Foreign Keys
Name	Referenced Table	Columns
PHOTO_PHOTO_TYPE_CDC	PHOTO_TYPE	PHOTO_TYPE_CD
PHOTO_QUAL_FLAG_CDC	QUALITY_FLAG	QUAL_FLAG_CD
PHOTO_OBJECT_TYPE_CDC	OBJECT_TYPE	OBJECT_TYPE_CD
PHOTO_REC_DEP_IDC	DEPARTMENT	REC_DEP_ID

Column Detail

PHOTO_ID

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

OBJECT_ID

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

PHOTO_NM

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

PHOTO_DIR_DC

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

PHOTO_CM

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

PHOTO_LK

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

PHOTO_DT

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

PHOTO_VALID_DT

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

PHOTO_QUALIF_DT

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

PHOTO_QUALIF_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:

PHOTO_TYPE_CD

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

QUAL_FLAG_CD

Type: VARCHAR2(40)
Length: 255
Precision: 19
Scale: 2
Nullable: true
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: false
Unique: false
Comment: