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)