ash.sql
4.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
create table `t_ash_warning_instance`
(
id varchar(32) not null,
code varchar(50),
alarm_date timestamp null,
content varchar(5000),
feedback_content varchar(5000),
analysis_status varchar(50) DEFAULT 'unanalysis',
review_status varchar(50) DEFAULT 'UNAUDITED',
phoneNum varchar(50),
municipal_police varchar(50),
county_police varchar(50),
jurisdictional_unit varchar(50),
county varchar(50),
category varchar(50),
type varchar(50),
type_detail varchar(50),
sub_type varchar(50),
alarm_category VARCHAR(50),
alarm_type VARCHAR(50),
alarm_type_detail VARCHAR(50),
alarm_sub_type VARCHAR(50),
result varchar(50),
address varchar(50),
create_time timestamp null,
create_by varchar(32),
last_modify_time timestamp null,
last_modify_by varchar(32),
primary key (id)
) comment = '警情列表' ENGINE = InnoDB;
create table `t_ash_warning_instance_analysis`
(
id varchar(32) not null,
wi_id varchar(32),
area varchar(50),
amount double,
sex varchar(50),
career varchar(50),
rainage_method varchar(50),
rainage_method_detail varchar(50),
pay_method varchar(50),
conform_status varchar(50) DEFAULT 'UNCONFIRMED',
create_time timestamp null,
create_by varchar(32),
last_modify_time timestamp null,
last_modify_by varchar(32),
primary key (id)
) comment = '警情分析结果' ENGINE = InnoDB;
create index i_wia_wi on t_ash_warning_instance_analysis (wi_id);
create table `t_ash_case`
(
id varchar(32) not null,
code varchar(50),
mark varchar(50),
name varchar(50),
case_detail varchar(5000),
alarm_date timestamp null,
filing_date timestamp null,
filing_unit varchar(200),
analysis_status varchar(50) DEFAULT 'unanalysis',
review_status varchar(50) DEFAULT 'UNAUDITED',
area varchar(50),
county varchar(50),
total_amount double,
amount double,
sex varchar(50),
age int,
career varchar(50),
id_card varchar(50),
fraud_type varchar(50),
rainage_method varchar(50),
rainage_detail varchar(500),
pay_method varchar(50),
create_time timestamp null,
create_by varchar(32),
last_modify_time timestamp null,
last_modify_by varchar(32),
primary key (id)
) comment = '案件列表' ENGINE = InnoDB;
create table `t_ash_case_analysis`
(
id varchar(32) not null,
case_id varchar(50),
area varchar(50),
county varchar(50),
total_amount double,
amount double,
sex varchar(50),
age int,
career varchar(50),
id_card varchar(50),
fraud_type varchar(50),
rainage_method varchar(50),
rainage_method_detail varchar(50),
rainage_detail varchar(500),
pay_method varchar(50),
conform_status varchar(50) DEFAULT 'UNCONFIRMED',
create_time timestamp null,
create_by varchar(32),
last_modify_time timestamp null,
last_modify_by varchar(32),
primary key (id)
) comment = '案件分析结果' ENGINE = InnoDB;
create index i_case_ci on t_ash_case_analysis (case_id);
create table `t_ash_file_data`
(
id varchar(32) not null,
type varchar(50),
path varchar(200),
create_time timestamp null,
create_by varchar(32),
last_modify_time timestamp null,
last_modify_by varchar(32),
primary key (id)
) comment = '文件数据' ENGINE = InnoDB;
create table `t_ash_user`
(
id varchar(32) not null,
employee_code varchar(50),
user_name varchar(50),
login_name varchar(50),
password varchar(50),
status varchar(50),
mobile varchar(50),
sex int,
create_time timestamp null,
create_by varchar(32),
last_modify_time timestamp null,
last_modify_by varchar(32),
primary key (id)
) comment = '用户表' ENGINE = InnoDB;
create index i_user_l on t_ash_user(login_name);
create unique index u_user_login_name on t_ash_user (login_name);