ash.sql
3.95 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
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),
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_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;