You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

40 lines
3.1 KiB

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

package models
import (
"time"
)
type TBaseTeacher struct {
PersonId string `xorm:"not null pk comment('教师ID') index(person_id) index(person_id_2) index(person_id_3) CHAR(36)"`
IdentityId int32 `xorm:"not null comment('人员身份ID') INT(11)"`
Xm string `xorm:"not null default '''' comment('教师姓名') VARCHAR(100)"`
Xmpy string `xorm:"not null default '''' comment('教师姓名拼音') VARCHAR(100)"`
Cym string `xorm:"not null default '''' comment('曾用名') VARCHAR(100)"`
Xbm string `xorm:"not null default '''' comment('性别 (有字典)') CHAR(1)"`
Csrq time.Time `xorm:"not null default ''1900-01-01'' comment('出生日期') DATE"`
Mzm string `xorm:"not null default '''' comment('民族 (有字典)') CHAR(2)"`
Zzmmm string `xorm:"not null default '''' comment('政治面貌 (有字典)') CHAR(2)"`
Sfzjlxm string `xorm:"not null default '''' comment('身份证件类型代码 (有字典)') CHAR(1)"`
Sfzjh string `xorm:"not null default '''' comment('身份证件号') index(person_id) index VARCHAR(100)"`
Xlm string `xorm:"not null default '''' comment('学历 (有字典)') CHAR(2)"`
Xwm string `xorm:"not null default '''' comment('学位 (有字典)') CHAR(1)"`
Zcm string `xorm:"not null default '''' comment('职称 (有字典)') CHAR(1)"`
Bzlbm string `xorm:"not null default '''' comment('编制 (有字典)') CHAR(1)"`
Cjny time.Time `xorm:"not null default ''1900-01-01'' comment('从教年月') DATE"`
StageId string `xorm:"not null default '''' comment('主要任课学段 (有字典)') index CHAR(1)"`
SubjectId string `xorm:"not null default '''' comment('主要任课学科 (有字典)') index CHAR(2)"`
Gwzym string `xorm:"not null default '''' comment('岗位 (有字典)') CHAR(2)"`
Lxdh string `xorm:"not null default '''' comment('联系电话') index index(person_id_2) VARCHAR(100)"`
Dzxx string `xorm:"not null default '''' comment('电子信箱') index index(person_id_3) VARCHAR(100)"`
BUse int32 `xorm:"not null default 1 comment('是否启用 0未启用 1启用') index(bureau_id) index(org_id) index(person_id) index(person_id_2) index(person_id_3) TINYINT(1)"`
StateId int32 `xorm:"not null default 0 comment('教师状态码') INT(11)"`
BureauId string `xorm:"not null comment('所属单位(主)') index(bureau_id) CHAR(36)"`
OrgId string `xorm:"not null comment('所属部门(主)') index(org_id) CHAR(36)"`
MainSchoolId string `xorm:"not null comment('所属主校ID') CHAR(36)"`
ProvinceCode string `xorm:"not null comment('所属省CODE') VARCHAR(36)"`
CityCode string `xorm:"not null comment('所属市CODE') CHAR(6)"`
DistrictCode string `xorm:"not null comment('所属县区CODE') CHAR(6)"`
SortId int32 `xorm:"not null default 1 comment('在主部门的排序号') INT(11)"`
CreateTime time.Time `xorm:"not null default 'current_timestamp()' comment('创建时间') TIMESTAMP"`
}