test

Tables (10)

p_ai_request_history

  • id — bigint — NOT NULL
  • menu_id — bigint — Foreign key → p_menu.menu_id — NOT NULL — 메뉴
  • request — text — 요청내용
  • response — text — 응답내용
  • status — varchar(20) — NOT NULL — 요청상태
  • error_message — text — 오류메시지
  • created_at — timestamp — NOT NULL — AI기록
  • created_by — bigint — Foreign key → p_user.user_id — AI기록

p_category

  • cat_id — bigint — NOT NULL
  • cat_name — varchar(100) — NOT NULL — 카테고리
  • created_at — timestamp — NOT NULL — 카테고리
  • created_by — bigint — Foreign key → p_user.user_id — 카테고리
  • updated_at — timestamp — 카테고리
  • updated_by — bigint — Foreign key → p_user.user_id — 카테고리
  • deleted_at — timestamp — 카테고리
  • deleted_by — bigint — Foreign key → p_user.user_id — 카테고리

p_menu

  • menu_id — bigint — NOT NULL
  • store_id — bigint — Foreign key → p_store.store_id — NOT NULL — 가게
  • name — varchar(200) — NOT NULL — 메뉴이름
  • description — text — 메뉴설명
  • is_ai_description — boolean — AI설명여부
  • price — integer — NOT NULL — 메뉴가격
  • is_hidden — boolean — 메뉴
  • created_at — timestamp — NOT NULL — 메뉴
  • created_by — bigint — Foreign key → p_user.user_id — 메뉴
  • updated_at — timestamp — 메뉴
  • updated_by — bigint — Foreign key → p_user.user_id — 메뉴
  • deleted_at — timestamp — 메뉴
  • deleted_by — bigint — Foreign key → p_user.user_id — 메뉴

p_order

  • order_id — bigint — NOT NULL
  • order_number — varchar(64) — NOT NULL — 주문번호
  • store_id — bigint — Foreign key → p_store.store_id — NOT NULL — 가게
  • customer_id — bigint — Foreign key → p_user.user_id — NOT NULL — 고객
  • status — order_status — NOT NULL — 주문상태
  • total_amount — integer — NOT NULL — 주문
  • ordered_at — timestamp — NOT NULL — 주문
  • canceled_at — timestamp — 주문
  • cancel_allowed_until — timestamp — NOT NULL — 주문
  • updated_at — timestamp — 주문
  • updated_by — bigint — Foreign key → p_user.user_id — 주문
  • deleted_at — timestamp — 주문
  • deleted_by — bigint — Foreign key → p_user.user_id — 주문

p_order_item

  • id — bigint — NOT NULL
  • order_id — bigint — Foreign key → p_order.order_id — NOT NULL — 주문
  • menu_id — bigint — Foreign key → p_menu.menu_id — NOT NULL — 메뉴
  • menu_name — varchar(200) — NOT NULL — 메뉴명
  • unit_price — integer — NOT NULL — 주문단가
  • quantity — integer — NOT NULL — 주문수량

p_payment

  • id — bigint — NOT NULL
  • order_id — bigint — Foreign key → p_order.order_id — NOT NULL — 주문
  • method — varchar(50) — NOT NULL — 결제수단
  • currency — varchar(3) — NOT NULL — 결제통화
  • amount — integer — NOT NULL — 결제금액
  • status — payment_status — NOT NULL — 결제상태
  • pg_transaction_id — varchar(255) — PG거래ID
  • payment_key — varchar(200) — NOT NULL — PG결제키
  • requested_at — timestamp — NOT NULL — 결제
  • approved_at — timestamp — 결제
  • created_at — timestamp — NOT NULL — 결제
  • updated_at — timestamp — 결제
  • updated_by — bigint — Foreign key → p_user.user_id — 결제
  • deleted_at — timestamp — 결제
  • deleted_by — bigint — Foreign key → p_user.user_id — 결제

p_review

  • id — bigint — NOT NULL
  • order_id — bigint — Foreign key → p_order.order_id — NOT NULL — 주문
  • store_id — bigint — Foreign key → p_store.store_id — NOT NULL — 가게
  • customer_id — bigint — Foreign key → p_user.user_id — NOT NULL — 고객
  • rating — smallint — NOT NULL — 평점
  • content — text — 리뷰
  • created_at — timestamp — NOT NULL — 리뷰
  • updated_at — timestamp — 리뷰
  • updated_by — bigint — Foreign key → p_user.user_id — 리뷰
  • deleted_at — timestamp — 리뷰
  • deleted_by — bigint — Foreign key → p_user.user_id — 리뷰

p_store

  • store_id — bigint — NOT NULL
  • owner_id — bigint — Foreign key → p_user.user_id — NOT NULL — 점주식별자
  • store_name — varchar(200) — NOT NULL — 가게명
  • address — varchar(500) — NOT NULL — 주소원문
  • geom — "geography(Point,4326)" — 주소좌표
  • rating_avg — decimal(3,2) — NOT NULL — 평균평점
  • review_count — int — NOT NULL — 리뷰개수
  • created_at — timestamp — NOT NULL — 가게
  • updated_at — timestamp — 가게
  • updated_by — bigint — Foreign key → p_user.user_id — 가게
  • deleted_at — timestamp — 가게
  • deleted_by — bigint — Foreign key → p_user.user_id — 가게

p_store_category

  • store_id — bigint — Foreign key → p_store.store_id — NOT NULL
  • cat_id — bigint — Foreign key → p_category.cat_id — NOT NULL — 카테고리
  • created_at — timestamp — NOT NULL — 연결
  • created_by — bigint — Foreign key → p_user.user_id — 연결
  • updated_at — timestamp — 연결
  • updated_by — bigint — Foreign key → p_user.user_id — 연결
  • deleted_at — timestamp — 연결
  • deleted_by — bigint — Foreign key → p_user.user_id — 연결

p_user

  • user_id — bigint — NOT NULL
  • username — varchar(100) — NOT NULL — 아이디
  • password — varchar(255) — NOT NULL — 비밀번호
  • role — user_role — NOT NULL — 권한
  • address — varchar(500) — 주소원문
  • geom — "geography(Point,4326)" — 주소좌표
  • created_at — timestamp — NOT NULL — 사용자
  • created_by — bigint — 사용자
  • updated_at — timestamp — 사용자
  • updated_by — bigint — 사용자
  • deleted_at — timestamp — 사용자
  • deleted_by — bigint — 사용자