커머스
테이블 (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