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
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
| SQLite format 3 @ ã | k Z ã -â& ô úôõêêâ ¡
| 4ª uTe§ö|.Õ õ õ 7K% indexsqlite_autoindex_visit_detail_1visit_detail$ ;tableCREATE TABLE "" (id BIGINT (10) PRIMARY KEY UNIQUE NOT NULL, visit_id BIGINT (10), state_id BIGINT (10), create_time TEXT (100), device_id BIGINT (10)) 3 indexsqlite_autoindex__1
etablevisitvisitCREATE TABLE visit (visit_id BIGINT (20) PRIMARY KEY UNIQUE NOT NULL, visit_reason_id BIGINT (10), remark TEXT (100), enter_time TEXT (100) NOT NULL, exit_time TEXT (100), visitor_type_id BIGINT (10), visitor_id BIGINT (10), visitor_company_id BIGINT (10), visitee_id BIGINT (10), visitee_company_id BIGINT (10), current_state_id INTEGER (10), warning INTEGER (1)))= indexsqlite_autoindex_visit_1visit*!! tablephone_callphone_callCREATE TABLE phone_call (phone_call_id BIGINT (20), date TEXT (100), caller_id BIGINT (10), callee_id BIGINT (10), device_id BIGINT (10))##ctableoperate_logoperate_logCREATE TABLE operate_log (operate_log_id BIGINT (10) PRIMARY KEY NOT NULL UNIQUE, operator TEXT (100) NOT NULL, operate_time TEXT (100) NOT NULL, content TEXT (255), operate TEXT (255), operator_id BIGINT (40), full_detail TEXT (2000))5I# indexsqlite_autoindex_operate_log_1operate_logV!!wtableattendanceattendanceCREATE TABLE attendance (attendance_id BIGINT (10) PRIMARY KEY UNIQUE NOT NULL, register_id BIGINT (10) NOT NULL, attendance_type_id BIGINT, time TEXT (100), device_id INTEGER (10))3G! indexsqlite_autoindex_attendance_1attendanceZ tabledevicedevice CREATE TABLE device (device_id BIGINT (10) PRIMARY KEY UNIQUE NOT NULL, company_id INTEGER (10), device_name TEXT (40) NOT NULL, type TEXT (100) NOT NULL, install_address TEXT (255), school_name TEXT (255), brand_id TEXT (255), ip TEXT (100), port TEXT (50), resolution_id TEXT (100), username TEXT (100), password TEXT (100), protocol_id TEXT (100), sn TEXT (100), belong_id TEXT (100), principal TEXT (100), install_time TEXT (50), install_company TEXT (100), manufacturer TEXT (100), production_date TEXT (100), remark TEXT (100), scrapped_date TEXT (100), sn_id TEXT (100))+ ? indexsqlite_autoindex_device_1devicek )tableemployeeemployee CREATE TABLE employee (register_id BIGINT (50), device_company_id BIGINT (10))] !!tabledictionarydictionary
| CREATE TABLE dictionary (dict_id BIGINT (50) PRIMARY KEY UNIQUE NOT NULL, sn TEXT (15), name TEXT (30), order_by INTEGER (11), pid INTEGER (11), remark TEXT (100), compnay_id INTEGER (11))3
| G! indexsqlite_autoindex_dictionary_1dictionary C!!QtabledepartmentdepartmentCREATE TABLE department (dept_id BIGINT (50) PRIMARY KEY UNIQUE NOT NULL, dept_name TEXT (40) NOT NULL, dept_name_en TEXT (100), company_id INTEGER (11) NOT NULL)3G! indexsqlite_autoindex_department_1department WtablecompanycompanyCREATE TABLE company (company_id BIGINT PRIMARY KEY UNIQUE NOT NULL, company_name TEXT (50) NOT NULL)-A indexsqlite_autoindex_company_1companym=tablepostpostCREATE TABLE post (post_id BIGINT (50) PRIMARY KEY NOT NULL UNIQUE, post_name TEXT (40))'; indexsqlite_autoindex_post_1post
I etableregisterregisterCREATE TABLE register (register_id INT (10) PRIMARY KEY UNIQUE, username TEXT (40) NOT NULL, name_en TEXT (100), gender_id INTEGER (4), country_id TEXT (100), province TEXT (20), city TEXT (20), birthday TEXT (20), tel TEXT (20), mobile_phone TEXT (20), identity_type_id INTEGER (10), identify_num TEXT (100), company_id INTEGER (10), department_id INTEGER (10), post_id INTEGER (10), remark TEXT (255), warning INTEGER (1), id_card_photo TEXT (255), upload_custom_photo TEXT (255), surveillance_photo TEXT (255), surveillance_photo_id BIGINT (22), visitor_type_id INTEGER (11), authentication TEXT (20), id_card_head_photo TEXT, attender_type_id INTEGER (11), card_number TEXT (255))/C indexsqlite_autoind # Ø ¿KØ q 333 22camera15555555555152017-06-23 10:58:35552017-06-23 10:58:3952017-06-23 10:58:515r 333 22camera24444444444142017-06-21 10:58:14442017-06-23 10:58:1842017-06-23 10:58:464? ) è´æç§android_device2222221011 ÙĨ ' àÁ # × ì×
| åå¡sw
| è´¢å¡cw
| ö üö
| ð üöð ¾IÕ t u B
| üöð
| ¸s.ë¨e! Ú N  z 6 ò ® j &
| â
|
| R
| Ê Bþºv2 D D D D D D D D H H D D D D D D H E G E G G D C C C E E H
|
| ûûûûûûûûûûû®§ }vohaZSLE>7 Á
| g g¹&[
|
| ='ÊÊÊÊ PT++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)T{CC/tablevisit_table_synchron_recordvisit_table_synchron_recordCREATE TABLE "visit_table_synchron_record" (
| "id" INTEGER NOT NULL,
| "table_name" TEXT(20),
| "synchron_time" TEXT(40),
| PRIMARY KEY ("id")
| )~!!
qtableattendanceattendanceCREATE TABLE "attendance" (
| "attendance_id" BIGINT(10) NOT NULL,
| "register_id" BIGINT(10) NOT NULL,
| "attendance_type_id" BIGINT,
| "time" TEXT(100),
| "device_id" INTEGER,
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT,
| PRIMARY KEY ("attendance_id" ASC),
| UNIQUE ("attendance_id" ASC)
| )3G! indexsqlite_autoindex_attendance_1attendance2;tablecompanycompany0CREATE TABLE "company" (
| "company_id" BIGINT NOT NULL,
| "company_name" TEXT(50) NOT NULL,
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT,
| PRIMARY KEY ("company_id" ASC),
| UNIQUE ("company_id" ASC)
| )-A indexsqlite_autoindex_company_1company5 ù| G[5 indexsqlite_autoindex__device_old_20170801_1_device_old_20170801Un55table_device_old_20170801_device_old_20170801TCREATE TABLE "_device_old_20170801" (
| "device_id" BIGINT(10) NOT NULL,
| "company_id" INTEGER,
| "device_name" TEXT(40) NOT NULL,
| "type" TEXT(100) NOT NULL,
| "install_address" TEXT(255),
| "school_name" TEXT(255),
| "brand_id" TEXT(255),
| "ip" TEXT(100),
| "port" TEXT(50),
| "resolution_id" TEXT(100),
| "username" TEXT(100),
| "password" TEXT(100),
| "protocol_id" TEXT(100),
| "sn" TEXT(100),
| "belong_id" TEXT(100),
| "principal" TEXT(100),
| "install_time" TEXT(50),
| "install_company" TEXT(100),
| "manufacturer" TEXT(100),
| "production_date" TEXT(100),
| "remark" TEXT(100),
| "scrapped_date" TEXT(100),
| "sn_id" TEXT(100),
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT,
| PRIMARY KEY ("device_id" ASC),
| UNIQUE ("device_id" ASC)
| ) . !! tabledictionarydictionaryYCREATE TABLE "dictionary" (
| "dict_id" BIGINT(50) NOT NULL,
| "sn" TEXT(15),
| "name" TEXT(30),
| "type" TEXT(100),
| "order_by" INTEGER,
| "pid" INTEGER,
| "remark" TEXT(100),
| "compnay_id" INTEGER,
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT,
| PRIMARY KEY ("dict_id" ASC),
| UNIQUE ("dict_id" ASC)
| )3G! indexsqlite_autoindex_dictionary_1dictionaryZ ® ®
VÌè _ S ytableemployeeemployee\CREATE TABLE "employee" (
| "register_id" BIGINT(50),
| "device_company_id" BIGINT(10),
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "is_valid" TEXT,
| "create_time" TEXT
| )M##atableoperate_logoperate_logeCREATE TABLE "operate_log" (
| "operate_log_id" BIGINT(10) NOT NULL,
| "operator" TEXT(100),
| "operate_time" TEXT(100) NOT NULL,
| "content" TEXT(255),
| "operate" TEXT(255),
| "operator_id" BIGINT(40),
| "full_detail" TEXT(2000),
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT,
| PRIMARY KEY ("operate_log_id" ASC),
| UNIQUE ("operate_log_id" ASC)
| )5I# indexsqlite_autoindex_operate_log_1operate_logf: !!?tablephone_callphone_calloCREATE TABLE "phone_call" (
| "phone_call_id" BIGINT(20),
| "date" TEXT(100),
| "caller_id" BIGINT(10),
| "callee_id" BIGINT(10),
| "device_id" BIGINT(10),
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT
| ) tablepostpostrCREATE TABLE "post" (
| "post_id" BIGINT(50) NOT NULL,
| "post_name" TEXT(40),
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT,
| PRIMARY KEY ("post_id" ASC),
| UNIQUE ("post_id" ASC)
| )' ; indexsqlite_autoindex_post_1postsI! etableregisterregisteruCREATE TABLE "register" (
| "register_id" TEXT,
| "username" TEXT(40) NOT NULL,
| "name_en" TEXT(100),
| "gender_id" INTEGER,
| "country_id" TEXT(100),
| "province" TEXT(20),
| "city" TEXT(20),
| "birthday" TEXT(20),
| "tel" TEXT(20),
| "mobile_phone" TEXT(20),
| "identity_type_id" INTEGER,
| "identify_num" TEXT(100),
| "company_id" INTEGER,
| "department_id" INTEGER,
| "post_id" INTEGER,
| "remark" TEXT(255),
| "warning" INTEGER,
| "id_card_photo" TEXT(255),
| "upload_custom_photo" TEXT(255),
| "surveillance_photo" TEXT(255),
| "surveillance_photo_id" BIGINT(22),
| "visitor_type_id" INTEGER,
| "authentication" TEXT(20),
| "id_card_head_photo" TEXT,
| "attender_type_id" INTEGER,
| "card_number" TEXT(255),
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "raw_surveillance_photo_path" TEXT,
| "raw_surveillance_photo_width" TEXT,
| "raw_surveillance_photo_height" TEXT,
| "create_time" TEXT,
| "company" TEXT,
| "visitor_or_attender" TEXT,
| "is_valid" TEXT,
| PRIMARY KEY ("register_id" ASC),
| UNIQUE ("register_id" ASC)
| )/"C indexsqlite_autoindex_register_1registerv o ¢h ý Ç ¥ [ë¿ » i4-tabledevicedeviceCREATE TABLE "device" (
| "device_id" BIGINT(10) NOT NULL,
| "company_id" INTEGER,
| "device_name" TEXT(40) NOT NULL,
| "type" TEXT(100) NOT NULL,
| "install_address" TEXT(255),
| "school_name" TEXT(255),
| "brand_id" TEXT(255),
| "ip" TEXT(100),
| "port" TEXT(50),
| "resolution_id" TEXT(100),
| "username" TEXT(100),
| "password" TEXT(100),
| "protocol_id" TEXT(100),
| "sn" TEXT(100),
| "belong_id" TEXT(100),
| "principal" TEXT(100),
| "install_time" TEXT(50),
| "install_company" TEXT(100),
| "manufacturer" TEXT(100),
| "production_date" TEXT(100),
| "remark" TEXT(100),
| "scrapped_date" TEXT(100),
| "sn_id" TEXT(100),
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT,
| "brand" TEXT,
| "resolution" TEXT,
| PRIMARY KEY ("device_id" ASC),
| UNIQUE ("device_id" ASC)
| )+5? indexsqlite_autoindex_device_1device K3_9 indexsqlite_autoindex__device_old_20170801_1_1_device_old_20170801_1299#table_device_old_20170801_1_device_old_20170801_1CREATE TABLE "_device_old_20170801_1" (
| "device_id" BIGINT(10) NOT NULL,
| "company_id" INTEGER,
| "device_name" TEXT(40) NOT NULL,
| "type" TEXT(100) NOT NULL,
| "install_address" TEXT(255),
| "school_name" TEXT(255),
| "brand_id" TEXT(255),
| "ip" TEXT(100),
| "port" TEXT(50),
| "resolution_id" TEXT(100),
| "username" TEXT(100),
| "password" TEXT(100),
| "protocol_id" TEXT(100),
| "sn" TEXT(100),
| "belong_id" TEXT(100),
| "principal" TEXT(100),
| "install_time" TEXT(50),
| "install_company" TEXT(100),
| "manufacturer" TEXT(100),
| "production_date" TEXT(100),
| "remark" TEXT(100),
| "scrapped_date" TEXT(100),
| "sn_id" TEXT(100),
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT,
| "brand" TEXT,
| PRIMARY KEY ("device_id" ASC),
| UNIQUE ("device_id" ASC)
| ) . )1= indexsqlite_autoindex_visit_1visitl07tablevisitvisitCREATE TABLE "visit" (
| "visit_id" TEXT(50) NOT NULL,
| "visit_reason_id" BIGINT(10),
| "remark" TEXT(100),
| "enter_time" TEXT(100) NOT NULL,
| "exit_time" TEXT(100),
| "visitor_type_id" BIGINT(10),
| "visitor_id" TEXT(50),
| "visitor_company_id" BIGINT(10),
| "visitee_id" TEXT(50),
| "visitee_company_id" BIGINT(10),
| "current_state_id" INTEGER,
| "warning" INTEGER,
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "create_time" TEXT,
| "is_valid" TEXT,
| "visit_reason" TEXT,
| "device_id" TEXT,
| PRIMARY KEY ("visit_id" ASC),
| UNIQUE ("visit_id" ASC)
| )G/[5 indexsqlite_autoindex_offline_surveillance_1offline_surveillance .55_tableoffline_surveillanceoffline_surveillance CREATE TABLE "offline_surveillance" (
| "surveillance_id" TEXT NOT NULL,
| "raw_data_path" TEXT,
| "camera_in_or_out" TEXT,
| "create_time" TEXT,
| "device_id" TEXT,
| "device_company_id" TEXT,
| PRIMARY KEY ("surveillance_id" ASC)
| )3(G! indexsqlite_autoindex_department_1departmentg'!!
tabledepartmentdepartmentCREATE TABLE "department" (
| "dept_id" BIGINT(50) NOT NULL,
| "dept_name" TEXT(40) NOT NULL,
| "dept_name_en" TEXT(100),
| "company_id" INTEGER,
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| "create_time" TEXT,
| PRIMARY KEY ("dept_id" ASC),
| UNIQUE ("dept_id" ASC)
| )7&K% indexsqlite_autoindex_visit_detail_1visit_detail|Z%%%wtablevisit_detailvisit_detail{CREATE TABLE "visit_detail" (
| "id" BIGINT(10) NOT NULL,
| "visit_id" BIGINT(10),
| "state_id" BIGINT(10),
| "create_time" TEXT(100),
| "device_id" BIGINT(10),
| "update_time" TEXT(30),
| "is_synchron" TEXT(10),
| "device_company_id" INTEGER,
| "is_valid" TEXT,
| PRIMARY KEY ("id" ASC),
| UNIQUE ("id" ASC)
| )
| ² Í À ? Í [ [ [ [ [ [ [ ² r p 333 22camera15555555555152017-06-23 10:58:35552017-06-23 10:58:3952017-06-23 10:58:515q 333 22camera24444444444142017-06-21 10:58:14442017-06-23 10:58:1842017-06-23 10:58:464 q q q y ¦ > ) è´æç§android_device2222221011
| Ø Ì üÒÌÆÆÆÆÆÆÆ Ø $ %
| çÌhDñÄvR( Û ´ g = é ¼ u P / ì È £
_ :
| õ
| Ó
|
|
| i " " $% ' Båå·¥attender_type $ % AVIPvisitor_type # @æ¤ç
§id_type#" % ?å
¶ä»visit_reason#! % >家é¿visitor_type$ ' =å¦çattender_type <UDPprotocol
| # % :海康camera_brand" % 9大åcamera_brand 8NetBEUIprotocol 7TCP/IPprotocol 6IPX/SPXprotocol# ! 51280*720resolution" ! 4704*480resolution! ! 3720*576resolution+ / 2å·²ç¾éattendance_status* / 1å·²ç¾å°attendance_status& % 0å·²ç¾ç¦»visit_status( %% /æ£å¨è®¿é®visit_status% + ç¾éattendance_type$ + ç¾å°attendance_type% % é»ååvisitor_type' %% æ®é访客visitor_type" ' æå¸attender_type( %% åå¡åä½visit_reason" % 访åvisit_reason! % ä¼è®®visit_reason)
|
| Xæ°å æ³¢countrySingapore+ # Xæ°è¥¿å
°countryNew Zealand% Tæ³°å½countryThailand* ' Mç¾å½countryUnited States" Ræ¥æ¬countryJapan" Zä¸å½countryChina 身份è¯id_type åçid_type 女gender ç·gender
| % üöðêäÞØÒÌÆÀº´®¨¢zsle^WPIB;4-&
| B%A$@#?">!= < : 9 8 76543210/
|
| öìâØÎĺ
|
|
|
|
|
|
| ü"Jr,½KÙkù ¯AÏ]è t
|
| K " ®HÞt Þ ¶ f Ô C µ '
| u ã Q ¿ 1 £ u µ õ j Þ R ¸ "
| üöðêäÞØÒÌÆÀº´®¨¢~xrlf`ZTNHB<60*$ úô Y j + $ ^ _ ` ] q p " ! m l B ? b c d a = > @ < t [ A X W K ; S R Q P 2 / 9 6 V D C * ( % J M E 1 G L g 8 : # ) 3 F ' 4 n , - . h x z y
| i w O N I H & 7 i h x w Þ»uR/ éÆ£]: ô Ñ ® h E " ÿ Ü ¹ s P - # # # # # # # # # # # # # # # # # # # # # # # # # # # " Ý ïÝ èå¡2 èå¡1
| ö üö ¹.~Ð#tÄ^¬ûDÖ h±úC×!b£÷=Ò \ ß Û R é5§ G Ò 0 Ý < ñ ¢ T ¼ s *
| á
|
| O
| ½ s ) ß ] Ã x . í ¤ a ! î % h ® c Ë Y æ s
| ûõïéãÝ×××××××××××××××××××××××××××××××××××××××××××××××××××××××××××× ÞºrN*â¾wS/ é Æ £ ] : ô Ñ ® h E " ÿ Ü ¹ # # # # # # # # # # # # # # # # # # $ $ # $ $ $ $ $ $ $ $ $ "
| üöðêäÞØÒÌÆÀº´®¨¢~xrlf`ZTNH
|
|
