Upcycle_Market_ERD

Tables (5)

CART

  • cart_id — INT
  • user_id — INT — Foreign key — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

CART_ITEM

  • cart_item_id — INT
  • cart_id — INT — Foreign key → CART.cart_id — NOT NULL
  • product_id — INT — Foreign key → PRODUCT.product_id — NOT NULL
  • quantity — INT — NOT NULL
  • added_at — DATETIME — NOT NULL

CATEGORY

  • category_id — INT
  • name — VARCHAR(100) — NOT NULL
  • parent_category_id — INT — Foreign key → CATEGORY.category_id

PRODUCT

  • product_id — INT
  • category_id — INT — Foreign key → CATEGORY.category_id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — DECIMAL(12,2) — NOT NULL
  • is_eco — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

PRODUCT_EMISSION

  • product_id — INT — Foreign key → PRODUCT.product_id
  • co2e_value — DECIMAL(12,4) — NOT NULL
  • unit — VARCHAR(30) — NOT NULL
  • source — VARCHAR(255)
  • updated_at — DATETIME — NOT NULL