db_term

Tables (18)

p_address

  • address_id — UUID
  • user_id — UUID — NOT NULL — 유저
  • address_name — VARCHAR(50) — 배송지
  • recipient_name — VARCHAR(50) — NOT NULL — 수령인
  • recipient_phone — VARCHAR(20) — NOT NULL — 수령인
  • zip_code — VARCHAR(10) — NOT NULL — 우편번호
  • address1 — VARCHAR(200) — NOT NULL — 기본주소
  • address2 — VARCHAR(200) — 상세주소
  • is_default — BOOLEAN — NOT NULL — 기본
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_cart

  • cart_id — UUID
  • user_id — UUID — NOT NULL — 구매자
  • product_id — UUID — NOT NULL — 상품
  • variant_id — UUID — NOT NULL — 변형(SKU)
  • quantity — INT — NOT NULL — 수량
  • created_at — TIMESTAMP — NOT NULL — 담은
  • updated_at — TIMESTAMP — 수정

p_category

  • category_id — UUID
  • parent_id — UUID — 상위
  • name — VARCHAR(100) — NOT NULL — 카테고리명
  • depth — INT — NOT NULL — 깊이
  • sort_order — INT — NOT NULL — 정렬
  • is_active — BOOLEAN — NOT NULL — 활성
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_order

  • order_id — UUID
  • order_number — VARCHAR(20) — NOT NULL — 주문번호
  • buyer_id — UUID — NOT NULL — 구매자
  • total_product_amt — BIGINT — NOT NULL — 총
  • total_delivery_fee — BIGINT — NOT NULL — 총
  • total_payment_amt — BIGINT — NOT NULL — 총
  • status — VARCHAR(20) — NOT NULL — 주문
  • recipient_name — VARCHAR(50) — NOT NULL — 수령인
  • recipient_phone — VARCHAR(20) — NOT NULL — 연락처
  • zip_code — VARCHAR(10) — NOT NULL — 우편번호
  • shipping_address — VARCHAR(300) — NOT NULL — 배송지
  • shipping_memo — VARCHAR(200) — 배송
  • ordered_at — TIMESTAMP — NOT NULL — 주문일시
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_order_item

  • order_item_id — UUID
  • order_id — UUID — NOT NULL — 주문
  • product_id — UUID — NOT NULL — 상품
  • variant_id — UUID — NOT NULL — 변형(SKU)
  • seller_id — UUID — NOT NULL — 판매자
  • product_title — VARCHAR(200) — NOT NULL — 상품명
  • product_thumbnail — VARCHAR(500) — 썸네일
  • option_name — VARCHAR(200) — 옵션
  • sku_code — VARCHAR(50) — SKU
  • unit_price — BIGINT — NOT NULL — 구매
  • quantity — INT — NOT NULL — 구매
  • subtotal — BIGINT — NOT NULL — 소계
  • item_status — VARCHAR(20) — NOT NULL — 개별
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_payment

  • payment_id — UUID
  • order_id — UUID — NOT NULL — 주문
  • payment_method — VARCHAR(20) — NOT NULL — 결제
  • amount — BIGINT — NOT NULL — 결제
  • status — VARCHAR(20) — NOT NULL — 결제
  • pg_provider — VARCHAR(50) — PG사
  • pg_payment_key — VARCHAR(255) — PG
  • approved_at — TIMESTAMP — 결제
  • cancelled_at — TIMESTAMP — 취소
  • cancel_reason — VARCHAR(255) — 취소
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_payment_history

  • history_id — UUID
  • payment_id — UUID — NOT NULL — 결제
  • status — VARCHAR(20) — NOT NULL — 결제
  • response — TEXT — PG
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자

p_product

  • product_id — UUID
  • seller_id — UUID — NOT NULL — 판매자
  • category_id — UUID — NOT NULL — 카테고리
  • title — VARCHAR(200) — NOT NULL — 상품명
  • description — TEXT — 상품
  • thumbnail_url — VARCHAR(500) — 대표
  • status — VARCHAR(20) — NOT NULL — 상품
  • has_options — BOOLEAN — NOT NULL — 옵션
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_product_option

  • option_id — UUID
  • product_id — UUID — NOT NULL — 상품
  • name — VARCHAR(50) — NOT NULL — 옵션명
  • sort_order — INT — NOT NULL — 표시
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_product_option_value

  • option_value_id — UUID
  • option_id — UUID — NOT NULL — 옵션
  • value — VARCHAR(100) — NOT NULL — 옵션값
  • sort_order — INT — NOT NULL — 표시
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_product_rating

  • product_id — UUID
  • avg_rating — DECIMAL(3,2) — NOT NULL — 평균
  • review_count — INT — NOT NULL — 리뷰
  • updated_at — TIMESTAMP — NOT NULL — 갱신일시

p_product_variant

  • variant_id — UUID
  • product_id — UUID — NOT NULL — 상품
  • sku_code — VARCHAR(50) — 재고관리코드
  • option_value_ids — UUID — 옵션값
  • option_name — VARCHAR(200) — 옵션
  • price — BIGINT — NOT NULL — 판매가
  • stock_quantity — INT — NOT NULL — 재고
  • status — VARCHAR(20) — NOT NULL — 상태
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_refund

  • refund_id — UUID
  • payment_id — UUID — NOT NULL — 결제
  • amount — BIGINT — NOT NULL — 환불
  • reason — VARCHAR(255) — NOT NULL — 환불
  • status — VARCHAR(20) — NOT NULL — 환불
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_review

  • review_id — UUID
  • order_id — UUID — NOT NULL — 주문
  • order_item_id — UUID — NOT NULL — 주문상품
  • product_id — UUID — NOT NULL — 상품
  • variant_id — UUID — 변형
  • user_id — UUID — NOT NULL — 작성자
  • rating — SMALLINT — NOT NULL — 별점
  • option_name — VARCHAR(200) — 구매
  • content — TEXT — 리뷰
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_seller

  • seller_id — UUID
  • user_id — UUID — NOT NULL — 유저
  • store_name — VARCHAR(200) — NOT NULL — 상점
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_shipment

  • shipment_id — UUID
  • order_id — UUID — NOT NULL — 주문
  • seller_id — UUID — NOT NULL — 판매자
  • courier_code — VARCHAR(20) — 택배사
  • courier_name — VARCHAR(50) — 택배사명
  • tracking_number — VARCHAR(50) — 운송장
  • status — VARCHAR(20) — NOT NULL — 배송
  • shipped_at — TIMESTAMP — 발송일시
  • delivered_at — TIMESTAMP — 배송
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자

p_shipment_item

  • shipment_item_id — UUID
  • shipment_id — UUID — NOT NULL — 배송
  • order_item_id — UUID — NOT NULL — 주문상품
  • quantity — INT — NOT NULL — 배송
  • created_at — TIMESTAMP — NOT NULL — 생성일시

p_user

  • user_id — UUID
  • email — VARCHAR(255) — NOT NULL — 로그인
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • nickname — VARCHAR(50) — NOT NULL — 별명
  • phone_number — VARCHAR(20) — NOT NULL — 전화번호
  • role — VARCHAR(20) — NOT NULL — 역할
  • status — VARCHAR(20) — NOT NULL — 상태
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • created_by — VARCHAR(100) — 생성자
  • updated_at — TIMESTAMP — 수정일시
  • updated_by — VARCHAR(100) — 수정자
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_by — VARCHAR(100) — 삭제자