Add Fields?

[kcwebby]

Add a few fields to the transmissions table?
HasTones as boolean
IsDispatch as boolean
TonesDetected as varchar(50) ?

[MaxwellDPS]

@kcwebby Added those + tones_meta which can be any valid json
New API Post looks like, the tones key can be null or a {} with none or all the keys

{
  "recorder": "<string>",
  "json": "<string>",
  "audio_file": "<string>",
  "name": "<string>",
  "tones": {
    "has_tones": true,
    "is_dispatch": true,
    "tones_detected": "8675 309",
    "tones_meta": {
        "anything": true,
        "yeet": {
            "why": "tho"
        }
    }
  }
}

{
            "UUID": "93ad2cbb-bf18-4c44-a126-106d8895c5b2",
            "system": "fdf84a95-7218-4988-8531-f999d9828eb2",
            "system_name": "PSERN",
            "recorder": "462d2479-021f-4fcf-b590-c320f8b2417c",
            "audio_type": "digital tdma",
            "start_time": "2024-02-09T16:27:54-08:00",
            "end_time": "2024-02-09T16:28:17-08:00",
            "audio_file": "",
            "talkgroup": {
                "UUID": "7ea5b34c-9d57-5b24-bcdc-bce4a326ce09",
                "system": "fdf84a95-7218-4988-8531-f999d9828eb2",
                "decimal_id": 2315,
                "alpha_tag": "Des PD Pri",
                "description": "Police Primary",
                "mode": "tdma",
                "encrypted": false,
                "agency": [],
                "notes": "",
                "transmission_count": 4440
            },
            "encrypted": false,
            "units": [
                {
                    "pos": 0.0,
                    "src": 12972,
                    "tag": "",
                    "UUID": "cc3f0292-8496-54b8-915d-7162c0f21cd2",
                    "time": 1707524874,
                    "unit": {
                        "UUID": "01db4686-6650-4f6f-8092-906e19f7777e",
                        "system": "fdf84a95-7218-4988-8531-f999d9828eb2",
                        "decimal_id": 12972,
                        "description": null
                    },
                    "emergency": 0,
                    "decimal_id": 12972,
                    "signal_system": ""
                },
                {
                    "pos": 1.84,
                    "src": 37540,
                    "tag": "",
                    "UUID": "ac4fbddf-cb13-5263-988e-d852cf5e48db",
                    "time": 1707524878,
                    "unit": {
                        "UUID": "276fdfc0-e8d6-4387-a1c4-423d1abc5caf",
                        "system": "fdf84a95-7218-4988-8531-f999d9828eb2",
                        "decimal_id": 37540,
                        "description": null
                    },
                    "emergency": 0,
                    "decimal_id": 37540,
                    "signal_system": ""
                },
                {
                    "pos": 3.96,
                    "src": 37540,
                    "tag": "",
                    "UUID": "a38fc20b-241f-5060-a4c2-3c773fcc19cc",
                    "time": 1707524884,
                    "unit": {
                        "UUID": "276fdfc0-e8d6-4387-a1c4-423d1abc5caf",
                        "system": "fdf84a95-7218-4988-8531-f999d9828eb2",
                        "decimal_id": 37540,
                        "description": null
                    },
                    "emergency": 0,
                    "decimal_id": 37540,
                    "signal_system": ""
                },
                {
                    "pos": 12.68,
                    "src": 12972,
                    "tag": "",
                    "UUID": "a998dae0-2447-5169-b396-bf2158c98b63",
                    "time": 1707524895,
                    "unit": {
                        "UUID": "01db4686-6650-4f6f-8092-906e19f7777e",
                        "system": "fdf84a95-7218-4988-8531-f999d9828eb2",
                        "decimal_id": 12972,
                        "description": null
                    },
                    "emergency": 0,
                    "decimal_id": 12972,
                    "signal_system": ""
                }
            ],
            "frequency": 851637500.0,
            "frequencys": [
                {
                    "len": 1.84,
                    "pos": 0.0,
                    "freq": 851637500,
                    "time": 1707524874,
                    "error_count": "0",
                    "spike_count": "0"
                },
                {
                    "len": 2.12,
                    "pos": 1.84,
                    "freq": 851637500,
                    "time": 1707524878,
                    "error_count": "0",
                    "spike_count": "0"
                },
                {
                    "len": 8.72,
                    "pos": 3.96,
                    "freq": 851637500,
                    "time": 1707524884,
                    "error_count": "0",
                    "spike_count": "0"
                },
                {
                    "len": 2.4,
                    "pos": 12.68,
                    "freq": 851637500,
                    "time": 1707524895,
                    "error_count": "0",
                    "spike_count": "0"
                }
            ],
            "length": 15.0,
            "locked": false,
            "transcript": null,
            "has_tones": false,
            "is_dispatch": false,
            "tones_detected": null,
            "tones_meta": {}
        },