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