-
Notifications
You must be signed in to change notification settings - Fork 0
/
dados_clinica_vet.sql
404 lines (377 loc) · 22.7 KB
/
dados_clinica_vet.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
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
-- Original data created by Ana Carolina Fortunato
-- Current schema by Ana Carolina Fortunato
-- Last modification: 2023-04-19 19:01:50
-- Esses dados são fabricados e não correspondem a pessoas reais.
-- Qualquer semelhança com pessoas existentes é mera coincidência.
-- Schema a ser utilizado
USE db_clinica_vet;
-- Inserção de dados nas tabelas
-- Tabela CLIENTE
INSERT INTO cliente (nome_cliente, cpf_cliente, endereco_cliente, telefone_cliente, email_cliente) VALUES
("Patricia Johnson", 19574179113, "Workhaven Lane 23", 11951009653, "patricia.johnson@gmail.com"),
("Linda Williams", 12938923155, "Lillydale Drive 1411", 11924455222, "linda.williams@gmail.com"),
("Barbara Jones", 44947611200, "Hanoi Way 1913", 11982181037, "barbara.jones@gmail.com"),
("Matthew Mahan", 38047827859, "Joliet Street 1121", 11906367268, "matthew.mahan@hotmail.com"),
("Timothy Bunn", 23055982286, "Santiago de Compostela Parkway 1795", 11915525745, "timothy.bunn@hotmail.com"),
("Jose Andrew", 38664921453, "Joliet Way 900", 11938788466, "jose.andrew@hotmail.com"),
("Alfredo Mcadams", 25241563344, "Santo Andr Manor 966", 11969920710, "alfredo.mcadams@gmail.com"),
("Alberto Henning", 41520005252, "Iligan Lane 770", 11933427977, "alberto.henning@gmail.com"),
("Eric Robert", 10221543034, "Aden Boulevard 1485", 11973956528, "eric.robert@hotmail.com"),
("Stephen Qualls", 14093969494, "Toulouse Parkway 419", 11954389850, "stephen.qualls@hotmail.com"),
("Sharon Robinson", 32445759630, "Toulon Boulevard 360", 11934145599, "sharon.robinson@gmail.com"),
("Carol Garcia", 14272676130, "Brest Avenue 270", 11954086212, "carol.garcia@gmail.com"),
("Sarah Lewis", 17392567923, "Charlotte Amalie Street 262", 11979440378, "sarah.lewis@gmail.com"),
("Nicholas Barfield", 37782872029, "Tafuna Way 1780", 11922322574, "nicholas.barfield@hotmail.com"),
("Victor Barkley", 41515094818, "San Felipe de Puerto Plata Street 96", 11922107005, "victor.barkley@hotmail.com"),
("Martin Bales", 29302615975, "Duisburg Boulevard 934", 11942398703, "martin.bales@hotmail.com"),
("Rebecca Scott", 10720084945, "Botshabelo Place 18", 11900444927, "rebecca.scott@gmail.com"),
("Pamela Baker", 37270276483, "Aurora Avenue 1425", 11954925684, "pamela.baker@gmail.com"),
("Martha Gonzalez", 37333968739, "Gorontalo Way 33", 11921711775, "martha.gonzalez@gmail.com"),
("Amanda Carter", 36591751305, "Mandaluyong Place 176", 11927807358, "amanda.carter@gmail.com"),
("Stephanie Mitchell", 20155137770, "Tama Street 61", 11955666667, "stephanie.mitchell@gmail.com"),
("Christine Roberts", 29433031912, "Callao Drive 391", 11905112779, "christine.roberts@gmail.com"),
("Marie Turner", 80254436340, "Munger (Monghyr) Lane 334", 11933060463, "marie.turner@gmail.com"),
("Alice Stewart", 20168413181, "Cam Ranh Parkway 269", 11943413283, "alice.stewart@gmail.com"),
("Sylvia Ortiz", 25126450336, "Antofagasta Place 306", 11915875315, "sylvia.ortiz@hotmail.com"),
("Josephine Gomez", 22189263680, "Graz Street 671", 11978095243, "josephine.gomez@hotmail.com"),
("Thelma Murray", 26993243870, "Brindisi Place 42", 11952674483, "thelma.murray@hotmail.com"),
("Elizabeth Brown", 23898881467, "Pjatigorsk Lane 1718", 11984941020, "elizabeth.brown@gmail.com"),
("Jennifer Davis", 24644470878, "Garland Manor 46", 11985767453, "jennifer.davis@gmail.com"),
("Maria Miller", 14532261380, "Garland Manor 686", 11908069636, "maria.miller@gmail.com"),
("Helen Harris", 15344365491, "Isesaki Place 909", 11904844121, "helen.harris@gmail.com"),
("Ivan Cromwell", 42831685593, "Hidalgo Parkway 725", 11928881259, "ivan.cromwell@gmail.com"),
("Sergio Stanfield", 32060830006, "Probolinggo Loop 1135", 11947623233, "sergio.stanfield@gmail.com"),
("Deborah Walker", 59065997880, "Kabul Boulevard 939", 11982646202, "deborah.walker@gmail.com"),
("Jessica Hall", 24129577622, "Hodeida Way 1213", 11912350516, "jessica.hall@gmail.com"),
("Ana Bradley", 38423116639, "Ponce Place 81", 11936303937, "ana.bradley@hotmail.com"),
("Tamara Nguyen", 12528657131, "Otsu Street 1966", 11962037330, "tamara.nguyen@hotmail.com"),
("Marlene Welch", 40703376775, "Cam Ranh Street 1124", 11924851291, "marlene.welch@hotmail.com"),
("Lydia Burke", 29282321860, "Poos de Caldas Boulevard 89", 11946743452, "lydia.burke@hotmail.com"),
("Joseph Joy", 41147678399, "Dos Quebradas Place 1947", 11932133320, "joseph.joy@hotmail.com"),
("Thomas Grigsby", 45482517879, "Salzburg Lane 1692", 11917950072, "thomas.grigsby@hotmail.com"),
("Christopher Greco", 32459919481, "Citt del Vaticano Boulevard 929", 11998871482, "christopher.greco@hotmail.com"),
("Daniel Cabral", 31028229013, "Firozabad Loop 1599", 11948463610, "daniel.cabral@hotmail.com"),
("Sheila Wells", 35212597721, "Vila Velha Manor 669", 11929960583, "sheila.wells@hotmail.com"),
("Antonio Meek", 42859715900, "Mandaluyong Place 1913", 11940765114, "antonio.meek@hotmail.com"),
("Tony Carranza", 21702825716, "Junan Way 1002", 11982895614, "tony.carranza@hotmail.com"),
("Luis Yanez", 20315758977, "Elista Drive 682", 11910617469, "luis.yanez@hotmail.com"),
("Leonard Schofield", 36465078998, "Belm Manor 758", 11954988466, "leonard.schofield@hotmail.com"),
("Nathan Runyon", 40913791630, "Saint Louis Way 1752", 11968174487, "nathan.runyon@hotmail.com"),
("Vincent Ralston", 22056456190, "Southampton Drive 898", 11973809543, "vincent.ralston@hotmail.com"),
("Alexander Fennell", 11241296720, "Johannesburg Avenue 261", 11990435935, "alexander.fennell@hotmail.com"),
("Bernard Colby", 37435434936, "Sunnyvale Avenue 126", 11900161591, "bernard.colby@hotmail.com"),
("Mario Cheatham", 12638164472, "So Bernardo do Campo Lane 913", 11973459539, "mario.cheatham@hotmail.com");
-- Tabela PACIENTE
INSERT INTO paciente (nome_paciente, id_cliente, especie, raca, sexo, pelagem, data_nascimento, castrado, peso) VALUES
("Belinha", 1, "C", "poodle", "F", "branco", "2010-08-23", 1, 8.3),
("Thor", 2, "C", "pitbull", "M", "cinza", "2020-09-22", 0, 18.6),
("Leona", 3, "C", "SRD", "F", "caramelo", "2021-05-05", 1, 20.1),
("Bob", 4, "C", "shih tzu", "M", "bege", "2008-10-10", 1, 4.3),
("Oscar", 5, "F", "SRD", "M", "tigrado com branco", "2021-05-08", 1, 5.5),
("Tadeu", 5, "F", "SRD", "M", "tigrado com branco ", "2021-05-09", 1, 5.4),
("Margo", 6, "F", "SRD", "F", "preto e branco", "2014-03-01", 1, 5.6),
("Lulu", 7, "C", "lhasa apso", "F", "marrom ", "2020-03-20", 0, 4.8),
("Batata", 8, "F", "SRD", "M", "preto e branco", "2014-04-02", 1, 6.3),
("Amora", 9, "F", "SRD", "F", "preto", "2018-06-10", 1, 5.2),
("Mel", 10, "C", "yorkshire", "F", "caramelo", "2018-09-22", 1, 3.0),
("Amora", 11, "C", "SRD", "F", "preto", "2019-08-23", 1, 10.0),
("Pérola", 12, "F", "persa", "F", "branco", "2021-10-01", 0, 4.2),
("Jade", 13, "F", "persa", "F", "branco", "2021-10-01", 0, 4.3),
("Princesa", 13, "F", "SRD", "F", "bege e branco", "2018-08-15", 1, 4.0),
("Arya", 14, "F", "siamês ", "F", "bege e marrom ", "2021-01-01", 1, 3.9),
("Fred", 15, "F", "SRD", "M", "laranja", "2020-03-20", 0, 6.0),
("Thor", 16, "C", "labrador", "M", "caramelo", "2020-03-20", 1, 23.1),
("Coralina", 17, "C", "border collie", "F", "marrom e branco", "2013-02-18", 1, 15.5),
("Gatoso", 18, "F", "sphynx", "M", "não tem ", "2017-01-01", 0, 4.0),
("Coca-cola", 19, "F", "SRD", "F", "preto", "2022-08-15", 0, 1.1),
("Guaraná", 19, "F", "SRD", "M", "laranja", "2022-08-15", 0, 1.1),
("Fanta", 19, "F", "SRD", "M", "tricolor", "2022-08-15", 0, 1.3),
("Princesa", 20, "C", "SRD", "F", "caramelo", "2017-10-04", 1, 12.5),
("Belinha", 21, "C", "poodle", "F", "branca", "2013-12-01", 1, 6.8),
("Amora", 21, "C", "golden ", "F", "caramelo", "2015-04-12", 0, 20.7),
("Vicky", 22, "C", "SRD", "F", "preto e branco", "2012-03-10", 1, 37.8),
("Binho", 23, "F", "SRD", "M", "laranja", "2020-03-20", 1, 6.3),
("Lady ", 24, "F", "maine coon ", "F", "tigrado", "2020-01-01", 0, 6.3),
("Bill", 25, "C", "american bully", "M", "branco", "2018-05-29", 0, 30.0),
("Tequila", 26, "F", "SRD", "M", "branco", "2017-09-27", 1, 5.1),
("Vitoria", 27, "F", "SRD", "F", "tricolor", "2017-10-04", 1, 4.7),
("Mel", 28, "C", "lhasa apso", "F", "marrom e preto", "2019-11-20", 1, 4.2),
("Zeus", 29, "F", "SRD", "M", "bege e branco0", "2018-12-10", 0, 5.3),
("Billy", 30, "F", "SRD", "M", "preto", "2019-03-23", 1, 6.0),
("Gege", 30, "F", "SRD", "M", "preto", "2017-05-20", 1, 5.1),
("Zara", 31, "C", "pitbull", "F", "preto e branco", "2016-12-20", 1, 38.5),
("Thor", 32, "C", "american bully", "M", "marrom e branco", "2018-03-01", 0, 33.5),
("July", 33, "F", "SRD", "F", "preto", "2021-05-08", 1, 4.9),
("Bruce", 34, "C", "labrador", "F", "marrom", "2019-05-19", 1, 27.8),
("Lance", 35, "C", "pointer alemão", "M", "marrom e branco", "2019-01-01", 1, 42.0),
("Judith", 35, "F", "SRD", "F", "preto e branco", "2019-11-24", 1, 4.4),
("Lua", 36, "F", "sphynx", "F", "não tem ", "2018-06-10", 1, 5.0),
("Amora", 37, "F", "SRD", "F", "tigrado", "2017-06-10", 1, 5.0),
("Percy", 38, "F", "SRD", "M", "laranja", "2018-05-14", 1, 6.3),
("Chilo", 39, "C", "spitz", "M", "caramelo", "2022-02-10", 0, 4.4),
("Mãezinha", 39, "C", "spitz", "F", "preto", "2021-08-20", 1, 5.0),
("Florzinha", 39, "C", "spitz", "F", "preto", "2022-02-10", 0, 4.7),
("Amora", 40, "C", "golder", "F", "caramelo", "2019-11-24", 1, 27.4),
("Tequila", 41, "F", "SRD", "F", "tricolor", "2018-03-01", 1, 4.9),
("Whisky ", 41, "F", "SRD", "M", "laranja ", "2018-03-01", 1, 5.7),
("Lulu", 42, "C", "shih tzu", "F", "cinza e branco", "2017-04-12", 1, 5.0),
("Toto", 43, "C", "SRD", "M", "cinza e preto", "2014-08-30", 1, 17.0),
("Charlie", 44, "F", "SRD", "M", "cinza e branco", "2022-07-10", 0, 3.0),
("Leona", 45, "C", "SRD", "F", "marrom", "2019-05-24", 1, 15.4),
("Bill", 45, "C", "pitbull", "M", "marrom ", "2018-12-25", 1, 19.1),
("Zeus", 46, "F", "SRD", "M", "branco", "2019-10-10", 1, 5.3),
("Tadeu", 47, "F", "SRD", "M", "laranja", "2022-09-09", 0, 2.5),
("Gaia", 48, "F", "maine coon ", "F", "tigrado", "2022-06-29", 1, 4.9),
("Florzinha", 49, "C", "shih tzu", "F", "cinza", "2020-09-09", 1, 5.0),
("Lua", 50, "F", "SRD", "F", "tigrado", "2020-05-20", 1, 5.5),
("Princesa", 51, "C", "yorkshire", "F", "caramelo e preto", "2019-11-24", 1, 3.8),
("Leona", 52, "C", "SRD", "M", "caramelo", "2022-01-19", 1, 8.3),
("Mimi", 53, "F", "SRD", "F", "branco ", "2018-07-30", 1, 5.7);
-- Tabela VETERINARIO
INSERT INTO veterinario (nome_mv, telefone_mv, email_mv, cpf_mv, crmv, especialidade) VALUES
("Thalita de Brito", 11999106258, "thalita.britovet@gmail.com", 32242663055 , "49933SP", "clínica de pequenos animais"),
("Vitória Gillioli", 11923800583, "vitoria.gillioli@hotmail.com", 46530529606, "57007SP", "clínica de pequenos animais"),
("Thiago Chagas", 21941530148, "thiago_orto@hotmail.com", 14174590809, "40524RJ", "ortopedia"),
("Tânia Fernandes", 11988480476, "tania.fernandes@hotmail.com", 15265058449, "1848SP", "dermatologia");
-- Tabela ESTAGIARIO
INSERT INTO estagiario (nome_estagiario, telefone_estagiario, email_estagiario, cpf_estagiario, instituicao_ensino, tipo_estagio) VALUES
("Lorena Grecco", 11990872660, "loogreco@gmail.com", 38342632627, "Universidade Anhembi Morumbi", "obrigatório"),
("Gabriela Ayumi", 11975007954, "ayumi@hotmail.com", 44931804490, "Faculdade Anhaguera", "obrigatório"),
("Bianca Rossi", 11914007459, "biarossi99@gmail.com", 42661466650, "Faculdades Metropolitanas Unidas", "extracurricular"),
("Gabriel Moraes", 11979644830, "gab_moraes@gmail.com", 40759769238, "Universidade Metodista de São Paulo", "obrigatório");
-- Tabela CONSULTA
INSERT INTO consulta (data_consulta, hora_consulta, id_mv, id_estagiario, tipo_consulta, id_cliente, id_paciente) VALUES
("2022-10-10", "08:30", 4, 2, "dermatologia", 1, 1),
("2022-10-10", "08:30", 1, 4, "clínica", 2, 2),
("2022-10-10", "09:00", 1, 4, "vacinação", 3, 3),
("2022-10-10", "10:00", 4, 2, "retorno dermatologia", 4, 4),
("2022-10-10", "10:30", 1, 4, "vacinação", 5, 5),
("2022-10-10", "10:50", 1, 4, "vacinação", 5, 6),
("2022-10-10", "11:30", 1, 4, "clínica", 6, 7),
("2022-10-10", "12:00", 1, 4, "retorno clínica", 7, 8),
("2022-10-10", "13:00", 1, 4, "retorno clínica", 8, 9),
("2022-10-10", "14:30", 2, 1, "clínica", 9, 10),
("2022-10-10", "15:00", 2, 1, "vacinação", 10, 11),
("2022-10-10", "15:30", 2, 1, "vacinação", 11, 12),
("2022-10-10", "16:00", 2, 1, "vacinação", 12, 13),
("2022-10-10", "16:30", 2, 1, "clínica", 13, 14),
("2022-10-10", "17:00", 2, 1, "clínica", 13, 15),
("2022-10-10", "18:00", 2, 1, "vacinação", 14, 16),
("2022-10-11", "08:30", 1, 4, "clínica", 15, 17),
("2022-10-11", "09:30", 1, 4, "vacinação", 16, 18),
("2022-10-11", "10:00", 1, 4, "retorno clínica", 17, 19),
("2022-10-11", "10:30", 1, 4, "retorno clínica", 18, 20),
("2022-10-11", "11:30", 1, 4, "vacinação", 19, 21),
("2022-10-11", "11:50", 1, 4, "vacinação", 19, 22),
("2022-10-11", "12:20", 1, 4, "vacinação", 19, 23),
("2022-10-11", "14:00", 1, 4, "clínica", 20, 24),
("2022-10-11", "15:10", 2, 1, "clínica", 21, 25),
("2022-10-11", "16:00", 2, 1, "clínica", 21, 26),
("2022-10-11", "17:00", 2, 1, "vacinação", 22, 27),
("2022-10-11", "17:30", 2, 1, "vacinação", 23, 28),
("2022-10-11", "17:30", 2, 1, "retorno clínica", 24, 29),
("2022-10-11", "18:30", 2, 1, "vacinação", 25, 30),
("2022-10-12", "09:00", 1, 4, "clínica", 26, 31),
("2022-10-12", "10:00", 1, 4, "retorno clínica", 27, 32),
("2022-10-12", "10:30", 1, 4, "retorno clínica", 28, 33),
("2022-10-12", "12:00", 1, 4, "vacinação", 29, 34),
("2022-10-12", "13:00", 1, 4, "clínica", 30, 35),
("2022-10-12", "13:30", 1, 4, "vacinação", 30, 36),
("2022-10-12", "14:00", 3, 3, "retorno ortopedia", 31, 37),
("2022-10-12", "15:00", 2, 1, "vacinação", 32, 38),
("2022-10-12", "15:00", 3, 3, "ortopedia", 17, 19),
("2022-10-12", "15:30", 2, 1, "retorno clínica", 6, 7),
("2022-10-12", "16:00", 3, 3, "ortopedia", 33, 39),
("2022-10-12", "16:30", 2, 1, "vacinação", 34, 40),
("2022-10-12", "17:30", 2, 1, "vacinação", 35, 41),
("2022-10-12", "18:00", 2, 1, "clínica", 35, 42),
("2022-10-13", "08:00", 1, 4, "clínica", 36, 43),
("2022-10-13", "09:00", 1, 4, "retorno clínica", 37, 44),
("2022-10-13", "10:00", 1, 4, "retorno clínica", 38, 45),
("2022-10-13", "11:30", 1, 4, "vacinação", 39, 46),
("2022-10-13", "11:50", 1, 4, "vacinação", 39, 47),
("2022-10-13", "12:10", 1, 4, "vacinação", 39, 48),
("2022-10-13", "13:30", 1, 4, "vacinação", 40, 49),
("2022-10-13", "14:30", 2, 1, "vacinação", 41, 50),
("2022-10-13", "15:00", 2, 1, "clínica", 41, 51),
("2022-10-13", "16:00", 2, 1, "clínica", 42, 52),
("2022-10-13", "16:30", 4, 2, "dermatologia", 27, 32),
("2022-10-13", "17:00", 2, 1, "retorno clínica", 21, 25),
("2022-10-13", "18:00", 4, 2, "dermatologia", 43, 53),
("2022-10-13", "18:30", 2, 1, "vacinação", 44, 54),
("2022-10-14", "08:30", 1, 4, "vacinação", 45, 55),
("2022-10-14", "08:50", 1, 4, "vacinação", 45, 56),
("2022-10-14", "10:00", 1, 4, "clínica", 46, 57),
("2022-10-14", "10:30", 1, 4, "retorno clínica", 15, 17),
("2022-10-14", "11:30", 1, 4, "vacinação", 47, 58),
("2022-10-14", "12:00", 1, 4, "vacinação", 48, 59),
("2022-10-14", "13:00", 2, 1, "vacinação", 49, 60),
("2022-10-14", "14:30", 2, 1, "vacinação", 50, 61),
("2022-10-14", "15:00", 2, 1, "clínica", 51, 62),
("2022-10-14", "16:30", 2, 1, "retorno clínica", 13, 14),
("2022-10-14", "17:30", 2, 1, "retorno clínica", 13, 15),
("2022-10-14", "18:00", 2, 1, "clínica", 52, 63),
("2022-10-14", "18:30", 2, 1, "vacinação", 53, 64);
-- Tabela PAGAMENTO
INSERT INTO pagamento (data_consulta, id_cliente, valor_pagamento, forma_pagamento) VALUES
("2022-10-10", 1, 250, "CD"),
("2022-10-10", 2, 80, "CD"),
("2022-10-10", 3, 120, "CD"),
("2022-10-10", 5, 250, "CC"),
("2022-10-10", 6, 80, "P"),
("2022-10-10", 9, 80, "CC"),
("2022-10-10", 10, 130, "CC"),
("2022-10-10", 11, 105, "CC"),
("2022-10-10", 12, 60, "D"),
("2022-10-10", 13, 160, "P"),
("2022-10-10", 14, 110, "CD"),
("2022-10-11", 15, 80, "P"),
("2022-10-11", 16, 70, "D"),
("2022-10-11", 19, 275, "CC"),
("2022-10-11", 20, 80, "CD"),
("2022-10-11", 21, 210, "CD"),
("2022-10-11", 22, 105, "CC"),
("2022-10-11", 23, 110, "D"),
("2022-10-11", 25, 120, "P"),
("2022-10-12", 26, 105, "CC"),
("2022-10-12", 29, 110, "CC"),
("2022-10-12", 30, 205, "CD"),
("2022-10-12", 32, 115, "CC"),
("2022-10-12", 17, 220, "P"),
("2022-10-12", 33, 220, "CC"),
("2022-10-12", 34, 120, "CD"),
("2022-10-12", 35, 200, "CC"),
("2022-10-13", 36, 80, "CC"),
("2022-10-13", 39, 210, "CC"),
("2022-10-13", 40, 115, "CD"),
("2022-10-13", 41, 190, "P"),
("2022-10-13", 42, 105, "CC"),
("2022-10-13", 27, 200, "CC"),
("2022-10-13", 43, 225, "CC"),
("2022-10-13", 44, 110, "CD"),
("2022-10-14", 45, 210, "P"),
("2022-10-14", 46, 130, "CD"),
("2022-10-14", 47, 75, "P"),
("2022-10-14", 48, 110, "CD"),
("2022-10-14", 49, 115, "CD"),
("2022-10-14", 50, 125, "CC"),
("2022-10-14", 51, 80, "CD"),
("2022-10-14", 52, 80, "CD"),
("2022-10-14", 53, 110, "CC");
-- Tabela TRATAMENTO
INSERT INTO tratamento (id_consulta, id_mv, tipo_tratamento, data_consulta) VALUES
(1, 4, "medicamentoso", "2022-10-10"),
(2, 1, "medicamentoso", "2022-10-10"),
(7, 1, "medicamentoso", "2022-10-10"),
(8, 1, "medicamentoso", "2022-10-10"),
(20, 1, "medicamentoso", "2022-10-11"),
(25, 2, "medicamentoso", "2022-10-11"),
(31, 1, "medicamentoso", "2022-10-12"),
(32, 1, "medicamentoso", "2022-10-12"),
(35, 1, "medicamentoso", "2022-10-12"),
(39, 3, "medicamentoso", "2022-10-12"),
(41, 3, "cirúrgico", "2022-10-12"),
(44, 2, "medicamentoso", "2022-10-12"),
(45, 1, "medicamentoso", "2022-10-13"),
(54, 2, "medicamentoso", "2022-10-13"),
(57, 4, "medicamentoso", "2022-10-13"),
(61, 1, "medicamentoso", "2022-10-14"),
(62, 1, "medicamentoso", "2022-10-14"),
(67, 2, "medicamentoso", "2022-10-14"),
(69, 2, "medicamentoso", "2022-10-14"),
(70, 2, "medicamentoso", "2022-10-14");
-- Tabela MEDICAMENTO
INSERT INTO medicamento (nome_medicamento, dosagem, administracao, frequencia, tempo_uso, categoria, id_tratamento) VALUES ("Meticorten 5mg", "1 cp", "VO", "SID", 5, "antialérgico", 1),
("Gaviz 10mg", "1 cp", "VO", "BID", 10, "protetor gástrico", 2),
("Cronidor 12mg", "1 cp", "VO", "BID", 5, "analgésico", 3),
("Prediderm 5mg", "1 cp", "VO", "SID", 5, "antiinflamatório ", 3),
("Dipirona ", "5 gotas", "VO", "TID", 5, "analgésico", 4),
("Agemoxi 50mg", "1/4 cp", "VO", "BID", 7, "antibiótico ", 4),
("Still", "1 gota cada olho", "ocular", "BID", 10, "colírio", 5),
("Cronidor 12mg", "1 cp", "VO", "BID", 7, "analgésico", 6),
("Agemoxi 50mg", "1/2 cp", "VO", "BID", 7, "antibiótico ", 6),
("Dipirona ", "7 gotas", "VO", "TID", 3, "analgésico", 7),
("Itraconazol 100 mg", "1 cap", "VO", "SID", 30, "antifúngico ", 8),
("Lactobac Cat ", "2 mg", "VO", "SID", 15, "probiótico ", 9),
("Condroplex 500mg", "1 cp", "VO", "SID", 60, "suplemento ", 10),
("Ograx 500mg", "1 cp", "VO", "SID", 30, "suplemento ", 12),
("Vetaglós 50g", "1 medida da espátula", "tópico", "BID", 10, "pomada cicatrizante ", 13),
("Dipirona ", "5 gotas", "VO", "TID", 3, "analgésico", 14),
("Prediderm 5mg", "1 + 1/2 cp", "VO", "BID", 5, "antiinflamatório ", 15),
("Agemoxi 50mg", "1/4 cp", "VO", "BID", 7, "antibiótico ", 16),
("Silimarina 200mg", "1 ml", "VO", "SID", 60, "protetor hepático ", 17),
("Hemolitan Pet 30 ml", "1 ml", "VO", "BID", 10, "suplemento ", 18),
("Otoguard 20 ml", "2 gotas", "auricular", "BID", 5, "otológico", 19),
("Drontal Puppy", "2 ml ", "VO", "SID", 3, "vermífugo", 20);
-- Tabela VACINA
INSERT INTO vacina (id_consulta, data_consulta, tipo_vacina, lote_vacina, data_revacina) VALUES
(3, "2022-10-10", "V10", "320/22", "2023-10-10"),
(3, "2022-10-10", "raiva", "508/22", "2023-10-10"),
(5, "2022-10-10", "V5", "123/22", "2023-10-10"),
(5, "2022-10-10", "raiva", "508/22", "2023-10-10"),
(6, "2022-10-10", "V5", "123/22", "2023-10-10"),
(6, "2022-10-10", "raiva", "508/22", "2023-10-10"),
(11, "2022-10-10", "giárdia", "456/22", "2022-11-10"),
(11, "2022-10-10", "gripe", "378/22", "2022-11-10"),
(12, "2022-10-10", "V8", "245/22", "2023-10-10"),
(12, "2022-10-10", "raiva", "508/22", "2023-10-10"),
(13, "2022-10-10", "V4", "350/22", "2022-11-10"),
(16, "2022-10-10", "V4", "350/22", "2023-10-10"),
(16, "2022-10-10", "raiva", "508/22", "2023-10-10"),
(18, "2022-10-11", "V10", "320/22", "2022-11-11"),
(21, "2022-10-11", "V5", "123/22", "2022-11-11"),
(22, "2022-10-11", "V5", "123/22", "2022-11-11"),
(23, "2022-10-11", "V5", "123/22", "2023-10-11"),
(23, "2022-10-11", "raiva", "508/22", "2023-10-11"),
(27, "2022-10-11", "V8", "245/22", "2023-10-11"),
(27, "2022-10-11", "raiva", "508/22", "2023-10-11"),
(28, "2022-10-11", "V4", "350/22", "2023-10-11"),
(28, "2022-10-11", "raiva", "508/22", "2023-10-11"),
(30, "2022-10-11", "V10", "320/22", "2023-10-11"),
(30, "2022-10-11", "raiva", "508/22", "2023-10-11"),
(34, "2022-10-12", "V4", "350/22", "2023-10-12"),
(34, "2022-10-12", "raiva", "508/22", "2023-10-12"),
(36, "2022-10-12", "V5", "123/22", "2023-10-12"),
(36, "2022-10-12", "raiva", "510/22", "2023-10-12"),
(38, "2022-10-12", "giárdia", "456/22", "2023-10-12"),
(38, "2022-10-12", "raiva", "510/22", "2023-10-12"),
(42, "2022-10-12", "V10", "320/22", "2023-10-12"),
(42, "2022-10-12", "raiva", "510/22", "2023-10-12"),
(43, "2022-10-12", "V10", "320/22", "2023-10-12"),
(43, "2022-10-12", "raiva", "510/22", "2022-11-13"),
(48, "2022-10-13", "V10", "320/22", "2022-11-13"),
(49, "2022-10-13", "V10", "320/22", "2022-11-13"),
(50, "2022-10-13", "V10", "320/22", "2022-11-13"),
(51, "2022-10-13", "raiva", "510/22", "2022-11-13"),
(51, "2022-10-13", "gripe", "378/22", "2022-11-13"),
(52, "2022-10-13", "V4", "350/22", "2023-10-13"),
(52, "2022-10-13", "raiva", "510/22", "2023-10-13"),
(58, "2022-10-13", "V4", "350/22", "2023-10-13"),
(58, "2022-10-13", "raiva", "510/22", "2023-10-13"),
(59, "2022-10-14", "V8", "245/22", "2023-10-14"),
(59, "2022-10-14", "raiva", "510/22", "2023-10-14"),
(60, "2022-10-14", "V8", "245/22", "2023-10-14"),
(60, "2022-10-14", "raiva", "510/22", "2023-10-14"),
(63, "2022-10-14", "V5", "123/22", "2022-11-14"),
(64, "2022-10-14", "V4", "350/22", "2023-10-14"),
(64, "2022-10-14", "raiva", "510/22", "2023-10-14"),
(65, "2022-10-14", "giárdia", "456/22", "2023-10-14"),
(65, "2022-10-14", "raiva", "518/22", "2023-10-14"),
(66, "2022-10-14", "V5", "123/22", "2023-10-14"),
(66, "2022-10-14", "raiva", "518/22", "2023-10-14"),
(71, "2022-10-14", "V4", "350/22", "2023-10-14"),
(71, "2022-10-14", "raiva", "518/22", "2023-10-14");
-- Tabela VALORES
INSERT INTO valores (servico, valor) VALUES
("consulta", 70),
("dermatologia", 200),
("ortopedia", 220),
("V4", 60),
("V5", 75),
("V8", 55),
("V10", 70),
("raiva", 50),
("giárdia", 65),
("gripe", 65),
("aplicação", 25);
-- End of file.