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