shoppingmall
Tables (6)
Category
- ID — INT
- Name — VARCHAR(100) — NOT NULL
Order
- ID — INT
- User_ID — INT
- Status — VARCHAR(50) — NOT NULL
- CreatedAt — TIMESTAMP
- TotalAmount — DECIMAL(10, 2) — NOT NULL
OrderItem
- ID — INT
- Order_ID — INT
- Product_ID — INT
- Quantity — INT — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
Product
- ID — INT
- Name — VARCHAR(255) — NOT NULL
- Description — TEXT
- Price — DECIMAL(10, 2) — NOT NULL
- Stock — INT — NOT NULL
- Category_ID — INT
- CreatedAt — TIMESTAMP
- UpdatedAt — TIMESTAMP
Review
- ID — INT
- User_ID — INT
- Product_ID — INT
- Rating — INT
- Comment — TEXT — EX
- CreatedAt — TIMESTAMP
User
- ID — INT
- Name — VARCHAR(100) — NOT NULL
- Email — VARCHAR(100) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- Role — VARCHAR(50) — NOT NULL