model

type Node struct {
	UUID    string   `json:"uuid" gorm:"primary_key;type:char(20);not null;"`
	Name    string   `json:"name" gorm:"type:varchar(32);unique;not null"`
	Group   string   `json:"location" gorm:"type:varchar(64)"`
	LocLat  float64  `json:"lat"`
	LocLon  float64  `json:"lon"`
	SinkID  uint     `json:"sink_id" gorm:"not null"`
	Sensors []Sensor `json:"sensors" gorm:"foreignkey:UUID"`
}

type NodeSensor struct {
	NodeUUID   string `gorm:"primary_key;type:char(20)"`
	SensorUUID string `gorm:"primary_key;type:char(20)"`
}

type Sensor struct {
	UUID      string        `json:"uuid" gorm:"primary_key;type:char(20);not null;"`
	Name      string        `json:"name" gorm:"type:varchar(32);unique;not null"`
	ValueList []SensorValue `json:"value_list" gorm:"foreignkey:SensorUUID"`
}

type SensorValue struct {
	SensorUUID string `json:"sensor_uuid" gorm:"primary_key;type:char(20);not null"`
	ValueName  string `json:"value_name" gorm:"primary_key;type:varchar(32);not null"`
	Index      int    `json:"index" gorm:"not null"`
}

type Sink struct {
	ID       uint   `json:"id" gorm:"primary_key"`
	Name     string `json:"name" gorm:"type:varchar(32);unique"`
	Location string `json:"location" gorm:"type:varchar(64)"`
	IP       string `json:"ip" gorm:"type:varchar(16);not null"`
	Nodes    []Node `json:"nodes" gorm:"foreignkey:SinkID"`
}