-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathNursingHome.sql
307 lines (282 loc) · 66.1 KB
/
NursingHome.sql
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
/*
Navicat MySQL Data Transfer
Source Server : Conn2
Source Server Type : MySQL
Source Server Version : 80016
Source Host : 106.15.187.231:3306
Source Schema : NursingHome
Target Server Type : MySQL
Target Server Version : 80016
File Encoding : 65001
Date: 06/07/2019 12:29:07
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for administrator
-- ----------------------------
DROP TABLE IF EXISTS `administrator`;
CREATE TABLE `administrator` (
`administrator_id` varchar(45) NOT NULL,
`administrator_name` varchar(45) NOT NULL,
`administrator_date` date DEFAULT NULL,
`administrator_position` varchar(45) NOT NULL,
`administrator_salary` double DEFAULT NULL,
PRIMARY KEY (`administrator_id`),
CONSTRAINT `admin_stafffk` FOREIGN KEY (`administrator_id`) REFERENCES `historical_staff` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of administrator
-- ----------------------------
BEGIN;
INSERT INTO `administrator` VALUES ('A1', '独孤求败', '2017-01-02', '主管', 8000);
COMMIT;
-- ----------------------------
-- Table structure for bed
-- ----------------------------
DROP TABLE IF EXISTS `bed`;
CREATE TABLE `bed` (
`bed_id` varchar(45) NOT NULL,
`bed_roomid` varchar(45) NOT NULL,
`bed_status` int(11) DEFAULT NULL,
PRIMARY KEY (`bed_id`,`bed_roomid`),
KEY `bed_roomid_idx` (`bed_roomid`),
CONSTRAINT `bed_roomid` FOREIGN KEY (`bed_roomid`) REFERENCES `room` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of bed
-- ----------------------------
BEGIN;
INSERT INTO `bed` VALUES ('01', 'R1', 0);
INSERT INTO `bed` VALUES ('01', 'R2', 0);
INSERT INTO `bed` VALUES ('01', 'R3', 0);
INSERT INTO `bed` VALUES ('01', 'R4', 0);
INSERT INTO `bed` VALUES ('01', 'R5', 0);
INSERT INTO `bed` VALUES ('01', 'R6', 0);
INSERT INTO `bed` VALUES ('01', 'R7', 1);
INSERT INTO `bed` VALUES ('01', 'R8', 1);
INSERT INTO `bed` VALUES ('01', 'R9', 0);
INSERT INTO `bed` VALUES ('02', 'R1', 0);
INSERT INTO `bed` VALUES ('02', 'R2', 0);
INSERT INTO `bed` VALUES ('02', 'R3', 0);
INSERT INTO `bed` VALUES ('02', 'R4', 0);
INSERT INTO `bed` VALUES ('02', 'R5', 0);
INSERT INTO `bed` VALUES ('02', 'R6', 0);
INSERT INTO `bed` VALUES ('03', 'R1', 0);
INSERT INTO `bed` VALUES ('03', 'R2', 0);
INSERT INTO `bed` VALUES ('03', 'R3', 0);
INSERT INTO `bed` VALUES ('04', 'R1', 0);
INSERT INTO `bed` VALUES ('04', 'R2', 0);
INSERT INTO `bed` VALUES ('04', 'R3', 0);
COMMIT;
-- ----------------------------
-- Table structure for customer
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`customer_id` varchar(45) NOT NULL,
`customer_name` varchar(45) NOT NULL,
`customer_date` date DEFAULT NULL,
`customer_entertime` date NOT NULL,
`customer_roomid` varchar(45) NOT NULL,
`customer_bedid` varchar(45) NOT NULL,
`customer_phone` varchar(45) DEFAULT NULL,
`customer_careworker` varchar(45) NOT NULL,
`customer_rank` int(11) NOT NULL,
`customer_relationname` varchar(45) NOT NULL,
`customer_relation` varchar(45) NOT NULL,
`customer_relationphone` varchar(45) NOT NULL,
PRIMARY KEY (`customer_id`),
UNIQUE KEY `customer_id_UNIQUE` (`customer_id`),
KEY `customer_roomid_idx1` (`customer_roomid`),
KEY `customer_rank_idx` (`customer_rank`),
KEY `customer_bedidfk_idx` (`customer_bedid`),
KEY `customer_workerfk_idx` (`customer_careworker`),
CONSTRAINT `customer_bedidfk` FOREIGN KEY (`customer_bedid`) REFERENCES `bed` (`bed_id`),
CONSTRAINT `customer_roomidfk` FOREIGN KEY (`customer_roomid`) REFERENCES `room` (`room_id`),
CONSTRAINT `customer_workerfk` FOREIGN KEY (`customer_careworker`) REFERENCES `historical_staff` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for defaultpic
-- ----------------------------
DROP TABLE IF EXISTS `defaultpic`;
CREATE TABLE `defaultpic` (
`pic_id` varchar(45) NOT NULL,
`pic` blob,
PRIMARY KEY (`pic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of defaultpic
-- ----------------------------
BEGIN;
INSERT INTO `defaultpic` VALUES ('P1', 0xFFD8FFE000104A46494600010101004800480000FFDB00430001010101010101010101010101020203020202020204030302030504050505040404050607060505070604040609060708080808080506090A09080A07080808FFDB00430101010102020204020204080504050808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808FFC000110804B004B003011100021101031101FFC4001D00010001050101010000000000000000000007010305060804020AFFC4004010010001030104050906050402030100000002010304050611121307213191E11732414253547193C114223351526223356172818292A2F063832473B1E2FFC40014010100000000000000000000000000000000FFC40014110100000000000000000000000000000000FFDA000C03010002110311003F00FDC4000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000029BE9F9D014E2853AB8A3DE071C3F547BC0E387EA8F7829CCB7ED21DE0732DFB487781CCB7ED21DE0732DFB487782BC70FD51EF038E1FAA3DE07142BD5C51EF0577D3F3A02A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000A4BB2BF006A9A96A37B1EFF0465C350695A9ED4E663CE348DEE1FF0048359CCDBCD42DF9B91FF1F1061EF748DA943B32A14FF4F8831791D276A90852B4CAECFF00C7E20C657A57D5E9D5F6C87CBF1029D2BEAF5EAFB643E5F8832763A4ED5270AD6B95DBFF008FC4194B3D236A53EDCA857FD3E20CC61EDE6A173CEC8FF8F88366D336A7332272A4AF717FA41BAE9BA8DEC8BFC12971541B5C7B29F005400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016AE75577FA018DBF99CB84AB4DDD408FB336DA38F72E5BADCEC97E9F1069999D2AD2C5FB96F99D54EAFC3FFF00A0695A8F49B5BF7EB2E66FA7FF005F88353CFDB6AE4CA35A4B7D3FB7C4182CADA5E66EDD2FF8F8831B7758A4FD6063EEEA1CC8EEEB0786B777F6EF029777766F07BAD6A1CB8EEEB0642D6B1487AC0C962ED2F2F7EF97FC7C419DC0DB6AE34A55ACB753FB7C41B7E99D2652CDFA4AB7377FEBF106EB89D295322EDA8733B7FF001F88370C3DB68E45CB76E973B65FA7C4120D8CCE64235AEEEB064ADF5D77FA01740000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E0CCCAA63465394B8634A6F06A59BB5B898F6EE56B7B877538BCD046D9BD25E99BA70FB5CF8BAFD5F10449A8ED5E25EBD7A74BDBF7D6BEA823BD433E19191727197146A0C35C9714AB507C000000000000000BB6AE72E5BC19BC0D4616322DCE72E10481A76D5E259BD6675BDBB7569EA825BC2E92F4CDD087DAE7C5D5EAF88249C2DADC4C8B76EB4BDC5BE9C5E6836DC3CAA64C6338CB8A35A6F07BC0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000058ADCAD3B640C5EA1AC58C184EE5DBD6EDC69FA81A06B9B6DA7CF1AF429998DE67EAF0042BAB6D3E2DDB77A91CAB3C558D7D6F0042B959359DD94A97018EACAB5EDA828000000000000000000002B49569D9506471726B0BB1956E026AD2769F16D5BB3496559E2A469EB78026AD0F6DB4F86359857331BCCFD5E00DFF004FD62C6742172D5EB77235FD20CA52E56BD9205F0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014AD7752B505BA5CEBEBDC0C16A1AA636379F3B31F8C8110EDC6BB8F73072296B22CF9D1EC97C41CE5A8E7CE71BD4A5CE2FBBFA81A84AECE5DB205B0000000000000000000000000017237671EC9036FD3B3E708D9A56E70FDDFD40E8DD87D771EDE0E3D2EE459F3A5DB2F8025ED3F54C6C9F327665F09033B5B9D7D5B817295DF4A5415000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000052B5DD4AD41F14B9F9D0182CCCEB56AE4A359423FEA0409D21EA95FE252D5CEBEAF5BE2080351CFBF7217292B9397FA81AE5655AF6D41F2000000000000000000000000000003EA92AD3B2A0D8F4ECFBF6E16E91B938FF00A813FF00479AA57F874BB73AFAFD6F8027BC3CEB576E46349425FEA0676B73F2A03EE95DF4A5415000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001F33F36A0C16564C6DD6E6E9537039C36F35BCAB1A86446CE44E31A6EF5BE2084B55D572B278A972FCE5F09035C94E52EDA83E4000000000000000000000000000000007D46728F6541B1E95AAE56370D2DDF9C7E3204DBB07ADE55FD431E37B22728D77FADF00747E2E4C6E56DEF9537033B0F3680FA00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002B5A53B4162FCE34B372BC54EC0734ED7ED2EA1899D970B57E718D275A7FF008082B5ED63332F26ECEEDEE64ABB81AA4EE4E7E74AB507C000000000000000000000000000000000000FB85C9C3CD95680DAF41D63331326D4ED5EE5CA9BC13AEC86D2EA1979D890BB7E728D674A7FFA0E96B138D6CDBAF153B017E95A57B0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000163265585A94A9DB40443AA6D4E7D89644232FBBBEB40733ED56B7957B3B2A5295775675068576F4AF4B8A60B2000000000000000000000000000000000000002F5ABD2B32E28037DD95D6F2ACE762CA32AEEA4E80E98D336A73EFCB1E1297DDDF4A025EC695676A32AF6D417C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016AF57863C5F90354D47579DBC6BD5E0A750393B5FDB1BF0CACA872FD7A822FCFCD966DEB977CDE296F0780000000000000000000000000000000000000000007BF03365857ADDDF3B865BC128681B637E7958B0E5FAF40758E9DABCEE6359AF053AC1B5D9AF1478BF305D0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000018ED5323ECF8972E7E51A8206D5B6C61C9BD6F973EDA8397F58C8A6466644FF0039D640C4800000000000000000000000000000000000000000000CB68F914C7CCC79FE53A481D41A4ED8C39366DF2E7DB404F3A5E47DA312DDCFCE340644000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000166EDCE5D38A5E6D01AAED0EA708E99915FD95071D6ABAEDA95DBD1A71F6D7D504779172372E4E54FCC160000000000000000000000000000000000000000000005FC7B91B77212AFE609134AD76D46ED98D78FB69EA83B1767B5384B4CC7AFECA036AB573994E28F9B505E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000189D5F2218F8D7273F3770220DA3D77125A6E54237A1C5C150721675DACEFDCAC65EB541E1000000000000000000000000000000000000000000000001EEC1BB585FB7594BD6A03AF76735DC48E9B8B095E871705012FE91910C8C6B73879BB819600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007C56E6EAEEEDFFBF006A9B617A96B49C89D7F40395B57D5612B37235B9EAD7D604397E5C5727D5E90590000000000000000000000000000000000000000000000017AC4B86E43ABD2098F48D5611B36E34B9EAD3D60754EC7DEA5DD271E74FD00DAE9737D77767FDF803EC0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000079E758C6B2AD7B011F74859148E839758CBEF700389B3F36F4AE4A95B93E1EB060AB5DF5AD4140000000000000000000000000000000000000000000000015A577569506770336F46E4694B93E1EA076CF47B914968389594BEF70024185632AC6B4EC07A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000061B54BD2B366528CB775821FDBBD42ECF45CA856E7A80E41C99D65725F7B783CC000000000000000000000000000000000000000000000000003D38D3AC6E47EF6E075F6C26A1761A2E2C2973D404C1A5DE95EB3194A5BFAC199000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001A66D6E4CF1F02538F06FDE0E7BDAAD56EDED372215E5F0D620E7ABB5DF7255A82D800000000000000000000000000000000000000000000000000B96ABBAE46B40742ECAEAB76CE9B8F0A72F869107426C964CF2302339706FDE0DCC00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000471D205FADBD2EE5631E2FBC0E5ED773E53C5BD1E1DC08AA75AD655AD41F0000000000000000000000000000000000000000000000000003EE15AD254AD012AE859F2862D98F0EF0750F47F7EB734BB7594787EF024700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000115F4997690D1EE4BFA8393755C9A4ACDC88345000000000000000000000000000000000000000000000000000001BD6959348D9B71075974677693D1EDCBFA82540000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011074A77797A25FAD69EB839033B2A338DCA5240D74000000000000000000000000000000000000000000000000000006C583951846DD2B2075FF004597799A258AD29EB825F0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010D74B93AD341BD4A53D707185F9F5CB703C6000000000000000000000000000000000000000000000000000003D9627D71DE0ECFE88E75AE836695A7AE09940000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000042FD2F537E857E9FBC1C617E15A4A55AC7D60798000000000000000000000000000000000000000000000000000007A6C42B5946B48FAC0ECFE8869BB42B14FDE09A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000043BD2BC695D0EFD7F7838EB32DFE2529F7418600000000000000000000000000000000000000000000000000000199C3B7F874AFDE0762F4511A5343B15FDE098800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000445D295295D16F7F7839073E1BA373D20D68000000000000000000000000000000000000000000000000000006CB810DF1B7E8075F745B4A5345B3FDE097400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000459D25C292D1EE469F98392F54B348DAB95A501A3D69BAB5A028000000000000000000000000000000000000000000000000002B4A6FAD280DE34BB3495AB75AD01D69D1A4291D1EDC6BF982530000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011D6DF59E6E997295EBEB072FEBD851B7897A548FAA089E74AD255A541F0000000000000000000000000000000000000000000000000003EE14AD654A5012C683851B98966558FAA0EA0D81B3CAD32DD29D5D6091400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000691B616E97302E53FA839CF69F0E90D3F22BFB41035DF3EA0B6000000000000000000000000000000000000000000000000002E5AF3E809E76630E93D3F1EBFB41D19B1F6E96F02DD3FA8377000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001AC6D15995EC595B8FDEAEF0415B67A7DDB5A4E54EB1EC803986FF00E2C8164000000000000000000000000000000000000000000000000005EB1F8B1074F6C669F76EE938B3A47B6009D7676CCACE2C6DCBEED7783670000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000018CCFB55BB6A748C78A4089F6FB0AE4743CCFE1F5F0038DF2ECCA377AA20F1000000000000000000000000000000000000000000000000000F6E25994AEF5C41D91B0385725A1E1FF000FAF8012C605AADAB50A4A3C32064C000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007CF047F20689D205BE3D0B32348FA80E29D430AE46572B5B73A768353953756B4050000000000000000000000000000000000000000000000005694DF5A501B669F857252B75A5B9D7B01DADD1FDBE0D0B0E358FA80DEF823F903E80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001ABED5C29734CC88D63C5F701CC9AD6152362F4AB6E7E6D4104DF8D237255A57AF782C000000000000000000000000000000000000000000000000BF623495C8D6B5EBDE09DB45C2A4AC59952DCFCDA03A6F65214B7A663C691E1FB80DA00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000078350B51BB66719766E0463B4DA6E3534CCAAD2DC232E09FAA0E2DD4AD561937377E750638000000000000000000000000000000000000000000000006474DB559E4DBDFF009D01DA5B33A6E3574CC5AD6DC252E087AA093B4FB51B566118F66E07BC000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005BB96F99D55EC06BDAF60DA9E9D911AC61D7090392755D0F1692BD2E5C37EFA8225CCB34B37AE463E6D2550790000000000000000000000000000000000000000000007AF0ECD2F5EB71979B595012D695A1E2D65665CB86FDF4075B683836A1A763C6918754220D86DDBE5F553B01700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E3CDB31BF6256E5E656808C354D90C0AE3DE9F2E7C40E49D7B02D5ACCCA846338EEB95883539C78655A03E0000000000000000000000000000000000000000007DC23C52A501B6683816AEE662C2519CB7DCA441D6DA5EC860531ECCF973E2049F8566362C46DC7CCA501EC0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016EE75EEA0319998B1BB8F7235976839B75DD89C7BB7F2AED6E53AE7590205D774E8E0E5DEB7497170CEB106080000000000000000000000000000000000000000067742D3A39D9766DD65C3C53A4413D685B138F6AFE2DDA5CA754E92074961E2C6D63DB8D25D80C9DBEADF405C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005ABD1E2870FE60D2B3F419DD8DE952E42BBC1CAFB63B3B73EDF95FC4879F2FA022DCBC4AE2DC942B2E2DC0F1800000000000000000000000000000000000000F66262572AE4614970EF04A5B1DB3B73EDF8BFC4879F1FA83AA303419DA8D9956E429B81BAD98F0C387F205D000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000AD295ED05ABD1A4AD4A9E80415B47B25939B979176DF2786B2AD7CE073C6D5E897F0B32F5B9D21D5B81A25CB72B75DD205B00000000000000000000000000000000000172DDB95CAEE8837BD94D12FE6E659B70A43AF783A1F67364B270B2F1EEDCE4F0D254AF9C09D6CC691B51A7A017694A53B0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007CCFCDA831F7AC467495797DB4A839C36FB66B3B3352C89D8C79CA35DDE6FF90413AD68B99A7D25CFB33B7D80D58000000000000000000000000000000000006D3A2E8B99A8523C8B33B9DA09DB60766B3B0F52C79DFC79C634DFE77F80747D9B1185235E5F65280C843CDA03E80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000052B4DF4AD01F3C11A7A6A0D5F51C0B57AECAB5B7C52A839DBA47D1AE569729671E74F33CD8FC410264E9B938D4ACEE5B9C777E710638000000000000000000000000000000006471B4DC9C9A5276EDCE5BFF0028827BE8E346B94A5BA5EC79D7CFF3A3F00744E9D816ACDD8D696F865406D1C11AFA6A0FAA53752940540000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000AD37D2B4059AD884ABBE54E20475B51A4E3E471715984FB3D5F88200DB5D1ADE3615F95BB3C32A569EAFC41064E128CA5BE80F8000000000000000000000000000001F7084A528EEA0273D8AD1ADE4E15895CB3C52AD6BEAFC013FECBE938F8FC3C36610F3BD5F80245A58846BBE34E105EA53753700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003C1918167269FC58C64088BA42D13169A7E55636A1DB4FA8397752D36D5B8DE946DF0EE069D5A6EAD680A000000000000000000000000000AD29BEB4A0371D374DB57236652B7C5BC1D45D1EE898B5D3F16B2B50EDAFD012EE3E059C6A7F0A31883DE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000D2F6A74F866E35E84ABF72BB81CF5B59B3B631F0F2AE478F8A90ACBCEF8039EEE5386E4A3E907C000000000000000000000000000FBB74E2B918FA41D09B27B3B63230F16E4B8F8AB0A4BCEF883A1765B4F8616359846BF729BC1BA000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C6E661FDAE328D78FAC1126DF6894B5A6674B8A7F835FA038E32ACD637AE529E8078C000000000000000000000000007B316CD657ADD2BE90763EC0E894BBA660CB8A7F834FA825BC3C3FB24691A71F5032400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008DBA42871E979F4FFC35FA0389B3716B4BB7240C1569BAB5A028000000000000000000000002B4A6FAD280CEE162D6B76DC81DB3D1EC3834BC0A7FE1A7D41248000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008F76F23596999B4A76F2ABF4071AEA166749DE9034D96FE2AEFED07C800000000000000000000000FA8EFE2A6EED06E5A7D99D676640ECAD838D63A66152BDBCAA7D41210000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008FB6EEEC21A6E6565E8B75FA038E351CAB359DEA7DC06933AEF956B407C800000000000000000000000FA85774A95A8376D3B2ACD27669F701D8FB097613D370EB1F4DBA7D412080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002CCEF46DD2B597A0118748799667A56752928525C9AFADF00713E65DA73AF7603180000000000000000000000000032787769CEB3D80ED8E8F332CC34AC1A5650ACB934F5BE2093E17A37294AC7D20BC0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F8E6D3FAF778035CD76FC2D59B92ACA91DD5A020ADB4CFB573033234B9C5FC3AFD01CBF7EBBEEDCAFF00505A00000000000000000000000000176C5775DB75FEA0EA0D8BCFB56F030E35B9C3FC3A7D413AE857E176CDB9525496FAD41B1F369FD7BBC01F60000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F9E38FE60F25EB96EDD3AEE708225E90F3F95A7E556DDEF4D3B3FC8396F53D4EF5EA5EA4AF4E55AFEE06975AEFAD6A0A000000000000000000000000000AD2BBAB4A8374D3353BD6696691BD38D69FB81D49D1E67F374FC5ADCBDE9AF6FF804B566E5BB94EAB9C40F5F1C7F307D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003E6B5A4A95A52A0B1595235EB9C01136DAEB77F0799CABD387679B2A7F5073E6D36D26666E35E84F22F4A35FDC08AEE644E7596F96FA54160000000000000000000000000000005FB79138563BA5BA9404A9B33B4999858D6610C8BD18D3F703A0F62B5BBF9DCBE6DE9CFB7CE953FA0259A4A92AF54E00BF4AD234A52B507D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003E67E6D4189BF933B759569F7770222DA8DB0CDD3B2EE5AB77A918D377ABBFEA083B69F6BF373B8F8EF716FDDEAFC411BE4EA17722328CA5C5406340000000000000000000000000000000064B1B50BB8F18C632E1A0248D98DAFCDC1E0E0BDC3BB7FABF004E3B2FB619BA8E5DBB572F5251AEFF5777D412ED8C99DCAC6B5FBDBC196879B407D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002D5F9705BACBF2068999B4D5C7E742B3ECAF0F9BE208A359E923ECD7EF4399D95AC7F0FC410FED06D5D351C9B9778F8A95DDEAEEFA8345CBCBE7F603C0000000000000000000000000000000000003DF8997C8ED06F5B3FB574D3B26DDDE3E1A537FABBFEA098346E923ED37ECC399DB5A47F0FC412BE1ED35723930A4FB6BC3E6F8837BB12E3B7497E60BA000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003CD937B9109CEB2E1EA06BD95B41631ED4AE4AF5631A0348CCE9234D8DB9C3ED52E2FEDF10443A96DC60DD9DEDD913DF5957D5F10441AC6A36F2F22F4E12A4B7CB7835F94AB2AEFA83E4000000000000000000000000000000000000007D46558D77D01B068FA8DBC4C8B339CA91DD2DE097F4DDB8C1B53B3BF227BE92A7ABE2097B0FA48D3656E10FB54B8BFB7C41BBE2ED058C8B51B91BD5946A0D871AF73E109D25C5D40F4800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F34EF70537CA40C667EB3630EDCAE4EF4211A7EA06A1AB6D9E9F1C7B9FFCCC7F37F578022BD5B6CB06EE34E10CCC694EB1AD3CEF0041D9BA8D272B958DEDDBEA0D52F5C94E72AF102D000000000000000000000000000000000000000000000BB6AE4A138D7881B5E16A3484ADD657B7EEA8271D276CB06D634213CCC68CE91A53CEF004A9A4ED9E9F2C7B7FFCCC7F37F578036FC0D66C665B8DC85E84E35FD20C9C2F71D37C640F48000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000292AEEA56A0B7CCDDDB4A03C77F51B362B18CEE598EFFD40D6B54DA0C2B508D6B918D1DFFB8117ED6ED0E2DEC1BB1B7918D29EFF00564082F57D4AB731EE4697A15A6EFD408FE77EECEBD7205AAD6B5EDA828000000000000000000000000000000000000000000000002B4AD69D9505D85FBB0AF548120693A956DE3DB8D6F4294DDFA813A6C96D0E2D9C1B71B9918D19EFF5A409434BDA0C2BB09569918D2DDFB81B2D8D46CDFACA30B9665BBF483D9CCDFD94A02E52BBE94A82A000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003E652E1DDD5BC14E675716EFFBDC0B33C8B74A4AB5943FDC0C364EA58F094B7DC847ABF50225DB0D5A3CCB34B77A1E6FEA0415B53AADFAD9B7C173FE408EAE66E4DCA5693BB2902CCAE4E5DB2A82D800000000000000000000000000000000000000000000000000000B91B938F64AA0BD6F3726DD29485D944122ECB6AB7E966E71DCFF0090275D8FD5A3CCBD4B97A1E6FEA04B58DA963CE51DD7212EAFD40CCC322DD691AD250FF702F733AB8B77FDEE05632E2DFD5B81F40000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F994A91ED05A9DC86EA57881E0C8CBB51B32AD254FF00BFE4114EBBABDDB79591185E9C634FDC08276A368B508656EB595763D54F5811FE6EB79F7AB1E3C8BD2F4F9C0C45DC9BD7A9BAE5C94A20B0000000000000000000000000000000000000000000000000000000000002FDAC9BD669BADDC94620CBE16B79F66B2E0C8BD1F4F9C090365F68B509E56EBB95765D55F5813B685ABDDB9958F19DE9CA35FDC095B1F2ED4ACC6B5953FEFF00907BE1721BAB5E205DA4A92EC07D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003E6B28D3B6B4A031DA95FE563DC9C2E438A91046DAD6B795631EF4ADE470CA91AFAC083757DB7D6ADE45EB71CB9D23C55047FA86D6EAD7722E56595396F06B791A8E5654F99767C52078AB5AD7B6A0A000000000000000000000000000000000000000000000000000000000000000AD2B5A76541EDC7D472B167CCB53E190364D3F6B756B5916EB1CA9C770240D236DF5AB99166DCB2E758F15013968BADE55FC7B32B991C52AC69EB0249D36FF00371EDCE7721C55883234946BD95A541F40000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C666DE9D9F37D20D1B68B6832F031F9B67CEDF40439ACF485ABF22F529721D5404679DB79AA5FA5CB53B90E1AEF069B93A9DFC8B939CFD35063A72ACE55957B41F2000000000000000000000000000000000000000000000000000000000000000000003EA12AC254953B4191C6D4EFE3DC84E1E8A8372C1DBCD52C52DDA85C870D37024CD1BA42D5F916695B90EBA0263D9DDA0CBCFC7E6DEF3B7D41BCE15E9DEF3BD00C98000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000292ECAFC01E2B977865BA910697AFED35DD32E5B846DF16F045BB47D24E4E3C615A59F4822ED63A47C9D4A12B52C7847EF0341CBD667936E70AC7B41839578ABBC1400000000000000000000000000000000000000000000000000000000000000000000000000158D786BBC19CC4D6678D6E10A47B01BF68FD23E4E9B08DA8E3C25F78128ECE7493939119D6B67D2094B40DA6BBA9DCB9095BE1DC0DD2DDDE296EAC41ED8F653E00A80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003E275DD1A8356CDDA18E2DCB96F867D408E75AE936D69F93CAAE35E90228DA3E912DEA172328D9BD1DC08C75BD723A8C634A4671DD506AC00000000000000000000000000000000000000000000000000000000000000000000000000000000000369D135C8E9D1952B19CB7D41276CE74896F4FB9294ACDE96F04AFA2F49B6B50C9E5531AF44123616D0C72AE5BB7C33EB06D30AEF8D01F6000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002D5C9F003C3775185A8EFA834ACCDBFC0B1295A973B8A95DDE68226D676F7027957AB1E77A7D50431B47AD5BD4336576D4A7C20D3AEDE95CAEFDF50580000000000000000000000000000000000000000000000000000000000000000000000000000000000000017ED5E95BAEFDF506E3B39AD5BD3F36376ECA7C2099F46DBDC086559ACB9DE8F5412CE1EDFE05F946D479DC55AEEF341BADAD461763BE80F75B9F182E80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003CD91930C7A4A53FBB1A030199B47A7DAB52ACAF43AA208E350DBCD1786E43ED9678FAFD6073FEAFAF5ABF957A76F229C1595411F6765CEEDFB928DCFBB50782B5ACABBEA0A000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000AD2B58D77D01EFC1CB9DABF6E52B9F768090748D7AD58CAB33B9914E0A4A80E80D3F6F345E1B70FB659E3EAF58123E1ED1E9F76D46B1BD0EB8833F8F930C8A4650FBD1A83D2000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002DF37FA7FDEE058C8CCB38F194AECA10A53F70351D775FD3E98D7B8722CF1707EA041FACED058959BD486443CCAFAC08073352C995E95697A728F157D6062E57AE4ABBEB2AEF05A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000017637AE46BBE92AEF06530F52C98DE8D6B7A718F153D604FDA36D0588D9B349E443CCA7AC09C342D7F4FAE359E2C8B3C5C1FA81B763E659C88C656A509D2BFB817F9BFD3FEF702E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003E293A4BABAFFEFF0080792EE459B3E7CC11C6DA6B11B385915B391C32E2A7D41CEDACED1664ACDFA7DAAF79BFA8118DED5B36E5654ADF9CA3FDC0C656B5AF6828000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002B4AD69D80C9D9D5B36DD634A5F9C63FDC093B46DA2CC8D9B14FB55EF37F503A2762F588DEC2C7ADEC8E297157E8091ED6459BDE64C1EBACE91EAEBFFBFE01F60000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000A4BB2BF0079AB38D2BBAB2A6F0441B73AF6569F497D9F23869D5D9FE41006BFB59A9E563DC8DCCA9CB7D411B5FD4726FF1D2772528D41E0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001EFB1A8E4D8E0A42E4A31A0249D036B353C5C7B71B79538EEA827FD86D7B2B50A47ED191C54EBEDFF000097E938D6BBA92A6F07A63D94F802A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000292ECAFC0119ED0EB97F0B26E421C1C34DC0E7BDB8DA1C8BDC5BF83D1F5043B919B7322928CA9F76A0F1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F6E3E6DCC7A4631A7DDA0262D87DA1C8B3C3BB83D3F407426CF6B97F3726DC27C1C35DE09323D94F802A000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003E67E64BE150734F487AE4B0F52C8852DF5D234FA8201D6F54966D25FC3E1AF50355000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001B5689AA4B0A91FE1F157AC13F7479AE4B3352C7856DF5D635FA03A5A1E647E1407D000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B73FC2B9F0A838EFA57BD1B7ACE65377A21F5041976E52E577EEEB05A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000176D5CA5BAEFDDD609CFA28BD1B9ACE1D377A27F4076243F0ADFC280B8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002DCFF000AE7C2A0E33E977F9C66FC23F5041E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000270E88BF9C617C25F4076643F0ADFC280B8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002DCFF0AE7C2A0E33E977F9C66FC23F5041E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000270E88BF9C617C25F4076643F0ADFC280B8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002DCFF000AE7C2A0E33E977F9C66FC23F5041E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000270E88BF9C617C25F4076643F0ADFC280B8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002DCFF0AE7C2A0E33E977F9C66FC23F5041E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000270E88BF9C617C25F4076643F0ADFC280B8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002DCFF000AE7C2A0E33E977F9C66FC23F5041E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000270E88BF9C617C25F4076643F0ADFC280B8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002DCFF0AE7C2A0E3DE95EDF16AF995AFE50FA820BBD6F8377502C800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BD66DF1EFEA04E9D145BE1D5F0EB4FCA7F4076143F0ADFC280B8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003E674E284E9FD01CDDD206936B2751C89CEDEEDFBBEA0E7ED7B4E862F1705BE1AF50353000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001B6683A7432B878EDF157AC1D03D1FE936B1B51C79C2DEFDDBFE80E918538610A7F407D000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F99537C654F4023DD73677EDF7EE5CAC6B2DFBBD6F00421B5FB1FC1496E8EFECF5BE3FD010FEA5A0D3123727C3D9FB81ACDCB5C1BFAC160000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005FB76B8F7758366D3741A65C6DCF87B7F70260D90D8FE3A477C7776FADF0FE809BF43D9DFB05FB77291AC776FF5BC0121469BA31A7A01F400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000292ECAFC01E6946B2AD3AC1A2ED16877F3F8A36EDF16FDDEB7C41186ADD1FEA5936AE421638E9FDC0D32E7451AC4B76EC3853FF67803CBE48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E007922D5FDCA3F33C00F245ABFB947E67801E48B57F728FCCF003C916AFEE51F99E00F55BE8A3588EFDF870AFFECF006E7A4F47FA9635AB709D8E0A7F7024FD9DD0EFE070C6E5BE1DDBFD6F8037A8C6B1AD7AC1E98F653E00A800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000A5631AFA280A5610976C620A72EDFB387701CBB7ECE1DC072EDFB387701CBB7ECE1DC0A72E1FA2DFF00B415E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B814E5C3F45BFF682BCBB7ECE1DC072EDFB387701CBB7ECE1DC072EDFB387701CBB7ECE1DC072EDFB387701CBB7ECE1DC072EDFB387701CBB7ECE1DC072EDFB387701CBB7ECE1DC0A72E1FA2DFF00B415E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B814E5C3F45BFF682BCBB7ECE1DC072EDFB387701CBB7ECE1DC072EDFB387701CBB7ECE1DC072EDFB387701CBB7ECE1DC072EDFB387701CBB7ECE1DC072EDFB387701CBB7ECE1DC0A72E1FA2DFF00B415E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B80E5DBF670EE03976FD9C3B814E5C3F45BFF682BCBB7ECE1DC072EDFB387701CBB7ECE1DC072EDFB387702B48423D91882BC31A7A280A80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003FFFD9);
COMMIT;
-- ----------------------------
-- Table structure for doctor
-- ----------------------------
DROP TABLE IF EXISTS `doctor`;
CREATE TABLE `doctor` (
`doctor_id` varchar(45) NOT NULL,
`doctor_name` varchar(45) NOT NULL,
`doctor_date` date DEFAULT NULL,
`doctor_salary` double NOT NULL DEFAULT '6000',
`doctor_major` varchar(45) NOT NULL,
PRIMARY KEY (`doctor_id`),
UNIQUE KEY `doctor_id_UNIQUE` (`doctor_id`),
CONSTRAINT `doctorid_stafffk` FOREIGN KEY (`doctor_id`) REFERENCES `historical_staff` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for doorboy
-- ----------------------------
DROP TABLE IF EXISTS `doorboy`;
CREATE TABLE `doorboy` (
`doorboy_id` varchar(45) NOT NULL,
`doorboy_name` varchar(45) NOT NULL,
`doorboy_date` date DEFAULT NULL,
`doorboy_salary` double NOT NULL DEFAULT '3000',
`doorboy_workplace` varchar(45) NOT NULL,
PRIMARY KEY (`doorboy_id`),
UNIQUE KEY `doorboy_id_UNIQUE` (`doorboy_id`),
CONSTRAINT `doorboyid_stafffk` FOREIGN KEY (`doorboy_id`) REFERENCES `historical_staff` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for historical_customer
-- ----------------------------
DROP TABLE IF EXISTS `historical_customer`;
CREATE TABLE `historical_customer` (
`hiscustomer_id` varchar(45) NOT NULL,
`hiscustomer_name` varchar(45) NOT NULL,
`hiscustomer_date` date DEFAULT NULL,
`hiscustomer_entertime` date NOT NULL,
`hiscustomer_roomid` varchar(45) NOT NULL,
`hiscustomer_bedid` varchar(45) NOT NULL,
`hiscustomer_phone` varchar(45) DEFAULT NULL,
`hiscustomer_careworker` varchar(45) NOT NULL,
`hiscustomer_rank` int(11) NOT NULL,
`hiscustomer_relationname` varchar(45) NOT NULL,
`hiscustomer_relation` varchar(45) NOT NULL,
`hiscustomer_relationphone` varchar(45) NOT NULL,
PRIMARY KEY (`hiscustomer_id`),
KEY `hisitorical_customer_workerfk_idx` (`hiscustomer_careworker`),
CONSTRAINT `hisitorical_customer_workerfk` FOREIGN KEY (`hiscustomer_careworker`) REFERENCES `historical_staff` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for historical_record
-- ----------------------------
DROP TABLE IF EXISTS `historical_record`;
CREATE TABLE `historical_record` (
`hisrecord_id` varchar(45) NOT NULL,
`hiscustomer_id` varchar(45) NOT NULL,
`hiscustomer_name` varchar(45) NOT NULL,
`hisdoctor_id` varchar(45) NOT NULL,
`hisrecord_date` date NOT NULL,
`hisrecord_context` varchar(45) NOT NULL,
PRIMARY KEY (`hisrecord_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Table structure for historical_staff
-- ----------------------------
DROP TABLE IF EXISTS `historical_staff`;
CREATE TABLE `historical_staff` (
`staff_id` varchar(45) NOT NULL,
`staff_name` varchar(45) NOT NULL,
`staff_date` date NOT NULL,
`staff_salary` double NOT NULL,
`staff_status` tinyint(4) NOT NULL,
PRIMARY KEY (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of historical_staff
-- ----------------------------
BEGIN;
INSERT INTO `historical_staff` VALUES ('A1', '独孤求败', '2017-01-02', 8000, 1);
COMMIT;
-- ----------------------------
-- Table structure for manager
-- ----------------------------
DROP TABLE IF EXISTS `manager`;
CREATE TABLE `manager` (
`manager_id` varchar(45) NOT NULL,
`manager_priv` int(11) NOT NULL,
`manager_password` varchar(45) NOT NULL,
`manager_pic` blob,
PRIMARY KEY (`manager_id`),
UNIQUE KEY `manager_id_UNIQUE` (`manager_id`),
CONSTRAINT `manager_historical_staff_idfk` FOREIGN KEY (`manager_id`) REFERENCES `historical_staff` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of manager
-- ----------------------------
BEGIN;
INSERT INTO `manager` VALUES ('A1', 0, 'dc483e80a7a0bd9ef71d8cf973673924', 0xFFD8FFE000104A46494600010100004800480000FFE100584578696600004D4D002A000000080002011200030000000100010000876900040000000100000026000000000003A00100030000000100010000A00200040000000100000064A0030004000000010000006400000000FFED003850686F746F73686F7020332E30003842494D04040000000000003842494D0425000000000010D41D8CD98F00B204E9800998ECF8427EFFC00011080064006403012200021101031101FFC4001F0000010501010101010100000000000000000102030405060708090A0BFFC400B5100002010303020403050504040000017D01020300041105122131410613516107227114328191A1082342B1C11552D1F02433627282090A161718191A25262728292A3435363738393A434445464748494A535455565758595A636465666768696A737475767778797A838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE1E2E3E4E5E6E7E8E9EAF1F2F3F4F5F6F7F8F9FAFFC4001F0100030101010101010101010000000000000102030405060708090A0BFFC400B51100020102040403040705040400010277000102031104052131061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A262728292A35363738393A434445464748494A535455565758595A636465666768696A737475767778797A82838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE2E3E4E5E6E7E8E9EAF2F3F4F5F6F7F8F9FAFFDB0043000909090909091009091016101010161E161616161E261E1E1E1E1E262E2626262626262E2E2E2E2E2E2E2E373737373737404040404048484848484848484848FFDB0043010B0C0C1211121F11111F4B332A334B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4B4BFFDD00040007FFDA000C03010002110311003F00F6F3C735C6EADAC99617F224315B2E434ABF79FD93D07BD3FC41A819261A4C27008DD311FDDECBF8F7AF32F136A5BD96C213855F9703F5FF000AF470F87B2F693386BD7D79225EB4845DCA5D0613AFAF5E9566EA348172DD4F4157746F2A3B39A67E021E7E98AE7353D43EF5C49D4F0AB5ED73B7377D91E5F2E8ADBB268226B99D621DCFE95D3A5A2C68114702A97872DBCD679DBAAA81F89EB5BF7CE9676ED33F6E00F53DAB1AF59B9F244D28D2B45CD9CEDEC896E360E5CF6F4AC424B1C9E49A74923CAE6473927AD5696E22806E91B6FF003AEC845423A9849F33D0B0212FC119A43A6ABFDDE0D32CB57B36711BB75F5E2B66E6359544D6122F9E9CAAE7EF8EEA7FA7BD633ADA5D6A5C69F466049A65CA728370F6EB5D2786FC453E9332D85FEE36EC78C8E509EE3DBD47E356AD27B6BBB237B1F0141DEBDD48EA0D476935ADFA930755EAA7822B9E728D5838C9686908CA9C938BD4F57041191CD2D7076DE2CB3D3A3FB0DE6E2F11C0239E3008FCBA559FF84E349F47FCABC7FA9D5E913D4FADD3EACFFFD0BAD7AD24F3DD31CB3313FE15E7D3BBCB74666FEF7E82BAB624123D4D3747D1D2FA5984BF7550807D19BA1FC2BE9318A14A93A92D91E1E194AA54E45BB2C4770D1DBC96E3A49B4FFDF35CADC16BCB866FF96719DBFE7EB8AE827496D95E2986D91073FE3F435A36FA315F0CB381FBC63E7FE038FF00D079ACB1F888C2106B69346985A1294A4BAA474BE160AD6D29EFBC7E58ACDF125D79B782D94FCB10E7FDE3543C39A92D9CA0CA711BAED6F623A1AC8BFBC2A24BA9396624FE26B6853B5595696D63194FF76A9ADCA57B7CB6C36272E7F4AC892CEF9EDCEA12A9F2C91F3377CFA5763A07877CE0353D486E2FF32237A7A9FE82B735D815F4D9108EA571F98AF0F119A7B5C4468C3BD8F5E865EA1465566FA5CF23AE874BB96954C321C95E9F4ADBD2741568A67B9185953628EF8CE73F9818AE5AD11ED751F224E0A9643F85766171095774D3D8E6C461E4A8AA92EA5ABCDD6D73E602424BF7BEB52C7249136F898A37AA9C1A9F508BCCB56F55F987E159D6EFBE204F51C57AD6E59B877D4F325AC548B5F7C967249279268DABEB4CA5AD0C8FFFD1A8E402C4F0066B2F46D57C446CE5B4D1ADCCF3B4E5CC8D8C2A10303923BE7AF156B517D96B330F423F3E2B3FC2BAB2E97A929915D924050AA296273D3007BE2BD5CEE4DC231479F95A4A6DB36E46F18AFEF75BD352EE1C60F925448BF4DA493F4C1AF41D1EF6C352B256B1276A008C8C30C840FBAC3B1AE3350D7FC62B1437D6B6D0416D744F9024399197190CC036071FCEAA695E3E92D6ECDA789228D0B6079D0F3D3FBC324FE23F2AF9D9C2A4A0A2F65FD6C7B5194149B44BAA69EDA4DF98C0FDC4DF3467D3DBF0A8AC34E1AAEAD0DBC8331440CAE3D71C01F89AF49B8B5B1D62CC2BE258A4019594E7E841AA1A3E8EDA5C933336FDFB42B77DA33D7DF9AF49666DE1254A5F11E7BC02588535F08DD606ACB6C13468E3695CEDDD21C2A0F5C77FA571EFE15F125CAEEBDD61839392A91E5411E9F32FF2ADDD4EC35CF116AA34FD32E9ECEC638FF7D32AE0B3E7EEA9E09ED9C1C75EFC578FDF68FA72BDC5CC73CB244B23246EC412E1782C78EE41C7B5797468C92528BB7C8F46A558DED2573B09F45F1A69B28B8B4BCFB6853F71C9191EE18E3F5CD675DBC92EAB15CC91340F300CD1B70548CA9FE5906B3EDA6F16E81610EA485FEC57271179C432B679181925738F6CD5B8B54975CBD86F270AAEA9860A0A818C9EE4FAD7A180A7355E29D8E5C6548BA2EC6D3AEE42BEA08AE6EC8F0CBF4AE9EB98D386E9B67AE3F9D7D557D2A43E67CE43E091A2AA08A76C14E65D8EC9FDD247E5495A189FFFD2C6D578B397FCF7AE3A36DAC0D77375025CA98E4FBB9C9F7C570D2156919906012703DABDCCCA176AFB34791839DB63D775EB93A869FA4EA71F0AC92C640E81D829C7E05180AE02DAF6D7C3D6BAC68FAED9B1BEBA4C42C555B6EE070739E319078AEEBC1863D5F41B8D22E0E446E1C7D1BFC197B1079E08A9C78056E6E85C6A977E78C8DDB63D8CC0762C59B8EDC738AF9C8D4515696E7B8E177746C7832DDADFC376AAD91B833807B0662463D88E6BA7229E91AA204418551803D852E2B8E5ABB9D11D15892D582CB83DC62BE748344D4351B65D0ED573731C9244CA4E30C84E724F4E057D0878AE235EF0F6A575A87F6AE8D34504EC30F9DC9B88E0316527E6038C81C8EB5BD1AAA2B96467529B6EE8E035FF0018C7A8786ADBC35F6778EE6D8A24E5B1B479236FCB839E71CE40C74E69DE698205B875C7950C56E38EAC89839FC41FCABA0D33C00526FB46B12A31CE7CB841C1EFF3337247B607D69FE29B78624B4D2ADC60162EDEB81C64FD726BBB09898AAF150577D0E4C4D17EC9B9688CA91F6C0CE7B293FA5616923376A3FDA5FE75A5A9CA23B52BDDF8AAFE1F84CD7E8BFED0FD326BE92BCBF7B15D8F0A9AFDDB7DCD1BA402E64FF7BF9D41B45696A2025F4AA3B11FFA08AA7BAB68CB4462E3A9FFD3CFBB6D90CADE80D70C2276708A3249C0AEC75025C181064B1E7E95059D8085BCE93EF761E95F4B88A2EACD25B23C1A551538B7D4BDE0ABE8F4AF101B499BF77366124FA93F29FCC63F1AF6C2A549535F305C487ED4F32F76247E75EE3E12F12A6B96A2D6E580BB897FEFE28EE3DC77FCFE9F2D8CA569B6B63DFC354BC527B9D2B3DD2CC711868F0318201A9F391CF1ED48ECCA85946E201381DFDAB886F1D588C8FB3CD91D8E073F9D709DD18CA5F0A3B53519ACDD1F536D5AD3ED7E51894B10A09CE40EFD077A9AF6FECEC13CCBA9020EC0F53F41D4D472B93B45037CBF1684933A451B4B290AAA3249EC05795DFDE2DCDE497F371BBE5453D420E9F89EA6B4757D7E6D5316D648C23CE7D598FD057302D6E6EAE7ECD18DD27F113D17EB5EF60A8C306BDBD77EF745FD753C9C4CE7897ECA8AD0CDBD99AE24DC7803A0AEB7C116665B979C8E2353F99E07F5AE7B53B2169746D90EEC05E4FA915E81A520D17C332DD9E2494657D79E17FC6BBD4F9D7B45D7F538650E49723E9FA1CADDCAB3DE4F2E7832363E9DAABFCBEB5594F14EC8AF51452D0F3B9AFA9FFFD4AAC06E3F5AA57937951103EF3702ACCD22C6493EB58937993B12064D7D7D59DA365B9F374E3777661CC314B6B3DCDACC9716C5848186CDBF78B76C7BD6D69DA2DFEB339874D8BCF2A70CDD224FF79FBFD0735ECBE1BF05D968856F2E8FDA6F31FEB08C2A7B22F6FAF5FA57855A14E37F6BF77F5B1ECD152D1A2AE99AF4C5A2B0F1047F64BD750577E02C99F4EDBBD47AFE431B59F0A4F77A89B9B32AB1CA72E0FF0009EE47AE7AFD6BD1754D234FD62DFECDA8442451CA923E653EAA7B1AE524B7F11E8A9E54683508173B5F7059001D981EBF515E056A4D6A8F6B0D8870774EC6D5B5BC5696E96D08C246028FC2B2754BFD3ED10C93842477600FFF00AFE95C6CBE2AD5EFD76D9C4B186EF9DC7FA5436DA15EDFCC27BF72C7FDAFE83B571F3DB63754FAC864BA85D6AB2186C54C719EAF8C123DB1D056ED858476316C41C9EA6B62D74C86D536C62B3F539C5BA98E320391C93D147A9FE95A50A53AB3508EEC556BC69C5CE5B239D5B31A9EB3248DFEAA32031F5C718FC69FE21D505DC8B6701FDD45D71D0B7FF5AA8CBA808A2FB2D970BDDBB9AC9AFBBA38750515D8F8AAB5DCDC9F71452E45368AE939CFFFD5A334680B39192013CD741E0ED034FD7AC7FB47540D2E18810E711F1EC304FE248AC39FEEBFD0D76DF0DBFE401FF6D1ABE9F1D271A4DC5D8F1700939BB9DF410C36D12C16E8B1A28C2AA8C003D80A9A93D296BE60F682A39FFD4BFF00BA7F954951CDFEA5FF00DD3FCA803CAB4289069B01C755AE9D005E95CDE85FF20DB7FF0076BA55AF199EB48C2F10DEDD5A409F667D85BA91D6B816692405A476624E4E4E79F5AED3C55FEA22FC6B8A1F76BEC72784561E324B53E4F3493F6CD5F421A28ED457AE798145145007FFD9);
COMMIT;
-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record` (
`record_id` varchar(45) NOT NULL,
`customer_id` varchar(45) NOT NULL,
`customer_name` varchar(45) NOT NULL,
`doctor_id` varchar(45) NOT NULL,
`record_date` date NOT NULL,
`record_context` varchar(45) NOT NULL,
PRIMARY KEY (`record_id`),
KEY `record_doctorfk_idx` (`doctor_id`),
CONSTRAINT `record_doctorfk` FOREIGN KEY (`doctor_id`) REFERENCES `historical_staff` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room` (
`room_id` varchar(45) NOT NULL,
`room_rank` varchar(45) NOT NULL,
`room_totalbed` int(11) NOT NULL,
`room_usedbed` int(11) NOT NULL,
PRIMARY KEY (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of room
-- ----------------------------
BEGIN;
INSERT INTO `room` VALUES ('R1', '1', 4, 0);
INSERT INTO `room` VALUES ('R2', '1', 4, 0);
INSERT INTO `room` VALUES ('R3', '1', 4, 0);
INSERT INTO `room` VALUES ('R4', '2', 2, 0);
INSERT INTO `room` VALUES ('R5', '2', 2, 0);
INSERT INTO `room` VALUES ('R6', '2', 2, 0);
INSERT INTO `room` VALUES ('R7', '3', 1, 1);
INSERT INTO `room` VALUES ('R8', '3', 1, 1);
INSERT INTO `room` VALUES ('R9', '3', 1, 0);
COMMIT;
-- ----------------------------
-- Table structure for worker
-- ----------------------------
DROP TABLE IF EXISTS `worker`;
CREATE TABLE `worker` (
`worker_id` varchar(45) NOT NULL,
`worker_name` varchar(45) NOT NULL,
`worker_date` date NOT NULL,
`worker_salary` double NOT NULL DEFAULT '3000',
`worker_rank` varchar(45) NOT NULL,
`worker_customerrank` int(11) NOT NULL,
`worker_customernumber` int(11) NOT NULL,
`worker_vispos` double NOT NULL DEFAULT '0',
PRIMARY KEY (`worker_id`),
UNIQUE KEY `worker_id_UNIQUE` (`worker_id`),
CONSTRAINT `workerid_stafffk` FOREIGN KEY (`worker_id`) REFERENCES `historical_staff` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Triggers structure for table customer
-- ----------------------------
DROP TRIGGER IF EXISTS `customer_BEFORE_DELETE`;
delimiter ;;
CREATE TRIGGER `customer_BEFORE_DELETE` BEFORE DELETE ON `customer` FOR EACH ROW BEGIN
INSERT INTO NursingHome.historical_customer VALUES(OLD);
INSERT INTO NursingHome.historical_record(hisrecord_id,hiscustomer_id,hiscustomer_name,hisdoctor_id,hisrecord_date,hisrecord_context) SELECT record_id,customer_id,customer_name,doctor_id,record_date,record_context FROM NursingHome.record WHERE customer_id = OLD.customer_id;
DELETE FROM NursingHome.record WHERE customer_id = OLD.customer_id;
END
;;
delimiter ;
SET FOREIGN_KEY_CHECKS = 1;