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