test
Tables (5)
AI
- incident_log — integer — Foreign key → incident_log.incident_log — NOT NULL
- plate_no — varchar
- violation_type — code
- confidence — float
Device
- serial_no — varchar
- user_id — integer — Foreign key → user.user_id
incident_log
- incident_log — integer — Primary key — NOT NULL
- serial_no — varchar(50) — Foreign key → Device.serial_no
- video_url — text
- time — datetime
- location_gps — varchar(100)
- status — varchar(20)
report
- incident_log — integer — Foreign key → incident_log.incident_log — NOT NULL
- user_id — integer — Foreign key → user.user_id
- report_id — integer
- ai_draft — text
- user_edit — text
- is_submitted — boolean
user
- user_id — integer
- user_name — varchar
- user_number — varchar
- email — varchar
- login_id — varchar
- login_pw — varchar(150)
- car_number — varchar