trm_layout_dt - 培训计划数据表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_trm_layout_dt | 培训规划数据主键 | CHAR | Y | 20 | 0 | | | | |
checknote | 审批意见 | VARCHAR | | 100 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 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 | | | | |
isactualized | 是否已实施 | CHAR | | 1 | 0 | N | | | |
issign_trmcontract | 是否签订培训协议 | SMALLINT | | 2 | 0 | 0 | | | |
layout_actname | 培训活动名称 | VARCHAR | | 50 | 0 | | | | |
layout_course | 培训课程 | CHAR | | 20 | 0 | | | | |
layout_itemcode | 规划项编码 | VARCHAR | | 28 | 0 | | | | |
layoutnote | 培训备注 | VARCHAR | | 100 | 0 | | | | |
methodnames | 培训方式名称 | VARCHAR | | 512 | 0 | | | | |
pk_trm_item | 培训类别(pk) | VARCHAR | | 1024 | 0 | | | | |
pk_trm_layout | 培训规划主键 | CHAR | | 20 | 0 | | | | |
pk_trm_org | 培训机构 | CHAR | | 20 | 0 | | | | |
plan_timebegin | 计划开始时间 | CHAR | | 10 | 0 | | | | |
plan_timeend | 计划结束时间 | CHAR | | 10 | 0 | | | | |
req_obj | 培训目标 | VARCHAR | | 128 | 0 | | | | |
tr_budget | 费用预算 | DECIMAL | | 16 | 4 | 0 | | | |
tr_method | 培训方式 | VARCHAR | | 512 | 0 | | | | |
tr_objs | 培训对象 | VARCHAR | | 256 | 0 | | | | |
tr_objs_sort | 培训对象类型 | VARCHAR | | 512 | 0 | | | | |
trcount | 培训次数 | SMALLINT | | 2 | 0 | 0 | | | |
trcoursesum | 培训时长 | DECIMAL | | 16 | 6 | 0 | | | |
trm_class_names | 培训类别(name) | VARCHAR | | 1024 | 0 | | | | |
trm_content | 培训内容 | VARCHAR | | 256 | 0 | | | | |
trm_location | 培训地点 | VARCHAR | | 60 | 0 | | | | |
trmobjsnames | 培训对象类别名称 | VARCHAR | | 512 | 0 | | | | |
trpsnsum | 培训人数 | SMALLINT | | 2 | 0 | 0 | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
type | 教师出处 | SMALLINT | | 2 | 0 | 0 | | | |
外键列表
索引列表