db

type Activity struct {
	ID        uint   `gorm:"primary_key"`
	Title     string `gorm:"type:varchar(255)"`       // 资源名称	名称搜索
	WxTo      string `gorm:"type:varchar(255)"`       // 目标地址 	小程序往哪里走
	Resource  string `gorm:"type:varchar(255);index"` // 目标地址
	Total     int64  // 次数统计
	Level     int32
	CreatedAt time.Time
	UpdatedAt time.Time
}

type Catalog struct {
	ID        uint   `gorm:"primary_key"`
	OpenID    string `gorm:"type:varchar(255);index"` // 微信文章地址
	Title     string `gorm:"type:varchar(255);"`      //订阅formID，一次订阅只能推送一次通知
	URL       string `gorm:"type:varchar(2048);"`     //订阅formID，一次订阅只能推送一次通知
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt *time.Time `sql:"index"`
}

type Fail struct {
	ID        uint `gorm:"primary_key"`
	FansID    uint `gorm:"index:user_id"` // 谁在收集助力
	CreatedAt time.Time
}

type Fans struct {
	ID              uint   `gorm:"primary_key"`
	OpenID          string `gorm:"type:varchar(255);unique_index"`
	NickName        string
	Gender          int
	Provider        string //平台
	City            string
	Province        string
	Country         string
	AvatarURL       string
	Language        string
	Timestamp       int64
	Level           int32 // 用户等级
	Score           int64 // 积分
	Total           int64 // 总分
	LoginTotal      int64 // 授权访问次数
	InvitationTotal int64 // 邀请用户次数
	AppID           string
	SessionKey      string // 粉丝上次的session key 如果有变化，同步一次粉丝数据
	CreatedAt       time.Time
	UpdatedAt       time.Time
	DeletedAt       *time.Time `sql:"index"`
}

type Feedback struct {
	ID        uint   `gorm:"primary_key"`
	OpenID    string `gorm:"type:varchar(255);index"` // 微信文章地址
	FormID    string `gorm:"type:varchar(255);"`      //订阅formID，一次订阅只能推送一次通知
	Problem   string `gorm:"type:text;"`              // 问题
	Answer    string `gorm:"type:text;"`              // 答复
	Show      bool   //是否显示
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt *time.Time `sql:"index"`
}

type Follow struct {
	ID        uint   `gorm:"primary_key"`
	OpenID    string `gorm:"type:varchar(255);index"`
	Title     string
	URL       string
	Drive     string
	Page      string
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt *time.Time `sql:"index"`
}

type Log struct {
	ID        uint   `gorm:"primary_key"`
	OpenID    string `gorm:"type:varchar(255);index"`
	Title     string
	URL       string
	Drive     string
	Page      string
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt *time.Time `sql:"index"`
}

type Post struct {
	ID        uint   `gorm:"primary_key"`
	Cate      int32  // 类型  1文章  2小说
	Name      string `gorm:"type:varchar(255);index"` // 资源名称	名称搜索
	WxTo      string `gorm:"type:varchar(255);index"` // 目标地址 	小程序往哪里走
	From      string // 数据来源
	Total     int64  // 次数统计
	Level     int32  // 级别限制(不加入搜索条件限制)
	CreatedAt time.Time
	UpdatedAt time.Time
}

type Qrcode struct {
	ID        uint   `gorm:"primary_key"`
	WxTo      string `gorm:"type:varchar(255);index"` // 目标地址
	Total     int64  //次数统计
	CreatedAt time.Time
	UpdatedAt time.Time
}

type Relation struct {
	ID         uint `gorm:"primary_key"`
	FansID     uint `gorm:"index:id"` //粉丝ID
	RelationID uint `gorm:"index:id"` //被吸来ID
	CreatedAt  time.Time
}

type Share struct {
	ID        uint `gorm:"primary_key"`
	FansID    uint `gorm:"index:index"`
	CreatedAt time.Time
}

type Sign struct {
	ID        uint `gorm:"primary_key"`
	FansID    uint `gorm:"index:user_id"` // 谁在收集助力
	CreatedAt time.Time
}

type Source struct {
	ID        uint   `gorm:"primary_key"`
	OpenID    string `gorm:"type:varchar(255);index"`
	Title     string
	URL       string
	Drive     string
	Page      string
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt *time.Time `sql:"index"`
}