444
Tables (5)
categories
- category_id — VARCHAR(36)
- category_name — VARCHAR(100) — NOT NULL
- category_description — TEXT
- category_created_at — TIMESTAMP
order_items
- order_item_id — VARCHAR(36)
- order_item_order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
- order_item_product_id — VARCHAR(36) — Foreign key → products.product_id — NOT NULL
- order_item_quantity — INTEGER — NOT NULL
- order_item_price — DECIMAL(12,2) — NOT NULL
orders
- order_id — VARCHAR(36)
- order_user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- order_total_amount — DECIMAL(12,2) — NOT NULL
- order_status — VARCHAR(20) — NOT NULL
- order_created_at — TIMESTAMP
products
- product_id — VARCHAR(36)
- product_category_id — VARCHAR(36) — Foreign key → categories.category_id — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- product_price — DECIMAL(12,2) — NOT NULL
- product_stock_quantity — INTEGER — NOT NULL
- product_status — VARCHAR(20)
- product_created_at — TIMESTAMP
users
- user_id — VARCHAR(36)
- user_email — VARCHAR(255) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- user_status — VARCHAR(20) — NOT NULL
- user_created_at — TIMESTAMP — NOT NULL
- user_updated_at — TIMESTAMP