models

type Address struct {
	// gorm.Model
	ID           uint `gorm:"primary_key"`
	Street       string
	StreetNumber string
	PostalCode   string
	City         string
	Country      string
	PlusCode     string
	Coordinate   string
	RidersID     uint
	EventsID     uint
}

type Class struct {
	//gorm.Model
	ID   uint
	Name string `gorm:"not null"`
}

type Event struct {
	ID            uint   `gorm:"primary_key"`
	Name          string `gorm:"not null"`
	Date          string `gorm:"not null"`
	TotalStages   int    `gorm:"not null"`
	AddressesID   uint
	Addresses     Address `gorm:"foreignkey:EventsID;association_foreignkey:AddressesID"`
	TypeOfRacesID uint
	TypeOfRaces   TypeOfRace `gorm:"foreignkey:EventsID;association_foreignkey:TypeOfRacesID"` // One-To-One relationship (has one)
	SeasonsID     uint
	Seasons       Season `gorm:"foreignkey:EventsID;association_foreignkey:SeasonsID"` //;association_foreignkey:ID"
	StagesID      uint
	Stages        []Stage `gorm:"foreignkey:EventsID;association_foreignkey:StagesID"` // ;association_foreignkey:ID

}

type Post struct {
	gorm.Model
	Text   string `sql:"type:text;"`
	User   User   `gorm:"foreignkey:UserID"`
	UserID uint
}

type Registered struct {
	ID          uint `gorm:"primary_key"`
	Date        time.Time
	StartNumber string
	RidersID    uint
	Riders      Rider `gorm:"ForeignKey:ID;association_foreignkey:RidersID"`
	EventsID    uint
	Events      Event `gorm:"ForeignKey:ID;association_foreignkey:EventsID"`
	ClassID     uint
	Class       Class `gorm:"foreignkey:ID;association_foreignkey:ClassID"`
}

type Result struct {
	ID        uint `gorm:"primary_key"`
	TotalTime time.Time
	Place     uint
	RidersID  uint
	EventsID  uint
	Events    Event `gorm:"ForeignKey:ID;association_foreignkey:EventsID"`
}

type Rider struct {
	// gorm.Model
	ID          uint      `gorm:"primary_key"`
	Firstname   string    `gorm:"not null"`
	Lastname    string    `gorm:"not null"`
	Gender      int       `gorm:"not null"`
	Mail        string    `gorm:"not null"`
	Birthday    time.Time `gorm:"not null"`
	AddressesID uint
	Addresses   Address `gorm:"ForeignKey:ID;association_foreignkey:AddressesID"`
	RunsID      uint
	Runs        []Run `gorm:"ForeignKey:RidersID;association_foreignkey:RunsID"`
	ResultsID   uint
	Results     Result `gorm:"ForeignKey:RidersID;association_foreignkey:ResultsID"`
	StagesID    uint
	Stages      []Stage `gorm:"ForeignKey:ID;association_foreignkey:StagesID"`
}

type Run struct {
	ID        uint `gorm:"primary_key"`
	StartTime time.Time
	EndTime   time.Time
	DNF       bool
	RidersID  uint
	EventsID  uint
	StagesID  uint
}

type Season struct {
	ID       uint   `gorm:"primary_key"` //	gorm.Model
	Name     string `gorm:"not null"`
	Year     uint   `gorm:"not null"`
	EventsID uint
}

type Stage struct {
	ID       uint   `gorm:"primary_key"`
	Name     string `gorm:"not null"`
	Location string `gorm:"not null"`
	Order    uint   `gorm:"not null"`
	EventsID uint
}

type TypeOfRace struct {
	ID       uint   `gorm:"primary_key"` //	gorm.Model
	Name     string `gorm:"not null"`
	EventsID uint
}

type User struct {
	gorm.Model
	Username     string `gorm:"column:username;not null"`
	PasswordHash string `gorm:"column:password;not null"`
	DisplayName  string `gorm:"not null"`
}

type UserAccess struct {
	gorm.Model
	SourceID uint
	Role     string `gorm:"not null"`
}