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_DELIVERYINFO (배송 정보)