커머스 테이블
테이블 (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