数据库名:wawacrm
TB_User
序号 |
列名 |
数据类型 |
长度 |
小数位 |
标识 |
主键 |
允许空 |
默认值 |
字段说明 |
1 |
FD_UserID |
int |
4 |
0 |
√ |
√ |
|
|
|
2 |
FD_user |
varchar |
20 |
0 |
|
|
√ |
|
|
3 |
FD_pwd |
varchar |
100 |
0 |
|
|
√ |
|
|
4 |
FD_tel |
varchar |
100 |
0 |
|
|
√ |
|
|
5 |
FD_addr |
varchar |
200 |
0 |
|
|
√ |
|
|
6 |
FD_level |
varchar |
10 |
0 |
|
|
√ |
|
|
7 |
FD_group |
varchar |
10 |
0 |
|
|
√ |
|
|
8 |
FD_trueName |
varchar |
20 |
0 |
|
|
√ |
|
|
TB_prod
序号 |
列名 |
数据类型 |
长度 |
小数位 |
标识 |
主键 |
允许空 |
默认值 |
字段说明 |
1 |
FD_prodID |
int |
4 |
0 |
√ |
√ |
|
|
|
2 |
FD_prod |
varchar |
100 |
0 |
|
|
√ |
|
|
3 |
FD_img |
varchar |
200 |
0 |
|
|
√ |
|
|
4 |
FD_description |
varchar |
100 |
0 |
|
|
√ |
|
|
5 |
FD_price |
varchar |
10 |
0 |
|
|
√ |
|
|
6 |
FD_type |
int |
4 |
0 |
|
|
√ |
|
|
7 |
FD_validity |
datetime |
8 |
3 |
|
|
√ |
|
|
8 |
FD_produceDate |
datetime |
8 |
3 |
|
|
√ |
|
|
TB_linker
序号 |
列名 |
数据类型 |
长度 |
小数位 |
标识 |
主键 |
允许空 |
默认值 |
字段说明 |
1 |
FD_linkerID |
int |
4 |
0 |
√ |
√ |
|
|
|
2 |
FD_linker |
varchar |
20 |
0 |
|
|
√ |
|
|
3 |
FD_img |
varchar |
20 |
0 |
|
|
√ |
|
|
4 |
FD_sex |
char |
2 |
0 |
|
|
√ |
|
|
5 |
FD_addr |
varchar |
200 |
0 |
|
|
√ |
|
|
6 |
FD_tel |
varchar |
20 |
0 |
|
|
√ |
|
|
7 |
FD_mail |
varchar |
200 |
0 |
|
|
√ |
|
|
8 |
FD_consort |
int |
4 |
0 |
|
|
√ |
|
|
TB_competitor
序号 |
列名 |
数据类型 |
长度 |
小数位 |
标识 |
主键 |
允许空 |
默认值 |
字段说明 |
1 |
FD_competitorID |
int |
4 |
0 |
√ |
√ |
|
|
|
2 |
FD_competitor |
varchar |
100 |
0 |
|
|
√ |
|
|
3 |
FD_addr |
varchar |
1000 |
0 |
|
|
√ |
|
|
4 |
FD_tel |
varchar |
20 |
0 |
|
|
√ |
|
|
5 |
FD_fax |
varchar |
20 |
0 |
|
|
√ |
|
|
6 |
FD_web |
varchar |
100 |
0 |
|
|
√ |
|
|
7 |
FD_money |
varchar |
100 |
0 |
|
|
√ |
|
|
8 |
FD_corpKind |
varchar |
1000 |
0 |
|
|
√ |
|
|
9 |
FD_calling |
varchar |
50 |
0 |
|
|
√ |
|
|
10 |
FD_halt |
varchar |
1000 |
0 |
|
|
√ |
|
|
11 |
FD_list |
varchar |
1000 |
0 |
|
|
√ |
|
|
12 |
FD_salesPromotion |
varchar |
1000 |
0 |
|
|
√ |
|
|
TB_chance
序号 |
列名 |
数据类型 |
长度 |
小数位 |
标识 |
主键 |
允许空 |
默认值 |
字段说明 |
1 |
FD_chanceID |
int |
4 |
0 |
√ |
√ |
|
|
|
2 |
FD_chance |
varchar |
100 |
0 |
|
|
√ |
|
|
3 |
FD_chanceType |
varchar |
100 |
0 |
|
|
√ |
|
|
4 |
FD_possibility |
datetime |
8 |
3 |
|
|
√ |
|
|
5 |
FD_principal |
varchar |
20 |
0 |
|
|
√ |
|
|
6 |
FD_actualize |
varchar |
1000 |
0 |
|
|
√ |
|
|
7 |
FD_source |
varchar |
100 |
0 |
|
|
√ |
|
|
TB_active
序号 |
列名 |
数据类型 |
长度 |
小数位 |
标识 |
主键 |
允许空 |
默认值 |
字段说明 |
||
1 |
FD_activeID |
int |
4 |
0 |
√ |
√ |
|
|
|
||
2 |
FD_activeTitle |
varchar |
100 |
0 |
|
|
√ |
|
|
||
3 |
FD_type |
int |
4 |
0 |
|
|
√ |
|
|
||
4 |
FD_startTime |
datetime |
8 |
3 |
|
|
√ |
|
|
||
5 |
FD_endTime |
datetime |
8 |
3 |
|
|
√ |
|
|
||
6 |
FD_principal |
varchar |
50 |
0 |
|
|
√ |
|
|
||
7 |
FD_plan |
varchar |
20 |
0 |
|
|
√ |
|
|
||
8 |
FD_level |
int |
4 |
0 |
|
|
√ |
|
|
||
9 |
FD_state |
int |
4 |
0 |
|
|
√ |
|
|
||
10 |
FD_actor |
varchar |
50 |
0 |
|
|
√ |
|
|