Database_Design
Tables (5)
Categories
- category_id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(30)
- description — VARCHAR(50)
Order_Items
- order_item_id — INTEGER — Primary key — NOT NULL
- quantity — INTEGER
- price — INTEGER
- product_id — INTEGER — Foreign key → Products.product_id — NOT NULL
- order_id — INTEGER — Foreign key → Orders.order_id — NOT NULL
Orders
- order_id — INTEGER — Primary key — NOT NULL
- order_date — DATETIME
- total_amount — INTEGER
- user_id — INTEGER — Foreign key → Users.user_id — NOT NULL
Products
- product_id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(30)
- price — INTEGER
- stock_quantity — INTEGER
- category_id — INTEGER — Foreign key → Categories.category_id — NOT NULL
Users
- user_id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(30)
- email — VARCHAR(50)
- phone_number — VARCHAR(20)