Department Store-2nd
Tables (8)
Campaign
- campaign_id — INT — Primary key — NOT NULL
- campaign_name — VARCHAR(100)
- start_date — DATE
- end_date — DATE
Campaign_Participation
- participation_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → Customer.customer_id — NOT NULL
- campaign_id — INT — Foreign key → Campaign.campaign_id — NOT NULL
- participation_date — DATE
Coupon
- coupon_id — INT — Primary key — NOT NULL
- coupon_name — VARCHAR(100)
- discount — DECIMAL(5, 2)
- valid_from — DATE
- valid_to — DATE
Coupon_Usage
- usage_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → Customer.customer_id — NOT NULL
- coupon_id — INT — Foreign key → Coupon.coupon_id — NOT NULL
- purchase_id — INT — Foreign key → Purchase.purchase_id — NOT NULL
- usage_date — DATE
Customer
- customer_id — INT — Primary key — NOT NULL
- customer_name — VARCHAR(100)
- gender — ENUM('남성', '여성')
- age — INT
- phone_number — VARCHAR(255)
- address — VARCHAR(255)
- join_date — DATE
- channel — ENUM('온라인', '오프라인')
Log
- log_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → Customer.customer_id — NOT NULL
- channel — ENUM('온라인', '오프라인')
- visit_log — TIMESTAMP
Product
- product_id — INT — Primary key — NOT NULL
- product_name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10, 2)
- brand_name — VARCHAR(100)
Purchase
- purchase_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → Customer.customer_id — NOT NULL
- product_id — INT — Foreign key → Product.product_id — NOT NULL
- purchase_date — DATE
- channel — ENUM('온라인', '오프라인')
- count — INT — NOT NULL
- total_spent — DECIMAL(10, 2) — NOT NULL