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