캠핑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