Pdelivery
Tables (13)
p_ai_request
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → p_store.id — NOT NULL — 이미지상 p_store.id 참조로 되어 있음
- system_text — TEXT
- request_text — TEXT
- response_text — TEXT
- created_at — TIMESTAMP — NOT NULL
- created_by — UUID — NOT NULL
p_cart
- id — BINARY(16) — Primary key — NOT NULL — 장바구니 ID (UUID)
- user_id — VARCHAR(100) — Foreign key → p_user.id — NOT NULL — 사용자 FK (UNIQUE)
- store_id — BINARY(16) — Foreign key → p_store.id — NOT NULL — 가게 FK
p_cart_line
- id — UUID — Primary key — NOT NULL — 장바구니 상품 ID (UUID)
- cart_id — UUID — Foreign key → p_cart.id — NOT NULL — 장바구니 FK
- menu_id — UUID — Foreign key → p_menu.id — NOT NULL — 상품 FK
- quantity — INTEGER — NOT NULL — 담은 수량
p_category
- id — UUID — Primary key — NOT NULL — 카테고리 ID (UUID)
- name — VARCHAR(10) — NOT NULL — 카테고리명
- created_at — TIMESTAMP — NOT NULL
- created_by — UUID — NOT NULL
- updated_at — TIMESTAMP
- updated_by — UUID
- deleted_at — TIMESTAMP
- deleted_by — UUID
p_menu
- id — UUID — Primary key — NOT NULL — 상품 ID (UUID)
- store_id — UUID — Foreign key → p_store.id — NOT NULL — 가게 FK
- name — VARCHAR(100) — NOT NULL — 상품 이름
- description — TEXT — 상품 설명
- price — INTEGER — NOT NULL — 상품 가격
- is_hidden — BOOLEAN — NOT NULL — 숨김 여부
- created_at — TIMESTAMP — NOT NULL
- created_by — UUID — NOT NULL
- updated_at — TIMESTAMP
- updated_by — UUID
- deleted_at — TIMESTAMP
- deleted_by — UUID
p_order
- id — UUID — Primary key — NOT NULL — 주문 ID (UUID)
- customer_id — UUID — Foreign key → p_user.id — NOT NULL — 주문자 FK
- store_id — UUID — Foreign key → p_store.id — NOT NULL — 가게 FK
- address — VARCHAR(100) — NOT NULL — 배송 주소
- status — ENUM('PENDING', 'ACCEPTED', 'COOKED', 'REJECTED', 'COMPLETED', 'CANCELLED') — NOT NULL
- order_type — ENUM('ONLINE') — NOT NULL — 주문 유형
- reason — TEXT — 취소/거절 사유
- total_price — INTEGER — NOT NULL — 총 주문 금액
- created_at — TIMESTAMP — NOT NULL
- created_by — UUID — NOT NULL
- updated_at — TIMESTAMP
- updated_by — UUID
- deleted_at — TIMESTAMP
- deleted_by — UUID
p_order_line
- id — UUID — Primary key — NOT NULL — 주문 상세 ID (UUID)
- order_id — UUID — Foreign key → p_order.id — NOT NULL — 주문 FK
- menu_id — UUID — Foreign key → p_menu.id — NOT NULL — 상품 FK
- menu_name — VARCHAR(200) — NOT NULL — 주문 시점 상품명
- quantity — INTEGER — NOT NULL — 주문 수량
- price — INTEGER — NOT NULL — 주문 시점 단가
p_payment
- id — UUID — Primary key — NOT NULL
- order_id — UUID — Foreign key → p_order.id — NOT NULL
- store_id — UUID — Foreign key → p_store.id — NOT NULL
- menu_id — VARCHAR(64) — NOT NULL — Toss ORDER ID
- payment_key — VARCHAR(200)
- payment_method — VARCHAR(30)
- amount — BIGINT — NOT NULL
- status — ENUM('READY', 'PAID', 'FAILED', 'REFUNDED') — NOT NULL
- approved_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
p_payment_transactions
- id — BINARY(16) — Primary key — NOT NULL
- payment_id — BINARY(16) — Foreign key → p_payment.id — NOT NULL
- type — ENUM('APPROVAL_RESPONSE', 'CANCEL_RESPONSE') — NOT NULL
- success — TINYINT(1) — NOT NULL
- payload_json — JSON
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
p_rating_stat
- id — UUID — Primary key — NOT NULL
- store_id — UUID — Foreign key → p_store.id — NOT NULL
- avg_rating — DOUBLE — NOT NULL
- review_cnt — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — UUID — NOT NULL
- updated_at — TIMESTAMP
- updated_by — UUID
- deleted_at — TIMESTAMP
- deleted_by — UUID
p_review
- id — UUID — Primary key — NOT NULL
- order_id — UUID — Foreign key → p_order.id — NOT NULL
- customer_id — UUID — Foreign key → p_user.id — NOT NULL
- store_id — UUID — Foreign key → p_store.id — NOT NULL
- rating — INTEGER — NOT NULL
- content — TEXT
- created_at — TIMESTAMP — NOT NULL
- created_by — UUID — NOT NULL
- updated_at — TIMESTAMP
- updated_by — UUID
- deleted_at — TIMESTAMP
- deleted_by — UUID
p_store
- id — UUID — Primary key — NOT NULL — 가게 ID (UUID)
- owner_id — UUID — Foreign key → p_user.id — NOT NULL — 가게 소유자 FK
- category_id — UUID — Foreign key → p_category.id — NOT NULL — 카테고리 FK
- name — VARCHAR(50) — NOT NULL — 가게 이름
- address — VARCHAR(100) — NOT NULL — 가게 상세 주소
- phone — VARCHAR(20) — 가게 전화번호
- status — ENUM('PENDING', 'APPROVED', 'REJECTED', 'CANCELED') — NOT NULL
- reject_code — ENUM('DOC_EXPIRED')
- reject_reason — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
- created_by — UUID — NOT NULL
- updated_at — TIMESTAMP
- updated_by — UUID
- deleted_at — TIMESTAMP
- deleted_by — UUID
p_user
- id — UUID — Primary key — NOT NULL — 사용자 ID
- username — VARCHAR(100)
- nickname — VARCHAR(20) — NOT NULL — 사용자 닉네임
- email — VARCHAR(255) — NOT NULL — 사용자 이메일
- password — VARCHAR(255) — NOT NULL — 사용자 비밀번호 (BCrypt)
- role — ENUM('CUSTOMER', 'OWNER', 'MANAGER', 'MASTER') — NOT NULL — 사용자 역할
- created_at — TIMESTAMP — NOT NULL
- created_by — UUID — NOT NULL
- updated_at — TIMESTAMP
- updated_by — UUID
- deleted_at — TIMESTAMP
- deleted_by — UUID