character

type Character struct {
	ID          int64     `gorm:"column:id;primaryKey;autoIncrement" json:"id"`
	NovelID     int64     `gorm:"column:novel_id;not null;index"    json:"novel_id"`
	Name        string    `gorm:"column:name;not null;index"        json:"name"`
	Description string    `gorm:"column:description"                json:"description"` // 自然语言描述，LLM 填写
	Personality string    `gorm:"column:personality"                json:"personality"` // JSON 自由格式，LLM 填写。如 {"traits":["勇敢","冲动"],"brief":"一个热血青年"}
	Abilities   string    `gorm:"column:abilities"                  json:"abilities"`   // JSON 数组，如 ["剑术","隐身"]
	CreatedAt   time.Time `gorm:"column:created_at;autoCreateTime"  json:"created_at"`
	UpdatedAt   time.Time `gorm:"column:updated_at;autoUpdateTime"  json:"updated_at"`
}

type CharacterRelation struct {
	ID                int64     `gorm:"column:id;primaryKey;autoIncrement"           json:"id"`
	NovelID           int64     `gorm:"column:novel_id;not null;index"              json:"novel_id"`
	SourceCharacterID int64     `gorm:"column:source_character_id;not null;index"   json:"source_character_id"` // 关系发出方
	TargetCharacterID int64     `gorm:"column:target_character_id;not null;index"   json:"target_character_id"` // 关系接收方
	RelationDescribe  string    `gorm:"column:relation_describe;not null"          json:"relation_describe"`    // 自由文本，LLM 自行描述，如 "亦师亦敌"、"朋友、高中同学"，工具描述的时候需要告诉llm详细描述而不是简单的type
	Description       string    `gorm:"column:description"                          json:"description"`         // 当前关系阶段的详细描述
	ChapterID         *int64    `gorm:"column:chapter_id;index"                     json:"chapter_id"`          // 此关系在哪个章节确立/变更；nil 表示未关联具体章节
	IsCurrent         bool      `gorm:"column:is_current;not null;index"            json:"is_current"`          // true=当前有效关系，false=历史记录
	CreatedAt         time.Time `gorm:"column:created_at;autoCreateTime"            json:"created_at"`
}

type Group struct {
	ID          int64     `gorm:"column:id;primaryKey;autoIncrement" json:"id"`
	NovelID     int64     `gorm:"column:novel_id;not null;uniqueIndex:uk_character_group_name" json:"novel_id"`
	Name        string    `gorm:"column:name;not null;uniqueIndex:uk_character_group_name" json:"name"`
	Description string    `gorm:"column:description" json:"description"`
	CreatedAt   time.Time `gorm:"column:created_at;autoCreateTime" json:"created_at"`
	UpdatedAt   time.Time `gorm:"column:updated_at;autoUpdateTime" json:"updated_at"`
}

type GroupMember struct {
	ID          int64     `gorm:"column:id;primaryKey;autoIncrement" json:"id"`
	NovelID     int64     `gorm:"column:novel_id;not null;index" json:"novel_id"`
	GroupID     int64     `gorm:"column:group_id;not null;uniqueIndex:uk_character_group_member" json:"group_id"`
	CharacterID int64     `gorm:"column:character_id;not null;uniqueIndex:uk_character_group_member;index" json:"character_id"`
	CreatedAt   time.Time `gorm:"column:created_at;autoCreateTime" json:"created_at"`
}

type GroupView struct {
	Group
	MemberCount int64 `gorm:"column:member_count;->;-:migration" json:"member_count"`
}

type ListByNovelOptions struct {
	PageParams storage.PageParams
	GroupID    *int64 // nil=全部，0=未分组，正整数=指定分组
	Search     string // 空字符串=不过滤，按 name LIKE 模糊匹配
	Order      string // 空字符串=默认 "updated_at DESC"；否则直接作为 ORDER BY 子句（如 "name ASC"）
}

type ListGroupMembersOptions struct {
	PageParams  storage.PageParams
	GroupID     int64  // 0=不过滤，正整数=指定分组
	CharacterID int64  // 0=不过滤，正整数=指定角色
	Search      string // 空字符串=不过滤，按角色 name LIKE 模糊匹配
	Order       string // 空字符串=默认 group_id ASC, character_id ASC；按成员表字段排序
}

type ListGroupsOptions struct {
	PageParams storage.PageParams
	Search     string // 空字符串=不过滤，按 name LIKE OR description LIKE 模糊匹配
	Order      string // 空字符串=默认 name ASC, id ASC；调用方可显式指定排序
}

type Store struct {
	DB *gorm.DB
	// contains filtered or unexported fields
}