mj
Tables (7)
Categories
- CategoryID — INT — Primary key — NOT NULL
- CategoryName — VARCHAR(50)
OrderDetails
- OrderID — INT — Foreign key → Orders.OrderID — NOT NULL
- ProductID — INT — Foreign key → Products.ProductID — NOT NULL
- Quantity — INT
- UnitCost — DECIMAL(15,0)
Orders
- OrderID — INT — Primary key — NOT NULL
- OrderDate — DATETIME
- shipDate — DATETIME
- user_id — VARCHAR(50)
- user_id2 — VARCHAR(50) — NOT NULL
Products
- ProductID — INT — Primary key — NOT NULL
- CategoryID — INT — NOT NULL
- ModelNumber — VARCHAR(10)
- ModelName — VARCHAR(120)
- ProductImage — VARCHAR(30)
- UnitCost — DECIMAL(15,0)
- Description — TEXT
Reviews
- ReviewID — INT — Primary key — NOT NULL
- ProductID — INT — NOT NULL
- Rating — INT
- Comments — TEXT
- user_id — VARCHAR(50) — NOT NULL
ShoppingCart
- RecordID — INT — Primary key — NOT NULL
- ProductID — INT — NOT NULL
- CartID — VARCHAR(150)
- Quantity — INT
- DateCreated — DATETIME
users
- user_id — VARCHAR(50) — Primary key — NOT NULL
- user_name — VARCHAR(50)
- user_password — VARCHAR(200)
- user_birth — VARCHAR(8)
- user_auth — VARCHAR(10)
- user_point — INT
- created_at — DATETIME
- latest_login_at — DATETIME