models

type DBAssumedCoverageHistory struct {
	// Res 8 cell of the location of the coverage
	Location h3light.DatabaseCell

	// Date this coverage was (assumed to be) present based on the measurements
	Date time.Time
}

type DBAssumedGatewayCoverageHistory struct {
	// Res 8 cell of the location of the coverage
	Location h3light.DatabaseCell

	// Date this coverage was (assumed to be) present based on the measurements
	Date time.Time

	// ID of the gateway that provides this coverage
	GatewayID string

	// The number of (res10) coverage records this gateway actually has within this (res8) cell
	NumCoverage int

	// The share of total all coverage records this gateway in this res8 cell, all shares for different gateways together must be 1000.
	Share int
}

type DBAssumedUnverifiedCoverage struct {
	// Res 8 cell of the location of the coverage
	Location h3light.DatabaseCell

	// When was this unverified assumed coverage last updated
	LatestUpdate time.Time
}

type DBCoverageHistory struct {
	// Res 10 cell of the location of the coverage
	Location h3light.DatabaseCell

	// Date this coverage was (assumed to be) present based on the measurements
	Date time.Time
	// ID of the gateway that provides this coverage
	GatewayID string

	// ID of the gateway that provides this coverage
	GatewayLocation h3light.DatabaseCell

	// FrequencyPlan
	FrequencyPlan frequency_plan.BandName

	// ID of the mapper that mapped this coverage
	MapperID string

	// ID of the mapping record that was used to base this coverage on
	MappingID string

	// time of the mapping record that was used to base this coverage on
	MappingTime time.Time

	// The RSSI (signal strength) of coverage at this location
	RSSI int
}

type DBMappingAuthToken struct {
	Owner      string
	Expiration time.Time
	Code       string
	Challenge  string
}

type DBMappingDiscoveryReceiptRecord struct {
	MappingID         string
	Frequency         int     `datastore:",noindex"`
	Rssi              int     `datastore:",noindex"`
	Snr               float64 `datastore:",noindex"`
	SpreadingFactor   int     `datastore:",noindex"`
	Bandwidth         int     `datastore:",noindex"`
	CodeRate          string  `datastore:",noindex"`
	Phy               []byte  `datastore:",noindex"`
	ReceivedTime      time.Time
	GatewayTime       time.Time
	GatewaySignature  []byte `datastore:",noindex"`
	GatewayID         string
	GatewayLocation   *h3light.DatabaseCell
	MapperID          string
	ServiceValidation types.MappingRecordValidation
}

type DBMappingDownlinkReceiptRecord struct {
	MappingID         string
	Frequency         int     `datastore:",noindex"`
	Rssi              int     `datastore:",noindex"`
	Snr               float64 `datastore:",noindex"`
	SpreadingFactor   int     `datastore:",noindex"`
	Bandwidth         int     `datastore:",noindex"`
	CodeRate          string  `datastore:",noindex"`
	Phy               []byte  `datastore:",noindex"`
	ReceivedTime      time.Time
	GatewayTime       time.Time
	GatewaySignature  []byte `datastore:",noindex"`
	GatewayID         string
	MapperID          string
	ServiceValidation types.MappingRecordValidation
}

type DBMappingRecord struct {
	ID                        string
	DiscoveryPhy              []byte `datastore:",noindex"`
	DownlinkPhy               []byte `datastore:",noindex"`
	MeasuredRssi              *int
	MeasuredSnr               *int
	FrequencyPlan             string
	ChallengedGatewayID       *string
	ChallengedGatewayLocation *h3light.DatabaseCell
	ChallengedTime            *time.Time
	MapperID                  string
	MapperLocation            h3light.DatabaseCell
	MapperLat                 float64
	MapperLon                 float64
	MapperHeight              float64
	MapperOsnmaAge            int
	MapperSpoofing            int
	MapperTow                 int
	MapperBattery             int
	MapperVersion             int
	MapperStatus              int
	ReceivedTime              time.Time
	ServiceValidation         types.MappingRecordValidation
}

type DBUnverifiedMappingGatewayRecord struct {
	MappingID       string
	GatewayID       string
	GatewayLocation *h3light.DatabaseCell
	GatewayTime     time.Time
	Rssi            int
	Snr             float64
}

type DBUnverifiedMappingRecord struct {
	ID                  string
	MapperID            string
	MapperLocation      h3light.DatabaseCell
	MapperLat           float64
	MapperLon           float64
	MapperAccuracy      float64
	MapperHeight        float64
	BestGatewayID       *string
	BestGatewayLocation *h3light.DatabaseCell
	BestGatewayRssi     *int
	BestGatewaySnr      *float64
	Frequency           int
	SpreadingFactor     int
	Bandwidth           int
	CodeRate            string
	ReceivedTime        time.Time
}