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