dao

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

type App struct {
	ID          uint32       `gorm:"column:app_id;type:mediumint(8);primaryKey;autoIncrement:true"`
	Type        uint8        `gorm:"column:app_type;type:tinyint(1);not null"`
	Creator     model.UserID `gorm:"column:app_creator;type:mediumint(8);not null"`
	Name        string       `gorm:"column:app_name;type:varchar(255);not null"`
	Description string       `gorm:"column:app_desc;type:mediumtext;not null"`
	URL         string       `gorm:"column:app_url;type:varchar(2000);not null"`
	Collects    int32        `gorm:"column:app_collects;type:mediumint(8);not null"`
	Status      bool         `gorm:"column:app_status;type:tinyint(1);not null"`
	CreatedTime int32        `gorm:"column:app_timestamp;type:int(10);not null"`
	UpdatedTime int32        `gorm:"column:app_lasttouch;type:int(10);not null"`
	Ban         bool         `gorm:"column:app_ban;type:tinyint(1);not null"`
}

type Cast struct {
	CharacterID   model.CharacterID `gorm:"column:crt_id;type:mediumint(9) unsigned;primaryKey"`
	PersonID      model.PersonID    `gorm:"column:prsn_id;type:mediumint(9) unsigned;primaryKey"`
	SubjectID     model.SubjectID   `gorm:"column:subject_id;type:mediumint(9) unsigned;primaryKey"`
	SubjectTypeID uint8             `gorm:"column:subject_type_id;type:tinyint(3) unsigned;not null"` // 根据人物归类查询角色，动画，书籍，游戏
	Summary       string            `gorm:"column:summary;type:varchar(255);not null"`                // 幼年，男乱马，女乱马，变身形态，少女形态。。
	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       model.CharacterID `gorm:"column:crt_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	Name     string            `gorm:"column:crt_name;type:varchar(255);not null"`
	Role     uint8             `gorm:"column:crt_role;type:tinyint(4) unsigned;not null"` // 角色，机体，组织。。
	Infobox  string            `gorm:"column:crt_infobox;type:mediumtext;not null"`
	Summary  string            `gorm:"column:crt_summary;type:mediumtext;not null"`
	Img      string            `gorm:"column:crt_img;type:varchar(255);not null"`
	Comment  uint32            `gorm:"column:crt_comment;type:mediumint(9) unsigned;not null"`
	Collects uint32            `gorm:"column:crt_collects;type:mediumint(8) unsigned;not null"`
	Dateline uint32            `gorm:"column:crt_dateline;type:int(10) unsigned;not null"`
	Lastpost uint32            `gorm:"column:crt_lastpost;type:int(11) unsigned;not null"`
	Lock     int8              `gorm:"column:crt_lock;type:tinyint(4);not null"`
	ImgAnidb string            `gorm:"column:crt_img_anidb;type:varchar(255);not null"`         // Deprecated
	AnidbID  uint32            `gorm:"column:crt_anidb_id;type:mediumint(8) unsigned;not null"` // Deprecated
	Ban      uint8             `gorm:"column:crt_ban;type:tinyint(3) unsigned;not null"`
	Redirect model.CharacterID `gorm:"column:crt_redirect;type:int(10) unsigned;not null"`
	Nsfw     bool              `gorm:"column:crt_nsfw;type:tinyint(1) unsigned;not null"`
	Fields   PersonField       `gorm:"foreignKey:crt_id;polymorphic:Owner;polymorphicValue:crt" json:"fields"`
}

type CharacterComment struct {
	ID          uint32 `gorm:"column:crt_pst_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	TopicID     uint32 `gorm:"column:crt_pst_mid;type:mediumint(8) unsigned;not null"` // 关联人物ID
	UID         uint32 `gorm:"column:crt_pst_uid;type:mediumint(8) unsigned;not null"`
	Related     uint32 `gorm:"column:crt_pst_related;type:mediumint(8) unsigned;not null"`
	CreatedTime uint32 `gorm:"column:crt_pst_dateline;type:int(10) unsigned;not null"`
	Content     string `gorm:"column:crt_pst_content;type:mediumtext;not null"`
}

type CharacterSubjects struct {
	CharacterID   model.CharacterID `gorm:"column:crt_id;type:mediumint(9) unsigned;primaryKey"`
	SubjectID     model.SubjectID   `gorm:"column:subject_id;type:mediumint(9) unsigned;primaryKey"`
	SubjectTypeID uint8             `gorm:"column:subject_type_id;type:tinyint(4) unsigned;not null"`
	CrtType       uint8             `gorm:"column:crt_type;type:tinyint(4) unsigned;not null"` // 主角，配角
	CtrAppearEps  string            `gorm:"column:ctr_appear_eps;type:mediumtext;not null"`    // 可选，角色出场的的章节
	CrtOrder      uint8             `gorm:"column:crt_order;type:tinyint(3) unsigned;not null"`
	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"`
	UserID      model.UserID    `gorm:"column:ep_stt_uid;type:mediumint(8) unsigned;not null"`
	SubjectID   model.SubjectID `gorm:"column:ep_stt_sid;type:mediumint(8) unsigned;not null"`
	OnPrg       bool            `gorm:"column:ep_stt_on_prg;type:tinyint(1) unsigned;not null"`
	Status      []byte          `gorm:"column:ep_stt_status;type:mediumtext;not null"`
	UpdatedTime uint32          `gorm:"column:ep_stt_lasttouch;type:int(10) unsigned;not null"`
}

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

type EpisodeComment struct {
	ID          uint32 `gorm:"column:ep_pst_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	TopicID     uint32 `gorm:"column:ep_pst_mid;type:mediumint(8) unsigned;not null"`
	UID         uint32 `gorm:"column:ep_pst_uid;type:mediumint(8) unsigned;not null"`
	Related     uint32 `gorm:"column:ep_pst_related;type:mediumint(8) unsigned;not null"`
	CreatedTime uint32 `gorm:"column:ep_pst_dateline;type:int(10) unsigned;not null"`
	Content     string `gorm:"column:ep_pst_content;type:mediumtext;not null"`
}

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

type Group struct {
	ID             model.GroupID `gorm:"column:grp_id;type:smallint(6) unsigned;primaryKey;autoIncrement:true"`
	Cat            uint16        `gorm:"column:grp_cat;type:smallint(6) unsigned;not null"`
	Name           string        `gorm:"column:grp_name;type:char(50);not null"`
	Title          string        `gorm:"column:grp_title;type:char(50);not null"`
	Icon           string        `gorm:"column:grp_icon;type:varchar(255);not null"`
	CreatorID      model.UserID  `gorm:"column:grp_creator;type:mediumint(8) unsigned;not null"`
	Topics         uint32        `gorm:"column:grp_topics;type:mediumint(8) unsigned;not null"`
	Posts          uint32        `gorm:"column:grp_posts;type:mediumint(8) unsigned;not null"`
	Members        uint32        `gorm:"column:grp_members;type:mediumint(8) unsigned;not null;default:1"`
	Description    string        `gorm:"column:grp_desc;type:text;not null"`
	LastPostedTime uint32        `gorm:"column:grp_lastpost;type:int(10) unsigned;not null"` // 目前永远是0
	CreatedTime    uint32        `gorm:"column:grp_builddate;type:int(10) unsigned;not null"`
	Accessible     uint8         `gorm:"column:grp_accessible;type:tinyint(1);not null;default:1"` // 可访问性
	Nsfw           bool          `gorm:"column:grp_nsfw;type:tinyint(1) unsigned;not null"`
}

type GroupMember struct {
	UserID      model.UserID  `gorm:"column:gmb_uid;type:mediumint(8);primaryKey"`
	GroupID     model.GroupID `gorm:"column:gmb_gid;type:smallint(6);primaryKey"`
	Moderator   bool          `gorm:"column:gmb_moderator;type:tinyint(1);not null"`
	CreatedTime uint32        `gorm:"column:gmb_dateline;type:int(10) unsigned;not null"`
}

type GroupTopic struct {
	ID          uint32 `gorm:"column:grp_tpc_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	GroupID     uint32 `gorm:"column:grp_tpc_gid;type:mediumint(8) unsigned;not null"`
	UID         uint32 `gorm:"column:grp_tpc_uid;type:mediumint(8) unsigned;not null"`
	Title       string `gorm:"column:grp_tpc_title;type:varchar(80);not null"`
	CreatedTime uint32 `gorm:"column:grp_tpc_dateline;type:int(10) unsigned;not null"`
	UpdatedTime uint32 `gorm:"column:grp_tpc_lastpost;type:int(10) unsigned;not null"`
	Replies     uint32 `gorm:"column:grp_tpc_replies;type:mediumint(8) unsigned;not null"`
	State       uint8  `gorm:"column:grp_tpc_state;type:tinyint(1) unsigned;not null"`
	Display     uint8  `gorm:"column:grp_tpc_display;type:tinyint(1) unsigned;not null;default:1"`
}

type GroupTopicComment struct {
	ID          uint32 `gorm:"column:grp_pst_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	TopicID     uint32 `gorm:"column:grp_pst_mid;type:mediumint(8) unsigned;not null"`
	UID         uint32 `gorm:"column:grp_pst_uid;type:mediumint(8) unsigned;not null"`
	Related     uint32 `gorm:"column:grp_pst_related;type:mediumint(8) unsigned;not null"` // 关联回复ID
	Content     string `gorm:"column:grp_pst_content;type:mediumtext;not null"`
	State       uint8  `gorm:"column:grp_pst_state;type:tinyint(1) unsigned;not null"`
	CreatedTime uint32 `gorm:"column:grp_pst_dateline;type:int(10) unsigned;not null"`
}

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

type IndexComment struct {
	ID          uint32 `gorm:"column:idx_pst_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	TopicID     uint32 `gorm:"column:idx_pst_mid;type:mediumint(8) unsigned;not null"`
	UID         uint32 `gorm:"column:idx_pst_uid;type:mediumint(8) unsigned;not null"`
	Related     uint32 `gorm:"column:idx_pst_related;type:mediumint(8) unsigned;not null"`
	CreatedTime uint32 `gorm:"column:idx_pst_dateline;type:int(10) unsigned;not null"`
	Content     string `gorm:"column:idx_pst_content;type:mediumtext;not null"`
}

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

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

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

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

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

type OAuthClient struct {
	AppID        uint32 `gorm:"column:app_id;type:mediumint(8);primaryKey"`
	ClientID     string `gorm:"column:client_id;type:varchar(80);not null"`
	ClientSecret string `gorm:"column:client_secret;type:varchar(80)"`
	RedirectURI  string `gorm:"column:redirect_uri;type:varchar(2000)"`
	GrantTypes   string `gorm:"column:grant_types;type:varchar(80)"`
	Scope        string `gorm:"column:scope;type:varchar(4000)"`
	UserID       string `gorm:"column:user_id;type:varchar(80)"`
	App          App    `gorm:"foreignKey:app_id;references:app_id" json:"app"`
}

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

type PersonComment struct {
	ID          uint32 `gorm:"column:prsn_pst_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	TopicID     uint32 `gorm:"column:prsn_pst_mid;type:mediumint(8) unsigned;not null"` // 关联人物ID
	UID         uint32 `gorm:"column:prsn_pst_uid;type:mediumint(8) unsigned;not null"`
	Related     uint32 `gorm:"column:prsn_pst_related;type:mediumint(8) unsigned;not null"`
	CreatedTime uint32 `gorm:"column:prsn_pst_dateline;type:int(10) unsigned;not null"`
	Content     string `gorm:"column:prsn_pst_content;type:mediumtext;not null"`
}

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

type PersonSubjects struct {
	PrsnType      string          `gorm:"column:prsn_type;type:enum('prsn','crt');primaryKey"`
	PersonID      model.PersonID  `gorm:"column:prsn_id;type:mediumint(9) unsigned;primaryKey"`
	PrsnPosition  uint16          `gorm:"column:prsn_position;type:smallint(5) unsigned;primaryKey"` // 监督，原案，脚本,..
	SubjectID     model.SubjectID `gorm:"column:subject_id;type:mediumint(9) unsigned;primaryKey"`
	SubjectTypeID uint8           `gorm:"column:subject_type_id;type:tinyint(4) unsigned;not null"`
	Summary       string          `gorm:"column:summary;type:mediumtext;not null"`
	PrsnAppearEps string          `gorm:"column:prsn_appear_eps;type:mediumtext;not null"` // 可选，人物参与的章节
	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                model.PrivateMessageID `gorm:"column:msg_id;type:int(10) unsigned;primaryKey;autoIncrement:true"`
	SenderID          model.UserID           `gorm:"column:msg_sid;type:mediumint(8) unsigned;not null"`
	ReceiverID        model.UserID           `gorm:"column:msg_rid;type:mediumint(8) unsigned;not null"`
	Folder            string                 `gorm:"column:msg_folder;type:enum('inbox','outbox');not null;default:inbox"`
	New               bool                   `gorm:"column:msg_new;type:tinyint(1);not null"`
	Title             string                 `gorm:"column:msg_title;type:varchar(75);not null"`
	CreatedTime       uint32                 `gorm:"column:msg_dateline;type:int(10) unsigned;not null"`
	Content           string                 `gorm:"column:msg_message;type:text;not null"`
	MainMessageID     model.PrivateMessageID `gorm:"column:msg_related_main;type:int(10) unsigned;not null"`
	RelatedMessageID  model.PrivateMessageID `gorm:"column:msg_related;type:int(10) unsigned;not null"`
	DeletedBySender   bool                   `gorm:"column:msg_sdeleted;type:tinyint(1) unsigned;not null"`
	DeletedByReceiver bool                   `gorm:"column:msg_rdeleted;type:tinyint(1) unsigned;not null"`
}

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

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

type Subject struct {
	ID          model.SubjectID `gorm:"column:subject_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	TypeID      uint8           `gorm:"column:subject_type_id;type:smallint(6) unsigned;not null"`
	Name        string          `gorm:"column:subject_name;type:varchar(80);not null"`
	NameCN      string          `gorm:"column:subject_name_cn;type:varchar(80);not null"`
	UID         string          `gorm:"column:subject_uid;type:varchar(20);not null"` // isbn / imdb
	Creator     uint32          `gorm:"column:subject_creator;type:mediumint(8) unsigned;not null"`
	Dateline    uint32          `gorm:"column:subject_dateline;type:int(10) unsigned;not null"`
	Image       string          `gorm:"column:subject_image;type:varchar(255);not null"`
	Platform    uint16          `gorm:"column:subject_platform;type:smallint(6) unsigned;not null"`
	Infobox     string          `gorm:"column:field_infobox;type:mediumtext;not null"`
	Summary     string          `gorm:"column:field_summary;type:mediumtext;not null"`            // summary
	Field5      string          `gorm:"column:field_5;type:mediumtext;not null"`                  // author summary
	Volumes     uint32          `gorm:"column:field_volumes;type:mediumint(8) unsigned;not null"` // 卷数
	Eps         uint32          `gorm:"column:field_eps;type:mediumint(8) unsigned;not null"`
	Wish        uint32          `gorm:"column:subject_wish;type:mediumint(8) unsigned;not null"`
	Done        uint32          `gorm:"column:subject_collect;type:mediumint(8) unsigned;not null"`
	Doing       uint32          `gorm:"column:subject_doing;type:mediumint(8) unsigned;not null"`
	OnHold      uint32          `gorm:"column:subject_on_hold;type:mediumint(8) unsigned;not null"` // 搁置人数
	Dropped     uint32          `gorm:"column:subject_dropped;type:mediumint(8) unsigned;not null"` // 抛弃人数
	Series      bool            `gorm:"column:subject_series;type:tinyint(1) unsigned;not null"`
	SeriesEntry uint32          `gorm:"column:subject_series_entry;type:mediumint(8) unsigned;not null"`
	IdxCn       string          `gorm:"column:subject_idx_cn;type:varchar(1);not null"`
	Airtime     uint8           `gorm:"column:subject_airtime;type:tinyint(1) unsigned;not null"`
	Nsfw        bool            `gorm:"column:subject_nsfw;type:tinyint(1);not null"`
	Ban         uint8           `gorm:"column:subject_ban;type:tinyint(1) unsigned;not null"`
	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"`
	UserID       model.UserID    `gorm:"column:interest_uid;type:mediumint(8) unsigned;not null"`
	SubjectID    model.SubjectID `gorm:"column:interest_subject_id;type:mediumint(8) unsigned;not null"`
	SubjectType  uint8           `gorm:"column:interest_subject_type;type:smallint(6) unsigned;not null"`
	Rate         uint8           `gorm:"column:interest_rate;type:tinyint(3) unsigned;not null"`
	Type         uint8           `gorm:"column:interest_type;type:tinyint(1) unsigned;not null"`
	HasComment   bool            `gorm:"column:interest_has_comment;type:tinyint(1) unsigned;not null"`
	Comment      string          `gorm:"column:interest_comment;type:mediumtext;not null"`
	Tag          string          `gorm:"column:interest_tag;type:mediumtext;not null"`
	EpStatus     uint32          `gorm:"column:interest_ep_status;type:mediumint(8) unsigned;not null"`
	VolStatus    uint32          `gorm:"column:interest_vol_status;type:mediumint(8) unsigned;not null"` // 卷数
	WishTime     uint32          `gorm:"column:interest_wish_dateline;type:int(10) unsigned;not null"`
	DoingTime    uint32          `gorm:"column:interest_doing_dateline;type:int(10) unsigned;not null"`
	DoneTime     uint32          `gorm:"column:interest_collect_dateline;type:int(10) unsigned;not null"`
	OnHoldTime   uint32          `gorm:"column:interest_on_hold_dateline;type:int(10) unsigned;not null"`
	DroppedTime  uint32          `gorm:"column:interest_dropped_dateline;type:int(10) unsigned;not null"`
	CreateIP     string          `gorm:"column:interest_create_ip;type:char(15);not null"`
	LastUpdateIP string          `gorm:"column:interest_lasttouch_ip;type:char(15);not null"`
	UpdatedTime  uint32          `gorm:"column:interest_lasttouch;type:int(10) unsigned;not null"`
	Private      uint8           `gorm:"column:interest_private;type:tinyint(1) unsigned;not null"`
}

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

type SubjectRelation struct {
	SubjectID            model.SubjectID `gorm:"column:rlt_subject_id;type:mediumint(8) unsigned;primaryKey"` // 关联主 ID
	SubjectTypeID        uint8           `gorm:"column:rlt_subject_type_id;type:tinyint(3) unsigned;not null"`
	RelationType         uint16          `gorm:"column:rlt_relation_type;type:smallint(5) unsigned;not null"`          // 关联类型
	RelatedSubjectID     model.SubjectID `gorm:"column:rlt_related_subject_id;type:mediumint(8) unsigned;primaryKey"`  // 关联目标 ID
	RelatedSubjectTypeID uint8           `gorm:"column:rlt_related_subject_type_id;type:tinyint(3) unsigned;not null"` // 关联目标类型
	ViceVersa            bool            `gorm:"column:rlt_vice_versa;type:tinyint(1) unsigned;primaryKey"`
	Order                uint8           `gorm:"column:rlt_order;type:tinyint(3) unsigned;not null"` // 关联排序
	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"`
	Type         uint8           `gorm:"column:rev_type;type:tinyint(3) unsigned;not null;default:1"` // 修订类型
	SubjectID    model.SubjectID `gorm:"column:rev_subject_id;type:mediumint(8) unsigned;not null"`
	TypeID       uint16          `gorm:"column:rev_type_id;type:smallint(6) unsigned;not null"`
	CreatorID    model.UserID    `gorm:"column:rev_creator;type:mediumint(8) unsigned;not null"`
	Dateline     uint32          `gorm:"column:rev_dateline;type:int(10) unsigned;not null"`
	Name         string          `gorm:"column:rev_name;type:varchar(80);not null"`
	NameCN       string          `gorm:"column:rev_name_cn;type:varchar(80);not null"`
	FieldInfobox string          `gorm:"column:rev_field_infobox;type:mediumtext;not null"`
	FieldSummary string          `gorm:"column:rev_field_summary;type:mediumtext;not null"`
	VoteField    string          `gorm:"column:rev_vote_field;type:mediumtext;not null"`
	FieldEps     uint32          `gorm:"column:rev_field_eps;type:mediumint(8) unsigned;not null"`
	EditSummary  string          `gorm:"column:rev_edit_summary;type:varchar(200);not null"`
	Platform     uint16          `gorm:"column:rev_platform;type:smallint(6) unsigned;not null"`
	Subject      Subject         `gorm:"foreignKey:rev_subject_id;references:subject_id" json:"subject"`
}

type SubjectTopic struct {
	ID          uint32 `gorm:"column:sbj_tpc_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	SubjectID   uint32 `gorm:"column:sbj_tpc_subject_id;type:mediumint(8) unsigned;not null"`
	UID         uint32 `gorm:"column:sbj_tpc_uid;type:mediumint(8) unsigned;not null"`
	Title       string `gorm:"column:sbj_tpc_title;type:varchar(80);not null"`
	CreatedTime uint32 `gorm:"column:sbj_tpc_dateline;type:int(10) unsigned;not null"`
	UpdatedTime uint32 `gorm:"column:sbj_tpc_lastpost;type:int(10) unsigned;not null"`
	Replies     uint32 `gorm:"column:sbj_tpc_replies;type:mediumint(8) unsigned;not null"`
	State       uint8  `gorm:"column:sbj_tpc_state;type:tinyint(1) unsigned;not null"`
	Display     uint8  `gorm:"column:sbj_tpc_display;type:tinyint(1) unsigned;not null;default:1"`
}

type SubjectTopicComment struct {
	ID          uint32 `gorm:"column:sbj_pst_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true"`
	TopicID     uint32 `gorm:"column:sbj_pst_mid;type:mediumint(8) unsigned;not null"`
	UID         uint32 `gorm:"column:sbj_pst_uid;type:mediumint(8) unsigned;not null"`
	Related     uint32 `gorm:"column:sbj_pst_related;type:mediumint(8) unsigned;not null"`
	Content     string `gorm:"column:sbj_pst_content;type:mediumtext;not null"`
	State       uint8  `gorm:"column:sbj_pst_state;type:tinyint(1) unsigned;not null"`
	CreatedTime uint32 `gorm:"column:sbj_pst_dateline;type:int(10) unsigned;not null"`
}

type TimeLine struct {
	ID       model.TimeLineID `gorm:"column:tml_id;type:int(10) unsigned;primaryKey;autoIncrement:true"`
	UID      model.UserID     `gorm:"column:tml_uid;type:mediumint(8) unsigned;not null"`
	Cat      uint16           `gorm:"column:tml_cat;type:smallint(6) unsigned;not null"`
	Type     uint16           `gorm:"column:tml_type;type:smallint(6) unsigned;not null"`
	Related  string           `gorm:"column:tml_related;type:char(255);not null;default:0"`
	Memo     []byte           `gorm:"column:tml_memo;type:mediumtext;not null"`
	Img      []byte           `gorm:"column:tml_img;type:mediumtext;not null"`
	Batch    uint8            `gorm:"column:tml_batch;type:tinyint(3) unsigned;not null"`
	Source   uint8            `gorm:"column:tml_source;type:tinyint(3) unsigned;not null"`    // 更新来源
	Replies  uint32           `gorm:"column:tml_replies;type:mediumint(8) unsigned;not null"` // 回复数
	Dateline uint32           `gorm:"column:tml_dateline;type:int(10) unsigned;not null"`
}

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

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