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)