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