new_b2b_pre-sales
Tables (3)
CAMPAIGN
- CAM_ID — NUMBER — Primary key — NOT NULL
- CAM_NAME — VARCHAR(100) — NOT NULL
- CAM_STATUS — VARCHAR(100) — NOT NULL
- CAM_START — DATE — NOT NULL
- CAM_END — DATE
- CAM_DESCRIPTION — VARCHAR(500)
- CAM_CHANNEL — NUMBER — Foreign key → CHANNEL_TB.CHANNEL_ID — NOT NULL
CHANNEL_TB
- CHANNEL_ID — NUMBER — Primary key — NOT NULL
- CHANNEL_NAME — VARCHAR(100) — NOT NULL
CUSTOMER_INFO
- CUSTOMER_ID — NUMBER — Primary key — NOT NULL
- CUSTOMER_NAME — VARCHAR(50) — NOT NULL
- CUSTOMER_STATUS — VARCHAR(500) — NOT NULL
- ADDRESS — NUMBER — NOT NULL