todo

Tables (6)

order (주문)

  • pk (id) — bigint — Primary key — NOT NULL
  • 가게_id (store_id) — bigint — Foreign key → store.pk — NOT NULL
  • 주문자_id (user_id) — bigint

order_menus (주문 메뉴)

  • pk (id) — bigint — Primary key — NOT NULL
  • 주문_id (order_id) — bigint — Foreign key → order.pk — NOT NULL
  • 가게메뉴_id (store_menu_id) — bigint — Foreign key → store_menu.가게_id — NOT NULL
  • 주문자_id (user_id) — bigint

review (리뷰)

  • pk (id) — bigint — Primary key — NOT NULL
  • 주문_id (order_id) — bigint — Foreign key → order.pk — NOT NULL
  • 주문자_id (user_id) — bigint

store (가게)

  • pk (id) — bigint — Primary key — NOT NULL

store_menu (가게 메뉴)

  • pk (id) — bigint — Primary key — NOT NULL
  • 가게_id (store_id) — bigint — Foreign key → store.pk — NOT NULL

user (유저)

  • pk (id) — bigint — Primary key — NOT NULL