models

type Firmware struct {
	ID       int64        `db:"id,pk"`
	Type     FirmwareType `db:"type"`
	Version  string       `db:"version"`
	ImageURL string       `db:"image_url"`

	// loaded from other tables
	Targets      []*FirmwareTarget      `db:"-"`
	Measurements []*FirmwareMeasurement `db:"-"`
}

type FirmwareMeasurement struct {
	ID                int64                `db:"id,pk"`
	FirmwareID        int64                `db:"firmware_id"`
	MeasurementTypeID int64                `db:"type_id"`
	Value             types.ConvertedBytes `db:"value"`

	// loaded from other tables
	Firmware                *Firmware                `db:"-"`
	FirmwareMeasurementType *FirmwareMeasurementType `db:"-"`
}

type FirmwareMeasurementMetadata struct {
	ID                int64  `db:"id,pk"`
	MeasurementTypeID int64  `db:"type_id"`
	Key               string `db:"key"`
	Value             string `db:"value"`

	// loaded from other tables
	FirmwareMeasurementType *FirmwareMeasurementType `db:"-"`
}

type FirmwareMeasurementType struct {
	ID          int64  `db:"id,pk"`
	Name        string `db:"name"`
	Description string `db:"description"`

	// loaded from other tables
	Metadata []*FirmwareMeasurementMetadata `db:"-"`
}

type FirmwareTarget struct {
	ID         int64   `db:"id,pk"`
	FirmwareID int64   `db:"firmware_id"`
	ModelID    *int64  `db:"model_id"`
	Hostname   *string `db:"hostname"`

	// loaded from other tables
	Firmware *Firmware `db:"-"`
}

type FirmwareType uint