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