dd

Tables (5)

CARTS

  • CART_ID — NUMBER — Primary key — NOT NULL
  • USER_ID — VARCHAR2(50) — Foreign key → USERS.USER_ID
  • PRODUCT_ID — NUMBER — Foreign key → PRODUCT.PRODUCT_ID
  • QUANTITY — NUMBER
  • CREATED_AT — DATE

ORDERS

  • ORDER_ID — VARCHAR2(20) — Primary key — NOT NULL
  • PRODUCT_ID — NUMBER — Foreign key → PRODUCT.PRODUCT_ID
  • USER_ID — VARCHAR2(50) — Foreign key → USERS.USER_ID
  • ORDER_DATE — DATE — NOT NULL

PRODUCT

  • PRODUCT_ID — NUMBER — Primary key — NOT NULL
  • PRODUCT_NAME — VARCHAR2(100) — NOT NULL
  • BRAND — VARCHAR2(50) — NOT NULL
  • PRICE — NUMBER — NOT NULL
  • CATEGORY — VARCHAR2(30) — NOT NULL
  • STOCK — NUMBER — NOT NULL
  • RATING — NUMBER(2,1)

REVIEWS

  • REVIEW_ID — VARCHAR2(20) — Primary key — NOT NULL
  • USER_ID — VARCHAR2(50) — Foreign key → USERS.USER_ID — NOT NULL
  • PRODUCT_ID — NUMBER — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • R_CONTENT — VARCHAR2(500) — NOT NULL
  • REVIEW_DATE — DATE

USERS

  • USER_ID — VARCHAR2(50) — Primary key — NOT NULL
  • USER_PW — VARCHAR2(50) — NOT NULL
  • USER_NAME — VARCHAR2(30) — NOT NULL
  • USER_PHONE — VARCHAR2(20) — NOT NULL
  • USER_GRADE — VARCHAR2(10) — NOT NULL
  • Field