db

type Creator struct {
	gorm.Model
	Name string `gorm:"uniqueIndex"`
}

type Episode struct {
	gorm.Model
	Title    string
	Part     int `gorm:"CHECK:part >= 0"`
	IssueID  uint
	Issue    Issue
	SeriesID uint
	Series   Series
	PageFrom int
	PageThru int
	Script   []*Creator `gorm:"many2many:episode_writers"`
	Art      []*Creator `gorm:"many2many:episode_artists"`
	Colours  []*Creator `gorm:"many2many:episode_colourists"`
	Letters  []*Creator `gorm:"many2many:episode_letterers"`
}

type EpisodeArtist struct {
	EpisodeID uint `gorm:"primaryKey"`
	CreatorID uint `gorm:"primaryKey"`
	CreatedAt time.Time
	DeletedAt gorm.DeletedAt
}

type EpisodeColourist struct {
	EpisodeID uint `gorm:"primaryKey"`
	CreatorID uint `gorm:"primaryKey"`
	CreatedAt time.Time
	DeletedAt gorm.DeletedAt
}

type EpisodeLetterer struct {
	EpisodeID uint `gorm:"primaryKey"`
	CreatorID uint `gorm:"primaryKey"`
	CreatedAt time.Time
	DeletedAt gorm.DeletedAt
}

type EpisodeWriter struct {
	EpisodeID uint `gorm:"primaryKey"`
	CreatorID uint `gorm:"primaryKey"`
	CreatedAt time.Time
	DeletedAt gorm.DeletedAt
}

type Issue struct {
	gorm.Model
	PublicationID uint `gorm:"uniqueIndex:idx_pub_issue"`
	Publication   Publication
	IssueNumber   int `gorm:"CHECK:issue_number >= 0;uniqueIndex:idx_pub_issue"`
	Episodes      []Episode
	Filename      string
}

type Publication struct {
	gorm.Model
	Title string `gorm:"CHECK:title <> NULL;uniqueIndex"`
}

type Series struct {
	gorm.Model
	Title string `gorm:"CHECK:title <> NULL;CHECK:title <> \"\";uniqueIndex"`
}

type Suggestion struct {
	From string
	To   string
	Type SuggestionType
}

type SuggestionType int64