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