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