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