trm_rs_teacher - 培训教师
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_trm_rs_teacher | 教师主键 | CHAR | Y | 20 | 0 | | | | |
course_cost | 课时费 | DECIMAL | | 16 | 4 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
duty | 职务 | VARCHAR | | 128 | 0 | | | | |
evallev | 评测等级 | CHAR | | 20 | 0 | | | | |
groupdef1 | groupdef1 | VARCHAR | | 128 | 0 | | | | |
groupdef10 | groupdef10 | VARCHAR | | 128 | 0 | | | | |
groupdef11 | groupdef11 | VARCHAR | | 128 | 0 | | | | |
groupdef12 | groupdef12 | VARCHAR | | 128 | 0 | | | | |
groupdef13 | groupdef13 | VARCHAR | | 128 | 0 | | | | |
groupdef14 | groupdef14 | VARCHAR | | 128 | 0 | | | | |
groupdef15 | groupdef15 | VARCHAR | | 128 | 0 | | | | |
groupdef16 | groupdef16 | VARCHAR | | 128 | 0 | | | | |
groupdef17 | groupdef17 | VARCHAR | | 128 | 0 | | | | |
groupdef18 | groupdef18 | VARCHAR | | 128 | 0 | | | | |
groupdef19 | groupdef19 | VARCHAR | | 128 | 0 | | | | |
groupdef2 | groupdef2 | VARCHAR | | 128 | 0 | | | | |
groupdef20 | groupdef20 | VARCHAR | | 128 | 0 | | | | |
groupdef3 | groupdef3 | VARCHAR | | 128 | 0 | | | | |
groupdef4 | groupdef4 | VARCHAR | | 128 | 0 | | | | |
groupdef5 | groupdef5 | VARCHAR | | 128 | 0 | | | | |
groupdef6 | groupdef6 | VARCHAR | | 128 | 0 | | | | |
groupdef7 | groupdef7 | VARCHAR | | 128 | 0 | | | | |
groupdef8 | groupdef8 | VARCHAR | | 128 | 0 | | | | |
groupdef9 | groupdef9 | VARCHAR | | 128 | 0 | | | | |
iscancel | 是否已注销 | CHAR | | 1 | 0 | N | | | |
isshare | 是否共享 | CHAR | | 1 | 0 | N | | | |
pk_corp | 公司主键 | CHAR | | 4 | 0 | | | | |
pk_psndoc | 内部人员主键 | CHAR | | 20 | 0 | | | | |
pk_trm_org | 所属培训机构 | CHAR | | 20 | 0 | | | | |
teacher_address | 住址 | VARCHAR | | 60 | 0 | | | | |
teacher_birth | 出生日期 | CHAR | | 10 | 0 | | | | |
teacher_code | 教师编号 | VARCHAR | | 28 | 0 | | | | |
teacher_corp | 工作单位 | VARCHAR | | 50 | 0 | | | | |
teacher_course | 讲授课程 | VARCHAR | | 128 | 0 | | | | |
teacher_edulev | 教师学历 | CHAR | | 20 | 0 | | | | |
teacher_email | 教师邮箱 | VARCHAR | | 50 | 0 | | | | |
teacher_name | 教师名称 | VARCHAR | | 50 | 0 | | | | |
teacher_note | 教师简介 | VARCHAR | | 1024 | 0 | | | | |
teacher_phone | 教师联系电话 | VARCHAR | | 30 | 0 | | | | |
teacher_postcode | 邮政编码 | CHAR | | 6 | 0 | | | | |
teacher_sex | 教师性别 | SMALLINT | | 2 | 0 | 0 | | | |
teacher_specialty | 教师专业 | CHAR | | 20 | 0 | | | | |
teacher_techposttitle | 职称 | VARCHAR | | 128 | 0 | | | | |
teacher_type | 教师类别 | SMALLINT | | 2 | 0 | 0 | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
外键列表
索引列表