커머스

테이블 (32)

' (R_COMMERCE_REFUND)

  • PK — INT — 기본 키 — NOT NULL
  • Key (ORDER_DETAIL_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (QTY) — INT
  • (STATE) — ENUM
  • Field (REFUND_REASON) — VARCHAR
  • Field (CREATED_AT) — DATETIME
  • Field (UPDATED_AT) — DATETIME
  • Field

Untitled (R_COMMERCE_PG_INFO)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (ORDER_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (TOTAL_PRICE) — INT
  • Field (PAY_METHOD) — ENUM — 카드 퀵계좌이체 간편결제
  • Field (PG_TID) — VARCHAR
  • Field (PG_MID) — VARCHAR
  • Field (REGIST_DT) — DATETIME
  • Field (PAID_DATE) — DATETIME
  • Field

Untitled (R_COMMERCE_PG_DETAIL)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (PG_INFO_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ORDER_VENDOR_PK) — INT — 외래 키 → `.Key — NOT NULL
  • Field (STATE) — ENUM — APPROVE PARTIAL_CANCEL CANCEL REFUND
  • Field (AMOUNT) — INT
  • Field (CREATED_AT) — DATETIME
  • Field

Untitled (R_COMMERCE_ORDER_DETAIL_OPTION)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (ORDER_DETAIL_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ITEM_OPTION_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ITEM_VALUE_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (OPTION_INPUT_TEXT) — VARCHAR
  • Field (CREATED_AT) — DATETIME
  • Field

Untitled (R_COMMERCE_CART_DETAIL_OPTION)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (CART_DETAIL_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ITEM_OPTION_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ITEM_VALUE_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (OPTION_INPUT_TEXT) — VARCHAR
  • Field (CREATED_AT) — DATETIME
  • Field

Untitled (R_COMMERCE_CATEGORY_OPTION)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (CATEGORY_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (OPTION_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (DISPLAY_ORDER) — INT
  • Field (AFFECTS_STOCK) — ENUM — FIXED SELECT
  • Field

Untitled (R_COMMERCE_ITEM_FIXED_ATTR)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (ITEM_PK) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (OPTION_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (VALUE_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field

Untitled (R_COMMERCE_ITEM_OPTION_VALUE)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (ITEM_OPTION_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (OPTION_VALUE_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (IS_AVAILABLE) — CHAR
  • Field (PRICE_DELTA) — INT
  • Field (IS_DEFAULT) — CHAR
  • Field

Untitled (R_COMMERCE_SETTLEMENT_POLICY_SNAPSHOT)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (POLICY_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (VENDOR_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (COMMISION_RATE) — DOUBLE
  • Field (BANK_NAME) — VARCHAR
  • Field (ACCOUNT) — VARCHAR
  • Field (BANK_OWNER) — VARCHAR
  • Field (CREATED_AT) — DATETIME
  • Field

Untitled (R_COMMERCE_SETTLEMENT_DETAIL)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (SETTLEMENT_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ORDER_VENDOR_PK) — INT — 외래 키 → `.Key — NOT NULL
  • Key (PG_DETAIL_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (STATE) — ENUM
  • Field (CREATED_AT) — DATETIME
  • Field (UPDATED_AT) — DATETIME
  • Field (ITEM_SUBTOTAL) — INT
  • Field (SHIPPING_FEE) — INT
  • Field (TAX) — INT
  • Field (VENDOR_PAYABLE) — INT
  • Field (REFUND_AMOUNT) — INT
  • Field (COMMISION_AMOUNT) — INT
  • Field (PG_FEE_AMOUNT) — INT
  • Field (NET_LINE_AMOUNT) — INT
  • Field

Untitled (R_COMMERCE_SETTLEMENT)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (VENDOR_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (START_DATE) — DATE
  • Field (END_DATE) — DATE
  • Field (STATE) — ENUM
  • Field (ORDER_COUNT) — INT
  • Field (ITEM_SUBTOTAL_TOTAL) — INT — SUBTOTAL의 합
  • Field (SHIPPING_TOTAL) — INT
  • Field (TAX_TOTAL) — INT
  • Field (VENDOR_PAYABLE_TOTAL) — INT — 벤더에게 주어지는 진짜 총 금액
  • Field (REFUND_TOTAL) — INT
  • Field (COMMISION_TOTAL) — INT
  • Field (PG_FEE_TOTAL) — INT
  • Field (NET_PAYABLE) — INT — 실제 지급 예정액
  • Field (CURRENCY) — CHAR — KRW
  • Field (CREATED_AT) — DATETIME
  • Field (UPDATED_AT) — DATETIME
  • Field

Untitled (R_COMMERCE_SHIPMENT_ITEM)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (SHIPMENT_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ORDER_DETAIL_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (QTY) — INT
  • Field (CREATED_AT) — DATETIME
  • Field

Untitled (R_COMMERCE_SHIPMENT)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (ORDER_VENDOR_PK) — INT — 외래 키 → `.Key — NOT NULL
  • Field (CARRIER_CODE) — VARCHAR
  • Field (INVOICE_NO) — VARCHAR
  • Field (RECEIVER_TEL) — VARCHAR
  • Field (STATE) — ENUM — 배송준비 집화완료 배송중 지점도착 배송출발 배송완료
  • Field

Untitled (R_COMMERCE_CARRIER)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • (CARRIER_CODE) — VARCHAR — 택배사 코드
  • Field (ACTIVE_YN) — CHAR
  • Field (TRACK_URL_TPL) — VARCHAR — 조회 URL 템플릿
  • Field (NAME) — VARCHAR — 택배사이름
  • Field (REGIST_DT) — DATETIME
  • Field (UPDATE_DT) — DATETIME
  • Field (TEL_NO) — VARCHAR — 택배사 고객센터
  • Field

Untitled (R_COMMERCE_VENDOR_POLICY)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (VENDOR_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (COMMISION_RATE) — DOUBLE — 플랫폼 수수료
  • Field (SETTLE_CYCLE) — ENUM — DAY WEEK MONTH
  • Field (SETTLE_DETAIL) — VARCHAR — WEEK의 경우 요일 MONTH의 경우 날짜
  • Field (BANK_NAME) — VARCHAR
  • Field (ACCOUNT) — VARCHAR
  • Field (BANK_OWNER) — VARCHAR
  • Field (STATE) — ENUM — 승인대기 승인완료 정산중지
  • Field (VAT_RATE) — DOUBLE — 부가세 정책
  • Field

Untitled (R_COMMERCE_ITEM)

  • Key (PK) — int — 기본 키 — NOT NULL
  • Key (CATEGORY_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (VENDOR_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (BRAND_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (CREATE_MBER_NO) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (NAME) — VARCHAR
  • Field (CONTENT) — TEXT
  • Field (THUMBNAIL_IMG_PK) — INT
  • Field (REGIST_DT) — DATETIME
  • Field (STATE) — ENUM — 승인대기 판매중 일시중지 노출중단 제재
  • Field (CONTENT_IMG_PK) — INT
  • Field (PRICE) — INT — 정가
  • Field (REAL_PRICE) — INT — 할인가
  • Field (UNIT_PRICE) — INT
  • Field

Untitled (R_COMMERCE_ORDER_DETAIL)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (ORDER_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (STOCK_PK) — INT — 외래 키 → 재고관리.Key — NOT NULL
  • Key (ORDER_VENDOR_PK) — INT — 외래 키 → `.Key — NOT NULL
  • Key (ITEM_PK) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (QTY) — INT
  • Field (STATE) — ENUM — 주문완료 배송준비중 배송중 배송완료 픽업완료 환불요청 부분취소 환불완료 주문취소
  • Field (REGIST_DT) — DATETIME
  • Field (UPDATE_DT) — DATETIME
  • Field (UNIT_PRICE_SNAP) — INT — 결제 상품당 가격
  • Field (OPTION_HASH) — CHAR(64)
  • Field (OPTION_PRICE_SNAP) — INT
  • Field (SUBTOTAL) — INT — (UNIT_PRICE+OPTION_PRICE) * QTY
  • Field

Untitled (R_COMMERCE_ORDER)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (MBER_NO) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (ADDRESS_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (PRICE) — INT
  • Field (REGIST_DT) — DATETIME
  • Field (UPDATE_DT) — DATETIME
  • Field (ORDER_ID) — VARCHAR
  • Field (RECEIVE_MBER_PK) — INT
  • Field (TYPE) — ENUM — PICKUP DELIVER
  • Field

Untitled (R_COMMERCE_ADDRESS)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (MBER_NO) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (ADDRESS) — VARCHAR
  • Field (ORDER_NO) — INT
  • Field (NAME) — VARCHAR
  • Field (TEL_NO) — VARCHAR
  • Field (POST_NO) — VARCHAR
  • Field

Untitled (R_COMMERCE_ADMIN)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (MBER_NO) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (VENDOR_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (ID) — VARCHAR
  • Field (PASSWORD) — VARCHAR
  • Field (ROLE) — ENUM — OWNER MANAGER
  • Field

Untitled (R_COMMERCE_BRAND)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Field (NAME) — VARCHAR
  • Field

Untitled (R_COMMERCE_CART_DETAIL)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (CART_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (STOCK_PK) — INT — 외래 키 → 재고관리.Key — NOT NULL
  • Field (QTY) — INT
  • Field (CREATED_AT) — DATETIME
  • Field (UPDATED_AT) — DATETIME
  • Field (OPTION_HASH) — CHAR(64) — 추가옵션 조합 해쉬
  • Field

Untitled (R_COMMERCE_CART)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (MBER_NO) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (CREATED_AT) — DATETIME
  • Field (UPDATED_AT) — DATETIME
  • Field (STATE) — ENUM — ACTIVE ORDERED
  • Field

Untitled (MBER_INFO)

  • Key (MBER_NO) — INT — 기본 키 — NOT NULL
  • Field

Untitled (R_COMMERCE_VENDOR)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Field (NAME) — VARCHAR
  • Field (TYPE) — ENUM — 개인 법인
  • Field (REF_SELLER_ID) — VARCHAR — 내부적으로 생성하여 제공
  • Field (SELLER_ID) — VARCHAR — 토스에서 제공
  • Field (EMAIL) — VARCHAR
  • Field (TEL_NO) — VARCHAR
  • Field (BIZ_NO) — VARCHAR — 사업자 등록번호
  • Field

Untitled (R_COMMERCE_STOCK_OPTION)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (STOCK_PK) — INT — 외래 키 → 재고관리.Key — NOT NULL
  • Key (OPTION_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (VALUE_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field

Untitled (R_COMMERCE_CATEGORY)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Field (NAME) — VARCHAR
  • Field (PARENT_PK) — INT
  • Field (DEPTH) — INT
  • Field

Untitled (R_COMMERCE_ITEM_OPTION)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (ITEM_PK) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (OPTION_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (AFFECTS_STOCK) — ENUM — 재고에 영향을 주는지 여부
  • Field (IS_REQUIRED) — CHAR
  • Field (DISPLAY_ORDER) — INT
  • Field

Untitled (R_COMMERCE_OPTION_VALUE)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (OPTION_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (NAME) — VARCHAR
  • Field (DISPLAY_ORDER) — INT
  • Field

Untitled (R_COMMERCE_OPTION)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Field (NAME) — VARCHAR
  • Field (USE_AT) — CHAR
  • Field

` (R_COMMERCE_ORDER_VENDOR)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (ORDER_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (VENDOR_PK) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (STATE) — ENUM — 주문생성 결제확정 벤더 접수 배송중 취소요청 취소 반품요청 반품 정산완료 실패
  • Field (SUBTOTAL) — INT — 상품 합계
  • Field (SHIPPING_FEE) — INT
  • Field (TAX) — INT
  • Field (COUPON) — INT
  • Field (CREATED_AT) — DATETIME
  • Field (UPDATED_AT) — DATETIME
  • Field (VENDOR_PAYABLE) — INT — PG_DETAIL의 VENDOR_PRICE와 같은 값인데, 배송비, 부가세, 쿠폰을 모두 제외한 금액
  • Field (REAL_PRICE) — INT — 사용자의 실제 결제금액
  • Field (SUPPLY_PRICE) — INT
  • Field

재고관리 (R_COMMERCE_STOCK)

  • Key (PK) — INT — 기본 키 — NOT NULL
  • Key (ITEM_PK) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (QTY) — INT
  • Field (STATE) — ENUM — 입고예정 단종 품절
  • Field