Practice

Tables (5)

Customer (고객)

  • id (고객 id) — BIGINT — Primary key — NOT NULL

FoodCourt (음식코너)

  • id (코너 id) — BIGINT — Primary key — NOT NULL
  • name (코너명) — VARCHAR(100)

Menu (메뉴)

  • id (메뉴 id) — BIGINT — Primary key — NOT NULL
  • id (코너 id) — BIGINT — Foreign key → FoodCourt.id — NOT NULL
  • name (메뉴명) — VARCHAR(100)
  • price (메뉴 가격) — INT

MenuOrder (메뉴 - 주문)

  • id (메뉴 - 주문 id) — BIGINT — Primary key — NOT NULL
  • orderId (주문 id) — BIGINT — Foreign key → Order.id — NOT NULL
  • menuId (메뉴 id) — BIGINT — Foreign key → Menu.id — NOT NULL
  • quantity (수량) — INT

Order (주문)

  • id (주문 id) — BIGINT — Primary key — NOT NULL
  • userId (고객 id) — BIGINT — Foreign key → Customer.id — NOT NULL
  • price (금액) — INT