쇼핑몰프로젝트

테이블 (8)

INQUIRYBOARD (문의게시판)

  • INQUIRY_POSTNUM (게시글번호) — PK — 기본 키 — NOT NULL
  • MEMBER_ID (아이디) — FK — 외래 키 → SHOPPING_MEMBER.MEMBER_ID — NOT NULL
  • INQUIRY_GROUP (문의분류) — NN
  • MEMBER_NAME (이름) — NN
  • MEMBER_LEVEL (등급) — NN
  • INQUIRY_TITLE (제목) — NN
  • INQUIRY_CONTENT (내용) — NN
  • INQUIRY_IMG (이미지)
  • INQUIRY_REGDATE (게시등록일자) — NN
  • INQUIRY_SECRET (비밀글여부) — NN

ITEMBOARD (아이템게시판)

  • ITEM_CODE (상품코드) — PK — 기본 키 — NOT NULL
  • ITEM_POSTNUM (게시글번호) — NN
  • ITEM_SECTION (대분류) — NN
  • ITEM_GROUP (소분류) — NN
  • ITEM_TITLE (아이템제목) — NN
  • ITEM_CONTENT (아이템내용) — NN
  • ITEM_SAVEDMONEY (아이템적립금) — NN
  • ITEM_COLOR (컬러) — NN
  • ITEM_SIZE (사이즈) — NN
  • ITEM_PRICE (아이템가격) — NN
  • ITEM_NUM (아이탬갯수) — NN
  • ITEM_SENDDAY (당일발송여부) — NN
  • ITEM_HASHTAG (해시태그) — NN
  • ITEM_VIEWS (조회수) — NN
  • ITEM_MAINIMG (메인이미지) — NN
  • ITEM_THUMBNAILIMG (썸네일이미지) — NN
  • ITEM_CONTENTIMG (내용이미지) — NN
  • ORDER_SUMNUM (누적판매개수)
  • ITEM_REGDATE (게시등록일자) — NN

ITEMQUESTIONBOAD (상품문의게시판)

  • QUESTION_POSTNUM (게시글번호) — PK — 기본 키 — NOT NULL
  • MEMBER_ID (아이디) — FK — 외래 키 → SHOPPING_MEMBER.MEMBER_ID — NOT NULL
  • ITEM_CODE (상품코드) — FK — 외래 키 → ITEMBOARD.ITEM_CODE — NOT NULL
  • ITEM_POSTNUM (아이템게시글번호) — FK
  • MEMBER_NAME (이름) — NN
  • QUESTION_TITLE (제목) — NN
  • QUESTION_CONTENT (내용) — NN
  • QUESTION_SECRET (비밀글여부) — NN
  • QUESTION_REGDATE (게시등록일자) — NN
  • MEMBER_LEVEL (등급) — NN

NOTICEBOARD (공지게시판)

  • NOTICE_POSTNUM (게시글번호) — PK — 기본 키 — NOT NULL
  • MEMBER_ID (아이디) — FK — 외래 키 → SHOPPING_MEMBER.MEMBER_ID — NOT NULL
  • NOTICE_TITLE (제목) — NN
  • NOTICE_CONTENT (내용) — NN
  • NOTICE_REGDATE (게시등록일자) — NN
  • NOTICE_VIEWS (조회수) — NN
  • MEMBER_LEVEL (등급) — NN
  • MEMBER_NAME (이름) — NN

REVIEWBOARD (후기게시판)

  • REVIEW_POSTNUM (게시글번호) — PK — 기본 키 — NOT NULL
  • MEMBER_ID (아이디) — FK — 외래 키 → SHOPPING_MEMBER.MEMBER_ID — NOT NULL
  • ITEM_CODE (상품코드) — FK — 외래 키 → ITEMBOARD.ITEM_CODE — NOT NULL
  • ITEM_POSTNUM (아이템게시글번호) — FK
  • MEMBER_NAME (이름) — NN
  • REVIEW_TITLE (제목) — NN
  • REVIEW_CONTENT (내용) — NN
  • REVIEW_IMG (이미지)
  • REVIEW_LIKE (리뷰좋아요)
  • REVIEW_REGDATE (게시등록일자) — NN
  • MEMBER_LEVEL (등급) — NN

SHOPPINGBASKET (장바구니)

  • BASKET_POSTNUM (일련번호) — PK — 기본 키 — NOT NULL
  • MEMBER_ID (아이디) — FK — 외래 키 → SHOPPING_MEMBER.MEMBER_ID — NOT NULL
  • ITEM_CODE (상품코드) — FK — 외래 키 → ITEMBOARD.ITEM_CODE — NOT NULL
  • ORDER_NUM (상품갯수) — NN
  • MEMBER_NAME (이름) — NN
  • BASKET_REGDATE (생성일자) — NN

SHOPPING_MEMBER (회원)

  • MEMBER_ID (아이디) — PK — 기본 키 — NOT NULL
  • MEMBER_PW (비밀번호) — NN
  • MEMBER_NAME (이름) — NN
  • MEMBER_PHONE (전화번호) — NN
  • MEMBER_ADDRESS (주소) — NN
  • MEMBER_EMAIL (이메일) — NN
  • MEMBER_ENABLED (가입여부) — NN
  • MEMBER_LEVEL (등급) — NN
  • MEMBER_REGDATE (가입날짜) — NN
  • MEMBER_SAVEDMONEY (적립금)

SHOPPING_ORDER (주문)

  • ORDERNUMBER (주문번호) — PK — 기본 키 — NOT NULL
  • MEMBER_ID (아이디) — FK — 외래 키 → SHOPPING_MEMBER.MEMBER_ID — NOT NULL
  • ITEM_CODE (상품코드) — FK — 외래 키 → ITEMBOARD.ITEM_CODE — NOT NULL
  • MEMBER_NAME (이름) — NN
  • MEMBER_PHONE (전화번호) — NN
  • MEMBER_EMAIL (이메일) — NN
  • ORDER_NUM (상품갯수) — NN
  • ORDER_PRICE (총가격) — NN
  • GET_NAME (수령자이름) — NN
  • GET_PHONE (수령자번호) — NN
  • GET_ADDRESS (수령장소) — NN
  • ORDER_REGDATE (주문날짜) — NN