database

type Connection struct {
	Host     string `json:"host"`
	Port     string `json:"port"`
	Username string `json:"username"`
	Password string `json:"password"`
	Database string `json:"database"`
}

type GROUP struct {
	ID               int64     `json:"id" db:"id"`
	LeagueID         int64     `json:"league_id" db:"league_id"`
	LeagueSeasonName string    `json:"league_season_name" db:"league_season_name"`
	Name             string    `json:"name" db:"name"`
	Created          time.Time `json:"created" db:"created"`
}

type GROUP_USER struct {
	GroupID int64 `json:"group_id" db:"group_id"`
	UserID  int64 `json:"user_id" db:"user_id"`
}

type LEAGUE struct {
	ID             int64     `json:"id" db:"id"`
	PlatformEloID  int64     `json:"platform_elo_id" db:"platform_elo_id"`
	Name           string    `json:"name" db:"name"`
	GroupsLimit    int       `json:"groups_limit" db:"groups_limit"`
	GroupSizeLimit int       `json:"group_size_limit" db:"group_size_limit"`
	Start          time.Time `json:"start" db:"start"`
	End            time.Time `json:"end" db:"end"`
}

type LEAGUE_SEASON struct {
	LeagueID int64     `json:"league_id" db:"league_id"`
	Name     string    `json:"name" db:"name"`
	Start    time.Time `json:"start" db:"start"`
	End      time.Time `json:"end" db:"end"`
}

type PLATFORM struct {
	ID      int64  `json:"id" db:"id"`
	Name    string `json:"name" db:"name"`
	Version string `json:"version" db:"version"`
}

type PLATFORM_AUTH struct {
	PlatformID int64 `json:"platform_id" db:"platform_id"`
}

type PLATFORM_ELO struct {
	PlatformID int64 `json:"platform_id" db:"platform_id"`
}

type PLATFORM_ENDPOINT struct {
	PlatformID int64  `json:"platform_id" db:"platform_id"`
	Name       string `json:"name" db:"name"`
	Path       string `json:"path" db:"path"`
}

type PLATFORM_USER struct {
	UserID          int64  `json:"user_id" db:"user_id"`
	PlatformID      int64  `json:"platform_id" db:"platform_id"`
	AccessToken     string `json:"access_token" db:"access_token"`
	VerificationKey string `json:"verification_key" db:"verification_key"`
}

type RESULT struct {
	ID            int64     `json:"id" db:"id"`
	GroupID       int64     `json:"group_id" db:"group_id"`
	ELOBefore     int       `json:"elo_before" db:"elo_before"`
	ELOAfter      int       `json:"elo_after" db:"elo_after"`
	ELODifference int       `json:"elo_difference" db:"elo_difference"`
	Outcome       string    `json:"outcome" db:"outcome"`
	Played        time.Time `json:"played" db:"played"`
}

type RESULT_PLATFORM_ELO struct {
	ResultID        int64  `json:"result_id" db:"result_id"`
	PlatformEloID   int64  `json:"platform_elo_id" db:"platform_elo_id"`
	VerificationKey string `json:"verification_key" db:"verification_key"`
}

type USER struct {
	ID         int64     `json:"id" db:"id"`
	Name       string    `json:"name" db:"name"`
	Email      string    `json:"email" db:"email"`
	Registered time.Time `json:"registered" db:"registered"`
	LastOnline time.Time `json:"last_online" db:"last_online"`
}