dao

type AccessToken struct {
	ID          uint32    `gorm:"column:id;type:mediumint(8);primaryKey;autoIncrement:true" json:""`
	Type        uint8     `gorm:"column:type;type:tinyint(1) unsigned;not null" json:""`
	AccessToken string    `gorm:"column:access_token;type:varchar(40);not null" json:""`
	ClientID    string    `gorm:"column:client_id;type:varchar(80);not null" json:""`
	UserID      string    `gorm:"column:user_id;type:varchar(80)" json:""`
	ExpiredAt   time.Time `gorm:"column:expires;type:timestamp;not null;default:CURRENT_TIMESTAMP" json:""`
	Scope       *string   `gorm:"column:scope;type:varchar(4000)" json:""`
	Info        []byte    `gorm:"column:info;type:varchar(255);not null" json:""`
}

type Cast struct {
	CharacterID   uint32 `gorm:"column:crt_id;type:mediumint(9) unsigned;primaryKey" json:""`
	PersonID      uint32 `gorm:"column:prsn_id;type:mediumint(9) unsigned;primaryKey" json:""`
	SubjectID     uint32 `gorm:"column:subject_id;type:mediumint(9) unsigned;primaryKey" json:""`
	SubjectTypeID uint8  `` // 根据人物归类查询角色，动画，书籍，游戏
	/* 137-byte string literal not displayed */
	Summary string `` // 幼年，男乱马，女乱马，变身形态，少女形态。。
	/* 131-byte string literal not displayed */
	Character Character `gorm:"foreignKey:crt_id;references:crt_id" json:"character"`
	Subject   Subject   `gorm:"foreignKey:subject_id;references:subject_id" json:"subject"`
	Person    Person    `gorm:"foreignKey:prsn_id;references:prsn_id" json:"person"`
}

type Character struct {
	ID       uint32      `gorm:"column:crt_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	Name     string      `gorm:"column:crt_name;type:varchar(255);not null" json:""`
	Role     uint8       `gorm:"column:crt_role;type:tinyint(4) unsigned;not null;comment:角色，机体，组织。。" json:""` // 角色，机体，组织。。
	Infobox  string      `gorm:"column:crt_infobox;type:mediumtext;not null" json:""`
	Summary  string      `gorm:"column:crt_summary;type:mediumtext;not null" json:""`
	Img      string      `gorm:"column:crt_img;type:varchar(255);not null" json:""`
	Comment  uint32      `gorm:"column:crt_comment;type:mediumint(9) unsigned;not null" json:""`
	Collects uint32      `gorm:"column:crt_collects;type:mediumint(8) unsigned;not null" json:""`
	Dateline uint32      `gorm:"column:crt_dateline;type:int(10) unsigned;not null" json:""`
	Lastpost uint32      `gorm:"column:crt_lastpost;type:int(11) unsigned;not null" json:""`
	Lock     int8        `gorm:"column:crt_lock;type:tinyint(4);not null" json:""`
	ImgAnidb string      `gorm:"column:crt_img_anidb;type:varchar(255);not null" json:""`         // Deprecated
	AnidbID  uint32      `gorm:"column:crt_anidb_id;type:mediumint(8) unsigned;not null" json:""` // Deprecated
	Ban      uint8       `gorm:"column:crt_ban;type:tinyint(3) unsigned;not null" json:""`
	Redirect uint32      `gorm:"column:crt_redirect;type:int(10) unsigned;not null" json:""`
	Nsfw     bool        `gorm:"column:crt_nsfw;type:tinyint(1) unsigned;not null" json:""`
	Fields   PersonField `gorm:"foreignKey:crt_id;polymorphic:Owner;polymorphicValue:crt" json:"fields"`
}

type CharacterSubjects struct {
	CharacterID   uint32    `gorm:"column:crt_id;type:mediumint(9) unsigned;primaryKey" json:""`
	SubjectID     uint32    `gorm:"column:subject_id;type:mediumint(9) unsigned;primaryKey" json:""`
	SubjectTypeID uint8     `gorm:"column:subject_type_id;type:tinyint(4) unsigned;not null" json:""`
	CrtType       uint8     `gorm:"column:crt_type;type:tinyint(4) unsigned;not null;comment:主角，配角" json:""`    // 主角，配角
	CtrAppearEps  string    `gorm:"column:ctr_appear_eps;type:mediumtext;not null;comment:可选，角色出场的的章节" json:""` // 可选，角色出场的的章节
	CrtOrder      uint16    `gorm:"column:crt_order;type:smallint(6) unsigned;not null" json:""`
	Character     Character `gorm:"foreignKey:crt_id;references:crt_id" json:"character"`
	Subject       Subject   `gorm:"foreignKey:subject_id;references:subject_id" json:"subject"`
}

type EpCollection struct {
	ID          uint32 `gorm:"column:ep_stt_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	UserID      uint32 `gorm:"column:ep_stt_uid;type:mediumint(8) unsigned;not null" json:""`
	SubjectID   uint32 `gorm:"column:ep_stt_sid;type:mediumint(8) unsigned;not null" json:""`
	OnPrg       bool   `gorm:"column:ep_stt_on_prg;type:tinyint(1) unsigned;not null" json:""`
	Status      []byte `gorm:"column:ep_stt_status;type:mediumtext;not null" json:""`
	UpdatedTime uint32 `gorm:"column:ep_stt_lasttouch;type:int(10) unsigned;not null" json:""`
}

type Episode struct {
	ID        uint32  `gorm:"column:ep_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	SubjectID uint32  `gorm:"column:ep_subject_id;type:mediumint(8) unsigned;not null" json:""`
	Sort      float32 `gorm:"column:ep_sort;type:float unsigned;not null" json:""`
	Type      uint8   `gorm:"column:ep_type;type:tinyint(1) unsigned;not null" json:""`
	Disc      uint8   `gorm:"column:ep_disc;type:tinyint(3) unsigned;not null;comment:碟片数" json:""` // 碟片数
	Name      string  `gorm:"column:ep_name;type:varchar(80);not null" json:""`
	NameCn    string  `gorm:"column:ep_name_cn;type:varchar(80);not null" json:""`
	Rate      int8    `gorm:"column:ep_rate;type:tinyint(3);not null" json:""`
	Duration  string  `gorm:"column:ep_duration;type:varchar(80);not null" json:""`
	Airdate   string  `gorm:"column:ep_airdate;type:varchar(80);not null" json:""`
	Online    string  `gorm:"column:ep_online;type:mediumtext;not null" json:""`
	Comment   uint32  `gorm:"column:ep_comment;type:mediumint(8) unsigned;not null" json:""`
	Resources uint32  `gorm:"column:ep_resources;type:mediumint(8) unsigned;not null" json:""`
	Desc      string  `gorm:"column:ep_desc;type:mediumtext;not null" json:""`
	Dateline  uint32  `gorm:"column:ep_dateline;type:int(10) unsigned;not null" json:""`
	Lastpost  uint32  `gorm:"column:ep_lastpost;type:int(10) unsigned;not null" json:""`
	Lock      uint8   `gorm:"column:ep_lock;type:tinyint(3) unsigned;not null" json:""`
	Ban       uint8   `gorm:"column:ep_ban;type:tinyint(3) unsigned;not null" json:""`
	Subject   Subject `gorm:"foreignKey:ep_subject_id;references:subject_id" json:"subject"`
}

type Friend struct {
	UserID      uint32 `gorm:"column:frd_uid;type:mediumint(8) unsigned;not null" json:""`
	FriendID    uint32 `gorm:"column:frd_fid;type:mediumint(8) unsigned;not null" json:""`
	Grade       uint8  `gorm:"column:frd_grade;type:tinyint(3) unsigned;not null;default:1" json:""`
	CreatedTime uint32 `gorm:"column:frd_dateline;type:int(10) unsigned;not null" json:""`
	Description string `gorm:"column:frd_description;type:char(255);not null" json:""`
}

type Index struct {
	ID           uint32                `gorm:"column:idx_id;type:mediumint(8);primaryKey;autoIncrement:true;comment:自动id" json:""` // 自动id
	Type         uint8                 `gorm:"column:idx_type;type:tinyint(3) unsigned;not null" json:""`
	Title        string                `gorm:"column:idx_title;type:varchar(80);not null;comment:标题" json:""`                       // 标题
	Desc         string                `gorm:"column:idx_desc;type:mediumtext;not null;comment:简介" json:""`                         // 简介
	ReplyCount   uint32                `gorm:"column:idx_replies;type:mediumint(8) unsigned;not null;comment:回复数" json:""`          // 回复数
	SubjectCount uint32                `gorm:"column:idx_subject_total;type:mediumint(8) unsigned;not null;comment:内含条目总数" json:""` // 内含条目总数
	CollectCount uint32                `gorm:"column:idx_collects;type:mediumint(8);not null;comment:收藏数" json:""`                  // 收藏数
	Stats        string                `gorm:"column:idx_stats;type:mediumtext;not null" json:""`
	CreatedTime  int32                 `gorm:"column:idx_dateline;type:int(10);not null;comment:创建时间" json:""` // 创建时间
	UpdatedTime  uint32                `gorm:"column:idx_lasttouch;type:int(10) unsigned;not null" json:""`
	CreatorID    uint32                `gorm:"column:idx_uid;type:mediumint(8);not null;comment:创建人UID" json:""` // 创建人UID
	Deleted      soft_delete.DeletedAt `gorm:"column:idx_ban;type:tinyint(1) unsigned;not null;softDelete:flag" json:""`
}

type IndexCollect struct {
	CltID       uint32 `gorm:"column:idx_clt_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	IndexID     uint32 `gorm:"column:idx_clt_mid;type:mediumint(8) unsigned;not null;comment:目录ID" json:""`  // 目录ID
	UserID      uint32 `gorm:"column:idx_clt_uid;type:mediumint(8) unsigned;not null;comment:用户UID" json:""` // 用户UID
	CreatedTime uint32 `gorm:"column:idx_clt_dateline;type:int(10) unsigned;not null" json:""`
}

type IndexSubject struct {
	ID          uint32                `gorm:"column:idx_rlt_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	Cat         int8                  `gorm:"column:idx_rlt_cat;type:tinyint(3);not null" json:""`
	IndexID     uint32                `gorm:"column:idx_rlt_rid;type:mediumint(8) unsigned;not null;comment:关联目录" json:""`   // 关联目录
	SubjectType uint8                 `gorm:"column:idx_rlt_type;type:smallint(6) unsigned;not null;comment:关联条目类型" json:""` // 关联条目类型
	SubjectID   uint32                `gorm:"column:idx_rlt_sid;type:mediumint(8) unsigned;not null;comment:关联条目ID" json:""` // 关联条目ID
	Order       uint32                `gorm:"column:idx_rlt_order;type:mediumint(8) unsigned;not null" json:""`
	Comment     string                `gorm:"column:idx_rlt_comment;type:mediumtext;not null" json:""`
	CreatedTime uint32                `gorm:"column:idx_rlt_dateline;type:int(10) unsigned;not null" json:""`
	Deleted     soft_delete.DeletedAt `gorm:"column:idx_rlt_ban;type:tinyint(1) unsigned;not null;softDelete:flag" json:""`
	Subject     Subject               `gorm:"foreignKey:idx_rlt_sid;references:subject_id" json:"subject"`
}

type Member struct {
	ID            uint32                     `gorm:"column:uid;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	Username      string                     `gorm:"column:username;type:char(15);not null" json:""`
	Nickname      string                     `gorm:"column:nickname;type:varchar(30);not null" json:""`
	Avatar        string                     `gorm:"column:avatar;type:varchar(255);not null" json:""`
	Groupid       uint8                      `gorm:"column:groupid;type:smallint(6) unsigned;not null" json:""`
	Regdate       int64                      `gorm:"column:regdate;type:int(10) unsigned;not null" json:""`
	Lastvisit     uint32                     `gorm:"column:lastvisit;type:int(10) unsigned;not null" json:""`
	Lastactivity  uint32                     `gorm:"column:lastactivity;type:int(10) unsigned;not null" json:""`
	Lastpost      uint32                     `gorm:"column:lastpost;type:int(10) unsigned;not null" json:""`
	Dateformat    string                     `gorm:"column:dateformat;type:char(10);not null" json:""`
	Timeformat    bool                       `gorm:"column:timeformat;type:tinyint(1);not null" json:""`
	Timeoffset    string                     `gorm:"column:timeoffset;type:char(4);not null" json:""`
	Newpm         bool                       `gorm:"column:newpm;type:tinyint(1);not null" json:""`
	NewNotify     uint16                     `gorm:"column:new_notify;type:smallint(6) unsigned;not null;comment:新提醒" json:""` // 新提醒
	Sign          utiltype.HTMLEscapedString `gorm:"column:sign;type:varchar(255);not null" json:""`
	PasswordCrypt []byte                     `gorm:"column:password_crypt;type:char(64);not null" json:""`
	Email         string                     `gorm:"column:email;type:char(50);not null" json:""`
	Acl           string                     `gorm:"column:acl;type:mediumtext;not null" json:""`
	Fields        MemberField                `gorm:"foreignKey:uid;references:uid" json:"fields"`
}

type MemberField struct {
	UID       uint32 `gorm:"column:uid;type:mediumint(8) unsigned;primaryKey" json:""`
	Site      string `gorm:"column:site;type:varchar(75);not null" json:""`
	Location  string `gorm:"column:location;type:varchar(30);not null" json:""`
	Bio       string `gorm:"column:bio;type:text;not null" json:""`
	Privacy   []byte `gorm:"column:privacy;type:mediumtext;not null" json:""`
	Blocklist string `gorm:"column:blocklist;type:mediumtext;not null" json:""`
}

type Notification struct {
	ID          uint32 `gorm:"column:nt_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	ReceiverID  uint32 `gorm:"column:nt_uid;type:mediumint(8) unsigned;not null" json:""`
	SenderID    uint32 `gorm:"column:nt_from_uid;type:mediumint(8) unsigned;not null" json:""`
	Status      uint8  `gorm:"column:nt_status;type:tinyint(1) unsigned;not null;default:1" json:""`
	Type        uint8  `gorm:"column:nt_type;type:tinyint(3) unsigned;not null" json:""`
	FieldID     uint32 `gorm:"column:nt_mid;type:mediumint(8) unsigned;not null;comment:ID in notify_field" json:""` // ID in notify_field
	RelatedID   uint32 `gorm:"column:nt_related_id;type:int(10) unsigned;not null" json:""`
	CreatedTime uint32 `gorm:"column:nt_dateline;type:int(10) unsigned;not null" json:""`
}

type NotificationField struct {
	ID          uint32 `gorm:"column:ntf_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	RelatedType uint8  `gorm:"column:ntf_hash;type:tinyint(3) unsigned;not null" json:""`
	RelatedID   uint32 `gorm:"column:ntf_rid;type:int(10) unsigned;not null" json:""`
	Title       string `gorm:"column:ntf_title;type:varchar(255);not null" json:""`
}

type Person struct {
	ID          uint32      `gorm:"column:prsn_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	Name        string      `gorm:"column:prsn_name;type:varchar(255);not null" json:""`
	Type        uint8       `gorm:"column:prsn_type;type:tinyint(4) unsigned;not null;comment:个人，公司，组合" json:""` // 个人，公司，组合
	Infobox     string      `gorm:"column:prsn_infobox;type:mediumtext;not null" json:""`
	Producer    bool        `gorm:"column:prsn_producer;type:tinyint(1);not null" json:""`
	Mangaka     bool        `gorm:"column:prsn_mangaka;type:tinyint(1);not null" json:""`
	Artist      bool        `gorm:"column:prsn_artist;type:tinyint(1);not null" json:""`
	Seiyu       bool        `gorm:"column:prsn_seiyu;type:tinyint(1);not null" json:""`
	Writer      bool        `gorm:"column:prsn_writer;type:tinyint(4);not null;comment:作家" json:""`      // 作家
	Illustrator bool        `gorm:"column:prsn_illustrator;type:tinyint(4);not null;comment:绘师" json:""` // 绘师
	Actor       bool        `gorm:"column:prsn_actor;type:tinyint(1);not null;comment:演员" json:""`       // 演员
	Summary     string      `gorm:"column:prsn_summary;type:mediumtext;not null" json:""`
	Img         string      `gorm:"column:prsn_img;type:varchar(255);not null" json:""`
	ImgAnidb    string      `gorm:"column:prsn_img_anidb;type:varchar(255);not null" json:""` // Deprecated
	Comment     uint32      `gorm:"column:prsn_comment;type:mediumint(9) unsigned;not null" json:""`
	Collects    uint32      `gorm:"column:prsn_collects;type:mediumint(8) unsigned;not null" json:""`
	Dateline    uint32      `gorm:"column:prsn_dateline;type:int(10) unsigned;not null" json:""`
	Lastpost    uint32      `gorm:"column:prsn_lastpost;type:int(11) unsigned;not null" json:""`
	Lock        int8        `gorm:"column:prsn_lock;type:tinyint(4);not null" json:""`
	AnidbID     uint32      `gorm:"column:prsn_anidb_id;type:mediumint(8) unsigned;not null" json:""` // Deprecated
	Ban         uint8       `gorm:"column:prsn_ban;type:tinyint(3) unsigned;not null" json:""`
	Redirect    uint32      `gorm:"column:prsn_redirect;type:int(10) unsigned;not null" json:""`
	Nsfw        bool        `gorm:"column:prsn_nsfw;type:tinyint(1) unsigned;not null" json:""`
	Fields      PersonField `gorm:"foreignKey:prsn_id;polymorphic:Owner;polymorphicValue:prsn" json:"fields"`
}

type PersonCollect struct {
	ID          uint32 `gorm:"column:prsn_clt_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	Category    string `gorm:"column:prsn_clt_cat;type:enum('prsn','crt');not null" json:""`
	TargetID    uint32 `gorm:"column:prsn_clt_mid;type:mediumint(8) unsigned;not null" json:""`
	UserID      uint32 `gorm:"column:prsn_clt_uid;type:mediumint(8) unsigned;not null" json:""`
	CreatedTime uint32 `gorm:"column:prsn_clt_dateline;type:int(10) unsigned;not null" json:""`
}

type PersonField struct {
	OwnerType string `gorm:"column:prsn_cat;type:enum('prsn','crt');primaryKey" json:""`
	OwnerID   uint32 `gorm:"column:prsn_id;type:int(8) unsigned;primaryKey" json:""`
	Gender    uint8  `gorm:"column:gender;type:tinyint(4) unsigned;not null" json:""`
	Bloodtype uint8  `gorm:"column:bloodtype;type:tinyint(4) unsigned;not null" json:""`
	BirthYear uint16 `gorm:"column:birth_year;type:year(4);not null" json:""`
	BirthMon  uint8  `gorm:"column:birth_mon;type:tinyint(2) unsigned;not null" json:""`
	BirthDay  uint8  `gorm:"column:birth_day;type:tinyint(2) unsigned;not null" json:""`
}

type PersonSubjects struct {
	PrsnType      string  `gorm:"column:prsn_type;type:enum('prsn','crt');primaryKey" json:""`
	PersonID      uint32  `gorm:"column:prsn_id;type:mediumint(9) unsigned;primaryKey" json:""`
	PrsnPosition  uint16  `gorm:"column:prsn_position;type:smallint(5) unsigned;primaryKey;comment:监督，原案，脚本,.." json:""` // 监督，原案，脚本,..
	SubjectID     uint32  `gorm:"column:subject_id;type:mediumint(9) unsigned;primaryKey" json:""`
	SubjectTypeID uint8   `gorm:"column:subject_type_id;type:tinyint(4) unsigned;not null" json:""`
	Summary       string  `gorm:"column:summary;type:mediumtext;not null" json:""`
	PrsnAppearEps string  `gorm:"column:prsn_appear_eps;type:mediumtext;not null;comment:可选，人物参与的章节" json:""` // 可选，人物参与的章节
	Subject       Subject `gorm:"foreignKey:subject_id;references:subject_id" json:"subject"`
	Person        Person  `gorm:"foreignKey:prsn_id;references:prsn_id" json:"person"`
}

type PrivateMessage struct {
	ID                uint32 `gorm:"column:msg_id;type:int(10) unsigned;primaryKey;autoIncrement:true" json:""`
	SenderID          uint32 `gorm:"column:msg_sid;type:mediumint(8) unsigned;not null" json:""`
	ReceiverID        uint32 `gorm:"column:msg_rid;type:mediumint(8) unsigned;not null" json:""`
	Folder            string `gorm:"column:msg_folder;type:enum('inbox','outbox');not null;default:inbox" json:""`
	New               bool   `gorm:"column:msg_new;type:tinyint(1);not null" json:""`
	Title             string `gorm:"column:msg_title;type:varchar(75);not null" json:""`
	CreatedTime       uint32 `gorm:"column:msg_dateline;type:int(10) unsigned;not null" json:""`
	Content           string `gorm:"column:msg_message;type:text;not null" json:""`
	MainMessageID     uint32 `gorm:"column:msg_related_main;type:int(10) unsigned;not null" json:""`
	RelatedMessageID  uint32 `gorm:"column:msg_related;type:int(10) unsigned;not null" json:""`
	DeletedBySender   bool   `gorm:"column:msg_sdeleted;type:tinyint(1) unsigned;not null" json:""`
	DeletedByReceiver bool   `gorm:"column:msg_rdeleted;type:tinyint(1) unsigned;not null" json:""`
}

type RevisionHistory struct {
	ID          uint32 `gorm:"column:rev_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	Type        uint8  `gorm:"column:rev_type;type:tinyint(3) unsigned;not null;comment:条目，角色，人物" json:""`    // 条目，角色，人物
	Mid         uint32 `gorm:"column:rev_mid;type:mediumint(8) unsigned;not null;comment:对应条目，人物的ID" json:""` // 对应条目，人物的ID
	TextID      uint32 `gorm:"column:rev_text_id;type:mediumint(9) unsigned;not null" json:""`
	CreatedTime uint32 `gorm:"column:rev_dateline;type:int(10) unsigned;not null" json:""`
	CreatorID   uint32 `gorm:"column:rev_creator;type:mediumint(8) unsigned;not null" json:""`
	Summary     string `gorm:"column:rev_edit_summary;type:varchar(200);not null" json:""`
}

type RevisionText struct {
	TextID uint32 `gorm:"column:rev_text_id;type:mediumint(9) unsigned;primaryKey;autoIncrement:true" json:""`
	Text   []byte `gorm:"column:rev_text;type:mediumblob;not null" json:""`
}

type Subject struct {
	ID          uint32                     `gorm:"column:subject_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	TypeID      uint8                      `gorm:"column:subject_type_id;type:smallint(6) unsigned;not null" json:""`
	Name        utiltype.HTMLEscapedString `gorm:"column:subject_name;type:varchar(80);not null" json:""`
	NameCN      utiltype.HTMLEscapedString `gorm:"column:subject_name_cn;type:varchar(80);not null" json:""`
	UID         string                     `gorm:"column:subject_uid;type:varchar(20);not null;comment:isbn / imdb" json:""` // isbn / imdb
	Creator     uint32                     `gorm:"column:subject_creator;type:mediumint(8) unsigned;not null" json:""`
	Dateline    uint32                     `gorm:"column:subject_dateline;type:int(10) unsigned;not null" json:""`
	Image       string                     `gorm:"column:subject_image;type:varchar(255);not null" json:""`
	Platform    uint16                     `gorm:"column:subject_platform;type:smallint(6) unsigned;not null" json:""`
	Infobox     utiltype.HTMLEscapedString `gorm:"column:field_infobox;type:mediumtext;not null" json:""`
	Summary     string                     `gorm:"column:field_summary;type:mediumtext;not null;comment:summary" json:""`       // summary
	Field5      string                     `gorm:"column:field_5;type:mediumtext;not null;comment:author summary" json:""`      // author summary
	Volumes     uint32                     `gorm:"column:field_volumes;type:mediumint(8) unsigned;not null;comment:卷数" json:""` // 卷数
	Eps         uint32                     `gorm:"column:field_eps;type:mediumint(8) unsigned;not null" json:""`
	Wish        uint32                     `gorm:"column:subject_wish;type:mediumint(8) unsigned;not null" json:""`
	Done        uint32                     `gorm:"column:subject_collect;type:mediumint(8) unsigned;not null" json:""`
	Doing       uint32                     `gorm:"column:subject_doing;type:mediumint(8) unsigned;not null" json:""`
	OnHold      uint32                     `gorm:"column:subject_on_hold;type:mediumint(8) unsigned;not null;comment:搁置人数" json:""` // 搁置人数
	Dropped     uint32                     `gorm:"column:subject_dropped;type:mediumint(8) unsigned;not null;comment:抛弃人数" json:""` // 抛弃人数
	Series      bool                       `gorm:"column:subject_series;type:tinyint(1) unsigned;not null" json:""`
	SeriesEntry uint32                     `gorm:"column:subject_series_entry;type:mediumint(8) unsigned;not null" json:""`
	IdxCn       string                     `gorm:"column:subject_idx_cn;type:varchar(1);not null" json:""`
	Airtime     uint8                      `gorm:"column:subject_airtime;type:tinyint(1) unsigned;not null" json:""`
	Nsfw        bool                       `gorm:"column:subject_nsfw;type:tinyint(1);not null" json:""`
	Ban         uint8                      `gorm:"column:subject_ban;type:tinyint(1) unsigned;not null" json:""`
	Fields      SubjectField               `gorm:"foreignKey:subject_id;references:field_sid" json:"fields"`
}

type SubjectCollection struct {
	ID           uint32                     `gorm:"column:interest_id;type:int(10) unsigned;primaryKey;autoIncrement:true" json:""`
	UserID       uint32                     `gorm:"column:interest_uid;type:mediumint(8) unsigned;not null" json:""`
	SubjectID    uint32                     `gorm:"column:interest_subject_id;type:mediumint(8) unsigned;not null" json:""`
	SubjectType  uint8                      `gorm:"column:interest_subject_type;type:smallint(6) unsigned;not null" json:""`
	Rate         uint8                      `gorm:"column:interest_rate;type:tinyint(3) unsigned;not null" json:""`
	Type         uint8                      `gorm:"column:interest_type;type:tinyint(1) unsigned;not null" json:""`
	HasComment   bool                       `gorm:"column:interest_has_comment;type:tinyint(1) unsigned;not null" json:""`
	Comment      utiltype.HTMLEscapedString `gorm:"column:interest_comment;type:mediumtext;not null" json:""`
	Tag          string                     `gorm:"column:interest_tag;type:mediumtext;not null" json:""`
	EpStatus     uint32                     `gorm:"column:interest_ep_status;type:mediumint(8) unsigned;not null" json:""`
	VolStatus    uint32                     `gorm:"column:interest_vol_status;type:mediumint(8) unsigned;not null;comment:卷数" json:""` // 卷数
	WishTime     uint32                     `gorm:"column:interest_wish_dateline;type:int(10) unsigned;not null" json:""`
	DoingTime    uint32                     `gorm:"column:interest_doing_dateline;type:int(10) unsigned;not null" json:""`
	DoneTime     uint32                     `gorm:"column:interest_collect_dateline;type:int(10) unsigned;not null" json:""`
	OnHoldTime   uint32                     `gorm:"column:interest_on_hold_dateline;type:int(10) unsigned;not null" json:""`
	DroppedTime  uint32                     `gorm:"column:interest_dropped_dateline;type:int(10) unsigned;not null" json:""`
	CreateIP     string                     `gorm:"column:interest_create_ip;type:char(15);not null" json:""`
	LastUpdateIP string                     `gorm:"column:interest_lasttouch_ip;type:char(15);not null" json:""`
	UpdatedTime  uint32                     `gorm:"column:interest_lasttouch;type:int(10) unsigned;not null" json:""`
	Private      uint8                      `gorm:"column:interest_private;type:tinyint(1) unsigned;not null" json:""`
}

type SubjectField struct {
	Sid      uint32    `gorm:"column:field_sid;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	Tid      uint16    `gorm:"column:field_tid;type:smallint(6) unsigned;not null" json:""`
	Tags     []byte    `gorm:"column:field_tags;type:mediumtext;not null" json:""`
	Rate1    uint32    `gorm:"column:field_rate_1;type:mediumint(8) unsigned;not null" json:""`
	Rate2    uint32    `gorm:"column:field_rate_2;type:mediumint(8) unsigned;not null" json:""`
	Rate3    uint32    `gorm:"column:field_rate_3;type:mediumint(8) unsigned;not null" json:""`
	Rate4    uint32    `gorm:"column:field_rate_4;type:mediumint(8) unsigned;not null" json:""`
	Rate5    uint32    `gorm:"column:field_rate_5;type:mediumint(8) unsigned;not null" json:""`
	Rate6    uint32    `gorm:"column:field_rate_6;type:mediumint(8) unsigned;not null" json:""`
	Rate7    uint32    `gorm:"column:field_rate_7;type:mediumint(8) unsigned;not null" json:""`
	Rate8    uint32    `gorm:"column:field_rate_8;type:mediumint(8) unsigned;not null" json:""`
	Rate9    uint32    `gorm:"column:field_rate_9;type:mediumint(8) unsigned;not null" json:""`
	Rate10   uint32    `gorm:"column:field_rate_10;type:mediumint(8) unsigned;not null" json:""`
	Airtime  uint8     `gorm:"column:field_airtime;type:tinyint(1) unsigned;not null" json:""`
	Rank     uint32    `gorm:"column:field_rank;type:int(10) unsigned;not null" json:""`
	Year     int32     `gorm:"column:field_year;type:year(4);not null;comment:放送年份" json:""`            // 放送年份
	Mon      int8      `gorm:"column:field_mon;type:tinyint(2);not null;comment:放送月份" json:""`          // 放送月份
	WeekDay  int8      `gorm:"column:field_week_day;type:tinyint(1);not null;comment:放送日(星期X)" json:""` // 放送日(星期X)
	Date     time.Time `gorm:"column:field_date;type:date;not null;comment:放送日期" json:""`               // 放送日期
	Redirect uint32    `gorm:"column:field_redirect;type:mediumint(8) unsigned;not null" json:""`
}

type SubjectRelation struct {
	SubjectID            uint32  `gorm:"column:rlt_subject_id;type:mediumint(8) unsigned;primaryKey;comment:关联主 ID" json:""` // 关联主 ID
	SubjectTypeID        uint8   `gorm:"column:rlt_subject_type_id;type:tinyint(3) unsigned;not null" json:""`
	RelationType         uint16  `gorm:"column:rlt_relation_type;type:smallint(5) unsigned;not null;comment:关联类型" json:""`            // 关联类型
	RelatedSubjectID     uint32  `gorm:"column:rlt_related_subject_id;type:mediumint(8) unsigned;primaryKey;comment:关联目标 ID" json:""` // 关联目标 ID
	RelatedSubjectTypeID uint8   `gorm:"column:rlt_related_subject_type_id;type:tinyint(3) unsigned;not null;comment:关联目标类型" json:""` // 关联目标类型
	ViceVersa            bool    `gorm:"column:rlt_vice_versa;type:tinyint(1) unsigned;primaryKey" json:""`
	Order                uint8   `gorm:"column:rlt_order;type:tinyint(3) unsigned;not null;comment:关联排序" json:""` // 关联排序
	Subject              Subject `gorm:"foreignKey:rlt_related_subject_id;references:subject_id" json:"subject"`
}

type SubjectRevision struct {
	ID           uint32  `gorm:"column:rev_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	Type         uint8   `gorm:"column:rev_type;type:tinyint(3) unsigned;not null;default:1;comment:修订类型" json:""` // 修订类型
	SubjectID    uint32  `gorm:"column:rev_subject_id;type:mediumint(8) unsigned;not null" json:""`
	TypeID       uint16  `gorm:"column:rev_type_id;type:smallint(6) unsigned;not null" json:""`
	CreatorID    uint32  `gorm:"column:rev_creator;type:mediumint(8) unsigned;not null" json:""`
	Dateline     uint32  `gorm:"column:rev_dateline;type:int(10) unsigned;not null" json:""`
	Name         string  `gorm:"column:rev_name;type:varchar(80);not null" json:""`
	NameCN       string  `gorm:"column:rev_name_cn;type:varchar(80);not null" json:""`
	FieldInfobox string  `gorm:"column:rev_field_infobox;type:mediumtext;not null" json:""`
	FieldSummary string  `gorm:"column:rev_field_summary;type:mediumtext;not null" json:""`
	VoteField    string  `gorm:"column:rev_vote_field;type:mediumtext;not null" json:""`
	FieldEps     uint32  `gorm:"column:rev_field_eps;type:mediumint(8) unsigned;not null" json:""`
	EditSummary  string  `gorm:"column:rev_edit_summary;type:varchar(200);not null" json:""`
	Platform     uint16  `gorm:"column:rev_platform;type:smallint(6) unsigned;not null" json:""`
	Subject      Subject `gorm:"foreignKey:rev_subject_id;references:subject_id" json:"subject"`
}

type UserGroup struct {
	ID       uint8  `gorm:"column:usr_grp_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:""`
	Name     string `gorm:"column:usr_grp_name;type:varchar(255);not null" json:""`
	Perm     []byte `gorm:"column:usr_grp_perm;type:mediumtext;not null" json:""`
	Dateline uint32 `gorm:"column:usr_grp_dateline;type:int(10) unsigned;not null" json:""`
}

type WebSession struct {
	Key       string `gorm:"column:key;type:char(64);primaryKey;comment:session key" json:""`                                          // session key
	UserID    uint32 `gorm:"column:user_id;type:int(10) unsigned;not null;comment:uint32 user id" json:""`                             // uint32 user id
	Value     []byte `gorm:"column:value;type:mediumblob;not null;comment:json encoded session data" json:""`                          // json encoded session data
	CreatedAt int64  `gorm:"column:created_at;type:bigint(20);not null;comment:int64 unix timestamp, when session is created" json:""` // int64 unix timestamp, when session is created
	ExpiredAt int64  `gorm:"column:expired_at;type:bigint(20);not null;comment:int64 unix timestamp, when session is expired" json:""` // int64 unix timestamp, when session is expired
}