model

type Collection struct {
	DeviceID  uint64    `gorm:"primarykey"`
	Timestamp time.Time `gorm:"primarykey"`
	CreatedAt time.Time `gorm:"autoCreateTime"`
	GeoPoint  GeoPoint  `gorm:"not null;type:geometry"`
}

type Device struct {
	Mac         string       `gorm:"primarykey"`
	DeviceID    uint64       `gorm:"not null;uniqueIndex"`
	Collections []Collection `gorm:"foreignKey:DeviceID;references:DeviceID;constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
	CreatedAt   time.Time    `gorm:"autoCreateTime"`
	UpdatedAt   time.Time    `gorm:"autoUpdateTime"`
}

type GeoPoint struct {
	Lat float64 `json:"lat"`
	Lng float64 `json:"lng"`
}