package yb_community_video

import "time"

// YbCommunityVideo 研报-视频社区表
type YbCommunityVideo struct {
	CommunityVideoID int       `gorm:"primaryKey;column:community_video_id;type:int(10) unsigned;not null" json:"-"`
	Title            string    `gorm:"column:title;type:varchar(255);not null;default:''" json:"title"`                                             // 视频标题
	VarietyTagId     int       `gorm:"index:idx_variety_tag_id;column:variety_tag_id;type:int(10) unsigned;not null;default:0" json:"varietyTagId"` // 品种权限ID
	VarietyTagName   string    `gorm:"column:variety_tag_name;type:varchar(30);not null;default:''" json:"varietyTagName"`                          // 品种权限名称
	CoverImgURL      string    `gorm:"column:cover_img_url;type:varchar(255);not null;default:''" json:"coverImgUrl"`                               // 封面图地址
	VideoURL         string    `gorm:"column:video_url;type:varchar(255);not null;default:''" json:"videoUrl"`                                      // 视频地址
	VideoSeconds     string    `gorm:"column:video_seconds;type:varchar(30);not null;default:''" json:"videoSeconds"`                               // 视频时长
	PublishState     int       `gorm:"column:publish_state;type:tinyint(4) unsigned;not null;default:0" json:"publishState"`                        // 发布状态：0-未发布 1-已发布
	SendThsState     int       `gorm:"column:send_ths_state;type:tinyint(4) unsigned;not null;default:0" json:"sendThsState"`                       // 推送客群状态：0-未推送 1-已推送
	IsDeleted        int       `gorm:"column:is_deleted;type:tinyint(4) unsigned;not null;default:0" json:"isDeleted"`                              // 是否已删除：0-未删除 1-已删除
	PublishTime      time.Time `gorm:"column:publish_time;type:datetime" json:"publishTime"`                                                        // 发布时间
	SendThsTime      time.Time `gorm:"column:send_ths_time;type:datetime" json:"sendThsTime"`                                                       // 推送客群时间
	CreateTime       time.Time `gorm:"column:create_time;type:datetime;default:CURRENT_TIMESTAMP" json:"createTime"`                                // 创建时间
	ModifyTime       time.Time `gorm:"column:modify_time;type:datetime;default:CURRENT_TIMESTAMP" json:"modifyTime"`                                // 更新时间
	DeleteTime       time.Time `gorm:"column:delete_time;type:datetime" json:"deleteTime"`
}

// TableName get sql table name.获取数据库表名
func (m *YbCommunityVideo) TableName() string {
	return "yb_community_video"
}

// YbCommunityVideoColumns get sql column name.获取数据库列名
var YbCommunityVideoColumns = struct {
	CommunityVideoID string
	Title            string
	varietyTagId     string
	varietyTagName   string
	CoverImgURL      string
	VideoURL         string
	VideoSeconds     string
	PublishState     string
	SendThsState     string
	IsDeleted        string
	PublishTime      string
	SendThsTime      string
	CreateTime       string
	ModifyTime       string
	DeleteTime       string
}{
	CommunityVideoID: "community_video_id",
	Title:            "title",
	varietyTagId:     "variety_tag_id",
	varietyTagName:   "variety_tag_name",
	CoverImgURL:      "cover_img_url",
	VideoURL:         "video_url",
	VideoSeconds:     "video_seconds",
	PublishState:     "publish_state",
	SendThsState:     "send_ths_state",
	IsDeleted:        "is_deleted",
	PublishTime:      "publish_time",
	SendThsTime:      "send_ths_time",
	CreateTime:       "create_time",
	ModifyTime:       "modify_time",
	DeleteTime:       "delete_time",
}