crm

Tables (5)

contacts

  • contact_id — NUMBER
  • customer_id — NUMBER — NOT NULL
  • name — VARCHAR2(255)
  • department — VARCHAR2(255)
  • position — VARCHAR2(255)
  • phone — VARCHAR2(15)
  • email — VARCHAR2(255)
  • contact_date — DATE
  • is_keyman — CHAR(1)
  • is_executive — CHAR(1)
  • preferred_channel — VARCHAR2(255)

customers

  • customer_id — NUMBER
  • company_name — VARCHAR2(255) — NOT NULL
  • company_type — VARCHAR2(50)
  • region — VARCHAR2(255)
  • reg_date — DATE
  • industry_type — VARCHAR2(255)
  • country — VARCHAR2(255)
  • size — VARCHAR2(255)

engagements

  • engagement_id — NUMBER
  • customer_id — NUMBER — NOT NULL
  • newsletter_opens — NUMBER
  • site_visits — NUMBER
  • survey_response — CHAR(1)
  • last_active_date — DATE

orders

  • order_id — NUMBER
  • customer_id — NUMBER — NOT NULL
  • order_date — DATE
  • product — VARCHAR2(255)
  • quantity — NUMBER
  • amount — FLOAT
  • cost — FLOAT
  • margin_rate — FLOAT
  • payment_status — VARCHAR2(50)
  • delivery_status — VARCHAR2(50)

products

  • product_id — NUMBER
  • product_name — VARCHAR2(255)
  • category — VARCHAR2(255)
  • price — FLOAT
  • stock_quantity — NUMBER
  • manufacture_date — DATE