models

type Album struct {
	gorm.Model

	Name string `gorm:"not null,unique_index"`

	Cover   *Image `gorm:"ForeignKey:CoverID"`
	CoverID NullInt64

	Year NullInt64

	Songs []*Song `gorm:"ForeignKey:AlbumID"`
}

type Artist struct {
	gorm.Model

	Name  string `gorm:"not null,unique_index"`
	Songs []*Song
}

type Image struct {
	gorm.Model

	Path string `gorm:"not null; unique"`
	Link string `gorm:"not null; unique"`
	Mime string `gorm:"not null"`
	Hash string `gorm:"not null; unique"`
}

type NullFloat64 struct {
	sql.NullFloat64
}

type NullInt64 struct {
	sql.NullInt64
}

type NullString struct {
	sql.NullString
}

type Playlist struct {
	gorm.Model

	Name  string  `gorm:"not null,unique_index"`
	Songs []*Song `gorm:"many2many:playlist_songs"`
}

type Song struct {
	gorm.Model

	Name string `gorm:"not null"`

	Artist   *Artist `gorm:"ForeignKey:ArtistID"`
	ArtistID NullInt64

	Album   *Album `gorm:"ForeignKey:AlbumID"`
	AlbumID NullInt64

	Cover   *Image `gorm:"ForeignKey:CoverID"`
	CoverID NullInt64

	Year        NullInt64
	Track       NullInt64
	TotalTracks NullInt64

	Genre    NullString
	Duration NullFloat64
	Mime     string `gorm:"not null"`
	Path     string `gorm:"not null"`
	Played   uint   `gorm:"not null"`
}

type User struct {
	gorm.Model

	Username string `gorm:"unique_index"`
	Password string `gorm:"not null"`
}