data

type Ability struct {
	ID          int64          `db:"id" json:"id"`
	Name        string         `db:"name" json:"name"`
	Description string         `db:"description" json:"description"`
	Categories  pq.StringArray `db:"categories" json:"categories"`
	Charges     int            `db:"charges" json:"charges"`
	AnyAbility  bool           `db:"any_ability" json:"any_ability"`
	Rarity      string         `db:"rarity" json:"rarity"`
	CreatedAt   string         `db:"created_at" json:"created_at"`
}

type AbilityModel struct {
	DB *sqlx.DB
}

type Action struct {
	ID                 int64  `db:"id" json:"id"`
	RequestedAction    string `db:"requested_action" json:"requested_action"`
	RequestedChannelID string `db:"requested_channel_id" json:"requested_channel_id"`
	RequestedMessageID string `db:"requested_message_id" json:"requested_message_id"`
	RequesterID        string `db:"requester_id" json:"requester_id"`
	RequestedAt        string `db:"requested_at" json:"requested_at"`
	RequestedDay       int64  `db:"requested_day" json:"requested_day"`
}

type ActionModel struct {
	DB *sqlx.DB
}

type Alliance struct {
	ID        int            `db:"id" json:"id"`
	Name      string         `db:"name" json:"name"`
	ChannelID string         `db:"channel_id" json:"channel_id"`
	MemberIDs pq.StringArray `db:"member_ids" json:"member_ids"`
}

type AllianceInvite struct {
	ID              int    `db:"id" json:"id"`
	InviterID       string `db:"inviter_id" json:"inviter_id"`
	InviteeID       string `db:"invitee_id" json:"invitee_id"`
	AllianceName    string `db:"alliance_name" json:"alliance_name"`
	InviteeAccepted bool   `db:"invitee_accepted" json:"invitee_accepted"`
}

type AllianceModel struct {
	DB *sqlx.DB
}

type AllianceRequest struct {
	ID          int    `db:"id" json:"id"`
	RequesterID string `db:"requester_id" json:"requester_id"`
	Name        string `db:"name" json:"name"`
}

type AnyAbility struct {
	ID          int64          `db:"id" json:"id"`
	Name        string         `db:"name" json:"name"`
	Description string         `db:"description" json:"description"`
	Categories  pq.StringArray `db:"categories" json:"categories"`
	Rarity      string         `db:"rarity" json:"rarity"`
	// Name of the role that this ability is specific to. If empty, it is not specific to any role.
	RoleSpecific string `db:"role_specific"`
}

type ComplexRole struct {
	Role    *Role
	Ability []*Ability
	Perk    []*Perk
}

type FunnelChannel struct {
	ID         int64  `db:"id" json:"id"`
	ChannelID  string `db:"channel_id" json:"channel_id"`
	GuildID    string `db:"guild_id" json:"guild_id"`
	CurrentDay int    `db:"current_day" json:"current_day"`
}

type FunnelChannelModel struct {
	DB *sqlx.DB
}

type Hitlist struct {
	ID         int64  `db:"id" json:"id"`
	PinChannel string `db:"pin_channel" json:"pin_channel"`
	PinMessage string `db:"pin_message" json:"pin_message"`
}

type HitlistModel struct {
	DB *sqlx.DB
}

type Insult struct {
	Id        int64  `db:"id" json:"id"`
	Insult    string `db:"insult" json:"insult"`
	AuthorID  string `db:"author_id" json:"author_id"`
	CreatedAt string `db:"created_at" json:"created_at"`
}

type InsultModel struct {
	DB *sqlx.DB
}

type Inventory struct {
	ID             int64          `db:"id" json:"id"`
	DiscordID      string         `db:"discord_id" json:"discord_id"`
	UserPinChannel string         `db:"user_pin_channel" json:"user_pin_channel"`
	UserPinMessage string         `db:"user_pin_message" json:"user_pin_message"`
	RoleName       string         `db:"role_name" json:"role_name"`
	Alignment      string         `db:"alignment" json:"alignment"`
	Abilities      pq.StringArray `db:"abilities" json:"abilities"`
	AnyAbilities   pq.StringArray `db:"any_abilities" json:"any_abilities"`
	Statuses       pq.StringArray `db:"statuses" json:"statuses"`
	Immunities     pq.StringArray `db:"immunities" json:"immunities"`
	Effects        pq.StringArray `db:"effects" json:"effects"`
	Items          pq.StringArray `db:"items" json:"items"`
	ItemLimit      int            `db:"item_limit" json:"item_limit"`
	Perks          pq.StringArray `db:"perks" json:"perks"`
	IsAlive        bool           `db:"is_alive" json:"is_alive"`
	Coins          int64          `db:"coins" json:"coins"`
	CoinBonus      float32        `db:"coin_bonus" json:"coin_bonus"`
	Luck           int64          `db:"luck" json:"luck"`
	Notes          pq.StringArray `db:"notes" json:"notes"`
	CreatedAt      string         `db:"created_at" json:"created_at"`
}

type InventoryCronJob struct {
	ID int `db:"id"`
	// foreign key to Inventory ID
	InventoryID int64  `db:"inventory_id" json:"inventory_id"`
	ChannelID   string `db:"channel_id" json:"channel_id"`
	PlayerID    string `db:"player_id" json:"player_id"`
	Category    string `db:"category" json:"category"`
	ActionType  string `db:"action_type" json:"action_type"`
	Value       string `db:"value" json:"value"`
	StartTime   int64  `db:"start_time" json:"start_time"`
	InvokeTime  int64  `db:"invoke_time" json:"invoke_time"`
}

type InventoryCronJobModel struct {
	DB *sqlx.DB
}

type InventoryModel struct {
	DB *sqlx.DB
}

type Item struct {
	ID          int64          `db:"id" json:"id"`
	Name        string         `db:"name" json:"name"`
	Description string         `db:"description" json:"description"`
	Cost        int64          `db:"cost" json:"cost"`
	Rarity      string         `db:"rarity" json:"rarity"`
	Categories  pq.StringArray `db:"categories" json:"categories"`
	CreatedAt   string         `db:"created_at" json:"created_at"`
}

type ItemModel struct {
	DB *sqlx.DB
}

type Models struct {
	Roles             RoleModel
	Insults           InsultModel
	Abilities         AbilityModel
	Perks             PerkModel
	Statuses          StatusModel
	Items             ItemModel
	Inventories       InventoryModel
	Whitelists        WhitelistModel
	Actions           ActionModel
	FunnelChannels    FunnelChannelModel
	Votes             VoteModel
	RoleLists         RoleListModel
	Hitlists          HitlistModel
	Alliances         AllianceModel
	InventoryCronJobs InventoryCronJobModel
}

type Perk struct {
	ID          int64  `db:"id" json:"id"`
	Name        string `db:"name" json:"name"`
	Description string `db:"description" json:"description"`
	CreatedAt   string `db:"created_at" json:"created_at"`
}

type PerkModel struct {
	DB *sqlx.DB
}

type Role struct {
	ID          int64  `db:"id" json:"id"`
	Name        string `db:"name" json:"name"`
	Description string `db:"description" json:"description"`
	Alignment   string `db:"alignment" json:"alignment"`
	CreatedAt   string `db:"created_at" json:"created_at"`
}

type RoleList struct {
	ID    int            `db:"id" json:"id"`
	Roles pq.StringArray `db:"roles" json:"roles"`
}

type RoleListModel struct {
	DB *sqlx.DB
}

type RoleModel struct {
	DB *sqlx.DB
}

type Status struct {
	ID          int64  `db:"id" json:"id"`
	Name        string `db:"name" json:"name"`
	Description string `db:"description" json:"description"`
	CratedAt    string `db:"created_at" json:"created_at"`
}

type StatusModel struct {
	DB *sqlx.DB
}

type Vote struct {
	ID        int    `db:"id" json:"id"`
	ChannelID string `db:"channel_id" json:"channel_id"`
}

type VoteModel struct {
	DB *sqlx.DB
}

type Whitelist struct {
	ID          int64  `db:"id" json:"id"`
	ChannelID   string `db:"channel_id" json:"channel_id"`
	GuildID     string `db:"guild_id" json:"guild_id"`
	ChannelName string `db:"channel_name" json:"channel_name"`
}

type WhitelistModel struct {
	DB *sqlx.DB
}