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) — 삭제자