TEST1
Tables (9)
TB_CUST_COUPON
- CUST_CPN_SQ (PK) — NUMBER — Primary key — NOT NULL — 고객쿠폰일련번호
- CPN_ID (CHECK2) — NUMBER — NOT NULL — 쿠폰ID
- AVAIL_STDT (CHECK3) — DATE — NOT NULL — 유효시작일시
- AVAIL_EDDT (CHECK4) — DATE — NOT NULL — 유효종료일시
- PUB_REASON (CHECK5) — VARCHAR2(20 BYTE) — NOT NULL — 발행사유(공통코드G068)
- CUST_NO (CHECK6) — NUMBER — NOT NULL — 고객번호
- REG_DT (CHECK7) — DATE — NOT NULL — 등록일시
- UPD_NO (CHECK8) — NUMBER — NOT NULL — 수정자번호
- UPD_DT (CHECK9) — DATE — NOT NULL — 수정일시
- PUB_REASON_DTL (Field) — VARCHAR2(1000 BYTE) — 발행사유상세
- USED_DT (Field2) — DATE — 사용된일시
TB_CUST_POINT
- CUST_PNT_SQ (PK) — NUMBER — Primary key — NOT NULL — 고객포인트일련번호
- PNT_GB (CHECK2) — VARCHAR2 — NOT NULL — 포인트구분(공통코드G099:
- GV_PNT_AMT (CHECK3) — NUMBER — NOT NULL — 지급포인트
- US_PNT_AMT (CHECK4) — NUMBER — NOT NULL — 사용포인트
- RM_PNT_AMT (CHECK5) — NUMBER — NOT NULL — 잔여포인트
- EXP_BE_DT (CHECK6) — DATE — NOT NULL — 만료예정일시
- CUST_NO (CHECK7) — NUMBER — NOT NULL — 고객번호
- REG_DT (CHECK8) — DATE — NOT NULL — 등록일시
- UPD_NO (CHECK9) — NUMBER — NOT NULL — 수정자번호
- UPD_DT (CHECK10) — DATE — NOT NULL — 수정일시
- EXP_CMP_DT (Field) — DATE — 만료완료일시
TB_DELIVERY_ADDR (Untitled3)
- DELV_ADDR_SQ (PK) — NUMBER — Primary key
- REG_DT (CHECK2) — DATE
- UPD_DT (CHECK3) — DATE
- UPD_NO (CHECK4) — NUMBER — NOT NULL
- DELV_MEMO (Field) — VARCHAR2
- GIFT_MSG (Field2) — VARCHAR2
- RECIP_BASE_ADDR (Field3) — VARCHAR2
- RECIP_ZIPCODE (Field4) — VARCHAR2
- RECIP_TELNO (Field5) — VARCHAR2
- RECIP_PHNNO (Field6) — VARCHAR2
- RECIP_NM (Field7) — VARCHAR2
- RECIP_DTL_ADDR (Field8) — VARCHAR2
TB_ORDER (Untitled)
- ORD_NO (PK) — NUMBER — Primary key — NOT NULL
- MALL_GB (CHECK) — VARCHAR2
- ORD_DT (CHECK2) — DATE
- CUST_NO (CHECK3) — NUMBER
- SITE_CD (CHECK4) — VARCHAR2
- FRONT_GB (CHECK5) — VARCHAR2
- DISP_YN (CHECK6) — CHAR
- REG_DT (CHECK7) — DATE
- REG_NO (CHECK8) — NUMBER
- UPD_NO (CHECK9) — NUMBER
- UPD_DT (CHECK10) — DATE
- GIFT_RECEIP_NM (Field) — VARCHAR2
- ORD_EMAIL (Field2) — VARCHAR2
- ORD_TELNO (Field3) — VARCHAR2
- ORD_PHNNO (Field4) — VARCHAR2
- ORD_NM (Field5) — VARCHAR2
- CUST_GB (Field6) — VARCHAR2
- GIFT_RECEIP_PHNNO (Field7) — VARCHAR2
- PAY_DT (Field8) — DATE
TB_ORDER_CHANGE (CopyOfTB_ORDER_CHANGE)
- ORD_CHG_SQ — NUMBER — Primary key — NOT NULL — 주문변경일련번호
- CHG_GB (CHECK) — VARCHAR2(20 BYTE) — NOT NULL — 변경구분(공통코드G680)
- CHG_REASON (CHECK2) — VARCHAR2(20 BYTE) — NOT NULL — 변경사유(공통코드
- ADD_PAY_COST (CHECK3) — NUMBER — NOT NULL — 추가결제비용
- ADD_PAY_AMT (CHECK4) — NUMBER — NOT NULL — 추가결제금액
- CPN_DC_CNCL_AMT (CHECK5) — NUMBER — NOT NULL — 쿠폰할인취소금액
- PNT_DC_CNCL_AMT (CHECK6) — NUMBER — NOT NULL — 포인트할인취소금액
- MILEAGE_DC_CNCL_AMT (CHECK7) — NUMBER — NOT NULL — 마일리지할인취소금액
- COIN_DC_CNCL_AMT (CHECK8) — NUMBER — NOT NULL — 코인할인취소금액
- PRE_PNT_DC_CNCL_AMT (CHECK9) — NUMBER — NOT NULL — 선포인트할인취소금액
- DELV_FEE_CNCL_AMT (CHECK10) — NUMBER — NOT NULL — 배송비취소금액
- RTN_DELV_FEE_AMT (CHECK11) — NUMBER — NOT NULL — 반품배송비금액
- WD_INVOICE_SEND_YN (CHECK12) — VARCHAR2(30 BYTE) — NOT NULL — 회수송장전송여부
- SWT_TRC_SEND_YN (CHECK13) — CHAR(1 BYTE) — NOT NULL — 스윗트래커전송여부
- WD_BF_SEND_YN (CHECK14) — CHAR(1 BYTE) — NOT NULL — 선발송여부
- DISP_YN (CHECK15) — CHAR(1 BYTE) — NOT NULL — 표시여부
- REG_NO (CHECK16) — NUMBER — NOT NULL — 등록자번호
- REG_DT (CHECK17) — DATE — NOT NULL — 등록일시
- UPD_NO (CHECK18) — NUMBER — NOT NULL — 수정자번호
- UPD_DT (CHECK19) — VARCHAR2(20 BYTE) — NOT NULL — 수정일시
- CHG_MEMO (Field) — VARCHAR2(1000 BYTE) — 변경메모
- WD_GB (Field2) — VARCHAR2(1 BYTE) — 회수구분
- WD_TARGET_YN (Field3) — CHAR(1 BYTE) — 회수지시대상여부
- CHGER_NM (Field4) — VARCHAR2(50 BYTE) — 변경자명
- CHGER_PHNNO (Field5) — VARCHAR2(20 BYTE) — 변경자휴대전화번호
- CHGER_TELNO (Field6) — VARCHAR2(20 BYTE) — 변경자전화번호
- CHGER_EMAIL (Field7) — VARCHAR2(100 BYTE) — 변경자이메일
- CHGER_ZIPCODE (Field8) — VARCHAR2(6 BYTE) — 변경자우편번호
- CHGER_BASE_ADDR (Field9) — VARCHAR2(200 BYTE) — 변경자기본주소
- CHGER_DTL_ADDR (Field10) — VARCHAR2(200 BYTE) — 변경자상세주소
- CHGER_RTN_MEMO (Field11) — VARCHAR2(1000 BYTE) — 변경자반품메모(수거시요청사항)
- WD_INVOICE_NO (Field12) — VARCHAR2(30 BYTE) — 회수송장번호
- SHIP_COMP_CD (Field13) — VARCHAR2(20 BYTE) — 배송업체코드(배송업체)
- WD_STDT (Field14) — DATE — 회수시작일시
- WD_EDDT (Field15) — DATE — 회수종료일시
- WD_SHIP_STATE (Field16) — VARCHAR2(20 BYTE) — 배송업체회수상태(공통코드G320)
- WD_REASON_CD (Field17) — VARCHAR2(20 BYTE) — 미회수사유코드(공통코드G321
- WD_STATE_DT (Field18) — DATE — 회수상태수정일시
TB_ORDER_CHANGE_DETAIL (CopyOfTB_ORDER_CHANGE_DETAIL)
- ORD_CHG_SQ (PK) — NUMBER — Primary key — NOT NULL — 주문변경일련번호(주문변경)
- ORD_DTL_NO (PK2) — NUMBER — Primary key — NOT NULL — 주문상세번호(주문상세)
- CHG_QTY (CHECK) — NUMBER — NOT NULL — 변경수량
- CHG_STAT (CHECK2) — VARCHAR2(20 BYTE) — NOT NULL — 변경상태(공통코드G685)
- RN_DC_CNCL_AMT (CHECK3) — NUMBER — NOT NULL — 즉시할인쿠폰반환금액
- GOODS_CPN_DC_CNCL_AMT (CHECK4) — NUMBER — NOT NULL — 상품할인쿠폰반환금액
- DEL_YN (CHECK5) — CHAR(1 BYTE) — NOT NULL — 삭제여부
- REG_NO (CHECK6) — NUMBER — NOT NULL — 등록자번호
- REG_DT (CHECK7) — DATE — NOT NULL — 등록일시
- UPD_NO (CHECK8) — NUMBER — NOT NULL — 수정자번호
- UPD_DT (CHECK9) — VARCHAR2(20 BYTE) — NOT NULL — 수정일시
- CHG_REASON (Field) — VARCHAR2(20 BYTE) — 변경사유(공통코드
- CHG_MEMO (Field2) — VARCHAR2(1000 BYTE) — 변경메모
- RTN_IMG_NM1 (Field3) — VARCHAR2(100 BYTE) — 반품이미지명1(반품
- RTN_IMG_NM2 (Field4) — VARCHAR2(100 BYTE) — 반품이미지명2(반품
- CHG_ORD_DTL_NO (Field5) — NUMBER — 교환주문상세번호(주문상세).
- WH_MEMO (Field6) — VARCHAR2(1000 BYTE) — 물류메모
- COMPLETE_DT (Field7) — DATE — 완료일시
- WD_CONFIRM_YN (Field8) — CHAR(1 BYTE) — 클레임상세단위_회수컨펌여부
TB_ORDER_DETAIL (Untitled2)
- ORD_DTL_NO (PK) — NUMBER — Primary key — NOT NULL
- ORD_NO (CHECK) — NUMBER — Foreign key → TB_ORDER.ORD_NO — NOT NULL
- ORD_EXCH_GB (CHECK2) — CHAR
- ORD_DTL_STAT (CHECK3) — VARCHAR2
- SUPPLY_COMP_CD (CHECK4) — VARCHAR2
- GOODS_CD (CHECK5) — VARCHAR2
- OPT_CD (CHECK6) — VARCHAR2
- GOODS_TYPE (CHECK7) — VARCHAR2
- LIST_PRICE (CHECK8) — NUMBER
- CURR_PRICE (CHECK9) — NUMBER
- DC_RATE (CHECK10) — NUMBER
- OPT_ADD_PRICE (CHECK11) — NUMBER
- ORD_QTY (CHECK12) — NUMBER
- ORD_AMT (CHECK13) — NUMBER
- CNCL_RTN_QTY (CHECK14) — NUMBER
- CNCL_RTN_AMT (CHECK15) — NUMBER
- RN_DC_AMT (CHECK16) — NUMBER
- GOODS_CPN_DC_AMT (CHECK17) — NUMBER
- CART_CPN_DC_AMT (CHECK18) — NUMBER
- BURDEN_RATE (CHECK19) — NUMBER
- PNT_GB (CHECK20) — VARCHAR2
- PNT_DC_AMT (CHECK21) — NUMBER
- PRE_PNT_DC_AMT (CHECK22) — NUMBER
- SAVE_PNT_AMT (CHECK23) — NUMBER
- REAL_ORD_AMT (CHECK24) — NUMBER
- CHANGEABLE_YN (CHECK25) — CHAR
- CHANGE_FEE_FREE_YN (CHECK26) — CHAR
- RETURNABLE_YN (CHECK27) — CHAR
- RETURNAVLE_FEE_FREE_YN (CHECK28) — CHAR
- SOLDOUT_YN (CHECK29) — CHAR
- DELV_ADDR_SQ (CHECK30) — NUMBER
- DELV_FEE_CD (CHECK31) — VARCHAR2
- GIFT_PACK_YN (CHECK32) — CHAR
- GIFT_STAT (CHECK33) — VARCHAR2
- DELV_ASSIGN_STAT (CHECK34) — CHAR
- INVOICE_SEND_YN (CHECK35) — CHAR
- SELF_FEE_RATE (CHECK36) — NUMBER
- REG_NO (CHECK37) — NUMBER
- REG_DT (CHECK38) — DATE
- UPD_NO (CHECK39) — NUMBER
- UPD_DT (Field) — DATE
- BENEFIT_YN (Field2) — CHAR
- ORG_ORD_DTL_NO (Field3) — NUMBER
- DEAL_GOODS_CD (Field4) — VARCHAR2
- OPT_CD1 (Field5) — VARCHAR2
- OPT_CD2 (Field6) — VARCHAR2
- FORMAL_GB (Field7) — VARCHAR2
- RN_CPN_SQ (Field8) — NUMBER
- GOODS_CPN_SQ (Field9) — NUMBER
- CART_CPN_SQ (Field10) — NUMBER
- VENDOR_ID (Field11) — VARCHAR2
- EXTMALL_ID (Field12) — VARCHAR2
- AGENT_ORDER_ID (Field13) — VARCHAR2
- EXTMALL_ORDER_ID (Field14) — VARCHAR2
- SOLDOUT_MEMO (Field15) — VARCHAR2
- SOLDOUT_REG_NO (Field16) — VARCHAR2
- SOLDOUT_REG_DT (Field17) — DATE
- DELV_LOC_CD (Field18) — VARCHAR2
- DELV_ASSIGN_DT (Field19) — DATE
- DSTRBT_NOTE (Field20) — VARCHAR2
- … +10
TB_PAYMENT
- PAY_SQ (PK) — NUMBER — Primary key — NOT NULL — 결제일련번호
- PAY_AMT (CHECK2) — NUMBER(*,0) — NOT NULL — 결제금액.
- PG_CPN_AMT (CHECK3) — NUMBER(*,0) — NOT NULL — PG쿠폰금액
- PAY_GB (CHECK4) — CHAR(1 BYTE) — NOT NULL — 결제구분(O:주문시결제
- PAY_STAT (CHECK5) — VARCHAR2(20 BYTE) — NOT NULL — 결제상태(공통코드G016)
- CARD_PCABLE_YN (CHECK6) — CHAR(1 BYTE) — NOT NULL — 부분취소가능여부
- ESCROW_YN (CHECK7) — CHAR(1 BYTE) — NOT NULL — 에스크로여부
- PAY_MEANS (CHECK8) — VARCHAR2(20 BYTE) — NOT NULL — 결제수단(공통코드G014)
- REG_DT (CHECK9) — DATE — NOT NULL — 등록일시
- UPD_NO (CHECK10) — NUMBER — NOT NULL — 수정자번호
- UPD_DT (CHECK11) — DATE — NOT NULL — 수정일시
- ORD_NO (Field) — NUMBER — 주문번호(주문)
- PAY_DT (Field2) — DATE — 결제일시
- PG_GB (Field3) — VARCHAR2(20 BYTE) — PG구분(공통코드G015)
- PG_TID (Field4) — VARCHAR2(100 BYTE) — PG거래ID
- PG_TRADE_NO (Field5) — VARCHAR2(50 BYTE) — PG거래번호(승인번호)
- PG_SHOP_ID (Field6) — VARCHAR2(20 BYTE) — PG가맹점ID
- PG_SHOP_KEY (Field7) — VARCHAR2(20 BYTE) — PG가맹점KEY
- CARD_TYPE (Field8) — VARCHAR2(1 BYTE) — PG카드유형(Y:체크카드
- CARD_KIND (Field9) — VARCHAR2(5 BYTE) — 카드종류.
- CARD_BANK (Field10) — VARCHAR2(10 BYTE) — 카드발급은행.
- CARD_CD (Field11) — VARCHAR2(10 BYTE) — 카드발급사코드.
- CARD_NM (Field12) — VARCHAR2(50 BYTE) — 카드명.
- COM_CARD_CD (Field13) — VARCHAR2(20 BYTE) — 카드공통코드(공통코드G050)
- CARD_MIPS (Field14) — VARCHAR2(2 BYTE) — 카드할부개월수.
- VA_NO (Field15) — VARCHAR2(20 BYTE) — 가상계좌번호.
- VA_NM (Field16) — VARCHAR2(100 BYTE) — 가상계좌예금주명.
- VA_BANK (Field17) — VARCHAR2(20 BYTE) — 가상계좌은행(공통코드G940).
- VA_DEADLINE (Field18) — DATE — 무통장입금마감일시.
- TELECOM (Field19) — VARCHAR2(3 BYTE) — 통신사.
- CASH_AUTH_NO (Field20) — VARCHAR2(20 BYTE) — 현금영수증
- CASH_TRADE_NO (Field21) — VARCHAR2(20 BYTE) — 현금영수증
- ORD_CHG_SQ (Field22) — NUMBER — 주문변경일련번호(주문변경)
TB_REFUND (CopyOfTB_REFUND)
- ORD_NO (PK) — NUMBER — Primary key — NOT NULL — 주문번호(주문)
- PAY_SQ (PK2) — NUMBER — Primary key — NOT NULL — 결제일련번호(결제)
- ORD_CHG_SQ (PK3) — NUMBER — Primary key — NOT NULL — 주문변경일련번호(주문변경)
- REFUND_AMT (CHECK) — NUMBER — NOT NULL — 환불금액
- RF_RN_DC_AMT (CHECK2) — NUMBER — NOT NULL — 환불즉시할인쿠폰금액
- RF_GOODS_CPN_AMT (CHECK3) — NUMBER — NOT NULL — 환불상품쿠폰할인금액
- RF_CART_CPN_AMT (CHECK4) — NUMBER — NOT NULL — 환불장바구니쿠폰할인금액
- RF_DELV_CPN_AMT (CHECK5) — NUMBER — NOT NULL — 환불배송비쿠폰할인금액
- RF_PNT_AMT (CHECK6) — NUMBER — NOT NULL — 환불포인트할인금액
- RF_PRE_PNT_AMT (CHECK7) — NUMBER — NOT NULL — 환불선포인트할인금액
- RF_CNCL_AMT (CHECK8) — NUMBER — NOT NULL — 환불상품취소금액
- RF_DELIVERY_FEE (CHECK9) — NUMBER — NOT NULL — 환불배송비
- RF_REAL_CNCL_AMT (CHECK10) — NUMBER — NOT NULL — 환불금액(배송비제외)
- REG_NO (CHECK11) — NUMBER — NOT NULL — 등록자번호
- REG_DT (CHECK12) — DATE — NOT NULL — 등록일시
- RA_NO (Field) — VARCHAR2(200 BYTE) — 환불계좌번호_암호화.
- RA_BANK (Field2) — VARCHAR2(20 BYTE) — 환불계좌은행(공통코드G940).
- RA_NM (Field3) — VARCHAR2(50 BYTE) — 환불계좌예금주명