gtsu_ui_app

Tables (6)

ai_pc (device)

  • device_id — VARCHAR(64) — Primary key — NOT NULL
  • device_type — VARCHAR(16) — NOT NULL — lidar | camera | aipc | ros_node
  • aipc_id — VARCHAR(64) — Foreign key → ai_pc.device_id — self-ref to owning AIPC (lidar/camera only)
  • display_name — VARCHAR(128)
  • created_at — TIMESTAMP — NOT NULL

camera (CopyOfCopyOfdevice)

  • device_id — VARCHAR(64) — Primary key — NOT NULL
  • aipc_id — VARCHAR(64)
  • device_type — VARCHAR(16) — NOT NULL — lidar | camera | aipc | ros_node
  • display_name — VARCHAR(128)
  • created_at — TIMESTAMP — NOT NULL

control

  • id — BIGINT — Primary key — NOT NULL
  • control_type — VARCHAR(32) — NOT NULL — lidar_reboot | camera_reboot | ptz_auto
  • target_device_id — VARCHAR(64) — Foreign key → ai_pc.device_id — NULL for ptz_auto
  • mode — VARCHAR(32) — ptz_auto only
  • reason — VARCHAR(256) — camera_reboot only
  • relay_status_code — INT
  • relay_success — BOOLEAN — NOT NULL
  • error_detail — TEXT
  • requester_ip — VARCHAR(45)
  • requested_at — TIMESTAMP — NOT NULL
  • responded_at — TIMESTAMP

lidar (CopyOfdevice)

  • device_id — VARCHAR(64) — Primary key — NOT NULL
  • aipc_id (aipc _id) — VARCHAR(64)
  • device_type — VARCHAR(16) — NOT NULL — lidar | camera | aipc | ros_node
  • display_name — VARCHAR(128)
  • created_at — TIMESTAMP — NOT NULL

operation_info (pointcloud_log)

  • id — BIGINT — Primary key — NOT NULL
  • pcd_format — VARCHAR(32) — NOT NULL — numpy_npz_bundle_v1 | numpy_f32_xyzi_v1
  • byte_size — INT — NOT NULL
  • point_count — INT — NOT NULL
  • parts — TEXT — JSON array: pointcloud/height_map/hatch_corner/...
  • stream_sent — BOOLEAN — NOT NULL
  • received_at — TIMESTAMP — NOT NULL

state (sensor_state_log)

  • id — BIGINT — Primary key — NOT NULL
  • device_id — VARCHAR(64) — Foreign key → ai_pc.device_id — NOT NULL
  • state — VARCHAR(64) — raw payload.state
  • run_state — VARCHAR(16) — ros_node only: RUNNING/STOPPED/UNKNOWN
  • health_state — VARCHAR(16) — ros_node only: HEALTHY/UNHEALTHY/UNKNOWN
  • ui_state — VARCHAR(16) — ros_node only: NORMAL/FAULT/UNKNOWN
  • cpu_usage — FLOAT — aipc only
  • memory_usage — FLOAT — aipc only
  • gpu_usage — FLOAT — aipc only
  • error_code — INT
  • message — VARCHAR(512)
  • event_timestamp — TIMESTAMP — payload.timestamp (TZ-aware)
  • last_update_time — TIMESTAMP — lidar/camera only
  • received_at — TIMESTAMP — NOT NULL