1
Tables (5)
AI_Analysis
- analysis_id — INT
- log_id — INT
- plate_no — VARCHAR(20)
- violation_type — VARCHAR(20)
- confidence — FLOAT
Device
- serial_no — VARCHAR(50)
- user_id — INT
- fw_version — VARCHAR(20)
Incident_Log
- log_id — INT
- serial_no — VARCHAR(50)
- video_url — TEXT
- timestamp — DATETIME
- location_gps — VARCHAR(100)
- status — VARCHAR(20)
Report
- report_id — INT
- log_id — INT
- ai_draft — TEXT
- user_edit — TEXT
- is_submitted — BOOLEAN
User
- user_id — INT
- user_name — VARCHAR(100)
- phone_number — VARCHAR(20)
- email — VARCHAR(100)
- login_id — VARCHAR(50)
- password — VARCHAR(255)