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) — 환불계좌예금주명