test

Tables (19)

AS_LIST

  • AS_NO — NUMBER — AS번호
  • AS_GUBUN — CHAR(1) — 교환환불구분
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — 회원번호
  • AS_TITLE — VARCHAR2(100) — 요청제목
  • AS_CONTENT — VARCHAR2(4000) — 요청내용
  • ORDER_NO — NUMBER — Foreign key → ORDER_LIST.ORDER_NO — 주문번호
  • ORDER_DETAIL_NO — NUMBER — Foreign key → ORDER_DETAIL.ORDER_DETAIL_NO — 주문디테일번호
  • AS_STATE — CHAR(1) — AS진행상태
  • AS_SDATE — DATE — AS신청날짜
  • AS_EDATE — DATE — AS완료날짜
  • ORDER_STATE — VARCHAR2(20)

BASKET

  • BASKET_NO — NUMBER — 장바구니번호
  • MEMBER_NO — NUMBER — 회원번호
  • GOODS_NO — NUMBER — Foreign key → GOODS.GOODS_NO — 상품번호
  • GOODS_ATT_NO — NUMBER — Foreign key → GOODS_ATTRIBUTE.GOODS_ATT_NO — 상품속성번호
  • BASKET_GOODS_AMOUNT — NUMBER — 상품수량
  • BASKET_DATE — DATE — 장바구니담은날짜
  • ORDER_COLOR — VARCHAR2(100)
  • ORDER_SIZE — VARCHAR2(100)
  • GUBUN — CHAR(1)

COUPON

  • COUPON_NO — NUMBER — 쿠폰번호
  • COUPON_ID — VARCHAR2(100) — 쿠폰명
  • COUPON_VALUE — VARCHAR2(100) — 쿠폰값
  • COUPON_S_VALIDITY — DATE — 쿠폰시작일자
  • COUPON_E_VALIDITY — DATE — 쿠폰종료일자

COUPON_STATUS

  • COUPON_STATUS_NO — NUMBER — 쿠폰현황번호
  • COUPON_NO — NUMBER — Foreign key → COUPON.COUPON_NO — 쿠폰번호
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — 회원번호
  • COUPON_USE_STATE — CHAR(1) — 쿠폰사용여부
  • COUPON_ISSUE_DATE — DATE — 쿠폰지급날짜
  • COUPON_USE_DATE — DATE — 쿠폰사용날짜

GOODS

  • GOODS_NO — NUMBER — 상품번호
  • GOODS_CATEGORY — VARCHAR2(100) — 상품
  • GOODS_NAME — VARCHAR2(200) — 상품명
  • GOODS_CONTENT — VARCHAR2(4000) — 상세정보
  • GOODS_ORIGIN_PRICE — NUMBER — 원가
  • GOODS_SELL_PRICE — NUMBER — 판매가
  • GOODS_SALE_PRICE — NUMBER — 할인판매가
  • GOODS_DATE — DATE — 상품등록일
  • GOODS_KEYWORD — VARCHAR2(100) — 키워드
  • GOODS_READCNT — NUMBER — 상품조회수
  • GOODS_PICK — VARCHAR2(100) — 상품표출
  • GOODS_THUMBNAIL — VARCHAR2(1000) — 썸네일사진
  • GUBUN — CHAR(1) — 삭제구분

GOODS_ATTRIBUTE

  • GOODS_ATT_NO — NUMBER — 상품속성번호
  • GOODS_NO — NUMBER — Foreign key → GOODS.GOODS_NO — 상품번호
  • GOODS_ATT_SIZE — VARCHAR2(1000) — 사이즈
  • GOODS_ATT_COLOR — VARCHAR2(100) — 색상
  • GOODS_ATT_AMOUNT — NUMBER — 수량
  • GOODS_ATT_DISPLAY — CHAR(1) — 출력여부

GOODS_IMAGE

  • GOODS_IMAGE_NUM — NUMBER
  • GOODS_NO — NUMBER — Foreign key → GOODS.GOODS_NO
  • GOODS_IMAGE_ORG — VARCHAR2(1000)
  • GOODS_IMAGE_STD — VARCHAR2(1000)

GOODS_LIKE

  • LIKE_NO — NUMBER — 찜하기번호
  • GOODS_NO — NUMBER — Foreign key → GOODS.GOODS_NO — 상품번호
  • MEMBER_NO — NUMBER — 회원번호
  • LIKE_DATE — DATE — 찜하기날짜
  • LIKE_DELETE — CHAR(1) — 삭제여부

GOODS_QNA

  • GOODS_QNA_NO — NUMBER — 상품문의번호
  • GOODS_NO — NUMBER — Foreign key → GOODS.GOODS_NO — 상품번호
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — 회원번호
  • GOODS_QNA_LEVEL — NUMBER — 답변레벨
  • GOODS_QNA_TITLE — VARCHAR2(100) — 제목
  • GOODS_QNA_CONTENT — VARCHAR2(4000) — 내용
  • GOODS_QNA_DATE — DATE — 등록일자
  • GOODS_QNA_SECRET — CHAR(1) — 비밀글여부
  • MEMBER_NAME — VARCHAR2(100)
  • GOODS_QNA_AN — VARCHAR2(30)

MEMBER

  • MEMBER_NO — NUMBER — 회원번호
  • MEMBER_ID — VARCHAR2(100) — 회원ID
  • MEMBER_PASSWD — VARCHAR2(100) — 비밀번호
  • MEMBER_NAME — VARCHAR2(100) — 이름
  • MEMBER_BIRTH — DATE — 생년월일
  • MEMBER_EMAIL — VARCHAR2(100) — 이메일
  • MEMBER_PHONE — VARCHAR2(100) — 핸드폰
  • MEMBER_ZIPCODE — VARCHAR2(100) — 우편번호
  • MEMBER_ADDR1 — VARCHAR2(100) — 주소
  • MEMBER_ADDR2 — VARCHAR2(100) — 상세주소
  • MEMBER_DATE — DATE — 가입날짜
  • MEMBER_GRADE — VARCHAR2(100) — 등급
  • MEMBER_TOTAL — NUMBER — 총결제금액
  • MEMBER_LOG — DATE — 마지막접속일
  • EMAIL_AGREE — CHAR(1) — Email수신여부
  • SMS_AGREE — CHAR(1) — SMS수신여부
  • MEMBER_DELETE — CHAR(1) — 삭제여부

NOTICE

  • NOTICE_NO — NUMBER — 공지번호
  • NOTICE_GUBUN — CHAR(1) — 구분
  • NOTICE_TITLE — VARCHAR2(100) — 제목
  • NOTICE_CONTENT — VARCHAR2(4000) — 내용
  • NOTICE_DATE — DATE — 등록일자
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — 회원번호

ORDER_DETAIL

  • ORDER_DETAIL_NO — NUMBER — 주문디테일번호
  • ORDER_NO — NUMBER — Foreign key → ORDER_LIST.ORDER_NO — 주문번호
  • GOODS_NO — NUMBER — Foreign key → GOODS.GOODS_NO — 상품번호
  • GOODS_ATT_NO — NUMBER — Foreign key → GOODS_ATTRIBUTE.GOODS_ATT_NO — 상품속성번호
  • ORDER_DETAIL_PRICE — NUMBER — 상품별가격
  • ORDER_DETAIL_COLOR — VARCHAR2(20) — 주문상품색상
  • ORDER_DETAIL_SIZE — VARCHAR2(20) — 주문상품사이즈
  • ORDER_DETAIL_AMOUNT — NUMBER — 주문상품수량
  • COUPON_NO — NUMBER — Foreign key → COUPON.COUPON_NO — 사용쿠폰번호
  • COUPON_DISCOUNT — NUMBER — 쿠폰할인값
  • ORDER_DISCOUNT_APPLY — NUMBER — 할인적용최종결제가
  • ORDER_DETAIL_SAVE_POINT — NUMBER — 적립포인트
  • ORDER_DETAIL_STATE — VARCHAR2(20)

ORDER_LIST

  • ORDER_NO — NUMBER — 주문번호
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — 회원번호
  • ORDER_NAME — VARCHAR2(20) — 수령인
  • ORDER_ZIPCODE — NUMBER — 수령인
  • ORDER_ADDR1 — VARCHAR2(100) — 수령인
  • ORDER_ADDR2 — VARCHAR2(100) — 수령인
  • ORDER_PHONE — NUMBER — 수령인
  • ORDER_PAY_NAME — VARCHAR2(20) — 입금인
  • ORDER_PAY_OPTION — VARCHAR2(20) — 결제방법
  • ORDER_PAY_BANK — VARCHAR2(20) — 입금
  • ORDER_DATE — DATE — 주문날짜
  • ORDER_TOTAL_ORDER_PRICE — NUMBER — 총
  • ORDER_TOTAL_PAY_PRICE — NUMBER — 총
  • ORDER_STATE — VARCHAR2(20) — 주문진행상태
  • ORDER_USE_POINT — NUMBER — 사용포인트
  • ORDER_SAVE_POINT — NUMBER — 적립포인트
  • ORDER_FEE — NUMBER — 배송비
  • ORDER_EXPRESS — VARCHAR2(20)

POINT

  • POINT_NO — NUMBER — 포인트번호
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — 회원번호
  • POINT_VAL — NUMBER — 포인트(금액)
  • POINT_SAVE_DATE — DATE — 적립날짜
  • POINT_USE_DATE — DATE — 사용날짜
  • POINT_TOTAL — NUMBER — 총

QNA

  • QNA_NO — NUMBER — QnA번호
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — 회원번호
  • QNA_NAME — VARCHAR2(20) — 이름
  • QNA_LEVEL — NUMBER — 답변레벨
  • QNA_CATEGORY — NUMBER — 카테고리
  • QNA_TITLE — VARCHAR2(100) — 제목
  • QNA_CONTENT — VARCHAR2(4000) — 내용
  • QNA_DATE — DATE — 등록일자
  • QNA_SECRET — CHAR(1) — 비밀글여부
  • QNA_PASSWD — VARCHAR2(20) — 비밀번호
  • QNA_AN — VARCHAR2(30)

REVIEW

  • REVIEW_NO — NUMBER — 상품후기번호
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — 회원번호
  • ORDER_NO — NUMBER — Foreign key → ORDER_LIST.ORDER_NO — 주문번호
  • ORDER_DETAIL_NO — NUMBER — Foreign key → ORDER_DETAIL.ORDER_DETAIL_NO — 주문디테일번호
  • REVIEW_TITLE — VARCHAR2(50) — 후기제목
  • REVIEW_CONTENT — VARCHAR2(4000) — 후기내용
  • REVIEW_RATING — NUMBER — 상품평점
  • REVIEW_DATE — DATE — 후기등록일자
  • GOODS_NO — NUMBER — Foreign key → GOODS.GOODS_NO
  • REVIEW_READCNT — NUMBER
  • REVIEW_IMG — VARCHAR2(1000)
  • MEMBER_NAME — VARCHAR2(100)

REVIEW_IMAGE

  • REVIEW_IMAGE_NUM — NUMBER
  • GOODS_NO — NUMBER — Foreign key → GOODS.GOODS_NO
  • REVIEW_IMAGE_ORG — VARCHAR2(1000)
  • REVIEW_IMAGE_STD — VARCHAR2(1000)

UPLOAD

  • UPLOAD_NO — NUMBER
  • GOODS_NO — NUMBER
  • REVIEW_NO — NUMBER
  • UPLOAD_ORIGIN_NAME — VARCHAR2(1000)
  • UPLOAD_SAVE_NAME — VARCHAR2(1000)
  • UPLOAD_SIZE — VARCHAR2(1000)
  • UPLOAD_DELETE — CHAR(1)

ZIPCODE

  • ZIPCODE_NO — VARCHAR2(10) — 우편코드
  • ZIPCODE_SIDO — VARCHAR2(200) — 시도
  • ZIPCODE_SIGUN — VARCHAR2(200) — 시군
  • ZIPCODE_ROAD — VARCHAR2(200) — 도로명
  • ZIPCODE_BNO — VARCHAR2(200) — 건물번호
  • ZIPCODE_CODE — VARCHAR2(200) — 법정동코드
  • ZIPCODE_DONG — VARCHAR2(200) — 동