model

type Ability struct {
	Group     string  `json:"group" gorm:"type:varchar(64);primaryKey;autoIncrement:false"`
	Model     string  `json:"model" gorm:"type:varchar(255);primaryKey;autoIncrement:false"`
	ChannelId int     `json:"channel_id" gorm:"primaryKey;autoIncrement:false;index"`
	Enabled   bool    `json:"enabled"`
	Priority  *int64  `json:"priority" gorm:"bigint;default:0;index"`
	Weight    uint    `json:"weight" gorm:"default:0;index"`
	Tag       *string `json:"tag" gorm:"index"`
}

type AbilityWithChannel struct {
	Ability
	ChannelType int `json:"channel_type"`
}

type BoundChannel struct {
	Name string `json:"name"`
	Type int    `json:"type"`
}

type CasinoAchievement struct {
	Id          int    `json:"id" gorm:"primaryKey;autoIncrement"`
	Key         string `json:"key" gorm:"type:varchar(50);uniqueIndex"`
	Name        string `json:"name" gorm:"type:varchar(100);not null"`
	Description string `json:"description" gorm:"type:varchar(255)"`
	Icon        string `json:"icon" gorm:"type:varchar(50)"`
	Category    string `json:"category" gorm:"type:varchar(30)"`
	Condition   string `json:"condition" gorm:"type:text"`
	RewardType  string `json:"reward_type" gorm:"type:varchar(20)"`
	RewardValue string `json:"reward_value" gorm:"type:varchar(100)"`
	SortOrder   int    `json:"sort_order" gorm:"default:0"`
	Enabled     bool   `json:"enabled" gorm:"default:true"`
	CreatedAt   int64  `json:"created_at" gorm:"bigint"`
}

type CasinoBigWin struct {
	Id         int     `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId     int     `json:"user_id" gorm:"not null;index:idx_casino_bigwin_user"`
	Username   string  `json:"username" gorm:"type:varchar(50)"`
	GameType   string  `json:"game_type" gorm:"type:varchar(20)"`
	BetAmount  float64 `json:"bet_amount"`
	Payout     float64 `json:"payout"`
	Multiplier float64 `json:"multiplier"`
	CreatedAt  int64   `json:"created_at" gorm:"bigint;index:idx_casino_bigwin_time"`
}

type CasinoDailyStats struct {
	Id           int    `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId       int    `json:"user_id" gorm:"not null;uniqueIndex:idx_casino_daily_ud"`
	Date         string `json:"date" gorm:"type:varchar(10);not null;uniqueIndex:idx_casino_daily_ud"`
	TotalBet     int    `json:"total_bet" gorm:"default:0"`
	TotalWon     int    `json:"total_won" gorm:"default:0"`
	TotalLost    int    `json:"total_lost" gorm:"default:0"`
	GamesPlayed  int    `json:"games_played" gorm:"default:0"`
	WinCount     int    `json:"win_count" gorm:"default:0"`
	BiggestWin   int    `json:"biggest_win" gorm:"default:0"`
	MaxWinStreak int    `json:"max_win_streak" gorm:"default:0"`
	CreatedAt    int64  `json:"created_at" gorm:"bigint"`
	UpdatedAt    int64  `json:"updated_at" gorm:"bigint"`
}

type CasinoGameRecord struct {
	Id          int    `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId      int    `json:"user_id" gorm:"not null;index:idx_casino_record_user"`
	GameType    string `json:"game_type" gorm:"type:varchar(20);not null;index:idx_casino_record_type"`
	BetAmount   int    `json:"bet_amount" gorm:"not null"`
	Payout      int    `json:"payout" gorm:"default:0"`
	NetProfit   int    `json:"net_profit" gorm:"default:0"`
	Result      string `json:"result" gorm:"type:varchar(10)"`
	Status      string `json:"status" gorm:"type:varchar(10);default:'active'"`
	Details     string `json:"details" gorm:"type:text"`
	CreatedAt   int64  `json:"created_at" gorm:"bigint"`
	CompletedAt *int64 `json:"completed_at,omitempty" gorm:"bigint"`
}

type CasinoUserAchievement struct {
	Id            int    `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId        int    `json:"user_id" gorm:"not null;uniqueIndex:idx_casino_ua_user_ach"`
	AchievementId int    `json:"achievement_id" gorm:"not null;uniqueIndex:idx_casino_ua_user_ach"`
	Progress      int    `json:"progress" gorm:"default:0"`
	Completed     bool   `json:"completed" gorm:"default:false"`
	ClaimedAt     *int64 `json:"claimed_at,omitempty" gorm:"bigint"`
	CreatedAt     int64  `json:"created_at" gorm:"bigint"`
	UpdatedAt     int64  `json:"updated_at" gorm:"bigint"`
}

type Channel struct {
	Id                 int     `json:"id"`
	Type               int     `json:"type" gorm:"default:0"`
	Key                string  `json:"key" gorm:"not null"`
	OpenAIOrganization *string `json:"openai_organization"`
	TestModel          *string `json:"test_model"`
	Status             int     `json:"status" gorm:"default:1"`
	Name               string  `json:"name" gorm:"index"`
	Weight             *uint   `json:"weight" gorm:"default:0"`
	CreatedTime        int64   `json:"created_time" gorm:"bigint"`
	TestTime           int64   `json:"test_time" gorm:"bigint"`
	ResponseTime       int     `json:"response_time"` // in milliseconds
	BaseURL            *string `json:"base_url" gorm:"column:base_url;default:''"`
	Other              string  `json:"other"`
	Balance            float64 `json:"balance"` // in USD
	BalanceUpdatedTime int64   `json:"balance_updated_time" gorm:"bigint"`
	Models             string  `json:"models"`
	Group              string  `json:"group" gorm:"type:varchar(64);default:'default'"`
	UsedQuota          int64   `json:"used_quota" gorm:"bigint;default:0"`
	ModelMapping       *string `json:"model_mapping" gorm:"type:text"`
	//MaxInputTokens     *int    `json:"max_input_tokens" gorm:"default:0"`
	StatusCodeMapping *string `json:"status_code_mapping" gorm:"type:varchar(1024);default:''"`
	Priority          *int64  `json:"priority" gorm:"bigint;default:0"`
	AutoBan           *int    `json:"auto_ban" gorm:"default:1"`
	OtherInfo         string  `json:"other_info"`
	Tag               *string `json:"tag" gorm:"index"`
	Setting           *string `json:"setting" gorm:"type:text"` // 渠道额外设置
	ParamOverride     *string `json:"param_override" gorm:"type:text"`
	HeaderOverride    *string `json:"header_override" gorm:"type:text"`
	Remark            *string `json:"remark" gorm:"type:varchar(255)" validate:"max=255"`
	// add after v0.8.5
	ChannelInfo ChannelInfo `json:"channel_info" gorm:"type:json"`

	OtherSettings string `json:"settings" gorm:"column:settings"` // 其他设置，存储azure版本等不需要检索的信息，详见dto.ChannelOtherSettings

	// cache info
	Keys []string `json:"-" gorm:"-"`
}

type ChannelInfo struct {
	IsMultiKey             bool                  `json:"is_multi_key"`                        // 是否多Key模式
	MultiKeySize           int                   `json:"multi_key_size"`                      // 多Key模式下的Key数量
	MultiKeyStatusList     map[int]int           `json:"multi_key_status_list"`               // key状态列表，key index -> status
	MultiKeyDisabledReason map[int]string        `json:"multi_key_disabled_reason,omitempty"` // key禁用原因列表，key index -> reason
	MultiKeyDisabledTime   map[int]int64         `json:"multi_key_disabled_time,omitempty"`   // key禁用时间列表，key index -> time
	MultiKeyPollingIndex   int                   `json:"multi_key_polling_index"`             // 多Key模式下轮询的key索引
	MultiKeyMode           constant.MultiKeyMode `json:"multi_key_mode"`
}

type Checkin struct {
	Id           int    `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId       int    `json:"user_id" gorm:"not null;uniqueIndex:idx_user_checkin_date"`
	CheckinDate  string `json:"checkin_date" gorm:"type:varchar(10);not null;uniqueIndex:idx_user_checkin_date"` // 格式: YYYY-MM-DD
	QuotaAwarded int    `json:"quota_awarded" gorm:"not null"`
	CreatedAt    int64  `json:"created_at" gorm:"bigint"`
}

type CheckinRecord struct {
	CheckinDate  string `json:"checkin_date"`
	QuotaAwarded int    `json:"quota_awarded"`
}

type CommentAuthor struct {
	Id          int    `json:"id"`
	Username    string `json:"username"`
	DisplayName string `json:"display_name"`
	AvatarUrl   string `json:"avatar_url"`
}

type CommentWithAuthor struct {
	SocialComment
	Author CommentAuthor `json:"author" gorm:"-"`
}

type CustomOAuthProvider struct {
	Id                    int    `json:"id" gorm:"primaryKey"`
	Name                  string `json:"name" gorm:"type:varchar(64);not null"`                          // Display name, e.g., "GitHub Enterprise"
	Slug                  string `json:"slug" gorm:"type:varchar(64);uniqueIndex;not null"`              // URL identifier, e.g., "github-enterprise"
	Icon                  string `json:"icon" gorm:"type:varchar(128);default:''"`                       // Icon name from @lobehub/icons
	Enabled               bool   `json:"enabled" gorm:"default:false"`                                   // Whether this provider is enabled
	ClientId              string `json:"client_id" gorm:"type:varchar(256)"`                             // OAuth client ID
	ClientSecret          string `json:"-" gorm:"type:varchar(512)"`                                     // OAuth client secret (not returned to frontend)
	AuthorizationEndpoint string `json:"authorization_endpoint" gorm:"type:varchar(512)"`                // Authorization URL
	TokenEndpoint         string `json:"token_endpoint" gorm:"type:varchar(512)"`                        // Token exchange URL
	UserInfoEndpoint      string `json:"user_info_endpoint" gorm:"type:varchar(512)"`                    // User info URL
	Scopes                string `json:"scopes" gorm:"type:varchar(256);default:'openid profile email'"` // OAuth scopes

	// Field mapping configuration (supports JSONPath via gjson)
	UserIdField      string `json:"user_id_field" gorm:"type:varchar(128);default:'sub'"`                 // User ID field path, e.g., "sub", "id", "data.user.id"
	UsernameField    string `json:"username_field" gorm:"type:varchar(128);default:'preferred_username'"` // Username field path
	DisplayNameField string `json:"display_name_field" gorm:"type:varchar(128);default:'name'"`           // Display name field path
	EmailField       string `json:"email_field" gorm:"type:varchar(128);default:'email'"`                 // Email field path

	// Advanced options
	WellKnown           string `json:"well_known" gorm:"type:varchar(512)"`            // OIDC discovery endpoint (optional)
	AuthStyle           int    `json:"auth_style" gorm:"default:0"`                    // 0=auto, 1=params, 2=header (Basic Auth)
	AccessPolicy        string `json:"access_policy" gorm:"type:text"`                 // JSON policy for access control based on user info
	AccessDeniedMessage string `json:"access_denied_message" gorm:"type:varchar(512)"` // Custom error message template when access is denied

	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type FollowCounts struct {
	Followers int64 `json:"followers"`
	Following int64 `json:"following"`
}

type FollowUserInfo struct {
	Id          int    `json:"id"`
	Username    string `json:"username"`
	DisplayName string `json:"display_name"`
	AvatarUrl   string `json:"avatar_url"`
	Bio         string `json:"bio"`
}

type GachaHistory struct {
	Id        int    `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId    int    `json:"user_id" gorm:"not null;index:idx_gacha_history_user"`
	PoolId    int    `json:"pool_id" gorm:"not null;index:idx_gacha_history_pool"`
	SpeciesId int    `json:"species_id" gorm:"not null"`
	Rarity    string `json:"rarity" gorm:"type:varchar(8)"`
	IsPity    bool   `json:"is_pity" gorm:"default:false"`
	CreatedAt int64  `json:"created_at" gorm:"bigint"`
}

type GachaPool struct {
	Id              int     `json:"id" gorm:"primaryKey;autoIncrement"`
	Name            string  `json:"name" gorm:"type:varchar(64);not null"`
	Description     string  `json:"description" gorm:"type:varchar(255)"`
	CostPerPull     int     `json:"cost_per_pull" gorm:"default:500"`
	TenPullDiscount float64 `json:"ten_pull_discount" gorm:"default:0.9"`
	Rates           string  `json:"rates" gorm:"type:text"`        // JSON: {"N":0.60,"R":0.25,"SR":0.12,"SSR":0.03}
	PityConfig      string  `json:"pity_config" gorm:"type:text"`  // JSON: {"sr_pity":10,"ssr_pity":80}
	SpeciesPool     string  `json:"species_pool" gorm:"type:text"` // JSON: [{"species_id":1,"rarity":"R","weight":100}]
	Enabled         bool    `json:"enabled" gorm:"default:true"`
	StartTime       int64   `json:"start_time" gorm:"default:0"`
	EndTime         int64   `json:"end_time" gorm:"default:0"`
	CreatedAt       int64   `json:"created_at" gorm:"bigint"`
	UpdatedAt       int64   `json:"updated_at" gorm:"bigint"`
}

type GringottsHeistRecord struct {
	Id          int    `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId      int    `json:"user_id" gorm:"not null;index:idx_heist_user"`
	HeistType   string `json:"heist_type" gorm:"type:varchar(20);not null"` // sneak, dragon, imperio
	EntranceFee int    `json:"entrance_fee" gorm:"default:0"`
	Success     bool   `json:"success" gorm:"default:false"`
	Reward      int    `json:"reward" gorm:"default:0"`
	Penalty     int    `json:"penalty" gorm:"default:0"`
	VaultBefore int64  `json:"vault_before" gorm:"default:0"`
	Details     string `json:"details" gorm:"type:text"` // JSON narrative
	CreatedAt   int64  `json:"created_at" gorm:"bigint;index:idx_heist_created"`
}

type JSONValue json.RawMessage

type Log struct {
	Id               int    `json:"id" gorm:"index:idx_created_at_id,priority:1;index:idx_user_id_id,priority:2"`
	UserId           int    `json:"user_id" gorm:"index;index:idx_user_id_id,priority:1"`
	CreatedAt        int64  `json:"created_at" gorm:"bigint;index:idx_created_at_id,priority:2;index:idx_created_at_type"`
	Type             int    `json:"type" gorm:"index:idx_created_at_type"`
	Content          string `json:"content"`
	Username         string `json:"username" gorm:"index;index:index_username_model_name,priority:2;default:''"`
	TokenName        string `json:"token_name" gorm:"index;default:''"`
	ModelName        string `json:"model_name" gorm:"index;index:index_username_model_name,priority:1;default:''"`
	Quota            int    `json:"quota" gorm:"default:0"`
	PromptTokens     int    `json:"prompt_tokens" gorm:"default:0"`
	CompletionTokens int    `json:"completion_tokens" gorm:"default:0"`
	UseTime          int    `json:"use_time" gorm:"default:0"`
	IsStream         bool   `json:"is_stream"`
	ChannelId        int    `json:"channel" gorm:"index"`
	ChannelName      string `json:"channel_name" gorm:"->"`
	TokenId          int    `json:"token_id" gorm:"default:0;index"`
	Group            string `json:"group" gorm:"index"`
	Ip               string `json:"ip" gorm:"index;default:''"`
	RequestId        string `json:"request_id,omitempty" gorm:"type:varchar(64);index:idx_logs_request_id;default:''"`
	Other            string `json:"other"`
}

type MarketFilter struct {
	SpeciesId   int
	Rarity      string
	MinStar     int
	MaxStar     int
	ListingType string
	MinPrice    int
	MaxPrice    int
	SortBy      string // price_asc, price_desc, time_desc, rarity
}

type MarketStats struct {
	TotalListings     int64 `json:"total_listings"`
	ActiveListings    int64 `json:"active_listings"`
	TotalTransactions int64 `json:"total_transactions"`
	TotalVolume       int64 `json:"total_volume"`
}

type Midjourney struct {
	Id          int    `json:"id"`
	Code        int    `json:"code"`
	UserId      int    `json:"user_id" gorm:"index"`
	Action      string `json:"action" gorm:"type:varchar(40);index"`
	MjId        string `json:"mj_id" gorm:"index"`
	Prompt      string `json:"prompt"`
	PromptEn    string `json:"prompt_en"`
	Description string `json:"description"`
	State       string `json:"state"`
	SubmitTime  int64  `json:"submit_time" gorm:"index"`
	StartTime   int64  `json:"start_time" gorm:"index"`
	FinishTime  int64  `json:"finish_time" gorm:"index"`
	ImageUrl    string `json:"image_url"`
	VideoUrl    string `json:"video_url"`
	VideoUrls   string `json:"video_urls"`
	Status      string `json:"status" gorm:"type:varchar(20);index"`
	Progress    string `json:"progress" gorm:"type:varchar(30);index"`
	FailReason  string `json:"fail_reason"`
	ChannelId   int    `json:"channel_id"`
	Quota       int    `json:"quota"`
	Buttons     string `json:"buttons"`
	Properties  string `json:"properties"`
}

type Model struct {
	Id           int            `json:"id"`
	ModelName    string         `json:"model_name" gorm:"size:128;not null;uniqueIndex:uk_model_name_delete_at,priority:1"`
	Description  string         `json:"description,omitempty" gorm:"type:text"`
	Icon         string         `json:"icon,omitempty" gorm:"type:varchar(128)"`
	Tags         string         `json:"tags,omitempty" gorm:"type:varchar(255)"`
	VendorID     int            `json:"vendor_id,omitempty" gorm:"index"`
	Endpoints    string         `json:"endpoints,omitempty" gorm:"type:text"`
	Status       int            `json:"status" gorm:"default:1"`
	SyncOfficial int            `json:"sync_official" gorm:"default:1"`
	CreatedTime  int64          `json:"created_time" gorm:"bigint"`
	UpdatedTime  int64          `json:"updated_time" gorm:"bigint"`
	DeletedAt    gorm.DeletedAt `json:"-" gorm:"index;uniqueIndex:uk_model_name_delete_at,priority:2"`

	BoundChannels []BoundChannel `json:"bound_channels,omitempty" gorm:"-"`
	EnableGroups  []string       `json:"enable_groups,omitempty" gorm:"-"`
	QuotaTypes    []int          `json:"quota_types,omitempty" gorm:"-"`
	NameRule      int            `json:"name_rule" gorm:"default:0"`

	MatchedModels []string `json:"matched_models,omitempty" gorm:"-"`
	MatchedCount  int      `json:"matched_count,omitempty" gorm:"-"`
}

type NotificationWithActor struct {
	SocialNotification
	Actor       PostAuthor `json:"actor" gorm:"-"`
	PostContent *string    `json:"post_content,omitempty" gorm:"-"`
}

type Option struct {
	Key   string `json:"key" gorm:"primaryKey"`
	Value string `json:"value"`
}

type PasskeyCredential struct {
	ID              int            `json:"id" gorm:"primaryKey"`
	UserID          int            `json:"user_id" gorm:"uniqueIndex;not null"`
	CredentialID    string         `json:"credential_id" gorm:"type:varchar(512);uniqueIndex;not null"` // base64 encoded
	PublicKey       string         `json:"public_key" gorm:"type:text;not null"`                        // base64 encoded
	AttestationType string         `json:"attestation_type" gorm:"type:varchar(255)"`
	AAGUID          string         `json:"aaguid" gorm:"type:varchar(512)"` // base64 encoded
	SignCount       uint32         `json:"sign_count" gorm:"default:0"`
	CloneWarning    bool           `json:"clone_warning"`
	UserPresent     bool           `json:"user_present"`
	UserVerified    bool           `json:"user_verified"`
	BackupEligible  bool           `json:"backup_eligible"`
	BackupState     bool           `json:"backup_state"`
	Transports      string         `json:"transports" gorm:"type:text"`
	Attachment      string         `json:"attachment" gorm:"type:varchar(32)"`
	LastUsedAt      *time.Time     `json:"last_used_at"`
	CreatedAt       time.Time      `json:"created_at"`
	UpdatedAt       time.Time      `json:"updated_at"`
	DeletedAt       gorm.DeletedAt `json:"-" gorm:"index"`
}

type PetActivity struct {
	Id           int    `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId       int    `json:"user_id" gorm:"not null;index:idx_pet_activity_user"`
	PetId        int    `json:"pet_id" gorm:"not null"`
	ActivityType string `json:"activity_type" gorm:"type:varchar(32);not null"` // hatched, evolved, star_up, ssr_pulled, mission_complete
	Data         string `json:"data" gorm:"type:text"`                          // JSON: activity details
	CreatedAt    int64  `json:"created_at" gorm:"bigint"`
}

type PetArenaBattle struct {
	Id                   int    `json:"id" gorm:"primaryKey;autoIncrement"`
	SeasonId             int    `json:"season_id" gorm:"index:idx_battle_season"`
	AttackerUserId       int    `json:"attacker_user_id" gorm:"not null"`
	AttackerPetId        int    `json:"attacker_pet_id" gorm:"not null"`
	DefenderUserId       int    `json:"defender_user_id" gorm:"not null"`
	DefenderPetId        int    `json:"defender_pet_id" gorm:"not null"`
	WinnerUserId         int    `json:"winner_user_id" gorm:"default:0"`
	AttackerRatingBefore int    `json:"attacker_rating_before" gorm:"default:0"`
	AttackerRatingAfter  int    `json:"attacker_rating_after" gorm:"default:0"`
	DefenderRatingBefore int    `json:"defender_rating_before" gorm:"default:0"`
	DefenderRatingAfter  int    `json:"defender_rating_after" gorm:"default:0"`
	BattleLog            string `json:"battle_log" gorm:"type:text"` // JSON rounds
	RewardQuota          int    `json:"reward_quota" gorm:"default:0"`
	CreatedAt            int64  `json:"created_at" gorm:"bigint;index:idx_battle_created"`
}

type PetArenaDefender struct {
	Id        int   `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId    int   `json:"user_id" gorm:"uniqueIndex"`
	PetId     int   `json:"pet_id" gorm:"not null"`
	Rating    int   `json:"rating" gorm:"default:1000;index:idx_defender_rating"`
	WinCount  int   `json:"win_count" gorm:"default:0"`
	LossCount int   `json:"loss_count" gorm:"default:0"`
	WinStreak int   `json:"win_streak" gorm:"default:0"`
	MaxStreak int   `json:"max_streak" gorm:"default:0"`
	SeasonId  int   `json:"season_id" gorm:"index:idx_defender_season"`
	CreatedAt int64 `json:"created_at" gorm:"bigint"`
	UpdatedAt int64 `json:"updated_at" gorm:"bigint"`
}

type PetArenaSeason struct {
	Id      int    `json:"id" gorm:"primaryKey;autoIncrement"`
	Name    string `json:"name" gorm:"type:varchar(64)"`
	StartAt int64  `json:"start_at" gorm:"bigint"`
	EndAt   int64  `json:"end_at" gorm:"bigint"`
	Status  string `json:"status" gorm:"type:varchar(10);default:'active'"` // active, ended
}

type PetDispatch struct {
	Id          int    `json:"id" gorm:"primaryKey;autoIncrement"`
	UserId      int    `json:"user_id" gorm:"not null;index:idx_pet_dispatch_user"`
	PetId       int    `json:"pet_id" gorm:"not null"`
	MissionId   int    `json:"mission_id" gorm:"not null"`
	StartedAt   int64  `json:"started_at" gorm:"bigint"`
	EndsAt      int64  `json:"ends_at" gorm:"bigint"`
	Status      string `json:"status" gorm:"type:varchar(16);default:'in_progress'"` // in_progress, completed, collected
	Success     bool   `json:"success" gorm:"default:false"`
	RewardsData string `json:"rewards_data" gorm:"type:text"` // JSON: actual rewards received
	CreatedAt   int64  `json:"created_at" gorm:"bigint"`
}

type PetItem struct {
	Id          int     `json:"id" gorm:"primaryKey;autoIncrement"`
	Name        string  `json:"name" gorm:"type:varchar(64);not null"`
	Description string  `json:"description" gorm:"type:varchar(255)"`
	Type        string  `json:"type" gorm:"type:varchar(16);not null"` // food, potion, material
	Rarity      string  `json:"rarity" gorm:"type:varchar(8)"`
	Effect      string  `json:"effect" gorm:"type:text"` // JSON: effect definition
	Price       float64 `json:"price" gorm:"default:0"`
	VisualKey   string  `json:"visual_key" gorm:"type:varchar(64)"`
	Enabled     bool    `json:"enabled" gorm:"default:true"`
	CreatedAt   int64   `json:"created_at" gorm:"bigint"`
	UpdatedAt   int64   `json:"updated_at" gorm:"bigint"`
}

type PetMarketBid struct {
	Id        int   `json:"id" gorm:"primaryKey;autoIncrement"`
	ListingId int   `json:"listing_id" gorm:"not null;index:idx_bid_listing"`
	BidderId  int   `json:"bidder_id" gorm:"not null;index:idx_bid_bidder"`
	Amount    int   `json:"amount" gorm:"not null"`
	CreatedAt int64 `json:"created_at" gorm:"bigint"`
}

type PetMarketListing struct {
	Id              int    `json:"id" gorm:"primaryKey;autoIncrement"`
	SellerId        int    `json:"seller_id" gorm:"not null;index:idx_listing_seller"`
	PetId           int    `json:"pet_id" gorm:"not null"`
	ListingType     string `json:"listing_type" gorm:"type:varchar(16);not null"` // fixed_price, auction
	Price           int    `json:"price" gorm:"default:0"`
	MinBid          int    `json:"min_bid" gorm:"default:0"`
	CurrentBid      int    `json:"current_bid" gorm:"default:0"`
	CurrentBidderId int    `json:"current_bidder_id" gorm:"default:0"`
	BidCount        int    `json:"bid_count" gorm:"default:0"`
	ExpiresAt       int64  `json:"expires_at" gorm:"bigint"`
	Status          string `json:"status" gorm:"type:varchar(16);default:'active';index:idx_listing_status"` // active, sold, expired, cancelled
	CreatedAt       int64  `json:"created_at" gorm:"bigint"`
	UpdatedAt       int64  `json:"updated_at" gorm:"bigint"`
}

type PetMarketTransaction struct {
	Id          int    `json:"id" gorm:"primaryKey;autoIncrement"`
	ListingId   int    `json:"listing_id" gorm:"not null;index:idx_tx_listing"`
	SellerId    int    `json:"seller_id" gorm:"not null;index:idx_tx_seller"`
	BuyerId     int    `json:"buyer_id" gorm:"not null;index:idx_tx_buyer"`
	PetId       int    `json:"pet_id" gorm:"not null"`
	Price       int    `json:"price" gorm:"not null"`
	ListingType string `json:"listing_type" gorm:"type:varchar(16)"`
	Fee         int    `json:"fee" gorm:"default:0"`
	CreatedAt   int64  `json:"created_at" gorm:"bigint"`
}

type PetMission struct {
	Id            int    `json:"id" gorm:"primaryKey;autoIncrement"`
	Name          string `json:"name" gorm:"type:varchar(64);not null"`
	Description   string `json:"description" gorm:"type:varchar(255)"`
	Duration      int    `json:"duration" gorm:"default:3600"` // seconds
	Difficulty    int    `json:"difficulty" gorm:"default:1"`  // 1-5
	RequiredLevel int    `json:"required_level" gorm:"default:1"`
	StatWeights   string `json:"stat_weights" gorm:"type:text"` // JSON: {"attack":0.3,"speed":0.5,"luck":0.2}
	Rewards       string `json:"rewards" gorm:"type:text"`      // JSON: [{"type":"quota","amount":100,"probability":1.0},{"type":"item","id":1,"amount":1,"probability":0.5}]
	MaxDaily      int    `json:"max_daily" gorm:"default:3"`
	Enabled       bool   `json:"enabled" gorm:"default:true"`
	CreatedAt     int64  `json:"created_at" gorm:"bigint"`
	UpdatedAt     int64  `json:"updated_at" gorm:"bigint"`
}

type PetPriceHistory struct {
	Id               int    `json:"id" gorm:"primaryKey;autoIncrement"`
	SpeciesId        int    `json:"species_id" gorm:"not null;index:idx_price_species"`
	Rarity           string `json:"rarity" gorm:"type:varchar(8)"`
	Star             int    `json:"star" gorm:"default:0"`
	AvgPrice         int    `json:"avg_price" gorm:"default:0"`
	MinPrice         int    `json:"min_price" gorm:"default:0"`
	MaxPrice         int    `json:"max_price" gorm:"default:0"`
	TransactionCount int    `json:"transaction_count" gorm:"default:0"`
	Period           string `json:"period" gorm:"type:varchar(16)"` // daily, weekly
	Date             string `json:"date" gorm:"type:varchar(16)"`
	CreatedAt        int64  `json:"created_at" gorm:"bigint"`
}

type PetSpecies struct {
	Id              int    `json:"id" gorm:"primaryKey;autoIncrement"`
	Name            string `json:"name" gorm:"type:varchar(64);not null"`
	Description     string `json:"description" gorm:"type:varchar(255)"`
	Rarity          string `json:"rarity" gorm:"type:varchar(8);not null"` // N, R, SR, SSR
	Element         string `json:"element" gorm:"type:varchar(16)"`
	BaseStats       string `json:"base_stats" gorm:"type:text"`       // JSON: {hp, atk, def, spd, ...}
	EvolutionStages string `json:"evolution_stages" gorm:"type:text"` // JSON: [{stage, name, visual_key}, ...]
	VisualKey       string `json:"visual_key" gorm:"type:varchar(64)"`
	IsStarter       bool   `json:"is_starter" gorm:"default:false"`
	Enabled         bool   `json:"enabled" gorm:"default:true"`
	CreatedAt       int64  `json:"created_at" gorm:"bigint"`
	UpdatedAt       int64  `json:"updated_at" gorm:"bigint"`
}

type PetStatsResult struct {
	PetCount   int `json:"pet_count"`
	MaxLevel   int `json:"max_level"`
	TotalStars int `json:"total_stars"`
}

type PostAuthor struct {
	Id          int    `json:"id"`
	Username    string `json:"username"`
	DisplayName string `json:"display_name"`
	AvatarUrl   string `json:"avatar_url"`
}

type PostWithAuthor struct {
	SocialPost
	Author         PostAuthor      `json:"author" gorm:"-"`
	LikeCount      int64           `json:"like_count" gorm:"-"`
	CommentCount   int64           `json:"comment_count" gorm:"-"`
	RepostCount    int64           `json:"repost_count" gorm:"-"`
	Liked          bool            `json:"liked" gorm:"-"`
	Bookmarked     bool            `json:"bookmarked" gorm:"-"`
	RepostOriginal *PostWithAuthor `json:"repost_original,omitempty" gorm:"-"`
}

type PrefillGroup struct {
	Id          int            `json:"id"`
	Name        string         `json:"name" gorm:"size:64;not null;uniqueIndex:uk_prefill_name,where:deleted_at IS NULL"`
	Type        string         `json:"type" gorm:"size:32;index;not null"`
	Items       JSONValue      `json:"items" gorm:"type:json"`
	Description string         `json:"description,omitempty" gorm:"type:varchar(255)"`
	CreatedTime int64          `json:"created_time" gorm:"bigint"`
	UpdatedTime int64          `json:"updated_time" gorm:"bigint"`
	DeletedAt   gorm.DeletedAt `json:"-" gorm:"index"`
}

type Pricing struct {
	ModelName              string                  `json:"model_name"`
	Description            string                  `json:"description,omitempty"`
	Icon                   string                  `json:"icon,omitempty"`
	Tags                   string                  `json:"tags,omitempty"`
	VendorID               int                     `json:"vendor_id,omitempty"`
	QuotaType              int                     `json:"quota_type"`
	ModelRatio             float64                 `json:"model_ratio"`
	ModelPrice             float64                 `json:"model_price"`
	OwnerBy                string                  `json:"owner_by"`
	CompletionRatio        float64                 `json:"completion_ratio"`
	CacheRatio             *float64                `json:"cache_ratio,omitempty"`
	CreateCacheRatio       *float64                `json:"create_cache_ratio,omitempty"`
	ImageRatio             *float64                `json:"image_ratio,omitempty"`
	AudioRatio             *float64                `json:"audio_ratio,omitempty"`
	AudioCompletionRatio   *float64                `json:"audio_completion_ratio,omitempty"`
	EnableGroup            []string                `json:"enable_groups"`
	SupportedEndpointTypes []constant.EndpointType `json:"supported_endpoint_types"`
	PricingVersion         string                  `json:"pricing_version,omitempty"`
}

type PricingVendor struct {
	ID          int    `json:"id"`
	Name        string `json:"name"`
	Description string `json:"description,omitempty"`
	Icon        string `json:"icon,omitempty"`
}

type Properties struct {
	Input             string `json:"input"`
	UpstreamModelName string `json:"upstream_model_name,omitempty"`
	OriginModelName   string `json:"origin_model_name,omitempty"`
}

type QuotaData struct {
	Id        int    `json:"id"`
	UserID    int    `json:"user_id" gorm:"index"`
	Username  string `json:"username" gorm:"index:idx_qdt_model_user_name,priority:2;size:64;default:''"`
	ModelName string `json:"model_name" gorm:"index:idx_qdt_model_user_name,priority:1;size:64;default:''"`
	CreatedAt int64  `json:"created_at" gorm:"bigint;index:idx_qdt_created_at,priority:2"`
	TokenUsed int    `json:"token_used" gorm:"default:0"`
	Count     int    `json:"count" gorm:"default:0"`
	Quota     int    `json:"quota" gorm:"default:0"`
}

type RankingUser struct {
	Rank        int    `json:"rank"`
	Id          int    `json:"id"`
	Username    string `json:"username"`
	DisplayName string `json:"display_name"`
	AvatarUrl   string `json:"avatar_url"`
	Value       int    `json:"value"`
}