model

type BaseModel struct {
	Id        uint64     `gorm:"primary_key;AUTO_INCREMENT;column:id" json:"-"`
	CreatedAt time.Time  `gorm:"column:createdAt" json:"-"`
	UpdatedAt time.Time  `gorm:"column:updatedAt" json:"-"`
	DeletedAt *time.Time `gorm:"column:deletedAt" sql:"index" json:"-"`
}

type Database struct {
	Self *gorm.DB
}

type Lab struct {
	CreatedAt    time.Time  `gorm:"column:createdAt" json:"-"`
	DeletedAt    *time.Time `gorm:"column:deletedAt" sql:"index" json:"-"`
	LabID        string     `gorm:"primary_key;unique_index" uri:"labid" json:"lab_id"`
	LabName      string     `json:"lab_name"`
	SeatNum      int        `json:"seat_num"`
	LabTypeID    int        `json:"lab_type_id"`
	S            int        `json:"s"`
	Detail       *LabDetail `json:"detail"`
	Userid       string     `json:"userid"`
	UserName     string     `json:"user_name"`
	Tel          string     `json:"tel"`
	DeviceNumber string     `json:"device_number"`
}

type LabClass struct {
	Id      uint64 `gorm:"primary_key;AUTO_INCREMENT;column:id" json:"-"`
	LabID   string
	Lab     Lab
	Class   string
	Day     string `gorm:"type:char(10)"`
	Time    string `gorm:"type:char(1)"`
	Teacher string
	Other   string
}

type LabDetail struct {
	LabID        string   `gorm:"primary_key;unique_index" uri:"labid" json:"-"`
	Context      string   `gorm:"type:text" json:"context"`
	ImagesString string   `gorm:"type:text" json:"-"`
	Images       []string `gorm:"-" json:"images"`
	Info         string   `json:"info"`
}

type LabType struct {
	Id   int    `gorm:"primary_key;AUTO_INCREMENT;column:id" json:"id"`
	Name string `gorm:"type:varchar(30);unique_index" json:"name"`
}

type ReserveInfo struct {
	Day  string
	Time string
	S    int
}

type ReserveRecord struct {
	Id           uint64     `gorm:"primary_key;AUTO_INCREMENT;column:id" json:"id"`
	CreatedAt    time.Time  `gorm:"column:createdAt" json:"created_at"`
	UpdatedAt    time.Time  `gorm:"column:updatedAt" json:"updated_at"`
	DeletedAt    *time.Time `gorm:"column:deletedAt" sql:"index" json:"-"`
	Uid          string     `gorm:"index" json:"uid"` // 2019-07-03 改为用户的userid
	LabID        string     `json:"lab_id"`
	Status       int        `gorm:"index;default:0" json:"status"`
	Content      string     `gorm:"type:varchar(100)" json:"content" binding:"exists"`      // 项目名称
	Explain      string     `gorm:"type:varchar(100)" json:"explain" binding:"exists"`      // 项目说明
	OpentypeID   string     `json:"opentype_id" binding:"required"`                         // 项目类型
	UserNum      int        `json:"user_num" binding:"required"`                            // 人数
	GuideTeacher string     `gorm:"type:varchar(20)" json:"guide_teacher" binding:"exists"` // 指导教师
	Remarks      string     `gorm:"type:varchar(255)" json:"remarks" binding:"exists"`      // 备注
	Expend       int        `json:"expend" binding:"exists"`                                // 是否需要消耗品
	Mobile       string     `gorm:"type:varchar(11)" json:"mobile" binding:"required"`      // 手机

	OpenId int    `gorm:"column:openid" json:"openid"` // neu返回的openid
	Note   string `json:"note"`                        // neu 预约失败返回的字段

	Details []ReserveRecordDetail `json:"-"`
	Lab     *Lab                  `gorm:"-" json:"lab_info"`
	Records map[string][]int      `gorm:"-" json:"records" binding:"required"`
}

type ReserveRecordDetail struct {
	Id              uint64 `gorm:"primary_key;AUTO_INCREMENT;column:id" json:"-"`
	ReserveRecordID uint64 `gorm:"index" json:"-"`
	Day             string `gorm:"type:char(10)"`
	Time            string `gorm:"type:char(1)"`
	Uid             string `json:"-"` // 2019-07-03 改为用户的userid
	Lid             string `json:"-"`
	Effective       int    `gorm:"index" json:"-"`
	UserNum         int    `json:"-"`
}

type Token struct {
	Token string `json:"token"`
}

type User struct {
	Id        uint64     `gorm:"primary_key;AUTO_INCREMENT;column:id" json:"id"`
	CreatedAt time.Time  `gorm:"column:createdAt" json:"created_at"`
	UpdatedAt time.Time  `gorm:"column:updatedAt" json:"updated_at"`
	DeletedAt *time.Time `gorm:"column:deletedAt" sql:"index" json:"-"`
	Openid    string     `gorm:"unique_index" json:"openid"`
	Role      uint       `json:"role"`
	Un        string     `json:"-"`
	Pa        string     `json:"-"`

	Info *UserInfo `gorm:"-" json:"info"`
}

type UserInfo struct {
	UserId         string `gorm:"primary_key" json:"user_id"`
	UserPass       string `gorm:"default:123456" json:"-"`
	UserName       string `json:"user_name"`
	UserDepartment string `json:"user_department"`
	Consuserid     string `json:"-"`
	UserRole       string `json:"user_role"`
	Uid            uint64 `gorm:"index" json:"uid"`
}

type WhiteList struct {
	Id        uint64    `gorm:"primary_key;AUTO_INCREMENT;column:id" json:"id"`
	CreatedAt time.Time `gorm:"column:createdAt" json:"created_at"`
	Uid       uint64    `gorm:"index" json:"uid"`
}