Kokeetea
Tables (5)
Branch (지점)
- id (지점id) — Primary key — NOT NULL
Customer (고객)
- id (고객id) — Primary key — NOT NULL
Drink (음료)
- id (음료id) — Primary key — NOT NULL
Inventory (재고)
- id (재고id) — Primary key — NOT NULL
- id (주문id) — Foreign key → Order.id — NOT NULL
- id (음료id) — Foreign key → Order.id — NOT NULL
Order (주문)
- id (주문id) — Primary key — NOT NULL
- id (음료id) — Foreign key → Drink.id — NOT NULL
- Field