test
Tables (8)
customers
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- address — VARCHAR(200)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
delivery_agents
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(100)
- vehicle_number — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
delivery_routes
- id — BIGINT
- order_id — BIGINT
- delivery_agent_id — BIGINT
- route_details — TEXT
- estimated_delivery_time — TIMESTAMP
- actual_delivery_time — TIMESTAMP
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
delivery_tracking
- id — BIGINT
- delivery_route_id — BIGINT
- status — VARCHAR(20)
- location — VARCHAR(200)
- timestamp — TIMESTAMP
inventory
- id — BIGINT
- product_id — BIGINT
- quantity — INT — NOT NULL
- updated_at — TIMESTAMP
order_items
- id — BIGINT
- order_id — BIGINT
- product_id — BIGINT
- quantity — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
orders
- id — BIGINT
- customer_id — BIGINT
- order_date — TIMESTAMP
- status — VARCHAR(20)
- total_price — DECIMAL(10, 2) — NOT NULL
products
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(1000)
- price — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP