persistence

type DiscordChannel struct {
	ID             uint         `gorm:"primaryKey"`
	DiscordGuildID uint         `gorm:"not null"`
	DiscordGuild   DiscordGuild `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
	DiscordID      string
	Name           string
	IsDM           bool
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type DiscordGuild struct {
	ID        uint `gorm:"primaryKey"`
	DiscordID string
	Name      string
	OwnerID   string
	CreatedAt time.Time
	UpdatedAt time.Time
}

type DiscordUser struct {
	ID            uint `gorm:"primaryKey"`
	DiscordID     string
	Name          string
	Discriminator string
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type SC2ReplayStatsUser struct {
	ID                uint        `gorm:"primaryKey"`
	DiscordUserID     uint        `gorm:"not null"`
	DiscordUser       DiscordUser `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
	APIKey            string
	LastReplayID      int
	LastCheckedAt     time.Time
	UpdateScheduledAt time.Time
	CreatedAt         time.Time
	UpdatedAt         time.Time
}

type Subscription struct {
	ID                   uint               `gorm:"primaryKey"`
	DiscordChannelID     uint               `gorm:"not null"`
	DiscordChannel       DiscordChannel     `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
	SC2ReplayStatsUserID uint               `gorm:"not null"`
	SC2ReplayStatsUser   SC2ReplayStatsUser `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
	CreatedAt            time.Time
	UpdatedAt            time.Time
}