ERD

Tables (5)

admin_user

  • employee_no — VARCHAR(30)
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • admin_name — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL

intersection_info

  • intersection_id — VARCHAR(20)
  • intersection_name — VARCHAR(100) — NOT NULL
  • latitude — NUMERIC(10,7)
  • longitude — NUMERIC(10,7)
  • created_at — TIMESTAMP — NOT NULL

risk_analysis_result

  • risk_result_id — BIGSERIAL
  • intersection_id — VARCHAR(20) — NOT NULL
  • controller_log_id — BIGINT — NOT NULL
  • communication_log_id — BIGINT — NOT NULL
  • analysis_time — TIMESTAMP — NOT NULL
  • controller_risk_score — NUMERIC(6,2)
  • v2x_risk_score — NUMERIC(6,2)
  • total_risk_score — NUMERIC(6,2) — NOT NULL
  • risk_level — VARCHAR(20) — NOT NULL
  • analysis_comment — TEXT — EX
  • created_at — TIMESTAMP — NOT NULL

signal_controller_log

  • controller_log_id — BIGSERIAL
  • intersection_id — VARCHAR(20) — NOT NULL
  • controller_device_id — VARCHAR(50) — NOT NULL
  • controller_log_time — TIMESTAMP — NOT NULL
  • response_time_ms — NUMERIC(8,2)
  • error_count — INTEGER — NOT NULL
  • reboot_count — INTEGER — NOT NULL
  • cpu_temp — NUMERIC(6,2)
  • uptime_min — INTEGER
  • created_at — TIMESTAMP — NOT NULL

v2x_communication_log

  • communication_log_id — BIGSERIAL
  • intersection_id — VARCHAR(20) — NOT NULL
  • v2x_device_id — VARCHAR(50) — NOT NULL
  • v2x_log_time — TIMESTAMP — NOT NULL
  • spat_send_count — INTEGER — NOT NULL
  • spat_fail_count — INTEGER — NOT NULL
  • avg_latency_ms — NUMERIC(8,2)
  • comm_fail_count — INTEGER — NOT NULL
  • connected_vehicle_count — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL