커머스 테이블

테이블 (13)

BUCKET (Untitled11)

  • BUYER_ID (Key2) — NUMBER() — 외래 키 → BUYER.BUYER_ID — NOT NULL
  • AMOUNT (Field) — NUMBER()
  • DETAIL_ID (Key) — NUMBER() — 외래 키 → PRODUCT_DETAIL.DETAIL_ID — NOT NULL
  • PROD_ID — NUMBER() — 외래 키 → PRODUCT_DETAIL.PROD_ID — NOT NULL
  • SELLER_ID (Key22) — NUMBER() — 외래 키 → PRODUCT_DETAIL.SELLER_ID — NOT NULL

BUYER (Untitled2)

  • BUYER_ID (Key2) — NUMBER() — 외래 키 → USER.USER_ID — NOT NULL
  • COUPON_ID (Key) — NUMBER() — 외래 키 → COUPON.COUPON_ID — NOT NULL

CATEGORY (Untitled9)

  • CATEGORY_ID (Key) — NUMBER() — 기본 키 — NOT NULL
  • CATEGORY_NAME (Field) — VARCHAR2()

COUPON (Untitled12)

  • COUPON_ID (Key) — NUMBER() — 기본 키 — NOT NULL
  • COUPON_TYPE (Field) — NUMBER()
  • DISCOUNT (Field2) — NUMBER()
  • CONDITION (Field3) — NUMBER()

LIKE (Untitled7)

  • BUYER_ID (Key2) — NUMBER() — 외래 키 → BUYER.BUYER_ID — NOT NULL
  • PROD_ID — NUMBER() — 외래 키 → PRODUCT.PROD_ID — NOT NULL
  • SELLER_ID (Key) — NUMBER() — 외래 키 → PRODUCT.SELLER_ID — NOT NULL

ORDER (Untitled5)

  • ORDER_ID (Key) — NUMBER() — 기본 키 — NOT NULL
  • PLACE (Field) — VARCHAR2()
  • ORDER_DATE (Field2) — DATE
  • TOTAL_PRICE (Field3) — NUMBER()
  • DELIVERY_STATE (Field4) — VARCHAR2()
  • BUYER_ID (Key2) — NUMBER() — 외래 키 → BUYER.BUYER_ID — NOT NULL

ORDER_DETAIL (Untitled6)

  • ORDER_ID (Key) — NUMBER() — 외래 키 → ORDER.ORDER_ID — NOT NULL
  • DETAIL_ID (Key2) — NUMBER() — 외래 키 → PRODUCT_DETAIL.DETAIL_ID — NOT NULL
  • PROD_ID — NUMBER() — 외래 키 → PRODUCT_DETAIL.PROD_ID — NOT NULL
  • PRODUCT_AMOUNT (Field) — NUMBER()
  • COUPON_ID (Key3) — NUMBER() — 외래 키 → COUPON.COUPON_ID — NOT NULL

PRODUCT (Untitled3)

  • PROD_ID — NUMBER() — 기본 키 — NOT NULL
  • SELLER_ID (Key) — NUMBER() — 외래 키 → SELLER.SELLER_ID — NOT NULL
  • IMG — VARCHAR2()
  • PRODUCT_NAME (Field2) — VARCHAR2()
  • BRAND_NAME (Field3) — VARCHAR2()
  • UPLOAD_DATE (Field4) — DATE
  • PRODUCT_INFO (Field) — VARCHAR2()

PRODUCT_DETAIL (Untitled4)

  • DETAIL_ID (Key) — NUMBER() — 기본 키 — NOT NULL
  • PROD_ID — NUMBER() — 외래 키 → PRODUCT.PROD_ID — NOT NULL
  • SELLER_ID (Key2) — NUMBER() — 외래 키 → PRODUCT.SELLER_ID — NOT NULL
  • OPTION_PRICE — NUMBER()
  • OPTION_AMOUNT — NUMBER()
  • OPTION_NAME — VARCHAR2() — NOT NULL
  • SALE_RATE (Field) — NUMBER()

PRODUCT_TYPE (Untitled10)

  • TYPE_ID (Key2) — NUMBER() — 기본 키 — NOT NULL
  • TYPE_NAME (Field) — VARCHAR2()
  • CATEGORY_ID (Key) — NUMBER() — 외래 키 → CATEGORY.CATEGORY_ID — NOT NULL
  • PROD_ID — NUMBER() — 외래 키 → PRODUCT.PROD_ID — NOT NULL
  • SELLER_ID (Key3) — NUMBER() — 외래 키 → PRODUCT.SELLER_ID — NOT NULL

REVIEW (Untitled8)

  • BUYER_ID (Key22) — NUMBER() — 외래 키 → BUYER.BUYER_ID — NOT NULL
  • CONTENT (Field) — VARCHAR2()
  • SCORE (Key) — NUMBER() — NOT NULL
  • DETAIL_ID (Key2) — NUMBER() — 외래 키 → PRODUCT_DETAIL.DETAIL_ID — NOT NULL
  • PROD_ID — NUMBER() — 외래 키 → PRODUCT_DETAIL.PROD_ID — NOT NULL
  • SELLER_ID (Key23) — NUMBER() — 외래 키 → PRODUCT_DETAIL.SELLER_ID — NOT NULL

SELLER (Untitled)

  • SELLER_ID (Key) — NUMBER() — 외래 키 → USER.USER_ID — NOT NULL
  • SELLER_INFO (Field4) — VARCHAR2()

USER (Untitled13)

  • USER_ID (Key) — NUMBER() — 기본 키 — NOT NULL
  • PW (Field) — VARCHAR2()
  • NAME (Field2) — VARCHAR2()
  • PHONE_NUMBER (Field3) — VARCHAR2()
  • EMAIL (Field4) — VARCHAR2()
  • ADDRESS (Field5) — VARCHAR2()
  • POSITION (Field6) — NUMBER