Schema PUBLIC

Table CAMPAIGN

Column Summary
Name SqlType Length Precision Scale Nullable Unique
CAMPAIGN_ID integer 255 19 2 false false
CAMPAIGN_SISMER_LK VARCHAR(40) 255 19 2 true false
CAMPAIGN_START_DT TIMESTAMP 255 19 2 false false
CAMPAIGN_END_DT TIMESTAMP 255 19 2 true false
CAMPAIGN_NM VARCHAR(100) 255 19 2 false false
CAMPAIGN_CM VARCHAR(2000) 255 19 2 true false
CAMPAIGN_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
QUSER_ID integer 255 19 2 false false
SHIP_ID integer 255 19 2 true false
POS_SYSTEM_ID integer 255 19 2 true false
REC_DEP_ID integer 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

CAMPAIGN_SISMER_LK

CAMPAIGN_START_DT

CAMPAIGN_END_DT

CAMPAIGN_NM

CAMPAIGN_CM

CAMPAIGN_POSITION_CM

UPDATE_DT

REMOTE_ID

QUSER_ID

SHIP_ID

POS_SYSTEM_ID

REC_DEP_ID