stillbox/pkg/database/models.go

// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.27.0

package database

import (
	"time"

	"dynatron.me/x/stillbox/internal/jsontypes"
	"dynatron.me/x/stillbox/pkg/alerting/rules"
	"github.com/google/uuid"
	"github.com/jackc/pgx/v5/pgtype"
)

type Alert struct {
	ID        int                `json:"id"`
	Time      pgtype.Timestamptz `json:"time"`
	TGID      int                `json:"tgid"`
	SystemID  int                `json:"system_id"`
	Weight    *float32           `json:"weight"`
	Score     *float32           `json:"score"`
	OrigScore *float32           `json:"orig_score"`
	Notified  bool               `json:"notified"`
	Metadata  []byte             `json:"metadata"`
}

type ApiKey struct {
	ID        int              `json:"id"`
	Owner     int              `json:"owner"`
	CreatedAt time.Time        `json:"created_at"`
	Expires   pgtype.Timestamp `json:"expires"`
	Disabled  *bool            `json:"disabled"`
	ApiKey    string           `json:"api_key"`
}

type Call struct {
	ID          uuid.UUID          `json:"id"`
	Submitter   *int32             `json:"submitter"`
	System      int                `json:"system"`
	Talkgroup   int                `json:"talkgroup"`
	CallDate    pgtype.Timestamptz `json:"call_date"`
	AudioName   *string            `json:"audio_name"`
	AudioBlob   []byte             `json:"audio_blob"`
	Duration    *int32             `json:"duration"`
	AudioType   *string            `json:"audio_type"`
	AudioUrl    *string            `json:"audio_url"`
	Frequency   int                `json:"frequency"`
	Frequencies []int              `json:"frequencies"`
	Patches     []int              `json:"patches"`
	TGLabel     *string            `json:"tg_label"`
	TGAlphaTag  *string            `json:"tg_alpha_tag"`
	TGGroup     *string            `json:"tg_group"`
	Source      int                `json:"source"`
	Transcript  *string            `json:"transcript"`
}

type Incident struct {
	ID          uuid.UUID        `json:"id"`
	Name        string           `json:"name"`
	Description *string          `json:"description"`
	StartTime   pgtype.Timestamp `json:"start_time"`
	EndTime     pgtype.Timestamp `json:"end_time"`
	Location    []byte           `json:"location"`
	Metadata    []byte           `json:"metadata"`
}

type IncidentsCall struct {
	IncidentID uuid.UUID `json:"incident_id"`
	CallID     uuid.UUID `json:"call_id"`
	Notes      []byte    `json:"notes"`
}

type Setting struct {
	Name      string `json:"name"`
	UpdatedBy *int32 `json:"updated_by"`
	Value     []byte `json:"value"`
}

type System struct {
	ID   int    `json:"id"`
	Name string `json:"name"`
}

type Talkgroup struct {
	ID          int                `json:"id"`
	SystemID    int32              `json:"system_id"`
	TGID        int32              `json:"tgid"`
	Name        *string            `json:"name"`
	AlphaTag    *string            `json:"alpha_tag"`
	TGGroup     *string            `json:"tg_group"`
	Frequency   *int32             `json:"frequency"`
	Metadata    jsontypes.Metadata `json:"metadata"`
	Tags        []string           `json:"tags"`
	Alert       bool               `json:"alert"`
	AlertConfig rules.AlertRules   `json:"alert_config"`
	Weight      float32            `json:"weight"`
	Learned     bool               `json:"learned"`
}

type TalkgroupsLearned struct {
	ID       int     `json:"id"`
	SystemID int     `json:"system_id"`
	TGID     int     `json:"tgid"`
	Name     string  `json:"name"`
	AlphaTag *string `json:"alpha_tag"`
	TGGroup  *string `json:"tg_group"`
	Ignored  *bool   `json:"ignored"`
}

type User struct {
	ID       int    `json:"id"`
	Username string `json:"username"`
	Password string `json:"password"`
	Email    string `json:"email"`
	IsAdmin  bool   `json:"is_admin"`
	Prefs    []byte `json:"prefs"`
}