ABCMART

Tables (9)

TB_CARTS (장바구니)

  • CART_NO (장바구니번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT_DETAIL_NO (상품번호) — NUMBER — Foreign key → TB_PRODUCT_STOCKS.PRODUCT_DETAIL_NO — NOT NULL
  • MEMBER_NO (회원번호) — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
  • PRODUCT_AMOUNT (상품수량) — NUMBER

TB_MEMBERS (회원)

  • MEMBER_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NAME — VERCHAR2
  • MEMBER_ID (아이디) — VERCHAR2
  • MEMBER_PWD (비밀번호) — VERCHAR2
  • MEMBER_EMAIL (이메일) — VERCHAR2
  • MEMBER_TEL (전화번호) — VERCHAR2
  • MEMBER_ADDRESS (주소) — VERCHAR2
  • MEMBER_PCT (포인트) — NUMBER
  • MEMBER_REGISTERED_DATE (회원등록일) — DATE
  • MEMBER_DELETED (탈퇴) — VERCHAR2
  • MEMBER_DELETED_DATE (탈퇴날짜) — DATE

TB_ORDERS (주문)

  • ORDER_NO (주문번호) — NUMBER — Primary key — NOT NULL
  • MEMBER_NO (회원번호) — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
  • ORDER_STATUS (주문상태) — VERCHAR2
  • ORDER_DATE (주문날짜) — VERCHAR2
  • ORDER_TOTAL_PRICE (총 결제금액) — NUMBER
  • CANCEL_REASON (취소사유) — VERCHAR2
  • CANCEL_STATUS (취소상태) — VERCHAR2
  • CANCELED_DATE (취소날짜) — VERCHAR2

TB_ORDER_ITEM (주문상품)

  • ORDER_NO (주문번호) — NUMBER — Foreign key → TB_ORDERS.ORDER_NO — NOT NULL
  • PRODUCT_DETAIL_NO (재고번호) — NUMBER — Foreign key → TB_PRODUCT_STOCKS.PRODUCT_DETAIL_NO — NOT NULL
  • PRODUCT_AMOUNT (상품수량) — NUMBER
  • REVIEW_STAUTS (리뷰상태) — VERCHAR2

TB_PRODUCT (상품)

  • PRODUCT_NO (상품번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT_CATEGORY (카테고리)
  • PROUDCT_NAME (상품명) — VERCHAR2
  • PRODUCT_IMG (이미지) — VERCHAR2
  • PRODUCT_BRAND (브랜드) — VERCHAR2
  • PRODUCT_PRICE (가격) — NUMBER
  • PRODUCT_DISPRICE (할인가격) — NUMBER
  • PRODUCT_GENDER (성별) — VERCHAR2
  • PRODUCT_CREATED_DATE (등록일) — NUMBER

TB_PRODUCT_STOCKS (재고테이블)

  • PRODUCT_DETAIL_NO (재고번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT_NO (상품번호) — NUMBER — Foreign key → TB_PRODUCT.PRODUCT_NO — NOT NULL
  • PRODUCT_SIZE (사이즈) — NUMBER
  • PRODUCT_STORCK (수량) — NUMBER

TB_QNA (q&a)

  • QUESTION_NO (QNA번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT_NO (상품번호) — NUMBER — Foreign key → TB_PRODUCT.PRODUCT_NO — NOT NULL
  • MEMBER_NO (회원번호) — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
  • QUESTION_TITLE (제목) — VERCHAR2
  • QUESTION_CONTENT (내용) — VERCHAR2
  • QUESTION_DATE (등록일) — VERCHAR2
  • QUESTION_ANSWERED (답변여부) — VERCHAR2
  • ANSWERED_CONTENT (답변내용)

TB_REVIEWS (리뷰)

  • REVEIW_NO (리뷰번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT_DETAIL_NO (재고번호) — NUMBER — Foreign key → TB_PRODUCT_STOCKS.PRODUCT_DETAIL_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
  • REVIEW_CONTENT (리뷰내용) — VERCHAR2
  • REVIEW_LIKE_COUNT (좋아요) — NUMBERR
  • REVIEW_DATE (등록일) — SYSDATE
  • REVIEW_DELETED (삭제여부) — VERCHAR2

TB_REVIEW_LIKERS (좋아요)

  • MEMBER_NO (회원번호) — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
  • REVEIW_NO (리뷰번호) — Foreign key → TB_REVIEWS.REVEIW_NO — NOT NULL