ORDER

Tables (8)

ORDERINFO (주문조회 2.0)

  • ordernum (주문번호) — NVARCHAR2(26) — Primary key — NOT NULL
  • order_date (주문일자) — DATE
  • is_member (회원 여부) — VARCHAR2(6)
  • start_price (최초 결제 금액) — NUMBER(11)
  • pay_price (주문 금액) — NUMBER(11)
  • Field

ORDERINFO_EXTENSION (할인, 추가금액)

    ORDERINFO_MEMO (관리자 메모)

    • memo_seq (Key) — NUMBER(10) — Primary key — NOT NULL
    • memo_seq1 (메모번호1) — NUMBER(10)
    • admin_id (담당자 아이디) — VARCHAR2(20) — NOT NULL

    ORDERINFO_PAYMENT (결제)

    • Key — Primary key — NOT NULL

    ORDERINFO_PAY_HISTORY (Untitled)

      ORDERINFO_PRODUCT (품목)

        ORDERINFO_PRODUCT_DELIVERYINFO (배송 정보)

          ORDERINFO_REFUND (환불 정보)