dao

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

type CharacterSubjects struct {
	CrtID         uint32 `gorm:"column:crt_id;type:mediumint(9) unsigned;primaryKey;autoIncrement:false" json:"crt_id"`
	SubjectID     uint32 `` /* 128-byte string literal not displayed */
	SubjectTypeID uint8  `gorm:"column:subject_type_id;type:tinyint(4) unsigned;not null;index:subject_type_id,priority:1" json:"subject_type_id"`
	CrtType       uint8  `gorm:"column:crt_type;type:tinyint(4) unsigned;not null;index:crt_type,priority:1" json:"crt_type"` // 主角，配角
	CtrAppearEps  string `gorm:"column:ctr_appear_eps;type:mediumtext;not null" json:"ctr_appear_eps"`                        // 可选，角色出场的的章节
	CrtOrder      uint8  `gorm:"column:crt_order;type:tinyint(3) unsigned;not null" json:"crt_order"`
}

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

type Member struct {
	UID          uint32      `gorm:"column:uid;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:"uid"`
	Username     string      `gorm:"column:username;type:char(15);not null;uniqueIndex:username,priority:1" json:"username"`
	Nickname     string      `gorm:"column:nickname;type:varchar(30);not null" json:"nickname"`
	Avatar       string      `gorm:"column:avatar;type:varchar(255);not null" json:"avatar"`
	Groupid      uint8       `gorm:"column:groupid;type:smallint(6) unsigned;not null;default:0" json:"groupid"`
	Regdate      time.Time   `gorm:"column:regdate;type:int(10) unsigned;not null;default:0" json:"regdate"`
	Lastvisit    int32       `gorm:"column:lastvisit;type:int(10) unsigned;not null;default:0" json:"lastvisit"`
	Lastactivity int32       `gorm:"column:lastactivity;type:int(10) unsigned;not null;default:0" json:"lastactivity"`
	Lastpost     int32       `gorm:"column:lastpost;type:int(10) unsigned;not null;default:0" json:"lastpost"`
	Dateformat   string      `gorm:"column:dateformat;type:char(10);not null" json:"dateformat"`
	Timeformat   bool        `gorm:"column:timeformat;type:tinyint(1);not null;default:0" json:"timeformat"`
	Timeoffset   string      `gorm:"column:timeoffset;type:char(4);not null" json:"timeoffset"`
	Newpm        bool        `gorm:"column:newpm;type:tinyint(1);not null;default:0" json:"newpm"`
	NewNotify    uint16      `gorm:"column:new_notify;type:smallint(6) unsigned;not null;default:0" json:"new_notify"` // 新提醒
	Sign         string      `gorm:"column:sign;type:varchar(255);not null" json:"sign"`
	Fields       MemberField `gorm:"foreignKey:UID;references:UID" json:"fields"`
}

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

type OAuthAccessToken struct {
	AccessToken string    `gorm:"column:access_token;type:varchar(40);primaryKey;autoIncrement:false" json:"access_token"`
	ClientID    string    `gorm:"column:client_id;type:varchar(80);not null" json:"client_id"`
	UserID      string    `gorm:"column:user_id;type:varchar(80)" json:"user_id"`
	Expires     time.Time `gorm:"column:expires;type:timestamp;not null;default:CURRENT_TIMESTAMP" json:"expires"`
	Scope       string    `gorm:"column:scope;type:varchar(4000)" json:"scope"`
}

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

type PersonField struct {
	Cat       string `gorm:"column:prsn_cat;type:enum('prsn','crt');primaryKey;autoIncrement:false" json:"prsn_cat"`
	ID        int32  `gorm:"column:prsn_id;type:int(8) unsigned;primaryKey;autoIncrement:false;index:prsn_id,priority:1" json:"prsn_id"`
	Gender    uint8  `gorm:"column:gender;type:tinyint(4) unsigned;not null" json:"gender"`
	Bloodtype uint8  `gorm:"column:bloodtype;type:tinyint(4) unsigned;not null" json:"bloodtype"`
	BirthYear int32  `gorm:"column:birth_year;type:year(4);not null" json:"birth_year"`
	BirthMon  uint8  `gorm:"column:birth_mon;type:tinyint(2) unsigned;not null" json:"birth_mon"`
	BirthDay  uint8  `gorm:"column:birth_day;type:tinyint(2) unsigned;not null" json:"birth_day"`
}

type PersonSubjects struct {
	PrsnType     string `gorm:"column:prsn_type;type:enum('prsn','crt');primaryKey;autoIncrement:false" json:"prsn_type"`
	PersonID     uint32 `gorm:"column:prsn_id;type:mediumint(9) unsigned;primaryKey;autoIncrement:false;index:prsn_id,priority:1" json:"prsn_id"`
	PrsnPosition uint16 `` // 监督，原案，脚本,..
	/* 136-byte string literal not displayed */
	SubjectID     uint32 `` /* 128-byte string literal not displayed */
	SubjectTypeID uint8  `gorm:"column:subject_type_id;type:tinyint(4) unsigned;not null;index:subject_type_id,priority:1" json:"subject_type_id"`
	Summary       string `gorm:"column:summary;type:mediumtext;not null" json:"summary"`
	PrsnAppearEps string `gorm:"column:prsn_appear_eps;type:mediumtext;not null" json:"prsn_appear_eps"` // 可选，人物参与的章节
}

type Subject struct {
	ID          uint32       `gorm:"column:subject_id;type:mediumint(8) unsigned;primaryKey;autoIncrement:true" json:"subject_id"`
	TypeID      uint8        `` /* 218-byte string literal not displayed */
	Name        string       `` /* 133-byte string literal not displayed */
	NameCN      string       `gorm:"column:subject_name_cn;type:varchar(80);not null;index:subject_name_cn,priority:1" json:"subject_name_cn"`
	UID         string       `gorm:"column:subject_uid;type:varchar(20);not null" json:"subject_uid"` // isbn / imdb
	Creator     uint32       `gorm:"column:subject_creator;type:mediumint(8) unsigned;not null;index:subject_creator,priority:1" json:"subject_creator"`
	Dateline    int32        `gorm:"column:subject_dateline;type:int(10) unsigned;not null;default:0" json:"subject_dateline"`
	Image       string       `gorm:"column:subject_image;type:varchar(255);not null" json:"subject_image"`
	Platform    uint16       `` /* 189-byte string literal not displayed */
	Infobox     string       `gorm:"column:field_infobox;type:mediumtext;not null" json:"field_infobox"`
	Summary     string       `gorm:"column:field_summary;type:mediumtext;not null" json:"field_summary"`                      // summary
	Field5      string       `gorm:"column:field_5;type:mediumtext;not null" json:"field_5"`                                  // author summary
	Volumes     uint32       `gorm:"column:field_volumes;type:mediumint(8) unsigned;not null;default:0" json:"field_volumes"` // 卷数
	Eps         uint32       `gorm:"column:field_eps;type:mediumint(8) unsigned;not null;default:0" json:"field_eps"`
	Wish        uint32       `gorm:"column:subject_wish;type:mediumint(8) unsigned;not null;default:0" json:"subject_wish"`
	Collect     uint32       `gorm:"column:subject_collect;type:mediumint(8) unsigned;not null;default:0" json:"subject_collect"`
	Doing       uint32       `gorm:"column:subject_doing;type:mediumint(8) unsigned;not null;default:0" json:"subject_doing"`
	OnHold      uint32       `gorm:"column:subject_on_hold;type:mediumint(8) unsigned;not null;default:0" json:"subject_on_hold"` // 搁置人数
	Dropped     uint32       `gorm:"column:subject_dropped;type:mediumint(8) unsigned;not null;default:0" json:"subject_dropped"` // 抛弃人数
	Series      bool         ``                                                                                                   /* 182-byte string literal not displayed */
	SeriesEntry uint32       ``                                                                                                   /* 146-byte string literal not displayed */
	IdxCn       string       `gorm:"column:subject_idx_cn;type:varchar(1);not null;index:subject_idx_cn,priority:1" json:"subject_idx_cn"`
	Airtime     uint8        `gorm:"column:subject_airtime;type:tinyint(1) unsigned;not null;index:subject_airtime,priority:1" json:"subject_airtime"`
	Nsfw        bool         `gorm:"column:subject_nsfw;type:tinyint(1);not null;index:subject_nsfw,priority:1" json:"subject_nsfw"`
	Ban         uint8        `` /* 173-byte string literal not displayed */
	Fields      SubjectField `gorm:"foreignKey:subject_id;references:field_sid" json:"fields"`
}

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

type SubjectRelation struct {
	SubjectID uint32 `` // 关联主 ID
	/* 181-byte string literal not displayed */
	SubjectTypeID uint8  `` /* 131-byte string literal not displayed */
	RelationType  uint16 `` // 关联类型
	/* 126-byte string literal not displayed */
	RelatedSubjectID uint32 `` // 关联目标 ID
	/* 197-byte string literal not displayed */
	RelatedSubjectTypeID uint8 `` // 关联目标类型
	/* 155-byte string literal not displayed */
	ViceVersa bool  ``                                                                                                                        /* 144-byte string literal not displayed */
	Order     uint8 `gorm:"column:rlt_order;type:tinyint(3) unsigned;not null;index:rlt_related_subject_type_id,priority:2" json:"rlt_order"` // 关联排序
}

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