Hibernate Mappings - Table Info

Schema PUBLIC

Table VIDEO

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
VIDEO_ID	integer	255	19	2	false	false
VIDEO_NM	VARCHAR(100)	255	19	2	true	false
VIDEO_CM	VARCHAR(2000)	255	19	2	true	false
VIDEO_LK	VARCHAR(255)	255	19	2	true	false
VIDEO_VALID_DT	TIMESTAMP	255	19	2	true	false
VIDEO_QUALIF_DT	TIMESTAMP	255	19	2	true	false
VIDEO_QUALIF_CM	VARCHAR(2000)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	true	false
REMOTE_ID	integer	255	19	2	true	false
QUAL_FLAG_CD	VARCHAR(40)	255	19	2	true	false
SURVEY_ID	integer	255	19	2	true	false

Primary Key
Name	Columns
VIDEOPK	VIDEO_ID

Foreign Keys
Name	Referenced Table	Columns
VIDEO_QUAL_FLAG_CDC	QUALITY_FLAG	QUAL_FLAG_CD
VIDEO_SURVEY_IDC	SURVEY	SURVEY_ID

Column Detail

VIDEO_ID

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

VIDEO_NM

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

VIDEO_CM

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

VIDEO_LK

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

VIDEO_VALID_DT

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

VIDEO_QUALIF_DT

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

VIDEO_QUALIF_CM

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

REMOTE_ID

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

QUAL_FLAG_CD

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

SURVEY_ID

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