database

type Board pq.StringArray

type DB = gorm.DB

type Game struct {
	ID    int   `gorm:"primaryKey;not null"`
	Board Board `gorm:"not null;type:varchar(16)[16];check:cardinality(board) <= 16"`
}

type Path []Point

type Player struct {
	ID    int    `gorm:"primaryKey;not null"`
	Name  string `gorm:"not null"`
	Words []Word `gorm:"many2many:word_players"`
}

type Point boggle.Point

type Word struct {
	ID      int `gorm:"primaryKey;not null"`
	GameID  int `gorm:"not null;uniqueKey:idx_word"`
	Game    *Game
	Path    Path     `gorm:"not null;uniqueKey:idx_word"`
	Players []Player `gorm:"many2many:word_players"`
}

type WordPlayer struct {
	WordID   int `gorm:"primaryKey;not null"`
	Word     *Word
	PlayerID int `gorm:"primaryKey;not null"`
	Player   *Player
}