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