test2

Tables (6)

image

  • image_id — BIGINT — Primary key — NOT NULL
  • image_url — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • gender — ENUM('MALE','FEMALE')
  • role — ENUM('ADMIN', 'POLICE', 'USER') — NOT NULL
  • police_id — VARCHAR(50)
  • status — ENUM('ACTIVE', 'INACTIVE', 'NOT_AVAILABLE', 'TRACKING') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • edge_device_id — VARCHAR(100)

member_location

  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • latitude — DECIMAL(10, 6) — NOT NULL
  • longitude — DECIMAL(10, 6) — NOT NULL
  • created_at — DATETIME — NOT NULL

task

  • task_id — BIGINT — Primary key — NOT NULL
  • wanted_vehicle_id — BIGINT — Foreign key → wanted_vehicles.wanted_vehicle_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • task_status — ENUM('ASSIGNED', 'ACCEPTED', 'REJECTED', 'COMPLETED', 'FAILED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

wanted_vehicles

  • wanted_vehicle_id — BIGINT — Primary key — NOT NULL
  • wanted_vehicle_number — VARCHAR(30) — NOT NULL
  • case_number — VARCHAR(50) — NOT NULL
  • crime_type — VARCHAR(100) — NOT NULL
  • owner_name — VARCHAR(100) — NOT NULL
  • wanted_vehicle_status — ENUM('WANTED', 'TRACKING', 'CAPTURED', 'INACTIVE', 'DELETED') — NOT NULL
  • notes — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

wanted_vehicles_location

  • location_id — BIGINT — Primary key — NOT NULL
  • wanted_vehicle_id — BIGINT — Foreign key → wanted_vehicles.wanted_vehicle_id — NOT NULL
  • latitude — DECIMAL(10, 6) — NOT NULL
  • longitude — DECIMAL(10, 6) — NOT NULL
  • reporter_name — VARCHAR(100) — NOT NULL
  • sighted_at — DATETIME — NOT NULL