gtsu_ui_app2
Tables (10)
ai_pc
- aipc_id — VARCHAR(64) — Primary key — NOT NULL
- aipc_name — VARCHAR(100)
- aipc_ip — VARCHAR(50)
- created_date — TIMESTAMP(3) — NOT NULL
aicp_state
- id — BIGINT — Primary key — NOT NULL
- seq — BIGINT — NOT NULL
- log_reason — VARCHAR(16) — NOT NULL — change | sample | heartbeat | error | first | restart
- aipc_id — VARCHAR(64) — Foreign key → ai_pc.aipc_id
- state — VARCHAR(64)
- cpu_usage — FLOAT — aiserver only
- memory_usage — FLOAT — aiserver only
- gpu_usage — FLOAT — aiserver only
- create_date — TIMESTAMP(3) — NOT NULL
api_failure_log
- id — BIGINT — Primary key — NOT NULL
- seq — BIGINT — NOT NULL
- method — VARCHAR(8) — NOT NULL
- path — VARCHAR(255) — NOT NULL
- http_status — INT
- error_code — INT — 1001/1002/2001/3001/3002/4001
- error_message — VARCHAR(512)
- detail — TEXT
- client_ip — VARCHAR(45)
- occurred_at — TIMESTAMP(3) — NOT NULL
camera
- camera_id — VARCHAR(64) — Primary key — NOT NULL
- camera_name — VARCHAR(100)
- camera_ip — VARCHAR(50) — NOT NULL
- aipc_id — VARCHAR(64) — Foreign key → ai_pc.aipc_id — NOT NULL
- create_date — TIMESTAMP(3)
camera_state
- seq — BIGINT — Primary key — NOT NULL
- camera_id — VARCHAR(64) — Foreign key → camera.camera_id
- aipc_id — VARCHAR(64) — Foreign key → ai_pc.aipc_id — NOT NULL
- device_state — VARCHAR(64)
- img_state — VARCHAR(15) — 정규화: status_types.coerce_bool 결과
- create_date — TIMESTAMP(3) — NOT NULL
control
- id — BIGINT — Primary key — NOT NULL
- seq — BIGINT — NOT NULL
- aipc_id — VARCHAR(64) — Foreign key → ai_pc.aipc_id — denormalized owner; NULL for ptz_auto
- target_lidar_id — VARCHAR(64) — Foreign key → lidar.lidar_id
- target_camera_id — VARCHAR(64) — Foreign key → camera.camera_id
- mode — VARCHAR(32) — ptz_auto only
- error_detail — TEXT
- requester_ip — VARCHAR(45)
- requested_at — TIMESTAMP(3) — NOT NULL
- responded_at — TIMESTAMP(3)
lidar
- lidar_id — VARCHAR(64) — Primary key — NOT NULL — boom_lidar | cabin_lidar1 | cabin_lidar2
- lidar_name — VARCHAR(30)
- lidar_ip — VARCHAR(50) — NOT NULL
- aipc_id — VARCHAR(64) — Foreign key → ai_pc.aipc_id — NOT NULL
- sn — VARCHAR(20)
- created_date — TIMESTAMP(3) — NOT NULL
lidar_state
- id — BIGINT — Primary key — NOT NULL
- seq — BIGINT — NOT NULL
- lidar_id — VARCHAR(64) — Foreign key → lidar.lidar_id
- aipc_id — VARCHAR(64) — Foreign key → ai_pc.aipc_id — NOT NULL
- state — VARCHAR(64) — change | sample | heartbeat | error | first | restart
- cpu_usage — FLOAT — aiserver only
- memory_usage — FLOAT — aiserver only
- gpu_usage — FLOAT — aiserver only
- error_code — INT
- create_date — TIMESTAMP(3) — lidar/camera only
pointcloud_log
- id — BIGINT — Primary key — NOT NULL
- seq — BIGINT — NOT NULL
- aipc_id — VARCHAR(64) — Foreign key → ai_pc.aipc_id — NOT NULL — sender AI PC (via X-AIPC-ID header)
- lidar_id — VARCHAR(64) — Foreign key → lidar.lidar_id — source LiDAR (out-of-band populate)
- byte_size — INT — NOT NULL
- hatch_corner — VARCHAR(100)
- hatch_width — VARCHAR(10)
- hatch_height — VARCHAR(10)
- digging_point — VARCHAR(30)
- pointcloud_path — VARCHAR(100)
- heightmap_path — VARCHAR(100)
- create_date — TIMESTAMP(3) — NOT NULL
ros_node_state
- node_name — VARCHAR(64) — Primary key — NOT NULL
- seq — BIGINT — NOT NULL
- aipc_id — VARCHAR(64) — Foreign key → ai_pc.aipc_id — NOT NULL — AI PC running this node
- run_state — VARCHAR(20)
- health_state — VARCHAR(20)
- state — VARCHAR(20)
- create_date — TIMESTAMP(3) — NOT NULL