model

type DataVer struct {
	gorm.Model       // updated_at etc
	ID         int32 `gorm:"primaryKey;autoIncrement:false"`
	CensusYear int32
	VerString  string
	Source     string
	Notes      string
	Public     bool
	GoMetrics  []GeoMetric `gorm:"foreignKey:DataVerID;references:ID"`
}

type Geo struct {
	ID        int32 `gorm:"primaryKey"`
	TypeID    int32
	Code      string `gorm:"index:unique"`
	Name      string
	WelshName string
	Lat       float64 // probably redundant use LongLatGeom
	Long      float64 // probably redundant use LongLatGeom
	Valid     bool    `gorm:"DEFAULT:true"`

	// wkb_geometry - added via ALTER don't migrate
	Wkbgeometry sql.NullString `gorm:"column:wkb_geometry;-:migration"`

	// wkb_long_lat_geom - added via ALTER don't migrate
	WkbLongLatGeom sql.NullString `gorm:"column:wkb_long_lat_geom;-:migration"`

	GoMetrics []GeoMetric `gorm:"foreignKey:GeoID;references:ID"`
	PostCodes []PostCode  `gorm:"foreignKey:GeoID;references:ID"`
}

type GeoMetric struct {
	ID         int32 `gorm:"primaryKey"`
	GeoID      int32 `gorm:"index"`
	CategoryID int32 `gorm:"index"`
	Metric     float64
	DataVerID  int32
}

type GeoType struct {
	ID   int32 `gorm:"primaryKey;autoIncrement:false"`
	Name string
	Geos []Geo `gorm:"foreignKey:TypeID;references:ID"`
}

type NomisCategory struct {
	// why do we need uniqueIndex? composite key!
	ID              int32 `gorm:"uniqueIndex;primaryKey"`
	NomisDescID     int32 `gorm:"primaryKey"`
	CategoryName    string
	MeasurementUnit string
	StatUnit        string
	LongNomisCode   string `gorm:"uniqueIndex"`
	Year            int32
	GoMetrics       []GeoMetric `gorm:"foreignKey:CategoryID;references:ID"`
}

type NomisDesc struct {
	ID              int32 `gorm:"uniqueIndex;primaryKey"`
	NomisTopicID    int32 `gorm:"primaryKey"`
	Name            string
	PopStat         string
	ShortNomisCode  string `gorm:"uniqueIndex"`
	Year            int32
	NomisCategories []NomisCategory `gorm:"foreignKey:NomisDescID;references:ID"`
}

type NomisTopic struct {
	ID           int32 `gorm:"primaryKey"`
	TopNomisCode string
	Name         string
	NomisDescs   []NomisDesc `gorm:"foreignKey:NomisTopicID;references:ID"`
}

type PostCode struct {
	ID    int32 `gorm:"primaryKey"`
	GeoID int32 `gorm:"index"`
	Pcds  string
	Geo   Geo // XXX
}

type SchemaVer struct {
	gorm.Model // updated_at etc
	BuildTime  string
	GitCommit  string
	Version    string
}

type YearMapping struct {
	ID           int32 `gorm:"primaryKey"`
	Lsoa2011code string
	Lad2020code  string
}