xps-server-go/datamodels/account.go

package datamodels

import "time"

// Account Data Model
type Account struct {
	OcId            int64       `json:"ocId"             xorm:"'oc_id'             bigint         comment('组织ID:公司或机构或单位ID')"`
	AccountId       int64       `json:"accountId"        xorm:"'account_id'        bigint not null pk comment('主键ID')"`
	AccountName     string      `json:"accountName"      xorm:"'account_name'      varchar(128)   comment('帐号名称')"`
	Password        string      `json:"password"         xorm:"'password'          varchar(128)   comment('密码')"`
	AccountType     int64       `json:"accountType"      xorm:"'account_type'      bigint         comment('帐号类型：0：系统用户，1：企业用户，2：集团用户，3:政府用户，4:合作伙伴')"`
	AccountRealName string      `json:"accountRealName"  xorm:"'account_real_name' varchar(64)    comment('姓名')"`
	AccountIntro    string      `json:"accountIntro"     xorm:"'account_intro'     varchar(511)   comment('个人简介')"`
	AccountAvatar   string      `json:"accountAvatar"    xorm:"'account_avatar'    varchar(255)   comment('头像')"`
	AccountPhoto    string      `json:"accountPhoto"     xorm:"'account_photo'     varchar(255)   comment('照片')"`
	AccountPhone    string      `json:"accountPhone"     xorm:"'account_phone'     varchar(32)    comment('手机号')"`
	AccountLastIp   string      `json:"accountLastIp"    xorm:"'account_last_ip'   varchar(10)    comment('最近一次登录IP')"`
	AccountLoc      string      `json:"accountLoc"       xorm:"'account_loc'       varchar(64)    comment('区域')"`
	AccountMail     string      `json:"accountMail"      xorm:"'account_mail'      varchar(64)    comment('Email')"`
	AccountStaffNo  string      `json:"accountStaffNo"   xorm:"'account_staff_no'  varchar(64)    comment('StaffNo')"`
	Status          int64       `json:"status"           xorm:"'status'            bigint         default 1 comment('状态，默认值 1，[0：未激活; 1：正常; 2:锁定; -1:删除'])"`
	WxId            int64       `json:"wxId"             xorm:"'wxId'              bigint         default 1 comment('状态，默认值 1，[0：未激活; 1：正常; 2:锁定; -1:删除'])"`
	IsFixed         int64       `json:"isFixed"          xorm:"'isFixed'           bigint         default 1 comment('状态，默认值 1，[0：未激活; 1：正常; 2:锁定; -1:删除'])"`
	CreatedBy       int64       `json:"createdBy"        xorm:"'created_by'"`
	CreatedAt       time.Time   `json:"createdAt"        xorm:"'created_at'"`
	UpdatedBy       int64       `json:"updatedBy"        xorm:"'updated_by'"`
	UpdatedAt       time.Time   `json:"updatedAt"        xorm:"'updated_at'"`
	DeletedFlag     int64       `json:"deletedFlag"      xorm:"'deleted_flag'"`
	DeletedBy       int64       `json:"deletedBy"        xorm:"'deleted_by'"`
	DeletedAt       time.Time   `json:"deletedAt"        xorm:"'deleted_at'"`
}

// TableName table name
func (t *Account) TableName() string {
	return "account"
}