YOOK
Tables (11)
ADMIN_ORDER (관리자)
- AORDER_NUM (주문관리번호) — NUMBER — Primary key — NOT NULL
- ORDER_NUM (주문번호) — NUMBER
- MEM_NUM (회원번호) — NUMBER
- AORDER_STATE (주문상태) — VARCHAR2
- AS_SDATE (신청날짜) — DATE
- AS_EDATE (완료날짜) — DATE
BASKET (장바구니)
- BASKET_NUM (장바구니번호) — NUMBER — Primary key — NOT NULL
- MEM_NUM (회원번호) — NUMBER — Foreign key → MEMBER.MEM_NUM — NOT NULL
- GOODS_NUM (상품번호) — NUMBER — Foreign key → GOODS.GOODS_NUM — NOT NULL
- GOODS_ATT_NO (상품속성번호) — NUMBER — Foreign key → GOODS_ATTRIBUTE.GOODS_ATT_NO — NOT NULL
- BASKET_AMOUNT (수량) — NUMBER
- BASKET_WEIGHT (중량) — NUMBER
- BASKET_CHECK (체크박스) — VARCHAR2
EVENT (이벤트)
- ET_NUM (이벤트 글번호) — NUMBER — Primary key — NOT NULL
- ET_TITLE (제목) — VARCHAR2
- ET_CONTENT (내용) — VARCHAR2
- ET_SD (이벤트 시작일) — DATE
- ET_FD (이벤트 종료일) — DATE
GOODS (상품)
- GOODS_NUM (상품번호) — NUMBER — Primary key — NOT NULL
- GOODS_NAME (상품이름) — VARCHAR2
- GOODS_CONTENT (상품설명) — VARCHAR2
- GOODS_PRICE (상품가격) — NUMBER
- GOODS_DATE (게시날짜) — DATE
- GOODS_COUNT (글조회수) — VARCHAR2
- GOODS_IMAGE (이미지) — VARCHAR2
- GOODS_CONTENTIMAGE (이미지2) — VARCHAR2
GOODS_ATTRIBUTE (상품속성)
- GOODS_ATT_NO (상품속성번호) — NUMBER — Primary key — NOT NULL
- GOODS_NUM (상품번호) — NUMBER — Foreign key → GOODS.GOODS_NUM — NOT NULL
- GOODS_TYPE (상품종류) — VARCHAR2
- GOODS_ATT_AMOUNT (재고) — NUMBER
- GOODS_WEIGHT (중량) — NUMBER
- GOODS_STATUS (상품상태) — NUMBER
MEMBER (회원정보)
- MEM_NUM (회원번호) — NUMBER — Primary key — NOT NULL
- MEM_GRADE (등급) — VARCHAR2
- MEM_ID (아이디) — VARCHAR2
- MEM_PW (비밀번호) — VARCHAR2
- MEM_NAME (이름) — VARCHAR2
- MEM_EMAIL (이메일) — VARCHAR2
- MEM_PHONE (전화번호) — VARCHAR2
- MEM_ZIPCODE (우편번호) — VARCHAR2
- MEM_ADDRESS1 (주소1) — VARCHAR2
- MEM_ADDRESS2 (주소2) — VARCHAR2
- MEM_JOINDATE (가입날짜) — DATE
- MEM_EMAILCK (이메일승인) — VARCHAR2
NOTICE (공지사항)
- NOTICE_NUM (글 번호) — NUMBER — Primary key — NOT NULL
- NOTICE_TITLE (제목) — VARCHAR2
- NOTICE_CONTENT (내용) — VARCHAR2
- NOTICE_COUNT (조회수) — NUMBER
- NOTICE_IMAGE (이미지) — VARCHAR2
ORDERS (주문)
- ORDER_NUM (주문번호) — NUMBER — Primary key — NOT NULL
- MEM_NUM (회원번호) — NUMBER — Foreign key → MEMBER.MEM_NUM — NOT NULL
- ORDER_DATE (주문일자) — DATE
- ORDER_PRICE (주문금액) — NUMBER
- ORDER_DCOST (배송비) — NUMBER
- ORDER_TCOST (최종결제) — NUMBER
- ORDER_DZIPCODE (배송우편번호) — VARCHAR2
- ORDER_DADD1 (배숭주소1) — VARCHAR2
- ORDER_DADD2 (배송주소2) — VARCHAR2
- ORDER_DMEMO (배송메모) — VARCHAR2
- ORDER_PAY_NAME (입금자명) — VARCHAR2
- ORDER_PAY_RBANK (환불계좌은행) — VARCHAR2
- ORDER_PAY_RACCOUNT (환불계좌번호) — VARCHAR2
ORDERS_DETAIL (주문상세)
- ORDER_DETAIL_NUM (주문상세번호) — NUMBER — Primary key — NOT NULL
- ORDER_NUM (주문번호) — NUMBER — Foreign key → ORDERS.ORDER_NUM — NOT NULL
- GOODS_NUM (상품번호) — NUMBER — Foreign key → GOODS.GOODS_NUM — NOT NULL
- BASKET_NUM (장바구니번호) — NUMBER — Foreign key → BASKET.BASKET_NUM — NOT NULL
- ORDER_DETAIL_AMOUNT (주문수량) — NUMBER
- ORDER_DETAIL_DATE (주문일자) — DATE
QNA (1:1 문의)
- QNA_NUM (문의글 번호) — NUMBER — Primary key — NOT NULL
- MEM_ID (아이디) — VARCHAR2
- QNA_TITLE (제목) — VARCHAR2
- QNA_CONTENT (내용) — VARCHAR2
- QNA_DATE (작성날짜) — DATE
- QNA_RTITLE (답변 제목) — VARCHAR2
- QNA_RCONTENT (답변 내용) — VARCHAR2
- QNA_RDATE (답변작성날짜) — DATE
- QNA_RSTATE (답변상태) — VARCHAR2
- QNA_PWD (글비밀번호) — VARCHAR2
- ITEM_NUM (상품번호) — VARCHAR2
- MEM_NAME (질문자이름) — VARCHAR2
- QNA_IMAGE (이미지) — VARCHAR2
REVIEW (리뷰)
- RE_NUM (리뷰글 번호) — NUMBER — Primary key — NOT NULL
- GOODS_NUM (상품번호2) — NUMBER — Foreign key → GOODS.GOODS_NUM — NOT NULL
- RE_TITLE (제목) — VARCHAR2
- RE_CONTENT (내용) — VARCHAR2
- RE_HIT (조회수) — NUMBER
- RE_DATE (작성일) — DATE
- RE_IMAGE (이미지) — VARCHAR2