tbm_lateearly - 2.12 迟到早退矿工
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_lateearly | 迟到早退主键 | CHAR | Y | 20 | 0 | | | | |
absenthour | 旷工工时 | DECIMAL | | 16 | 2 | 0 | | | |
calendar | 日历 | CHAR | | 10 | 0 | | | | |
dr | 删除标志dr | SMALLINT | | 2 | 0 | | | | |
earlycount | 早退次数 | INT | | 4 | 0 | 0 | | | |
fourbeginstatus | 时段四开始状态 | SMALLINT | | 2 | 0 | 0 | | | |
fourendstatus | 时段四结束状态 | SMALLINT | | 2 | 0 | 0 | | | |
latecount | 迟到次数 | INT | | 4 | 0 | 0 | | | |
nightabsenthour | 夜班旷工工时 | DECIMAL | | 16 | 2 | 0 | | | |
onebeginstatus | 时段一开始状态 | SMALLINT | | 2 | 0 | 0 | | | |
oneendstatus | 时段一结束状态 | SMALLINT | | 2 | 0 | 0 | | | |
pk_corp | 公司主键 | CHAR | | 4 | 0 | | | | |
pk_psndoc | 人员主键 | CHAR | | 20 | 0 | | | | |
threebeginstatus | 时段三开始状态 | SMALLINT | | 2 | 0 | 0 | | | |
threeendstatus | 时段三结束状态 | SMALLINT | | 2 | 0 | 0 | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
twobeginstatus | 时段二开始状态 | SMALLINT | | 2 | 0 | 0 | | | |
twoendstatus | 时段二结束状态 | SMALLINT | | 2 | 0 | 0 | | | |
外键列表
索引列表
编码 | 显示名称 | i_tbm_lateearly | i_tbm_lateearly |