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