FrontErd
Tables (4)
Untitled (User)
- Key (user_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR
- Field2 (email) — VARCHAR
- Field3 (password) — VARCHAR
Untitled (Event)
- Key (events_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR
- Field
- Key (item_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (Products)
- Key (item_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR
- Field2 (thumbnail) — VARCHAR
- Field3 (price) — INT
- Field4 (discount) — INT
- Field5 (description) — VARCHAR
- Field6 (category) — VARCHAR
- Field7 (brand) — VARCHAR
- Field8 (rating) — DOUBLE
Untitled2 (Carts)
- Key (carts_id) — BIGINT — Primary key — NOT NULL
- Field (quantity) — INT
- Key (item_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL