DSMS (department store management system)
테이블 (6)
고객 (Customer)
- customer_id (Key) — 기본 키 — NOT NULL
- name (Field)
- age (Field2)
- gender (Field3)
- membership_level (Field4)
- contact_info (Field5)
구매 내역 (Purchase)
- purchase_id (Key) — 기본 키 — NOT NULL
- customer_id (Key2) — 외래 키 → 고객.customer_id — NOT NULL
- purchase_date (Field2)
- total_amount (Field3)
- coupon_id (Key3) — 외래 키 → 쿠폰.coupon_id — NOT NULL
구매상세 (Purchase_Item)
- product_id (Key) — 외래 키 → 상품.product_id — NOT NULL
- purchase_id (Key2) — 외래 키 → 구매 내역.purchase_id — NOT NULL
- quantity (Field3)
상품 (Product)
- product_id (Key) — 기본 키 — NOT NULL
- product_name (Field)
- category (Field2)
- price (Field3)
캠페인 (Campaign)
- campaign_id (Key) — 기본 키 — NOT NULL
- campaign_name (Field)
- start_date (Field2)
- end_date (Field3)
- target_audience (Field4)
- coupon_id (Key2) — 외래 키 → 쿠폰.coupon_id — NOT NULL
쿠폰 (Coupon)
- coupon_id (Key) — 기본 키 — NOT NULL
- campaign_id (Field)
- discount_amount (Field2)
- expiration_date (Field3)