backOffice

Tables (5)

Review (Untitled)

  • PK (review_id) — bigserial — Primary key — NOT NULL
  • 작성자이름 (nickname) — Text
  • 내용 (content) — Text
  • 주문음식 (food) — Text
  • 별점 (score) — int
  • user_pk (user_id) — bigserial — Foreign key → User.PK — NOT NULL
  • menu_pk (menu_id) — bigserial — Foreign key → store_menu.PK — NOT NULL

Store (store)

  • PK (store_id) — bigserial — Primary key — NOT NULL
  • 가게이름 (store_name) — Text
  • 가게설명 (store_cotent) — Text
  • 전화번호 (store_number) — int
  • user_pk (user_id) — bigserial — Foreign key → User.PK — NOT NULL

User (app_user)

  • PK (user_id) — bigserial — Primary key — NOT NULL
  • 이름 (name) — Text
  • 이메일 (email) — Text_unique
  • 비밀번호 (password) — Text
  • 역할 (role) — Text

order_history (order)

  • PK (id) — Bigserial — Primary key — NOT NULL
  • 주문가게 (order_store) — Text
  • 주문메뉴 (menu) — Text
  • 주문가격 (price) — bigInt
  • 주문날짜 (order_at) — timestempz
  • user_pk (user_id) — bigserial — Foreign key → User.PK — NOT NULL

store_menu (menu)

  • PK (menu_id) — bigserial — Primary key — NOT NULL
  • 가게메뉴 (menu) — Text — Primary key
  • 메뉴설명 (description) — Text
  • 메뉴가격 (price) — bigint
  • store_pk (store_id) — bigserial — Foreign key → Store.PK — NOT NULL