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