ㅇ
Tables (6)
customer
- customer_id — INT
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
payment
- payment_id — INT
- reservation_id — INT — NOT NULL
- payment_date — DATE — NOT NULL
- payment_method — VARCHAR(30) — NOT NULL
product
- product_id — INT
- name — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- product_type — ENUM('DESSERT', 'CAKE', 'SET') — NOT NULL
product_set_item
- set_id — INT — Primary key — NOT NULL
- dessert_id — INT — Primary key — NOT NULL
- quantity — INT — NOT NULL
reservation
- reservation_id — INT
- customer_id — INT — NOT NULL
- reservation_date — DATE — NOT NULL
- pickup_time — TIME — NOT NULL
reservation_item
- reservation_item_id — INT
- reservation_id — INT — NOT NULL
- product_id — INT — NOT NULL
- quantity — INT — NOT NULL