smartlogistics

Tables (4)

admin

  • admin_id — INT — Primary key — NOT NULL
  • login_id — VARCHAR(20)
  • password — VARCHAR(20) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — VARCHAR(10) — NOT NULL

error_log

  • error_id — INT — Primary key — NOT NULL
  • robot_id — INT — Foreign key → robot.robot_id
  • error_message — VARCHAR(100) — NOT NULL
  • created_at — DATETIME

robot

  • robot_id — INT — Primary key — NOT NULL
  • robot_name — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • battery — INT — NOT NULL
  • location — VARCHAR(50)
  • last_completed_at — DATETIME

task

  • task_id — INT — Primary key — NOT NULL
  • task_name — VARCHAR(100) — NOT NULL
  • start_location — VARCHAR(50) — NOT NULL
  • end_location — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • priority — VARCHAR(10) — NOT NULL
  • robot_id — INT — Foreign key → robot.robot_id
  • created_at — DATETIME
  • completed_at — DATETIME
  • failure_reason — VARCHAR(255)