orderService

Tables (4)

MENU

  • 메뉴id (menu_id) — long — Primary key — NOT NULL
  • 메뉴이름 (menu_name) — varchar(100) — NOT NULL
  • 카테고리 (category) — varchar(100) — NOT NULL
  • 가격 (price) — int — NOT NULL
  • 설명 (details) — varchar(500)

customer

  • 고객id (customer_id) — long — Primary key — NOT NULL
  • 지점id (restaurant_id) — long — Foreign key → restaurant.지점id — NOT NULL
  • 이름 (name) — varchar(10) — NOT NULL
  • 전화번호 (phone) — int — NOT NULL
  • 주소 (address) — varchar(100) — NOT NULL

order

  • 주문id (order_id) — long — Primary key — NOT NULL
  • 메뉴id (menu_id) — long — Foreign key → MENU.메뉴id — NOT NULL
  • 고객id (customer_id) — long — Foreign key → customer.고객id — NOT NULL
  • 지점id (restaurant_id2) — long — Foreign key → customer.지점id — NOT NULL
  • 주문상태 (order_status) — enum — NOT NULL
  • 주문시간 (order_time) — datetime — NOT NULL

restaurant

  • 지점id (restaurant_id) — long — Primary key — NOT NULL
  • 지점이름 (restaurant_name) — varchar(100) — NOT NULL
  • 지점주소 (restaurant_address) — varchar(100) — NOT NULL
  • 지점번호 (restuarant_number) — int — NOT NULL