| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
主键 |
integer |
None. |
| salary_date |
工资时间 格式:201701 |
string |
None. |
| d_id |
部门id |
integer |
None. |
| d_name |
部门名称 |
string |
None. |
| emp_id |
员工编号（主键） |
integer |
None. |
| emp_name |
姓名 |
string |
None. |
| add_time |
添加时间 |
date |
None. |
| update_time |
更新时间 |
date |
None. |
| order_num |
单数 |
integer |
None. |
| order_price |
单数单价 |
decimal number |
None. |
| piece_count |
件数 |
integer |
None. |
| piece_price |
件数单价 |
decimal number |
None. |
| performance |
绩效（单数*单数单价+件数*件数单价） |
decimal number |
None. |
| backup_performance |
备用司机固定绩效（抽签获得） |
decimal number |
None. |
| other_performance |
其他绩效 |
decimal number |
None. |
| amount_performance |
合计 |
decimal number |
None. |
| sum_order_num |
总单数 |
integer |
None. |
| sum_piece_count |
总件数 |
integer |
None. |
| sum_performance |
总绩效 |
decimal number |
None. |
| sum_backup_performance |
总备用司机固定绩效 |
decimal number |
None. |
| sum_other_performance |
总其他绩效 |
decimal number |
None. |
| sum_amount_performance |
总合计 |
decimal number |
None. |