r3testing

type Artist struct {
	ID   int64 `gorm:"primaryKey"`
	Name string
	// Add more fields as needed (e.g., Bio, Genre, etc.)
	Translations []ArtistTranslation `gorm:"foreignKey:ArtistID"`
}

type ArtistToEvent struct {
	ArtistID int64 `gorm:"primaryKey"`
	EventID  int   `gorm:"primaryKey"`
}

type ArtistTranslation struct {
	ID       int64 `gorm:"primaryKey"`
	Name     string
	ArtistID int64  // Foreign key to Artist.ID
	Locale   string // e.g., "en", "es", "de"
}

type City struct {
	ID          int64 `gorm:"primaryKey"`
	Name        string
	CountryName string
	Popularity  int

	// Association: one-to-many with CityTranslation
	Translations []CityTranslation `gorm:"foreignKey:CityID"`
}

type CityTranslation struct {
	ID     int64 `gorm:"primaryKey"`
	Name   string
	CityID int64  // Foreign key to City.ID
	Locale string // e.g., "en", "es", "de"
}

type Event struct {
	ID         int64 `gorm:"primaryKey"`
	HappenedAt time.Time
	Name       string
	Weight     int
	LocationID int64 `gorm:"column:venue_id"` // DB column is venue_id
	Active     bool

	Location *Location `gorm:"foreignKey:LocationID"`

	Artists      []Artist           `gorm:"many2many:artist_to_events"`
	Translations []EventTranslation `gorm:"foreignKey:EventID"`
}

type EventTranslation struct {
	ID      int64 `gorm:"primaryKey"`
	Name    string
	EventID int64  // Foreign key to Event.ID
	Locale  string // e.g., "en", "es", "de"
}

type Location struct {
	ID         int64 `gorm:"primaryKey"`
	Name       string
	Slug       string
	CityID     int64
	Popularity int
	Visible    bool

	City         *City                 `gorm:"foreignKey:CityID"`
	Translations []LocationTranslation `gorm:"foreignKey:LocationID"`
}

type LocationTranslation struct {
	ID         int64 `gorm:"primaryKey"`
	Name       string
	Slug       string
	LocationID int64  // Foreign key to Location.ID
	Locale     string // e.g., "en", "es", "de"
}