db

type BaseField struct {
	Id         uint  `db:"id" json:"id"`
	AddTime    int64 `db:"add_time" json:"add_time"`
	UpdateTime int64 `db:"update_time" json:"-"`
}

type Dating struct {
	BaseField
	CreateUserId uint   `db:"create_user_id" json:"create_user_id" info:"会面创建者"`
	Result       string `db:"result" json:"result" info:"推荐结果"`
	Status       int8   `db:"status" json:"status" info:"会面状态; 0:结束;1:进行中;"`
	AddTime      int64  `db:"add_time" json:"-"`
}

type DatingResult struct {
	Res  bool  `json:"r" info:"匹配是否成功"`
	Date []int `json:"d" info:"建议时间, 放时间戳"`
}

type Dbfunc interface {
	TableName() string
}

type Feedback struct {
	BaseField
	Desc   string `db:"desc" json:"desc" info:"反馈详情"`
	UserId uint   `db:"user_id" json:"user_id" info:"反馈人"`
	FileId string `db:"file_id" json:"file_id" info:"file表id, 逗号相隔"`
}

type File struct {
	BaseField        // (实质上当前表并没有update_time字段)
	Path      string `db:"path" json:"path" info:"文件路径"`
	Ext       string `db:"ext" json:"ext" info:"文件类型,如jpg/mp4等"`
	Type      int8   `db:"type" json:"type" info:"类型;0:本地;1:远程(如cdn)"`
}

type User struct {
	BaseField
	NickName    string `db:"nick_name" json:"nick_name" info:"昵称"`
	Avatar      uint   `db:"avatar" json:"-" info:"头像, 关联file表"`
	Gender      int8   `db:"gender" json:"gender" info:"性别;0:未知;1:男;2:女"`
	PhoneNumber string `db:"phone_number" json:"phoneNumber" info:"手机号"`
	OpenId      string `db:"openid" json:"-" info:"小程序平台的用户识别码"`
	UnionId     string `db:"unionid" json:"-" info:"微信用户识别码"`
	SessionKey  string `db:"session_key" json:"-" info:"微信Session_Key"`
}

type UserTime struct {
	BaseField
	DatingId uint   `db:"dating_id" json:"dating_id" info:"dating表id"`
	UserId   uint   `db:"user_id" json:"user_id" info:"user表id"`
	Info     string `db:"info" json:"info" info:"空闲时间信息;{'t': [[1706978785,1706978785]]}"`
	Status   int8   `db:"status" json:"status" info:"状态; 0:已退出;1:加入"`
}

type UserTimeInfo struct {
	Time [][2]int64 `json:"t"`
}