package yb_activity_register

import "time"

// YbActivityRegister 活动报名表
type YbActivityRegister struct {
	ID         uint32 `gorm:"primaryKey;column:id;type:int(11) unsigned;not null" json:"-"`
	ActivityID uint32 `gorm:"index:inx_activity_id;column:activity_id;type:int(11) unsigned;not null;default:0" json:"activityId"` // 活动ID
	UserID     uint64 `gorm:"index:inx_user_id;column:user_id;type:bigint(20) unsigned;not null;default:0" json:"userId"`          // 微信用户表ID
	CompanyID  uint64 `gorm:"column:company_id;type:bigint(20) unsigned;not null;default:0" json:"companyId"`                      // 用户ID
	RealName   string `gorm:"column:real_name;type:varchar(32);not null;default:''" json:"realName"`                               // 用户实际名称
	Mobile     string `gorm:"column:mobile;type:varchar(32);not null;default:''" json:"mobile"`                                    // 用户手机号
	CreateTime time.Time `gorm:"column:create_time;type:datetime;default:CURRENT_TIMESTAMP" json:"createTime"`
}

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

// YbActivityRegisterColumns get sql column name.获取数据库列名
var YbActivityRegisterColumns = struct {
	ID         string
	ActivityID string
	UserID     string
	CompanyID  string
	RealName   string
	Mobile     string
}{
	ID:         "id",
	ActivityID: "activity_id",
	UserID:     "user_id",
	CompanyID:  "company_id",
	RealName:   "real_name",
	Mobile:     "mobile",
}