· 4 years ago · Apr 24, 2021, 05:10 PM
1
2SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
3SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
4SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
5
6-- -----------------------------------------------------
7-- Schema mydb
8-- -----------------------------------------------------
9-- -----------------------------------------------------
10-- Schema aplicativo
11-- -----------------------------------------------------
12
13-- -----------------------------------------------------
14-- Schema aplicativo
15-- -----------------------------------------------------
16CREATE SCHEMA IF NOT EXISTS `aplicativo` DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci ;
17USE `aplicativo` ;
18
19-- -----------------------------------------------------
20-- Table `aplicativo`.`periods`
21-- -----------------------------------------------------
22CREATE TABLE IF NOT EXISTS `aplicativo`.`periods` (
23 `idPeriod` INT NOT NULL,
24 `name` VARCHAR(90) NULL DEFAULT NULL,
25 PRIMARY KEY (`idPeriod`))
26ENGINE = InnoDB
27DEFAULT CHARACTER SET = latin1
28COLLATE = latin1_danish_ci;
29
30
31-- -----------------------------------------------------
32-- Table `aplicativo`.`slots`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `aplicativo`.`slots` (
35 `idSlot` INT NOT NULL,
36 `name` VARCHAR(90) NULL DEFAULT NULL,
37 `Period_id` INT NOT NULL,
38 PRIMARY KEY (`idSlot`),
39 INDEX `Period_id_idx` (`Period_id` ASC) VISIBLE,
40 CONSTRAINT `Period_id`
41 FOREIGN KEY (`Period_id`)
42 REFERENCES `aplicativo`.`periods` (`idPeriod`))
43ENGINE = InnoDB
44DEFAULT CHARACTER SET = latin1
45COLLATE = latin1_danish_ci;
46
47
48-- -----------------------------------------------------
49-- Table `aplicativo`.`semesters`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `aplicativo`.`semesters` (
52 `idSemester` INT NOT NULL,
53 `semester` VARCHAR(90) NULL DEFAULT NULL,
54 `Slot_id` INT NOT NULL,
55 PRIMARY KEY (`idSemester`),
56 INDEX `Slot_id_idx` (`Slot_id` ASC) VISIBLE,
57 CONSTRAINT `Slot_id`
58 FOREIGN KEY (`Slot_id`)
59 REFERENCES `aplicativo`.`slots` (`idSlot`))
60ENGINE = InnoDB
61DEFAULT CHARACTER SET = latin1
62COLLATE = latin1_danish_ci;
63
64
65-- -----------------------------------------------------
66-- Table `aplicativo`.`students`
67-- -----------------------------------------------------
68CREATE TABLE IF NOT EXISTS `aplicativo`.`students` (
69 `idStudent` INT NOT NULL,
70 `identification` VARCHAR(16) NULL DEFAULT NULL,
71 `name` VARCHAR(45) NULL DEFAULT NULL,
72 `lastName` VARCHAR(45) NULL DEFAULT NULL,
73 `phone` VARCHAR(14) NULL DEFAULT NULL,
74 `mail` VARCHAR(256) NULL DEFAULT NULL,
75 `Semester_id` INT NOT NULL,
76 PRIMARY KEY (`idStudent`),
77 INDEX `Semester_id_idx` (`Semester_id` ASC) VISIBLE,
78 CONSTRAINT `Semester_id`
79 FOREIGN KEY (`Semester_id`)
80 REFERENCES `aplicativo`.`semesters` (`idSemester`))
81ENGINE = InnoDB
82DEFAULT CHARACTER SET = latin1
83COLLATE = latin1_danish_ci;
84
85
86-- -----------------------------------------------------
87-- Table `aplicativo`.`activities`
88-- -----------------------------------------------------
89CREATE TABLE IF NOT EXISTS `aplicativo`.`activities` (
90 `idActivitie` INT NOT NULL,
91 `activityName` VARCHAR(90) NULL DEFAULT NULL,
92 `dateF` DATE NULL DEFAULT NULL,
93 `timeH` TIME NULL DEFAULT NULL,
94 `valueV` DECIMAL(4,2) NULL DEFAULT NULL,
95 `score` DECIMAL(4,2) NULL DEFAULT NULL,
96 `Student_id` INT NOT NULL,
97 `Slot_id` INT NOT NULL,
98 PRIMARY KEY (`idActivitie`),
99 INDEX `Student_id_idx` (`Student_id` ASC) VISIBLE,
100 INDEX `Slot_id_idx` (`Slot_id` ASC) VISIBLE,
101 CONSTRAINT `SlotA_id`
102 FOREIGN KEY (`Slot_id`)
103 REFERENCES `aplicativo`.`slots` (`idSlot`),
104 CONSTRAINT `Student_id`
105 FOREIGN KEY (`Student_id`)
106 REFERENCES `aplicativo`.`students` (`idStudent`))
107ENGINE = InnoDB
108DEFAULT CHARACTER SET = latin1
109COLLATE = latin1_danish_ci;
110
111
112-- -----------------------------------------------------
113-- Table `aplicativo`.`sessions`
114-- -----------------------------------------------------
115CREATE TABLE IF NOT EXISTS `aplicativo`.`sessions` (
116 `idSession` INT NOT NULL,
117 `name` VARCHAR(90) NULL DEFAULT NULL,
118 `Slot_id` INT NOT NULL,
119 PRIMARY KEY (`idSession`),
120 INDEX `Slot_id_idx` (`Slot_id` ASC) VISIBLE,
121 CONSTRAINT `SlotB_id`
122 FOREIGN KEY (`Slot_id`)
123 REFERENCES `aplicativo`.`slots` (`idSlot`))
124ENGINE = InnoDB
125DEFAULT CHARACTER SET = latin1
126COLLATE = latin1_danish_ci;
127
128
129-- -----------------------------------------------------
130-- Table `aplicativo`.`assistances`
131-- -----------------------------------------------------
132CREATE TABLE IF NOT EXISTS `aplicativo`.`assistances` (
133 `idAssistance` INT NOT NULL,
134 `dateF` DATE NULL DEFAULT NULL,
135 `timeH` TIME NULL DEFAULT NULL,
136 `note` VARCHAR(45) NULL,
137 `Student_id` INT NOT NULL,
138 `Session_id` INT NOT NULL,
139 PRIMARY KEY (`idAssistance`),
140 INDEX `Student_id_idx` (`Student_id` ASC) VISIBLE,
141 INDEX `Session_id_idx` (`Session_id` ASC) VISIBLE,
142 CONSTRAINT `Session_id`
143 FOREIGN KEY (`Session_id`)
144 REFERENCES `aplicativo`.`sessions` (`idSession`),
145 CONSTRAINT `StudentA_id`
146 FOREIGN KEY (`Student_id`)
147 REFERENCES `aplicativo`.`students` (`idStudent`))
148ENGINE = InnoDB
149DEFAULT CHARACTER SET = latin1
150COLLATE = latin1_danish_ci;
151
152
153SET SQL_MODE=@OLD_SQL_MODE;
154SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
155SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
156
157-- INSERTANDO DATOS EN TABLA PERIODS
158insert into PERIODS (idPeriod, name) values (1, '1980-1');
159insert into PERIODS (idPeriod, name) values (2, '1980-2');
160insert into PERIODS (idPeriod, name) values (3, '1981-1');
161insert into PERIODS (idPeriod, name) values (4, '1981-2');
162insert into PERIODS (idPeriod, name) values (5, '1982-1');
163insert into PERIODS (idPeriod, name) values (6, '1982-2');
164insert into PERIODS (idPeriod, name) values (7, '1983-1');
165insert into PERIODS (idPeriod, name) values (8, '1983-2');
166insert into PERIODS (idPeriod, name) values (9, '1984-1');
167insert into PERIODS (idPeriod, name) values (10, '1984-2');
168insert into PERIODS (idPeriod, name) values (11, '1985-1');
169insert into PERIODS (idPeriod, name) values (12, '1985-2');
170insert into PERIODS (idPeriod, name) values (13, '1986-1');
171insert into PERIODS (idPeriod, name) values (14, '1987-2');
172insert into PERIODS (idPeriod, name) values (15, '1988-1');
173insert into PERIODS (idPeriod, name) values (16, '1988-2');
174insert into PERIODS (idPeriod, name) values (17, '2019-1');
175insert into PERIODS (idPeriod, name) values (18, '2019-2');
176insert into PERIODS (idPeriod, name) values (19, '2020-1');
177insert into PERIODS (idPeriod, name) values (20, '2020-2');
178
179-- SELECT * FROM PERIODS;
180
181-- INSERTANDO DATOS EN TABLA SLOTS
182
183insert into SLOTS (idSlot, name, Period_id) values (1, 'Kourou', 1);
184insert into SLOTS (idSlot, name, Period_id) values (2, 'Maicao', 2);
185insert into SLOTS (idSlot, name, Period_id) values (3, 'Manorom', 3);
186insert into SLOTS (idSlot, name, Period_id) values (4, 'Prueba', 4);
187insert into SLOTS (idSlot, name, Period_id) values (5, 'Yangsan', 5);
188insert into SLOTS (idSlot, name, Period_id) values (6, 'Nove-Misto', 6);
189insert into SLOTS (idSlot, name, Period_id) values (7, 'Passos', 7);
190insert into SLOTS (idSlot, name, Period_id) values (8, 'Shushicë', 8);
191insert into SLOTS (idSlot, name, Period_id) values (9, 'Santa Monica', 9);
192insert into SLOTS (idSlot, name, Period_id) values (10, 'Petropavlovsk', 10);
193insert into SLOTS (idSlot, name, Period_id) values (11, 'Geldrop', 11);
194insert into SLOTS (idSlot, name, Period_id) values (12, 'Billa', 12);
195insert into SLOTS (idSlot, name, Period_id) values (13, 'Beslan', 13);
196insert into SLOTS (idSlot, name, Period_id) values (14, 'Banggel', 14);
197insert into SLOTS (idSlot, name, Period_id) values (15, 'Paiisa', 15);
198insert into SLOTS (idSlot, name, Period_id) values (16, 'Bamusso', 16);
199insert into SLOTS (idSlot, name, Period_id) values (17, 'Rufino', 17);
200insert into SLOTS (idSlot, name, Period_id) values (18, 'Barretos', 18);
201insert into SLOTS (idSlot, name, Period_id) values (19, 'Menlou', 19);
202insert into SLOTS (idSlot, name, Period_id) values (20, 'Catende', 20);
203
204
205-- SELECT * FROM SLOTS;
206
207
208-- INSERTANDO DATOS EN TABLA SEMESTERS
209
210insert into SEMESTERS (idSemester, semester, Slot_id) values (1, 1, 1);
211insert into SEMESTERS (idSemester, semester, Slot_id) values (2, 2, 2);
212insert into SEMESTERS (idSemester, semester, Slot_id) values (3, 3, 3);
213insert into SEMESTERS (idSemester, semester, Slot_id) values (4, 4, 4);
214insert into SEMESTERS (idSemester, semester, Slot_id) values (5, 5, 5);
215insert into SEMESTERS (idSemester, semester, Slot_id) values (6, 6, 6);
216insert into SEMESTERS (idSemester, semester, Slot_id) values (7, 7, 7);
217insert into SEMESTERS (idSemester, semester, Slot_id) values (8, 8, 8);
218insert into SEMESTERS (idSemester, semester, Slot_id) values (9, 9, 9);
219insert into SEMESTERS (idSemester, semester, Slot_id) values (10, 10, 10);
220insert into SEMESTERS (idSemester, semester, Slot_id) values (11, 2, 11);
221insert into SEMESTERS (idSemester, semester, Slot_id) values (12, 6, 12);
222insert into SEMESTERS (idSemester, semester, Slot_id) values (13, 1, 13);
223insert into SEMESTERS (idSemester, semester, Slot_id) values (14, 7, 14);
224insert into SEMESTERS (idSemester, semester, Slot_id) values (15, 8, 15);
225insert into SEMESTERS (idSemester, semester, Slot_id) values (16, 9, 16);
226insert into SEMESTERS (idSemester, semester, Slot_id) values (17, 4, 17);
227insert into SEMESTERS (idSemester, semester, Slot_id) values (18, 3, 18);
228insert into SEMESTERS (idSemester, semester, Slot_id) values (19, 1, 19);
229insert into SEMESTERS (idSemester, semester, Slot_id) values (20, 3, 20);
230
231
232-- SELECT*FROM SEMESTERS;
233
234
235
236-- INSERTANDO DATOS EN LA TABLA STUDENTS;
237
238insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (1, '8923424552', 'Loise', 'Robet', '(541) 6922499', 'lrobet0@cdbaby.com', 1);
239insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (2, '2562774478', 'Diahann', 'Gonzales', '(148) 6630311', 'dgonzales1@tmall.com', 2);
240insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (3, '5203166555', 'Jolynn', 'Lightwing', '(123) 3730246', 'jlightwing2@indiatimes.com', 3);
241insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (4, '8217297777', 'Faydra', 'Kittow', '(918) 8431343', 'fkittow3@netvibes.com', 4);
242insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (5, '7394653567', 'Cariotta', 'Paintain', '(834) 1097568', 'cpaintain4@pbs.org', 5);
243insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (6, '7582632682', 'Levi', 'Feye', '(205) 8496680', 'lfeye5@biblegateway.com', 6);
244insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (7, '4422120867', 'Halette', 'Benettini', '(929) 9221006', 'hbenettini6@yale.edu', 7);
245insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (8, '1594909491', 'Nellie', 'Mattys', '(978) 6525847', 'nmattys7@blogs.com', 8);
246insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (9, '3975412758', 'Gwyn', 'Swainger', '(713) 9628451', 'gswainger8@irs.gov', 9);
247insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (10, '2965954639', 'Sandy', 'Bridgement', '(323) 2417832', 'sbridgement9@yellowbook.com', 10);
248insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (11, '4932165270', 'Brittney', 'Swithenby', '(457) 9222177', 'bswithenbya@tmall.com', 11);
249insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (12, '6857647528', 'Rriocard', 'Carrabott', '(890) 6895606', 'rcarrabottb@statcounter.com', 12);
250insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (13, '4867603348', 'Germaine', 'Mollen', '(919) 3884232', 'gmollenc@cornell.edu', 13);
251insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (14, '2209566711', 'Benyamin', 'Mewhirter', '(304) 9080409', 'bmewhirterd@independent.co.uk', 14);
252insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (15, '9196073395', 'Cole', 'McCarron', '(245) 5082792', 'cmccarrone@t-online.de', 15);
253insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (16, '7725281088', 'Wendeline', 'Argrave', '(586) 2250716', 'wargravef@wordpress.com', 16);
254insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (17, '1997476540', 'Wileen', 'Hayer', '(461) 5382256', 'whayerg@telegraph.co.uk', 17);
255insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (18, '1263265467', 'Oralie', 'Haukey', '(784) 6831397', 'ohaukeyh@accuweather.com', 18);
256insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (19, '4097073377', 'Willard', 'Crossfield', '(452) 1679285', 'wcrossfieldi@people.com.cn', 19);
257insert into STUDENTS (idStudent, identification, name, lastName, phone, mail, Semester_id) values (20, '2134064397', 'Therine', 'Caddock', '(714) 8662355', 'tcaddockj@engadget.com', 20);
258
259
260-- SELECT*FROM STUDENTS;
261
262
263-- INSERTANDO DATOS EN LA TABLA ACTIVITIES
264
265insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (1, 'Nepal', '2020-05-01', '21:54:10', 26, 2, 1, 1);
266insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (2, 'Russia', '2021-03-28', '21:43:45', 92, 2, 2, 2);
267insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (3, 'Indonesia', '2020-10-18', '19:26:15', 74, 1, 3, 3);
268insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (4, 'China', '2020-10-20', '21:29:47', 72, 3, 4, 4);
269insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (5, 'Brazil', '2020-09-25', '21:17:54', 4, 4, 5, 5);
270insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (6, 'Kyrgyzstan', '2020-05-07', '21:55:44', 33, 4, 6, 6);
271insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (7, 'United States', '2021-02-26', '18:30:06', 34, 3, 7, 7);
272insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (8, 'Brazil', '2021-02-26', '18:35:31', 27, 1, 8, 8);
273insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (9, 'Canada', '2021-03-08', '19:54:17', 58, 3, 9, 9);
274insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (10, 'Philippines', '2020-11-09', '18:47:11', 51, 4, 10, 10);
275insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (11, 'Mali', '2020-10-18', '18:37:28', 12, 2, 11, 11);
276insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (12, 'Indonesia', '2020-12-08', '20:13:12', 85, 5, 12, 12);
277insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (13, 'China', '2020-12-01', '19:21:42', 37, 3, 13, 13);
278insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (14, 'Albania', '2021-01-14', '19:07:29', 80, 3, 14, 14);
279insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (15, 'Cameroon', '2020-02-13', '21:20:07', 67, 1, 15, 15);
280insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (16, 'France', '2020-02-16', '21:42:01', 75, 3, 16, 16);
281insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (17, 'Norway', '2021-01-30', '18:44:37', 54, 2, 17, 17);
282insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (18, 'Poland', '2020-06-28', '18:36:51', 91, 5, 18, 18);
283insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (19, 'China', '2020-12-15', '20:55:49', 58, 3, 19, 19);
284insert into ACTIVITIES (idActivitie, activityName, dateF, timeH, valueV, score, Student_id, Slot_id) values (20, 'China', '2020-07-13', '19:49:40', 89, 1, 20, 20);
285
286-- SELECT*FROM ACTIVITIES;
287
288
289
290
291
292
293-- INSERTANDO DATOS EN LA TABLA SESSIONS
294
295insert into SESSIONS (idSession, name, Slot_id) values (1, 'Aimbo', 1);
296insert into SESSIONS (idSession, name, Slot_id) values (2, 'Browsezoom', 2);
297insert into SESSIONS (idSession, name, Slot_id) values (3, 'Kwideo', 3);
298insert into SESSIONS (idSession, name, Slot_id) values (4, 'Skaboo', 4);
299insert into SESSIONS (idSession, name, Slot_id) values (5, 'Voolia', 5);
300insert into SESSIONS (idSession, name, Slot_id) values (6, 'Tambee', 6);
301insert into SESSIONS (idSession, name, Slot_id) values (7, 'Bubblebox', 7);
302insert into SESSIONS (idSession, name, Slot_id) values (8, 'Skyvu', 8);
303insert into SESSIONS (idSession, name, Slot_id) values (9, 'Jetwire', 9);
304insert into SESSIONS (idSession, name, Slot_id) values (10, 'Eare', 10);
305insert into SESSIONS (idSession, name, Slot_id) values (11, 'Pixope', 11);
306insert into SESSIONS (idSession, name, Slot_id) values (12, 'Babblestorm', 12);
307insert into SESSIONS (idSession, name, Slot_id) values (13, 'Gabvine', 13);
308insert into SESSIONS (idSession, name, Slot_id) values (14, 'Skyble', 14);
309insert into SESSIONS (idSession, name, Slot_id) values (15, 'Topiclounge', 15);
310insert into SESSIONS (idSession, name, Slot_id) values (16, 'Voolith', 16);
311insert into SESSIONS (idSession, name, Slot_id) values (17, 'Blogtags', 17);
312insert into SESSIONS (idSession, name, Slot_id) values (18, 'Tagopia', 18);
313insert into SESSIONS (idSession, name, Slot_id) values (19, 'Dazzlesphere', 19);
314insert into SESSIONS (idSession, name, Slot_id) values (20, 'Mynte', 20);
315
316
317-- SELECT*FROM SESSIONS;
318
319
320
321
322
323-- INSERTANDO DATOS EN LA TABLA ASSISTANCES
324
325
326insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (1, '2020-07-12', '9:30:47', 'Peccary, collared', 1, 1);
327insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (2, '2020-11-29', '15:14:09', 'Crane, sandhill', 2, 2);
328insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (3, '2021-04-05', '21:15:52', 'Shrike, common boubou', 3, 3);
329insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (4, '2021-04-20', '11:01:10', 'Squirrel, pine', 4, 4);
330insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (5, '2020-07-30', '8:06:46', 'Openbill stork', 5, 5);
331insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (6, '2020-10-08', '19:05:36', 'Constrictor, eastern boa', 6, 6);
332insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (7, '2020-11-01', '18:02:47', 'Rhesus monkey', 7, 7);
333insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (8, '2020-12-01', '20:02:05', 'Hoary marmot', 8, 8);
334insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (9, '2020-09-20', '19:46:00', 'Pale-throated three-toed sloth', 9, 9);
335insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (10, '2020-04-25', '15:36:49', 'Lemur, grey mouse', 10, 10);
336insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (11, '2020-09-05', '13:08:00', 'Greater roadrunner', 11, 11);
337insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (12, '2020-10-01', '7:51:32', 'Tsessebe', 12, 12);
338insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (13, '2020-11-10', '15:16:45', 'Yellow-crowned night heron', 13, 13);
339insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (14, '2020-06-06', '9:31:54', 'Siskin, yellow-rumped', 14, 14);
340insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (15, '2020-12-02', '16:59:02', 'American marten', 15, 15);
341insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (16, '2020-08-13', '17:28:52', 'Blue crane', 16, 16);
342insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (17, '2020-09-25', '14:27:05', 'Prehensile-tailed porcupine', 17, 17);
343insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (18, '2020-09-14', '19:35:01', 'Pallas''s fish eagle', 18, 18);
344insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (19, '2021-02-10', '19:09:14', 'Great kiskadee', 19, 19);
345insert into ASSISTANCES (idAssistance, dateF, timeH, note, Student_id, Session_id) values (20, '2021-02-27', '20:19:11', 'Olive baboon', 20, 20);
346
347
348-- SELECT*FROM ASSISTANCES;