1
Tables (9)
category
- id — INT
- name — VARCHAR(100) — NOT NULL
customer
- id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
order_detail
- id — INT
- order_id — INT — NOT NULL
- product_id — INT — NOT NULL
- quantity — INT — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
order_info
- id — INT
- customer_id — INT — NOT NULL
- total_price — DECIMAL(10,2) — NOT NULL
- status — ENUM('pending', 'paid', 'shipped', 'delivered', 'cancelled')
- created_at — TIMESTAMP
payment
- id — INT
- order_id — INT — NOT NULL
- method — ENUM('credit_card', 'paypal', 'bank_transfer', 'cash') — NOT NULL
- status — ENUM('pending', 'completed', 'failed')
- created_at — TIMESTAMP
product
- id — INT
- store_id — INT — NOT NULL
- category_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- stock — INT
- created_at — TIMESTAMP
seller
- id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
shipment
- id — INT
- order_id — INT — NOT NULL
- tracking_number — VARCHAR(50)
- status — ENUM('processing', 'shipped', 'delivered')
- created_at — TIMESTAMP
store
- id — INT
- seller_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP