WALL-E
Tables (6)
Groups
- group_id — INT — Primary key — NOT NULL
- group_name — VARCHAR(255)
MapData
- image_url — URL — Primary key — NOT NULL — 맵의
- map_id — INT — Foreign key → Maps.map_id — NOT NULL
- map_result — LIST
- mode — VARCHAR
- resolution — REAL
- origin — LIST
- negate — BOOLEAN
- occupied_thresh — REAL
- free_thresh — REAL
- width — REAL
- height — REAL
Maps
- map_id — INT — Primary key — NOT NULL
- group_id — INT — Foreign key → Groups.group_id — NOT NULL
- name (map_name) — VARCHAR(255) — NOT NULL — 맵의
- initial_robot_pos_x — INT
- initial_robot_pos_y — INT
- initial_robot_pos_yaw — REAL
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
Partitions
- partition_id — INT — Primary key — NOT NULL
- type — VARCHAR — NOT NULL
- width — REAL — NOT NULL — 파티션의
- height — REAL — 하나의
Robots
- robot_id — UUID — Primary key — NOT NULL
- group_id — INT — Foreign key → Groups.group_id — NOT NULL
- serial_number — CHAR
- car_nickname — VARCHAR(255) — NOT NULL
Tasks
- task_id — INT — Primary key — NOT NULL
- map_id — INT — Foreign key → Maps.map_id — NOT NULL
- partition_id — UUID — Foreign key → Partitions.partition_id — NOT NULL
- status — VARCHAR(status) — NOT NULL
- target_x — INT — 작업
- target_y — INT
- target_yaw — REAL
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ