数据表 |
HR人员基础信息(hr_person_basic) | |||
字段名 |
中文名 |
类型 |
值域 |
描述 |
id |
主键ID |
int(11) |
|
PRIMARY
KEY |
personid | int(11) | KEY | ||
number | varchar(20) | |||
sex | 性别 | int(4) | ||
truename | 真实姓名 | varchar(20) | ||
prename | varchar(100) | |||
identity | varchar(30) | |||
depid | 部门 | int(11) | ||
state | int(4) | |||
otypeid | 职级 | int(11) | ||
reason | varchar(254) | |||
station1 | int(11) | |||
station2 | varchar(254) | |||
birthday |
出生日期 |
date | ||
workdate | date | |||
workage | int(4) | |||
marry | int(4) | |||
face | int(4) | |||
wage | decimal(11,2) | |||
education | int(4) | |||
nation | varchar(20) | |||
hometown | varchar(40) | |||
memo | varchar(254) | |||
appendix | varchar(40) | |||
photo | varchar(40) | |||
memo | varchar(254) |