Hibernate Mappings - Table Info

Schema PUBLIC

Table OCCASION

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
OCCAS_ID	integer	255	19	2	false	false
OCCAS_DT	TIMESTAMP	255	19	2	false	false
OCCAS_NM	VARCHAR(100)	255	19	2	false	false
OCCAS_CM	VARCHAR(2000)	255	19	2	true	false
OCCAS_POSITION_CM	VARCHAR(2000)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	true	false
REMOTE_ID	integer	255	19	2	true	false
REC_DEP_ID	integer	255	19	2	false	false
CAMPAIGN_ID	integer	255	19	2	false	false
POS_SYSTEM_ID	integer	255	19	2	true	false
SHIP_ID	integer	255	19	2	true	false

Primary Key
Name	Columns
OCCASIONPK	OCCAS_ID

Foreign Keys
Name	Referenced Table	Columns
OCCASION_REC_DEP_IDC	DEPARTMENT	REC_DEP_ID
OCCASION_CAMPAIGN_IDC	CAMPAIGN	CAMPAIGN_ID
OCCASION_POS_SYSTEM_IDC	POSITIONNING_SYSTEM	POS_SYSTEM_ID
OCCASION_SHIP_IDC	SHIP	SHIP_ID

Column Detail

OCCAS_ID

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

OCCAS_DT

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

OCCAS_NM

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

OCCAS_CM

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

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

REC_DEP_ID

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

CAMPAIGN_ID

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

POS_SYSTEM_ID

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

SHIP_ID

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