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 — 사용자