캠핑1

테이블 (12)

CART

  • CART_ID — NUMBER — 기본 키 — NOT NULL
  • QUANTITY — NUMBER
  • MEMBER_ID — VARCHAR2(50) — 외래 키 → MEMBER.Key — NOT NULL
  • PRODUCT_ID (PRODUCT_ID2) — NUMBER — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL

CATEGORY

  • CATEGORY_ID — NUMBER — 기본 키 — NOT NULL
  • NAME — VARCHAR2(100)
  • DESCRIPTION — VARCHAR2(200)

GRADE

  • GRADE_ID — NUMBER — 기본 키 — NOT NULL
  • GRADE_NAME — VARCHAR2(50)
  • CRITERIA_COUNT — NUMBER
  • BENEFIT_DESCRIPTION — VARCHAR2(200)

MEMBER

  • Key (MEMBER_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • PASSWORD — VARCHAR2(100)
  • NAME — VARCHAR2(100)
  • BIRTH — DATE
  • EMAIL — VARCHAR2(100)
  • PHONE — VARCHAR2(20)
  • ADDRESS — VARCHAR2(200)
  • GRADE_ID — NUMBER
  • RECOMMEND_ID — VARCHAR2(50)
  • MARKETING_AGREE — CHAR(1)
  • SOCIAL_TYPE — VARCHAR2(20)
  • STATUS — CHAR(1)
  • CREATED_AT — DATE
  • GRADE_ID (GRADE_ID2) — NUMBER — 외래 키 → GRADE.GRADE_ID — NOT NULL

ORDERS

  • ORDER_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50)
  • ORDER_DATE — DATE
  • STATUS — VARCHAR2(20)
  • TOTAL_PRICE — NUMBER
  • USED_POINT — NUMBER
  • PAYMENT_TYPE — VARCHAR2(20)
  • Key (MEMBER_ID2) — VARCHAR2(50) — 외래 키 → MEMBER.Key — NOT NULL

ORDER_DETAIL

  • ORDER_DETAIL — NUMBER — 기본 키 — NOT NULL
  • ORDER_ID — NUMBER
  • PRODUCT_ID — NUMBER
  • QUANTITY — NUMBER
  • UNIT_PRICE — NUMBER
  • ORDER_ID (ORDER_ID2) — NUMBER — 외래 키 → ORDERS.ORDER_ID — NOT NULL
  • PRODUCT_ID (PRODUCT_ID2) — NUMBER — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL

PRODUCT

  • PRODUCT_ID — NUMBER — 기본 키 — NOT NULL
  • NAME — VARCHAR2(100)
  • PRICE — NUMBER
  • STOCK — NUMBER
  • RATING — NUMBER(2,1)
  • SALES_COUNT — NUMBER
  • IMAGE_URL — VARCHAR2(200)
  • DESCRIPTION — VARCHAR2(500)
  • CREATED_AT — DATE
  • CATEGORY_ID (CATEGORY_ID2) — NUMBER — 외래 키 → CATEGORY.CATEGORY_ID — NOT NULL

QNA

  • QNA_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50)
  • PRODUCT_ID — NUMBER
  • TYPE — VARCHAR2(20)
  • TITLE — VARCHAR2(200)
  • CONTENT — VARCHAR2(1000)
  • REPLY — VARCHAR2(1000)
  • CREATED_AT — DATE
  • Key (MEMBER_ID2) — VARCHAR2(50) — 외래 키 → MEMBER.Key — NOT NULL
  • PRODUCT_ID (PRODUCT_ID2) — NUMBER — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL

REVIEW

  • REVIEW_ID — NUMBER — 기본 키 — NOT NULL
  • RATING — NUMBER(2,1)
  • CONTENT — VARCHAR2(1000)
  • CREATED_AT — DATE
  • MEMBER_ID — VARCHAR2(50) — 외래 키 → MEMBER.Key — NOT NULL
  • PRODUCT_ID (PRODUCT_ID2) — NUMBER — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • COMMENT_ID — NUMBER — 외래 키 → REVIEW_COMMENT.COMMENT_ID — NOT NULL

REVIEW_COMMENT

  • COMMENT_ID — NUMBER — 기본 키 — NOT NULL
  • REVIEW_ID — NUMBER
  • MEMBER_ID — VARCHAR2(50)
  • CONTENT — VARCHAR2(500)
  • CREATED_AT — DATE
  • REVIEW_ID (REVIEW_ID2) — NUMBER — 외래 키 → REVIEW.REVIEW_ID — NOT NULL
  • Key (MEMBER_ID2) — VARCHAR2(50) — 외래 키 → MEMBER.Key — NOT NULL

REVIEW_LIKE

  • LIKE_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID — VARCHAR2(50)
  • REVIEW_ID — NUMBER

WISHLIST

  • WISHLIST_ID — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID (MEMBER_ID2) — VARCHAR2(50) — 외래 키 → MEMBER.Key — NOT NULL
  • PRODUCT_ID (PRODUCT_ID2) — NUMBER — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL