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