sql
Tables (6)
cart_items
- id — BIGINT
- cart_id — BIGINT
- product_id — BIGINT
- quantity — INT
- created_at — TIMESTAMP
carts
- id — BIGINT
- user_id — BIGINT
- updated_at — TIMESTAMP
orders
- id — BIGINT
- user_id — BIGINT
- order_no — VARCHAR(100)
- total_amount — DECIMAL(15,2)
- status — VARCHAR(50
product_images
- id — BIGINT
- product_id — BIGINT
- image_url — VARCHAR(500)
- is_thumbnail — BOOLEAN
- ord — INT
products
- id — BIGINT
- name — VARCHAR(255)
- category — VARCHAR(50)
- carat — VARCHAR(50)
- price — DECIMAL(15,2)
- description — TEXT
- is_active — BOOLEAN
- created_at — TIMESTAMP
users
- id — BIGINT
- email — VARCHAR(255)
- password — VARCHAR(255)
- company_name — VARCHAR(255)
- business_number — VARCHAR(255)
- country — VARCHAR(255)
- address — TEXT
- role — VARCHAR(50)
- status — VARCHAR(50)
- created_at — TIMESTAMP