4조 최종
테이블 (8)
Benefit
- benefit_id — INT — 기본 키 — NOT NULL
- description — TEXT
- discount_rate — INT
- points_reward — INT
- free_shipping — BOOLEAN
- priority_support — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Benefit_Usage_Logs
- usage_id — INT — 기본 키 — NOT NULL
- usage_date — TIMESTAMP — NOT NULL
- benefit_id — INT — 외래 키 → Benefit.benefit_id — NOT NULL
- customer_id — INT — 외래 키 → Customers.customer_id — NOT NULL
- log_id — INT — 외래 키 → Logs.log_id — NOT NULL
Customers
- customer_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(15) — NOT NULL
- phone — CHAR(11) — NOT NULL
- gender — ENUM('M', 'F', 'O') — NOT NULL
- join_date — DATE — NOT NULL
- tier_name — VARCHAR(10)
Grade_Tiers
- tier_name — VARCHAR(10) — 기본 키 — NOT NULL
- tier_description — VARCHAR(50) — NOT NULL
Grades
- customer_id — INT — 외래 키 → Customers.customer_id — NOT NULL
- sum_account — INT — NOT NULL
- update_date — TIMESTAMP — NOT NULL
- tier_name — VARCHAR(10) — 외래 키 → Grade_Tiers.tier_name — NOT NULL
Logs
- log_id — INT — 기본 키 — NOT NULL
- customer_id — INT — 외래 키 → Customers.customer_id — NOT NULL
- purchase_date — TIMESTAMP — NOT NULL
- account — INT — NOT NULL
- store_id — INT — 외래 키 → Stores.store_id — NOT NULL
Staff
- staff_id — INT — 기본 키 — NOT NULL
- staff_name — CHAR(4)
- staff_phone — CHAR(11)
- staff_address — VARCHAR(70)
- staff_gender — ENUM('M', 'F', 'O') — NOT NULL
- staff_position — VARCHAR(10)
- staff_age — TINYINT
- store_id — INT — 외래 키 → Stores.store_id — NOT NULL
Stores
- store_id — INT — 기본 키 — NOT NULL
- store_name — VARCHAR(50) — NOT NULL
- location — VARCHAR(100)