deliverySystem

Tables (16)

p_ai_request

  • id — BINARY(16) — Primary key — NOT NULL
  • user_id — BINARY(16) — 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 — VARCHAR(100) — 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 — BINARY(16) — Primary key — NOT NULL — 장바구니 상품 ID (UUID)
  • cart_id — BINARY(16) — Foreign key → p_cart.id — NOT NULL — 장바구니 FK
  • menu_id — BINARY(16) — Foreign key → p_menu.id — NOT NULL — 상품 FK
  • quantity — INTEGER — NOT NULL — 담은 수량

p_category

  • id — BINARY(16) — Primary key — NOT NULL — 카테고리 ID (UUID)
  • name — VARCHAR(10) — NOT NULL — 카테고리명
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_delivery_address

  • id — BINARY(16) — Primary key — NOT NULL — 배송지 ID (UUID)
  • customer_id — VARCHAR(100) — Foreign key → p_user.id — NOT NULL — 주문자 FK
  • address — VARCHAR(100) — NOT NULL — 시+구+동+상세주소
  • is_default — BOOLEAN — NOT NULL — 기본 배송지 여부
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_menu

  • id — BINARY(16) — Primary key — NOT NULL — 상품 ID (UUID)
  • store_id — BINARY(16) — 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 — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_order

  • id — BINARY(16) — Primary key — NOT NULL — 주문 ID (UUID)
  • customer_id — VARCHAR(100) — Foreign key → p_user.id — NOT NULL — 주문자 FK
  • store_id — BINARY(16) — 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 — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_order_line

  • id — BINARY(16) — Primary key — NOT NULL — 주문 상세 ID (UUID)
  • order_id — BINARY(16) — Foreign key → p_order.id — NOT NULL — 주문 FK
  • menu_id — BINARY(16) — 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 — BINARY(16) — Primary key — NOT NULL
  • order_id — BINARY(16) — Foreign key → p_order.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
  • store_id — BINARY(16) — Foreign key → p_store.id — 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 — BINARY(16) — Primary key — NOT NULL
  • store_id — BINARY(16) — Foreign key → p_store.id — NOT NULL
  • avg_rating — DOUBLE — NOT NULL
  • review_cnt — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_region

  • id — BINARY(16) — Primary key — NOT NULL — 지역 ID (UUID)
  • region_name — VARCHAR(20) — NOT NULL — 지역 이름
  • is_active — BOOLEAN — NOT NULL — 운영 활성화 여부
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_region_detail

  • id — BINARY(16) — Primary key — NOT NULL — 지역 세부 ID (UUID)
  • region_id — BINARY(16) — Foreign key → p_region.id — NOT NULL — 지역 FK
  • city — VARCHAR(100) — NOT NULL — 시
  • district — VARCHAR(100) — NOT NULL — 군/구
  • neighborhood — VARCHAR(100) — NOT NULL — 동/면
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_review

  • id — BINARY(16) — Primary key — NOT NULL
  • order_id — BINARY(16) — Foreign key → p_order.id — NOT NULL
  • customer_id — VARCHAR(100) — Foreign key → p_user.id — NOT NULL
  • store_id — BINARY(16) — Foreign key → p_store.id — NOT NULL
  • rating — INTEGER — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_store

  • id — BINARY(16) — Primary key — NOT NULL — 가게 ID (UUID)
  • owner_id — VARCHAR(100) — Foreign key → p_user.id — NOT NULL — 가게 소유자 FK
  • category_id — BINARY(16) — Foreign key → p_category.id — NOT NULL — 카테고리 FK
  • region_id — BINARY(16) — Foreign key → p_region.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 — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)

p_user

  • id — VARCHAR(100) — Primary key — NOT NULL — 사용자 ID
  • 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 — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)