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) — 동