molly
Tables (7)
Brand
- brand_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- description — TEXT
Category
- category_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- description — TEXT
Order
- order_id — INT — Primary key
- user_id — INT
- order_date — TIMESTAMP
- total_amount — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(50)
- shipping_address — VARCHAR(255)
Order_Item
- order_item_id — INT — Primary key
- order_id — INT
- product_id — INT
- quantity — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
Product
- product_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- stock — INT — NOT NULL
- category_id — INT
- brand_id — INT
- created_at — TIMESTAMP
Review
- review_id — INT — Primary key
- user_id — INT
- product_id — INT
- rating — INT
- comment — TEXT — EX
- created_at — TIMESTAMP
User
- user_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- address — VARCHAR(255)
- created_at — TIMESTAMP