ㅁㄴㅇㅁ
Tables (5)
Customers
- customer_id — INT — Primary key — NOT NULL
- name — VARCHAR(15) — NOT NULL
- phone — CHAR(11) — NOT NULL
- gender — ENUM('M', 'F', 'O') — NOT NULL
- join_date — DATE — NOT NULL
- created_at — TIMESTAMP — NOT NULL
Grade_Tiers
- tier_id — INT — Primary key — NOT NULL
- grade_name — VARCHAR(10) — NOT NULL
- min_amount — DECIMAL(10, 2) — NOT NULL
- max_amount — DECIMAL(10, 2)
- benefit — VARCHAR(255)
Grades
- customer_id — INT — Foreign key → Customers.customer_id — NOT NULL
- sum_account — DECIMAL(10, 2) — NOT NULL
- grade_name — VARCHAR(10) — Foreign key → Grade_Tiers.grade_name — NOT NULL
- update_date — DATETIME — NOT NULL
- last_calculated_at — TIMESTAMP — NOT NULL
Logs
- log_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → Customers.customer_id — NOT NULL
- store_id — INT — Foreign key → Stores.store_id — NOT NULL
- purchase_date — DATETIME — NOT NULL
- account — DECIMAL(10, 2) — NOT NULL
Stores
- store_id — INT — Primary key — NOT NULL
- store_name — VARCHAR(50) — NOT NULL
- location — VARCHAR(100)