test

Tables (5)

alerts

  • alert_id — int — Primary key — NOT NULL
  • device_id — varchar(50) — Foreign key → devices.device_id — NOT NULL
  • fire_event_id — int — Foreign key → fire_events.fire_event_id
  • alert_time — datetime — NOT NULL
  • distance_m — double
  • fire_level — varchar(20)
  • fire_lat — double
  • fire_lon — double
  • status — enum('SENT','FAILED','QUEUED')

detections

  • detection_id — int — Primary key — NOT NULL
  • scene_id — varchar(20) — Foreign key → scenes.scene_id — NOT NULL
  • fire_event_id — int — Foreign key → fire_events.fire_event_id
  • detection_time_utc — datetime — NOT NULL
  • area_m2 — double
  • center_lat — double
  • center_long — double
  • geometry — geometry

devices

  • device_id — varchar(50) — Primary key — NOT NULL
  • lat — double
  • lon — double
  • last_seen — datetime

fire_events

  • fire_event_id — int — Primary key — NOT NULL
  • started_at_utc — datetime — NOT NULL
  • last_seen_utc — datetime — NOT NULL
  • status — enum('active','resolved')
  • geom — geometry
  • area_m2 — double
  • origin_lat — double
  • origin_long — double
  • origin_address — varchar(255)

scenes

  • scene_id — varchar(20) — Primary key — NOT NULL
  • source — varchar(30)
  • scene_time — datetime — NOT NULL
  • path_ff — varchar(255) — NOT NULL
  • created_at — timestamp