表名:hrmperformancealert
中文名称:人力资源提醒时间设定数据表
表类型:
返回目录说明:
序号 |
中文名称 |
英文名称 |
数据类型 |
长度 |
允许空值 |
主键 |
默认值 |
自增 |
说明 |
1 |
|
id |
int |
|
N |
|
|
Y |
|
2 |
|
type_a |
char |
1 |
|
|
|
|
0:开始 1:结束 |
3 |
年度提醒开始 |
yearCondition1 |
int |
|
|
|
|
|
0:前 1:后 |
4 |
年度提醒前后 |
yearCondition2 |
int |
|
|
|
|
|
|
5 |
|
yearConCount |
int |
|
|
|
|
|
|
6 |
年度提醒次数 |
yearAlertCount |
int |
|
|
|
|
|
|
7 |
|
yearAlertUnit |
char |
1 |
|
|
|
|
|
8 |
|
yearFrequency |
int |
|
|
|
|
|
|
9 |
|
yearInterval |
int |
|
|
|
|
|
|
10 |
每月提醒开始 |
monthCondition1 |
int |
|
|
|
|
|
0:开始 1:结束 |
11 |
每月提醒前后 |
monthCondition2 |
int |
|
|
|
|
|
0:前 1:后 |
12 |
|
monthConCount |
int |
|
|
|
|
|
|
13 |
|
monthAlertCount |
int |
|
|
|
|
|
|
14 |
|
monthAlertUnit |
char |
1 |
|
|
|
|
|
15 |
|
monthFrequency |
int |
|
|
|
|
|
|
16 |
|
monthInterval |
int |
|
|
|
|
|
|
17 |
季度提醒开始 |
quarterCondition1 |
int |
|
|
|
|
|
0:开始 1:结束 |
18 |
季度提醒前后 |
quarterCondition2 |
int |
|
|
|
|
|
0:前 1:后 |
19 |
季度提醒次数 |
quarterConCount |
int |
|
|
|
|
|
|
20 |
|
quarterAlertCount |
int |
|
|
|
|
|
|
21 |
|
quarterAlertUnit |
char |
1 |
|
|
|
|
|
22 |
|
quarterFrequency |
int |
|
|
|
|
|
|
23 |
|
quarterInterval |
int |
|
|
|
|
|
|
24 |
每周提醒 |
weekCondition1 |
int |
|
|
|
|
|
|
25 |
|
weekCondition2 |
int |
|
|
|
|
|
|
26 |
|
weekConCount |
int |
|
|
|
|
|
|
27 |
|
weekAlertCount |
int |
|
|
|
|
|
|
28 |
|
weekAlertUnit |
char |
1 |
|
|
|
|
|
29 |
|
weekFrequency |
int |
|
|
|
|
|
|
30 |
|
weekInterval |
int |
|
|
|
|
|
|