jwshop

Tables (6)

Deliveries (배송정보)

  • ORDER_NO (주문번호) — NUMBER — Primary key — NOT NULL
  • ORDER_ITEM_NO (주문상품번호) — NUMBER — Primary key — NOT NULL
  • DELIVERY_STATUS (배송상태) — VARCHAR2(2)
  • DELIVERY_STATUS_DATE (상태일자) — VARCHAR2(14)
  • REMARK (비고) — VARCHAR2(400)
  • IN_DATE (입력일자) — VARCHAR2(14)
  • UP_DATE (수정일자) — VARCHAR2(14)

Items (상품)

  • ITEM_NO (상품번호) — NUMBER — Primary key — NOT NULL
  • CATEGORY (상품구분) — VARCHAR2(3)
  • ITEM_NAME (상품이름) — VARCHAR2(50)
  • PRICE (가격) — VARCHAR2(14)
  • HIT (조회) — VARCHAR2(14)
  • LIKE (찜) — VARCHAR2(14)
  • IN_DATE (입력일자) — VARCHAR2(14)
  • UP_DATE (수정일자) — VARCHAR2(14)

OrderItems (주문상품)

  • ORDER_NO (주문번호) — NUMBER — Primary key — NOT NULL
  • ORDER_ITEM_NO (주문상품번호) — NUMBER — Primary key — NOT NULL
  • ORDER_COUNT (주문수량) — NUMBER
  • ORDER_PRICE (주문가격) — VARCHAR2(14)
  • TOTAL_PRICE (총 가격) — VARCHAR2(14)
  • IN_DATE (입력일자) — VARCHAR2(14)
  • UP_DATE (수정일자) — VARCHAR2(14)

Orders (주문)

  • ORDER_NO (주문번호) — NUMBER — Primary key — NOT NULL
  • MEMBER_ID (회원아이디) — VARCHAR2(20) — NOT NULL
  • SEQ (순번) — NUMBER — NOT NULL
  • ORDER_DATE (주문일자) — VARCHAR2(8)
  • PRICE (주문가격) — VARCHAR2(10)
  • IN_DATE (입력일자) — VARCHAR2(14)
  • UP_DATE (수정일자) — VARCHAR2(14)

Users (사용자)

  • MEMBER_ID (회원아이디) — VARCHAR2(20) — Primary key — NOT NULL — 회원아이디
  • PASSWORD (패스워드) — VARCHAR2(128)
  • NAME (이름) — VARCHAR2(10)
  • EMAIL (이메일) — VARCHAR2(30)
  • SEX (성별) — VARCHAR(2)
  • MEMBER_GRADE (회원등급) — VARCHAR2(2)
  • SIGN_UP_DATE (가입일자) — VARCHAR2(8)
  • IN_DATE (입력일자) — VARCHAR2(14)
  • UP_DATE (수정일자) — VARCHAR2(14)

address (배송지)

  • MEMBER_ID (회원아이디) — VARCHAR2(20) — Primary key — NOT NULL
  • SEQ (순번) — NUMBER — Primary key — NOT NULL
  • ADDRESS (주소) — VARCHAR2(100)
  • MAIN_YN (주배송지여부) — VARCHAR2(2)
  • TEL (연락처) — VARCHAR(12)
  • NAME (수령인) — VARCHAR2(10)
  • IN_DATE (입력일자) — VARCHAR2(14)
  • UP_DATE (수정일자) — VARCHAR2(14)