기말과제 1
테이블 (10)
Untitled (Customer)
- Key (customer_id) — varchar(10) — 기본 키 — NOT NULL
- Field (name) — varchar(50)
- Field (phone_number) — varchar(11)
- Field (join_date) — date
Untitled (store)
- Key (store_id) — varchar(10) — 기본 키 — NOT NULL
- Field (store_name) — varchar(50)
- Field (location) — varchar(100)
- Field (open_date) — date
Untitled (staff)
- Key (staff_id) — varchar(10) — 기본 키 — NOT NULL
- Field (staff_name) — varchar(50)
- Field (role) — varchar(30
- Field (hire_date) — date
- Key (store_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (category)
- Key (category_id) — varchar(10) — 기본 키 — NOT NULL
- Field (category_name) — varchar(30)
Untitled (menu)
- Key (menu_id) — varchar(10) — 기본 키 — NOT NULL
- Field (menu_name) — varchar(50)
- Field (price) — int
- Key (category_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (ingredient)
- Key (ingredient_id) — varchar(10) — 기본 키 — NOT NULL
- Field (ingredient_name) — varchar(50)
- Field (unit) — varchar(20)
- Field (unit_price) — int
Untitled (orders)
- Key (order_id) — varchar(10) — 기본 키 — NOT NULL
- Field (order_datetime) — datetime
- Key (customer_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (staff_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (store_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (order_item)
- Key (order_item_id) — varchar(10) — 기본 키 — NOT NULL
- Field (quantity) — int
- Key (order_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (menu_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (payment)
- Key (payment_id) — varchar(10) — 기본 키 — NOT NULL
- Field (payment_amount) — int
- Field (payment_method) — varchar(20)
- Field (payment_datetime) — datetime
- Key (order_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (menu_ingredient)
- Key (menu_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (ingredient_id) — varchar(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (quantity_used) — int