Hibernate Mappings - Table Info

Schema Q2DBA

Table CAMPAIGN

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
CAMPAIGN_ID	NUMBER(18)	255	19	2	false	false
CAMPAIGN_SISMER_LK	VARCHAR2(40)	255	19	2	true	false
CAMPAIGN_START_DT	DATE	255	19	2	false	false
CAMPAIGN_END_DT	DATE	255	19	2	true	false
CAMPAIGN_NM	VARCHAR2(100)	255	19	2	false	false
CAMPAIGN_CM	VARCHAR2(2000)	255	19	2	true	false
CAMPAIGN_POSITION_CM	VARCHAR2(2000)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	false	false
QUSER_ID	NUMBER(18)	255	19	2	false	false
SHIP_ID	NUMBER(18)	255	19	2	true	false
POS_SYSTEM_ID	NUMBER(18)	255	19	2	true	false
REC_DEP_ID	NUMBER(18)	255	19	2	false	false

Primary Key
Name	Columns
CAMPAIGNPK	CAMPAIGN_ID

Foreign Keys
Name	Referenced Table	Columns
CAMPAIGN_QUSER_IDC	QUSER	QUSER_ID
CAMPAIGN_SHIP_IDC	SHIP	SHIP_ID
CAMPAIGN_POS_SYSTEM_IDC	POSITIONNING_SYSTEM	POS_SYSTEM_ID
CAMPAIGN_REC_DEP_IDC	DEPARTMENT	REC_DEP_ID

Column Detail

CAMPAIGN_ID

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

CAMPAIGN_SISMER_LK

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

CAMPAIGN_START_DT

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

CAMPAIGN_END_DT

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

CAMPAIGN_NM

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

CAMPAIGN_CM

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

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

QUSER_ID

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

SHIP_ID

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

POS_SYSTEM_ID

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

REC_DEP_ID

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