RelationalDesign: data_load.sql

File data_load.sql, 38.3 KB (added by 236024, 4 days ago)
Line 
1BEGIN;
2
3SET search_path TO project;
4
5TRUNCATE TABLE
6 cooperation,
7 companies,
8 volunteers,
9 responsible_for,
10 announces_absence,
11 required_attendance,
12 participation,
13 holds_event_function,
14 applications,
15 related_to,
16 activity_sessions,
17 event_sessions,
18 event_functions,
19 event_function_types,
20 event_edition_locations,
21 event_editions,
22 locations,
23 event_session_types,
24 event_types,
25 activity_types,
26 function_mandates,
27 board,
28 non_board,
29 organizational_functions,
30 has_stage,
31 alumni,
32 young_members,
33 full_members,
34 observers,
35 membership_stages,
36 members,
37 students
38RESTART IDENTITY CASCADE;
39
40INSERT INTO students (
41 student_index, first_name, last_name, faculty, field_of_studies,
42 year_of_studies, birthday, email, phone_number
43) VALUES
44 (230001, 'Elena', 'Petrova', 'FINKI', 'Software Engineering and Information Systems', 4, DATE '2002-05-14', 'elena.petrova@student.ukim.mk', '+38970111001'),
45 (230002, 'Marko', 'Nikolov', 'FEEIT', 'Computer Technologies and Engineering', 3, DATE '2003-03-02', 'marko.nikolov@student.ukim.mk', '+38970111002'),
46 (230003, 'Ana', 'Trajkovska', 'FINKI', 'Internet, Networks and Security', 3, DATE '2003-09-18', 'ana.trajkovska@student.ukim.mk', '+38970111003'),
47 (230004, 'Stefan', 'Kostov', 'FEEIT', 'Telecommunication and Information Engineering', 4, DATE '2002-01-27', 'stefan.kostov@student.ukim.mk', '+38970111004'),
48 (230005, 'Mila', 'Jovanovska', 'FINKI', 'Computer Science', 2, DATE '2004-06-08', 'mila.jovanovska@student.ukim.mk', '+38970111005'),
49 (230006, 'Boris', 'Angelov', 'MFS', 'Industrial Engineering and Management', 4, DATE '2002-11-11', 'boris.angelov@student.ukim.mk', '+38970111006'),
50 (230007, 'Sara', 'Mitrevska', 'FINKI', 'Computer Engineering', 4, DATE '2002-04-20', 'sara.mitrevska@student.ukim.mk', '+38970111007'),
51 (230008, 'Petar', 'Stojanovski', 'TMF', 'Design and Management of Technological Processes', 3, DATE '2003-12-05', 'petar.stojanovski@student.ukim.mk', '+38970111008'),
52 (230009, 'Ivana', 'Ilievska', 'PMF', 'Molecular Biology with Genetics', 3, DATE '2003-07-30', 'ivana.ilievska@student.ukim.mk', '+38970111009'),
53 (230010, 'Viktor', 'Ristovski', 'MFS', 'Mechatronics', 4, DATE '2002-02-16', 'viktor.ristovski@student.ukim.mk', '+38970111010'),
54 (230011, 'Jana', 'Arsovska', 'FEEIT', 'Power Systems', 3, DATE '2003-10-01', 'jana.arsovska@student.ukim.mk', '+38970111011'),
55 (230012, 'Filip', 'Dimitrov', 'TMF', 'Biotechnology', 3, DATE '2003-08-13', 'filip.dimitrov@student.ukim.mk', '+38970111012'),
56 (230013, 'Tamara', 'Gjorgjievska', 'PMF', 'Geography, Physical Geography with Geoecology Module', 2, DATE '2004-05-19', 'tamara.gjorgjievska@student.ukim.mk', '+38970111013'),
57 (230014, 'Nikola', 'Spasovski', 'FINKI', 'Application of Information Technologies', 2, DATE '2004-12-22', 'nikola.spasovski@student.ukim.mk', '+38970111014'),
58 (230015, 'Marija', 'Karanfilova', 'FEEIT', 'Electrical Power Engineering and Project Management', 4, DATE '2002-06-30', 'marija.karanfilova@student.ukim.mk', '+38970111015'),
59 (230016, 'Andrej', 'Pavlov', 'MFS', 'Transport, Mechanization and Logistics', 3, DATE '2003-01-17', 'andrej.pavlov@student.ukim.mk', '+38970111016'),
60 (230017, 'Teodora', 'Ilieva', 'TMF', 'Materials Engineering and Nanotechnologies', 2, DATE '2004-03-24', 'teodora.ilieva@student.ukim.mk', '+38970111017'),
61 (230018, 'Damjan', 'Mitev', 'PMF', 'Mathematics', 3, DATE '2003-11-09', 'damjan.mitev@student.ukim.mk', '+38970111018'),
62 (230019, 'Katerina', 'Naumoska', 'FINKI', 'Professional Studies in Programming', 1, DATE '2005-02-12', 'katerina.naumoska@student.ukim.mk', '+38970111019'),
63 (230020, 'Martin', 'Simonovski', 'FEEIT', 'Computer Hardware Engineering and Electronics', 2, DATE '2004-09-04', 'martin.simonovski@student.ukim.mk', '+38970111020'),
64 (230021, 'Nevena', 'Lazarevska', 'TMF', 'Food Technology', 1, DATE '2005-07-07', 'nevena.lazarevska@student.ukim.mk', '+38970111021'),
65 (230022, 'Luka', 'Popov', 'MFS', 'Energy and Environment', 2, DATE '2004-04-28', 'luka.popov@student.ukim.mk', '+38970111022'),
66 (230023, 'Hristina', 'Koleska', 'PMF', 'Ecology and Environment', 1, DATE '2005-09-25', 'hristina.koleska@student.ukim.mk', '+38970111023'),
67 (230024, 'Dario', 'Petreski', 'FINKI', 'Informatics Education', 1, DATE '2005-12-03', 'dario.petreski@student.ukim.mk', '+38970111024'),
68 (230025, 'Elena', 'Manevska', 'FEEIT', 'Power Engineering, Automation and Renewable Energy Sources', 1, DATE '2005-01-14', 'elena.manevska@student.ukim.mk', '+38970111025'),
69 (230026, 'Goran', 'Todorov', 'MFS', 'Thermal Engineering', 2, DATE '2004-08-18', 'goran.todorov@student.ukim.mk', '+38970111026'),
70 (230027, 'Irena', 'Naumova', 'PMF', 'Chemistry', 1, DATE '2005-10-30', 'irena.naumova@student.ukim.mk', '+38970111027'),
71 (230028, 'Aleksandar', 'Ivanovski', 'FINKI', 'Software Engineering and Information Systems', 0, DATE '1998-04-11', 'aleksandar.ivanovski@alumni.best.org.mk', '+38970111028'),
72 (230029, 'Simona', 'Jakimovska', 'TMF', 'Polymer Materials', 0, DATE '1999-02-09', 'simona.jakimovska@alumni.best.org.mk', '+38970111029'),
73 (230030, 'Gorjan', 'Naumovski', 'MFS', 'Motor Vehicles', 0, DATE '1998-06-23', 'gorjan.naumovski@alumni.best.org.mk', '+38970111030'),
74 (230031, 'Lina', 'Stamenovska', 'PMF', 'Physics', 2, DATE '2004-05-05', 'lina.stamenovska@student.ukim.mk', '+38970111031'),
75 (230032, 'David', 'Atanasov', 'FINKI', 'Computer Science', 1, DATE '2005-03-19', 'david.atanasov@student.ukim.mk', '+38970111032');
76
77INSERT INTO members (student_index) VALUES
78 (230001), (230002), (230003), (230004), (230005), (230006), (230007), (230008),
79 (230009), (230010), (230011), (230012), (230013), (230014), (230015), (230016),
80 (230017), (230018), (230019), (230020), (230021), (230022), (230023), (230024),
81 (230025), (230026), (230027), (230028), (230029), (230030);
82
83INSERT INTO observers (student_index) VALUES
84 (230024), (230025), (230026), (230027);
85
86INSERT INTO full_members (student_index) VALUES
87 (230001), (230002), (230003), (230004), (230005), (230006), (230007), (230008),
88 (230009), (230010), (230011), (230012), (230013), (230014), (230015), (230016),
89 (230017), (230018);
90
91INSERT INTO young_members (student_index, mentor_index) VALUES
92 (230019, 230001),
93 (230020, 230002),
94 (230021, 230005),
95 (230022, 230004),
96 (230023, 230007);
97
98INSERT INTO alumni (student_index) VALUES
99 (230028), (230029), (230030);
100
101INSERT INTO membership_stages (ms_id, ms_name) VALUES
102 (1, 'Observer'),
103 (2, 'Young member'),
104 (3, 'Full member'),
105 (4, 'Alumni');
106
107INSERT INTO has_stage (student_index, ms_id, valid_from, valid_to) VALUES
108 (230001, 1, DATE '2021-10-03', DATE '2021-11-06'),
109 (230001, 2, DATE '2021-11-07', DATE '2022-02-19'),
110 (230001, 3, DATE '2022-02-20', NULL),
111 (230002, 1, DATE '2022-02-20', DATE '2022-03-19'),
112 (230002, 2, DATE '2022-03-20', DATE '2022-10-08'),
113 (230002, 3, DATE '2022-10-09', NULL),
114 (230003, 1, DATE '2022-10-09', DATE '2022-11-12'),
115 (230003, 2, DATE '2022-11-13', DATE '2023-02-18'),
116 (230003, 3, DATE '2023-02-19', NULL),
117 (230004, 1, DATE '2022-10-09', DATE '2022-11-12'),
118 (230004, 2, DATE '2022-11-13', DATE '2023-02-18'),
119 (230004, 3, DATE '2023-02-19', NULL),
120 (230005, 1, DATE '2023-02-19', DATE '2023-03-18'),
121 (230005, 2, DATE '2023-03-19', DATE '2023-10-07'),
122 (230005, 3, DATE '2023-10-08', NULL),
123 (230006, 1, DATE '2023-02-19', DATE '2023-03-18'),
124 (230006, 2, DATE '2023-03-19', DATE '2023-10-07'),
125 (230006, 3, DATE '2023-10-08', NULL),
126 (230007, 1, DATE '2023-02-19', DATE '2023-03-18'),
127 (230007, 2, DATE '2023-03-19', DATE '2023-10-07'),
128 (230007, 3, DATE '2023-10-08', NULL),
129 (230008, 1, DATE '2023-10-08', DATE '2023-11-11'),
130 (230008, 2, DATE '2023-11-12', DATE '2024-02-17'),
131 (230008, 3, DATE '2024-02-18', NULL),
132 (230009, 1, DATE '2023-10-08', DATE '2023-11-11'),
133 (230009, 2, DATE '2023-11-12', DATE '2024-02-17'),
134 (230009, 3, DATE '2024-02-18', NULL),
135 (230010, 1, DATE '2024-02-18', DATE '2024-03-16'),
136 (230010, 2, DATE '2024-03-17', DATE '2024-10-05'),
137 (230010, 3, DATE '2024-10-06', NULL),
138 (230011, 1, DATE '2024-02-18', DATE '2024-03-16'),
139 (230011, 2, DATE '2024-03-17', DATE '2024-10-05'),
140 (230011, 3, DATE '2024-10-06', NULL),
141 (230012, 1, DATE '2024-02-18', DATE '2024-03-16'),
142 (230012, 2, DATE '2024-03-17', DATE '2024-10-05'),
143 (230012, 3, DATE '2024-10-06', NULL),
144 (230013, 1, DATE '2024-10-06', DATE '2024-11-09'),
145 (230013, 2, DATE '2024-11-10', DATE '2025-02-15'),
146 (230013, 3, DATE '2025-02-16', NULL),
147 (230014, 1, DATE '2024-10-06', DATE '2024-11-09'),
148 (230014, 2, DATE '2024-11-10', DATE '2025-02-15'),
149 (230014, 3, DATE '2025-02-16', NULL),
150 (230015, 1, DATE '2025-02-16', DATE '2025-03-15'),
151 (230015, 2, DATE '2025-03-16', DATE '2025-10-11'),
152 (230015, 3, DATE '2025-10-12', NULL),
153 (230016, 1, DATE '2025-02-16', DATE '2025-03-15'),
154 (230016, 2, DATE '2025-03-16', DATE '2025-10-11'),
155 (230016, 3, DATE '2025-10-12', NULL),
156 (230017, 1, DATE '2025-10-12', DATE '2025-11-15'),
157 (230017, 2, DATE '2025-11-16', DATE '2026-02-21'),
158 (230017, 3, DATE '2026-02-22', NULL),
159 (230018, 1, DATE '2025-10-12', DATE '2025-11-15'),
160 (230018, 2, DATE '2025-11-16', DATE '2026-02-21'),
161 (230018, 3, DATE '2026-02-22', NULL),
162 (230019, 1, DATE '2025-10-12', DATE '2026-02-21'),
163 (230019, 2, DATE '2026-02-22', NULL),
164 (230020, 1, DATE '2025-10-12', DATE '2026-02-21'),
165 (230020, 2, DATE '2026-02-22', NULL),
166 (230021, 1, DATE '2025-10-12', DATE '2026-02-21'),
167 (230021, 2, DATE '2026-02-22', NULL),
168 (230022, 1, DATE '2025-10-12', DATE '2026-02-21'),
169 (230022, 2, DATE '2026-02-22', NULL),
170 (230023, 1, DATE '2025-10-12', DATE '2026-02-21'),
171 (230023, 2, DATE '2026-02-22', NULL),
172 (230024, 1, DATE '2026-03-11', NULL),
173 (230025, 1, DATE '2026-03-11', NULL),
174 (230026, 1, DATE '2026-03-11', NULL),
175 (230027, 1, DATE '2026-03-11', NULL),
176 (230028, 1, DATE '2019-10-06', DATE '2019-11-09'),
177 (230028, 2, DATE '2019-11-10', DATE '2020-02-15'),
178 (230028, 3, DATE '2020-02-16', DATE '2025-02-15'),
179 (230028, 4, DATE '2025-02-16', NULL),
180 (230029, 1, DATE '2019-10-06', DATE '2019-11-09'),
181 (230029, 2, DATE '2019-11-10', DATE '2020-02-15'),
182 (230029, 3, DATE '2020-02-16', DATE '2025-02-15'),
183 (230029, 4, DATE '2025-02-16', NULL),
184 (230030, 1, DATE '2018-10-07', DATE '2018-11-10'),
185 (230030, 2, DATE '2018-11-11', DATE '2019-02-16'),
186 (230030, 3, DATE '2019-02-17', DATE '2024-02-17'),
187 (230030, 4, DATE '2024-02-18', NULL);
188
189INSERT INTO organizational_functions (of_id, of_title) VALUES
190 (1, 'President'),
191 (2, 'Treasurer'),
192 (3, 'Secretary'),
193 (4, 'HR Coordinator'),
194 (5, 'FR Coordinator'),
195 (6, 'PR Coordinator'),
196 (7, 'IT Coordinator'),
197 (8, 'Design Coordinator'),
198 (9, 'Logistics Coordinator'),
199 (10, 'Social Activities Coordinator'),
200 (11, 'Vivaldi Coordinator'),
201 (12, 'Grants Coordinator');
202
203INSERT INTO board (of_id) VALUES
204 (1), (2), (3), (4), (5), (6), (7);
205
206INSERT INTO non_board (of_id) VALUES
207 (8), (9), (10), (11), (12);
208
209INSERT INTO function_mandates (student_index, of_id, mandate_year) VALUES
210 (230001, 1, 2025),
211 (230002, 2, 2025),
212 (230003, 3, 2025),
213 (230004, 4, 2025),
214 (230005, 5, 2025),
215 (230006, 6, 2025),
216 (230007, 7, 2025),
217 (230008, 8, 2025),
218 (230009, 9, 2025),
219 (230010, 10, 2025),
220 (230011, 11, 2025),
221 (230012, 12, 2025),
222 (230013, 11, 2024);
223
224INSERT INTO activity_types (at_id, at_name, at_description) VALUES
225 (1, 'Weekly Meeting', 'Regular weekly meeting held by the President in Baraka 2.2.'),
226 (2, 'BCS Meeting', 'Weekly BEST Course in Summer meeting held at the BEST Benches by the Main Organisers.'),
227 (3, 'Core Team Meeting', 'Operational meeting for the core team of a specific event.'),
228 (4, 'FR Call', 'Sponsorship calling session for an event, supported by members of the organisation.'),
229 (5, 'PR Workshop', 'Workshop for promotion and social media posts tasks.'),
230 (6, 'Design Workshop', 'Workshop for event visual identity and design tasks.'),
231 (7, 'IT Workshop', 'Workshop for event technical and IT tasks.'),
232 (8, 'FR Workshop', 'Workshop for fundraising preparation.'),
233 (9, 'Logistics Workshop', 'Workshop for logistics planning.'),
234 (10, 'Social Activities Workshop', 'Workshop for social activities.'),
235 (11, 'Full Member Meeting', 'Monthly meeting intended for full members.'),
236 (12, 'Board Meeting', 'Weekly meeting intended for Board members.'),
237 (13, 'Training Session', 'Soft skills training session coordinated by HR and held by Trainers.'),
238 (14, 'Event Evaluation', 'Meeting after an event used for evaluation and feedback.'),
239 (15, 'Party', 'Social activity or party organised by BEST Skopje.');
240
241INSERT INTO event_types (et_id, et_name, et_description) VALUES
242 (1, 'Motivational Weekend', 'Traditional BEST Skopje event where members spend a weekend outside their usual environment, combining studying, socializing and team-building activities.'),
243 (2, 'Job Fair', 'Large annual BEST Skopje event where students connect directly with technical and technology companies through stands, presentations, internships and employment opportunities.'),
244 (3, 'BEST Course in Summer', 'International educational event that brings students from Europe to Macedonia for lectures, workshops, company visits, cultural activities and social programme.'),
245 (4, 'beBESTie', 'Recruitment event where UKIM students learn about BEST Skopje and try practical activities from PR, design, IT and fundraising.'),
246 (5, 'BOMBA', 'Event where observers can become young members and full members can become mentors.'),
247 (6, 'Hackathon', 'Event for innovation, teamwork and hands-on learning where students solve real-world challenges in a dynamic environment.'),
248 (7, 'Birthday', 'Annual celebration of BEST Skopje''s birthday on 9 March.'),
249 (8, 'Other Event', 'Other event type not covered by the predefined event categories.');
250
251INSERT INTO locations (l_id, l_name) VALUES
252 (1, 'Baraka 2.2'),
253 (2, 'Baraka 2.1'),
254 (3, 'Baraka 3.1'),
255 (4, 'Baraka 3.2'),
256 (5, 'Netaville'),
257 (6, 'Base42'),
258 (7, 'BEST Office'),
259 (8, 'BEST Benches'),
260 (9, 'Vrteshka Mountain Lodge'),
261 (10, 'FINKI Room 117'),
262 (11, 'FINKI Amphitheater'),
263 (12, 'INNOFEIT'),
264 (13, 'FEEIT'),
265 (14, 'MFS'),
266 (15, 'Goce Delchev Student Dormitory'),
267 (16, 'FINKI Partner Faculty Premises'),
268 (17, 'Nikola Karev Ohrid Dormitory'),
269 (18, 'Netcetera Campus'),
270 (19, 'Macedonia Square');
271
272INSERT INTO event_editions (ee_id, et_id, ee_title, ee_start_time, ee_end_time) VALUES
273 (1, 1, 'Winter Motivational Weekend 2026', TIMESTAMP '2026-02-06 18:00:00', TIMESTAMP '2026-02-08 16:00:00'),
274 (2, 5, 'BOMBA Spring 2026', TIMESTAMP '2026-02-21 10:00:00', TIMESTAMP '2026-02-22 16:00:00'),
275 (3, 7, 'BEST Skopje Birthday 2026', TIMESTAMP '2026-03-09 20:00:00', TIMESTAMP '2026-03-10 01:00:00'),
276 (4, 2, 'Job Fair 2026', TIMESTAMP '2026-03-23 09:00:00', TIMESTAMP '2026-03-27 18:00:00'),
277 (5, 1, 'Spring Motivational Weekend 2026', TIMESTAMP '2026-05-15 18:00:00', TIMESTAMP '2026-05-17 16:00:00'),
278 (6, 3, 'BEST Course in Summer 2026', TIMESTAMP '2026-07-05 12:00:00', TIMESTAMP '2026-07-13 18:00:00'),
279 (7, 4, 'beBESTie Autumn 2026', TIMESTAMP '2026-10-05 17:00:00', TIMESTAMP '2026-10-05 21:00:00'),
280 (8, 6, 'Impact Hackathon 2026', TIMESTAMP '2026-12-12 09:00:00', TIMESTAMP '2026-12-13 18:00:00');
281
282INSERT INTO event_edition_locations (ee_id, l_id) VALUES
283 (1, 9),
284 (2, 10),
285 (3, 7),
286 (4, 12),
287 (4, 13),
288 (4, 14),
289 (5, 9),
290 (6, 15),
291 (6, 16),
292 (6, 17),
293 (7, 11),
294 (8, 18);
295
296INSERT INTO event_session_types (est_id, est_name, est_description) VALUES
297 (1, 'Official Opening', 'Formal opening session for an event edition.'),
298 (2, 'Company Stands', 'Session in which students visit company stands.'),
299 (3, 'Company Presentation', 'Session in which companies present their work and opportunities.'),
300 (4, 'Official Closing', 'Formal closing session for an event edition.'),
301 (5, 'Lecture Timeslot', 'Academic or professional lecture session.'),
302 (6, 'Coffee Break', 'Break between programme sessions.'),
303 (7, 'Lunch Break', 'Meal break during an event programme.'),
304 (8, 'City Rally', 'Outdoor city exploration activity for participants.'),
305 (9, 'Social Activity', 'Informal social session inside an event.'),
306 (10, 'Company Visit', 'Visit to a partner company during an event.'),
307 (11, 'Weekend Trip', 'Weekend trip session during an international course.'),
308 (12, 'Participants Working', 'Hackathon working block where participants solve tasks.'),
309 (13, 'Party', 'Evening party or celebration.'),
310 (14, 'Mentor Matching', 'BOMBA session for assigning angels to young members.'),
311 (15, 'Info Meeting', 'Informative recruitment session for students.'),
312 (16, 'Workshop Session', 'Hands-on session or practical workshop.'),
313 (17, 'Team Building', 'Team-building activity for members or participants.');
314
315INSERT INTO event_sessions (
316 ee_id, es_no, est_id, l_id, es_start_time, es_title, needed_no_volunteers
317) VALUES
318 (1, 1, 1, 9, TIMESTAMP '2026-02-06 20:00:00', 'Winter MW Opening', 4),
319 (1, 2, 16, 9, TIMESTAMP '2026-02-07 10:00:00', 'Morning Workshop', 2),
320 (1, 3, 17, 9, TIMESTAMP '2026-02-07 17:00:00', 'Team Building Challenge', 4),
321 (1, 4, 4, 9, TIMESTAMP '2026-02-08 14:00:00', 'Winter MW Closing', 3),
322 (2, 1, 1, 10, TIMESTAMP '2026-02-21 10:30:00', 'BOMBA Opening', 3),
323 (2, 2, 16, 10, TIMESTAMP '2026-02-21 12:00:00', 'Membership Workshop', 2),
324 (2, 3, 14, 10, TIMESTAMP '2026-02-22 14:00:00', 'Angel Matching', 2),
325 (3, 1, 13, 7, TIMESTAMP '2026-03-09 21:00:00', 'BEST Skopje Birthday Party', 3),
326 (4, 1, 1, 12, TIMESTAMP '2026-03-23 10:00:00', 'Job Fair Opening Ceremony', 4),
327 (4, 2, 2, 13, TIMESTAMP '2026-03-24 10:00:00', 'Technical Companies Stands', 4),
328 (4, 3, 2, 14, TIMESTAMP '2026-03-24 10:00:00', 'Engineering Companies Stands', 4),
329 (4, 4, 3, 13, TIMESTAMP '2026-03-26 12:00:00', 'Career Development Presentations', 3),
330 (4, 5, 4, 13, TIMESTAMP '2026-03-27 17:00:00', 'Job Fair Closing', 3),
331 (5, 1, 1, 9, TIMESTAMP '2026-05-15 20:00:00', 'Spring MW Opening', 4),
332 (5, 2, 16, 9, TIMESTAMP '2026-05-16 10:00:00', 'Afternoon Workshop', 2),
333 (5, 3, 9, 9, TIMESTAMP '2026-05-16 21:00:00', 'Campfire Social', 4),
334 (5, 4, 4, 9, TIMESTAMP '2026-05-17 14:00:00', 'Spring MW Closing', 3),
335 (6, 1, 1, 15, TIMESTAMP '2026-07-05 18:00:00', 'Course Opening', 4),
336 (6, 2, 5, 16, TIMESTAMP '2026-07-06 10:00:00', 'First Academic Lecture', 1),
337 (6, 3, 6, 16, TIMESTAMP '2026-07-06 11:30:00', 'Morning Coffee Break', 2),
338 (6, 4, 10, 18, TIMESTAMP '2026-07-07 14:00:00', 'Partner Company Visit', 4),
339 (6, 5, 8, 19, TIMESTAMP '2026-07-08 18:00:00', 'Skopje City Rally', 4),
340 (6, 6, 9, 15, TIMESTAMP '2026-07-09 21:00:00', 'International Evening', 5),
341 (6, 7, 11, 17, TIMESTAMP '2026-07-11 09:00:00', 'Ohrid Weekend Trip', 6),
342 (6, 8, 4, 16, TIMESTAMP '2026-07-13 17:00:00', 'Course Closing', 4),
343 (7, 1, 15, 11, TIMESTAMP '2026-10-05 17:30:00', 'beBESTie Info Meeting', 4),
344 (7, 2, 16, 11, TIMESTAMP '2026-10-05 18:30:00', 'Hands-on BEST Process Trial', 4),
345 (8, 1, 1, 18, TIMESTAMP '2026-12-12 09:30:00', 'Hackathon Opening', 4),
346 (8, 2, 12, 18, TIMESTAMP '2026-12-12 10:00:00', 'Challenge Work Block 1', 2),
347 (8, 3, 6, 18, TIMESTAMP '2026-12-12 12:00:00', 'Coffee Break', 2),
348 (8, 4, 7, 18, TIMESTAMP '2026-12-12 14:00:00', 'Lunch Break', 3),
349 (8, 5, 12, 18, TIMESTAMP '2026-12-12 15:00:00', 'Challenge Work Block 2', 2),
350 (8, 6, 13, 18, TIMESTAMP '2026-12-12 21:00:00', 'Hackathon Party', 3),
351 (8, 7, 4, 18, TIMESTAMP '2026-12-13 17:00:00', 'Hackathon Closing', 4);
352
353INSERT INTO event_function_types (eft_id, eft_name) VALUES
354 (1, 'Main Organiser'),
355 (2, 'Corporate Relations Responsible'),
356 (3, 'Logistics Responsible'),
357 (4, 'PR Responsible'),
358 (5, 'FR Responsible'),
359 (6, 'IT Responsible'),
360 (7, 'Design Responsible'),
361 (8, 'Social Responsible'),
362 (9, 'Participants Responsible'),
363 (10, 'Academic Responsible');
364
365INSERT INTO event_functions (ee_id, ef_no, eft_id) VALUES
366 (1, 1, 1),
367 (3, 1, 1),
368 (4, 1, 1),
369 (4, 2, 1),
370 (4, 3, 2),
371 (4, 4, 2),
372 (4, 5, 3),
373 (4, 6, 4),
374 (4, 7, 5),
375 (4, 8, 6),
376 (4, 9, 7),
377 (5, 1, 1),
378 (6, 1, 1),
379 (6, 2, 1),
380 (6, 3, 3),
381 (6, 4, 3),
382 (6, 5, 8),
383 (6, 6, 8),
384 (6, 7, 4),
385 (6, 8, 5),
386 (6, 9, 6),
387 (6, 10, 7),
388 (6, 11, 9),
389 (6, 12, 10),
390 (7, 1, 1),
391 (8, 1, 1),
392 (8, 2, 9),
393 (8, 3, 5),
394 (8, 4, 6),
395 (8, 5, 7),
396 (8, 6, 4);
397
398INSERT INTO activity_sessions (as_id, at_id, l_id, as_start_time) VALUES
399 (1, 1, 1, TIMESTAMP '2026-02-09 20:00:00'),
400 (2, 1, 1, TIMESTAMP '2026-03-02 20:00:00'),
401 (3, 1, 1, TIMESTAMP '2026-03-16 20:00:00'),
402 (4, 1, 1, TIMESTAMP '2026-04-06 20:00:00'),
403 (5, 1, 1, TIMESTAMP '2026-05-04 20:00:00'),
404 (6, 12, 7, TIMESTAMP '2026-03-03 19:00:00'),
405 (7, 12, 7, TIMESTAMP '2026-03-10 19:00:00'),
406 (8, 11, 7, TIMESTAMP '2026-03-12 18:00:00'),
407 (9, 11, 7, TIMESTAMP '2026-04-16 18:00:00'),
408 (10, 4, 7, TIMESTAMP '2026-03-14 12:00:00'),
409 (11, 6, 5, TIMESTAMP '2026-03-08 17:00:00'),
410 (12, 3, 7, TIMESTAMP '2026-03-05 18:30:00'),
411 (13, 14, 7, TIMESTAMP '2026-03-30 18:00:00'),
412 (14, 2, 8, TIMESTAMP '2026-07-06 20:00:00'),
413 (15, 2, 8, TIMESTAMP '2026-07-08 20:00:00'),
414 (16, 2, 8, TIMESTAMP '2026-07-10 20:00:00'),
415 (17, 3, 7, TIMESTAMP '2026-06-25 18:30:00'),
416 (18, 5, 2, TIMESTAMP '2026-06-18 17:00:00'),
417 (19, 9, 4, TIMESTAMP '2026-06-19 17:00:00'),
418 (20, 10, 1, TIMESTAMP '2026-06-21 17:00:00'),
419 (21, 13, 6, TIMESTAMP '2026-04-20 17:00:00'),
420 (22, 7, 6, TIMESTAMP '2026-11-26 17:00:00'),
421 (23, 3, 7, TIMESTAMP '2026-12-01 18:30:00'),
422 (24, 14, 7, TIMESTAMP '2026-12-15 18:00:00'),
423 (25, 15, 7, TIMESTAMP '2026-03-09 21:00:00'),
424 (26, 14, 7, TIMESTAMP '2026-02-10 18:00:00'),
425 (27, 14, 7, TIMESTAMP '2026-02-24 18:00:00'),
426 (28, 14, 7, TIMESTAMP '2026-03-11 18:00:00'),
427 (29, 14, 7, TIMESTAMP '2026-05-19 18:00:00'),
428 (30, 14, 7, TIMESTAMP '2026-07-16 18:00:00'),
429 (31, 14, 7, TIMESTAMP '2026-10-06 18:00:00');
430
431INSERT INTO related_to (as_id, ee_id) VALUES
432 (14, 6),
433 (15, 6),
434 (16, 6),
435 (12, 4),
436 (17, 6),
437 (23, 8),
438 (10, 4),
439 (18, 6),
440 (19, 6),
441 (20, 6),
442 (11, 4),
443 (22, 8),
444 (13, 4),
445 (24, 8),
446 (25, 3),
447 (26, 1),
448 (27, 2),
449 (28, 3),
450 (29, 5),
451 (30, 6),
452 (31, 7);
453
454INSERT INTO applications (
455 student_index, ee_id, ef_no, motivational_letter, application_type, application_status
456) VALUES
457 (230010, 1, 1, 'I want to organise a productive winter weekend with enough space for bonding and rest.', 'event_function', 'accepted'),
458 (230013, 3, 1, 'I want to coordinate the birthday celebration and include members from different generations.', 'event_function', 'accepted'),
459 (230001, 4, 1, 'I want to lead Job Fair because I have experience coordinating faculty and company communication.', 'event_function', 'accepted'),
460 (230016, 4, 2, 'I want to support the Job Fair team by coordinating logistics and the daily schedule.', 'event_function', 'accepted'),
461 (230005, 4, 3, 'I want to contact companies and build partnerships for Job Fair.', 'event_function', 'accepted'),
462 (230011, 4, 4, 'I want to help with company relations and make the stands useful for students.', 'event_function', 'accepted'),
463 (230009, 4, 5, 'I want to handle venue logistics for FEEIT, MFS and INNOFEIT.', 'event_function', 'accepted'),
464 (230006, 4, 6, 'I want to promote Job Fair clearly to students and companies.', 'event_function', 'accepted'),
465 (230015, 4, 7, 'I want to work on sponsorship packages and support FR calls.', 'event_function', 'accepted'),
466 (230007, 4, 8, 'I want to manage the technical side and online information for Job Fair.', 'event_function', 'accepted'),
467 (230008, 4, 9, 'I want to create a consistent visual identity for Job Fair.', 'event_function', 'accepted'),
468 (230012, 5, 1, 'I want to organise a spring motivational weekend before the exam period.', 'event_function', 'accepted'),
469 (230002, 6, 1, 'I want to coordinate the summer course and keep the team aligned before participants arrive.', 'event_function', 'accepted'),
470 (230003, 6, 2, 'I want to be responsible for the participant experience and international atmosphere.', 'event_function', 'accepted'),
471 (230009, 6, 3, 'I want to coordinate accommodation and faculty rooms for the course.', 'event_function', 'accepted'),
472 (230016, 6, 4, 'I want to support transport, dormitory logistics and weekend trip planning.', 'event_function', 'accepted'),
473 (230010, 6, 5, 'I want to organise city rally, parties and participant bonding activities.', 'event_function', 'accepted'),
474 (230013, 6, 6, 'I want to help participants experience Macedonia through cultural activities.', 'event_function', 'accepted'),
475 (230006, 6, 7, 'I want to document the course and promote it before and during the event.', 'event_function', 'accepted'),
476 (230005, 6, 8, 'I want to secure support for accommodation, food and materials.', 'event_function', 'accepted'),
477 (230007, 6, 9, 'I want to maintain participant information and technical support for the course.', 'event_function', 'accepted'),
478 (230008, 6, 10, 'I want to prepare course materials and visuals.', 'event_function', 'accepted'),
479 (230017, 6, 11, 'I want to communicate with international participants and support them during the event.', 'event_function', 'accepted'),
480 (230018, 6, 12, 'I want to coordinate lectures, workshops and academic content with the partner faculty.', 'event_function', 'accepted'),
481 (230004, 7, 1, 'I want to organise recruitment so interested students understand how BEST works.', 'event_function', 'accepted'),
482 (230014, 8, 1, 'I want to organise a hackathon focused on teamwork, innovation and real-world challenges.', 'event_function', 'accepted'),
483 (230017, 8, 2, 'I want to communicate with teams and keep the participant flow smooth.', 'event_function', 'accepted'),
484 (230005, 8, 3, 'I want to coordinate sponsorship and partner communication for the hackathon.', 'event_function', 'accepted'),
485 (230020, 8, 4, 'I want to support the technical infrastructure and team submissions.', 'event_function', 'accepted'),
486 (230021, 8, 5, 'I want to create hackathon visuals and participant materials.', 'event_function', 'accepted'),
487 (230023, 8, 6, 'I want to promote the hackathon to students and document the event.', 'event_function', 'accepted'),
488 (230024, 2, NULL, 'I want to become a young member because I want to contribute more actively to BEST Skopje.', 'young_member', 'accepted'),
489 (230025, 2, NULL, 'I want to become a young member and learn from older members.', 'young_member', 'submitted'),
490 (230015, 2, NULL, 'I want to become a mentor and help observers feel included.', 'mentor', 'accepted'),
491 (230026, 6, NULL, 'I want to attend the course because the academic topic is connected to my studies and I want to learn in an international environment.', 'event_participation', 'submitted'),
492 (230027, 6, NULL, 'I want to join the summer course to gain practical knowledge, meet students from other countries and represent my faculty well.', 'event_participation', 'accepted'),
493 (230031, 8, NULL, 'I want to participate in the hackathon because I enjoy solving real problems in a team and want to improve my practical skills.', 'event_participation', 'submitted'),
494 (230032, 8, NULL, 'I want to take part in the hackathon to work on an innovative solution and learn from mentors and other participants.', 'event_participation', 'accepted');
495
496INSERT INTO holds_event_function (
497 student_index, ee_id, ef_no
498)
499SELECT student_index, ee_id, ef_no
500FROM applications
501WHERE application_type = 'event_function'
502 AND application_status = 'accepted'
503 AND ef_no IS NOT NULL;
504
505INSERT INTO participation (
506 student_index, as_id, rsvp_status, rsvp_at, attendance_status
507) VALUES
508 (230001, 3, 'going', TIMESTAMP '2026-03-15 20:10:00', 'present'),
509 (230002, 3, 'going', TIMESTAMP '2026-03-15 20:12:00', 'present'),
510 (230003, 3, 'going', TIMESTAMP '2026-03-15 20:14:00', 'late'),
511 (230004, 3, 'going', TIMESTAMP '2026-03-15 20:16:00', 'present'),
512 (230019, 3, 'maybe', TIMESTAMP '2026-03-15 21:00:00', 'not_checked'),
513 (230024, 3, 'not_going', TIMESTAMP '2026-03-15 21:15:00', 'excused'),
514 (230001, 7, 'going', TIMESTAMP '2026-03-09 12:00:00', 'present'),
515 (230002, 7, 'going', TIMESTAMP '2026-03-09 12:05:00', 'present'),
516 (230003, 7, 'going', TIMESTAMP '2026-03-09 12:10:00', 'present'),
517 (230004, 7, 'going', TIMESTAMP '2026-03-09 12:15:00', 'present'),
518 (230005, 7, 'going', TIMESTAMP '2026-03-09 12:20:00', 'present'),
519 (230006, 7, 'going', TIMESTAMP '2026-03-09 12:25:00', 'present'),
520 (230007, 7, 'going', TIMESTAMP '2026-03-09 12:30:00', 'present'),
521 (230003, 8, 'going', TIMESTAMP '2026-03-11 15:00:00', 'present'),
522 (230005, 8, 'not_going', TIMESTAMP '2026-03-11 15:20:00', 'absent'),
523 (230006, 10, 'going', TIMESTAMP '2026-03-13 10:00:00', 'present'),
524 (230011, 10, 'going', TIMESTAMP '2026-03-13 10:20:00', 'present'),
525 (230008, 11, 'going', TIMESTAMP '2026-03-07 13:00:00', 'present'),
526 (230021, 22, 'going', TIMESTAMP '2026-11-25 11:00:00', 'not_checked'),
527 (230002, 14, 'going', TIMESTAMP '2026-07-05 21:00:00', 'present'),
528 (230003, 14, 'going', TIMESTAMP '2026-07-05 21:02:00', 'present'),
529 (230017, 14, 'going', TIMESTAMP '2026-07-05 21:08:00', 'present'),
530 (230018, 21, 'going', TIMESTAMP '2026-04-19 09:30:00', 'present'),
531 (230001, 12, 'going', TIMESTAMP '2026-03-04 11:00:00', 'present'),
532 (230005, 12, 'going', TIMESTAMP '2026-03-04 11:05:00', 'present'),
533 (230006, 12, 'going', TIMESTAMP '2026-03-04 11:10:00', 'present'),
534 (230007, 12, 'going', TIMESTAMP '2026-03-04 11:15:00', 'present'),
535 (230008, 12, 'going', TIMESTAMP '2026-03-04 11:20:00', 'present'),
536 (230009, 12, 'going', TIMESTAMP '2026-03-04 11:25:00', 'present'),
537 (230011, 12, 'going', TIMESTAMP '2026-03-04 11:30:00', 'present'),
538 (230015, 12, 'going', TIMESTAMP '2026-03-04 11:35:00', 'present'),
539 (230016, 12, 'going', TIMESTAMP '2026-03-04 11:40:00', 'present'),
540 (230001, 13, 'going', TIMESTAMP '2026-03-29 18:00:00', 'present'),
541 (230005, 13, 'going', TIMESTAMP '2026-03-29 18:05:00', 'present'),
542 (230006, 13, 'going', TIMESTAMP '2026-03-29 18:10:00', 'present'),
543 (230007, 13, 'going', TIMESTAMP '2026-03-29 18:15:00', 'present'),
544 (230008, 13, 'going', TIMESTAMP '2026-03-29 18:20:00', 'present'),
545 (230009, 13, 'going', TIMESTAMP '2026-03-29 18:25:00', 'present'),
546 (230011, 13, 'going', TIMESTAMP '2026-03-29 18:30:00', 'present'),
547 (230015, 13, 'going', TIMESTAMP '2026-03-29 18:35:00', 'present'),
548 (230016, 13, 'going', TIMESTAMP '2026-03-29 18:40:00', 'present'),
549 (230002, 17, 'going', TIMESTAMP '2026-06-24 12:00:00', 'present'),
550 (230003, 17, 'going', TIMESTAMP '2026-06-24 12:05:00', 'present'),
551 (230005, 17, 'going', TIMESTAMP '2026-06-24 12:10:00', 'present'),
552 (230006, 17, 'going', TIMESTAMP '2026-06-24 12:15:00', 'present'),
553 (230007, 17, 'going', TIMESTAMP '2026-06-24 12:20:00', 'present'),
554 (230008, 17, 'going', TIMESTAMP '2026-06-24 12:25:00', 'present'),
555 (230009, 17, 'going', TIMESTAMP '2026-06-24 12:30:00', 'present'),
556 (230010, 17, 'going', TIMESTAMP '2026-06-24 12:35:00', 'present'),
557 (230013, 17, 'going', TIMESTAMP '2026-06-24 12:40:00', 'present'),
558 (230016, 17, 'going', TIMESTAMP '2026-06-24 12:45:00', 'present'),
559 (230017, 17, 'going', TIMESTAMP '2026-06-24 12:50:00', 'present'),
560 (230018, 17, 'going', TIMESTAMP '2026-06-24 12:55:00', 'present'),
561 (230002, 30, 'going', TIMESTAMP '2026-07-15 12:00:00', 'present'),
562 (230003, 30, 'going', TIMESTAMP '2026-07-15 12:05:00', 'present'),
563 (230005, 30, 'going', TIMESTAMP '2026-07-15 12:10:00', 'present'),
564 (230006, 30, 'going', TIMESTAMP '2026-07-15 12:15:00', 'present'),
565 (230007, 30, 'going', TIMESTAMP '2026-07-15 12:20:00', 'present'),
566 (230008, 30, 'going', TIMESTAMP '2026-07-15 12:25:00', 'present'),
567 (230009, 30, 'going', TIMESTAMP '2026-07-15 12:30:00', 'present'),
568 (230010, 30, 'going', TIMESTAMP '2026-07-15 12:35:00', 'present'),
569 (230013, 30, 'going', TIMESTAMP '2026-07-15 12:40:00', 'present'),
570 (230016, 30, 'going', TIMESTAMP '2026-07-15 12:45:00', 'present'),
571 (230017, 30, 'going', TIMESTAMP '2026-07-15 12:50:00', 'present'),
572 (230018, 30, 'going', TIMESTAMP '2026-07-15 12:55:00', 'present'),
573 (230014, 23, 'going', TIMESTAMP '2026-11-30 14:00:00', 'present'),
574 (230017, 23, 'going', TIMESTAMP '2026-11-30 14:05:00', 'present'),
575 (230005, 23, 'going', TIMESTAMP '2026-11-30 14:10:00', 'present'),
576 (230020, 23, 'going', TIMESTAMP '2026-11-30 14:15:00', 'present'),
577 (230021, 23, 'going', TIMESTAMP '2026-11-30 14:20:00', 'present'),
578 (230023, 23, 'going', TIMESTAMP '2026-11-30 14:25:00', 'present'),
579 (230010, 26, 'going', TIMESTAMP '2026-02-09 12:00:00', 'present'),
580 (230004, 27, 'going', TIMESTAMP '2026-02-23 12:00:00', 'present'),
581 (230013, 28, 'going', TIMESTAMP '2026-03-10 12:00:00', 'present'),
582 (230012, 29, 'going', TIMESTAMP '2026-05-18 12:00:00', 'present'),
583 (230004, 31, 'going', TIMESTAMP '2026-10-05 12:00:00', 'present'),
584 (230014, 24, 'going', TIMESTAMP '2026-12-14 12:00:00', 'present'),
585 (230017, 24, 'going', TIMESTAMP '2026-12-14 12:05:00', 'present'),
586 (230005, 24, 'going', TIMESTAMP '2026-12-14 12:10:00', 'present'),
587 (230020, 24, 'going', TIMESTAMP '2026-12-14 12:15:00', 'present'),
588 (230021, 24, 'going', TIMESTAMP '2026-12-14 12:20:00', 'present'),
589 (230023, 24, 'going', TIMESTAMP '2026-12-14 12:25:00', 'present');
590
591INSERT INTO required_attendance (
592 student_index, as_id
593)
594SELECT student_index, as_id
595FROM (
596 SELECT fm.student_index, a.as_id
597 FROM full_members fm
598 CROSS JOIN activity_sessions a
599 JOIN activity_types at
600 ON at.at_id = a.at_id
601 WHERE at.at_name IN ('Weekly Meeting', 'Full Member Meeting')
602
603 UNION
604
605 SELECT fm.student_index, a.as_id
606 FROM function_mandates fm
607 JOIN board b
608 ON b.of_id = fm.of_id
609 CROSS JOIN activity_sessions a
610 JOIN activity_types at
611 ON at.at_id = a.at_id
612 WHERE at.at_name = 'Board Meeting'
613
614 UNION
615
616 SELECT hef.student_index, a.as_id
617 FROM holds_event_function hef
618 JOIN related_to rt
619 ON rt.ee_id = hef.ee_id
620 JOIN activity_sessions a
621 ON a.as_id = rt.as_id
622 JOIN activity_types at
623 ON at.at_id = a.at_id
624 WHERE at.at_name = 'Core Team Meeting'
625
626 UNION
627
628 SELECT fm.student_index, a.as_id
629 FROM function_mandates fm
630 JOIN board b
631 ON b.of_id = fm.of_id
632 CROSS JOIN activity_sessions a
633 JOIN activity_types at
634 ON at.at_id = a.at_id
635 WHERE at.at_name = 'Event Evaluation'
636
637 UNION
638
639 SELECT hef.student_index, a.as_id
640 FROM holds_event_function hef
641 JOIN related_to rt
642 ON rt.ee_id = hef.ee_id
643 JOIN activity_sessions a
644 ON a.as_id = rt.as_id
645 JOIN activity_types at
646 ON at.at_id = a.at_id
647 WHERE at.at_name = 'Event Evaluation'
648) mandatory_attendance
649ORDER BY as_id, student_index;
650
651INSERT INTO announces_absence (
652 student_index, as_id, reason, announced_at
653) VALUES
654 (230011, 1, 'Traveling back to Skopje after the weekend.', TIMESTAMP '2026-02-08 19:30:00'),
655 (230008, 3, 'Sick and unable to attend the weekly meeting.', TIMESTAMP '2026-03-16 12:30:00'),
656 (230018, 5, 'Faculty project deadline on the same evening.', TIMESTAMP '2026-05-03 21:00:00'),
657 (230003, 6, 'Faculty obligations at the same time.', TIMESTAMP '2026-03-02 15:18:00'),
658 (230004, 6, 'Family obligation outside Skopje.', TIMESTAMP '2026-03-02 21:10:00'),
659 (230005, 8, 'Faculty laboratory exercise at the same time.', TIMESTAMP '2026-03-11 15:18:00'),
660 (230010, 9, 'Project deadline at faculty.', TIMESTAMP '2026-04-15 19:00:00'),
661 (230001, 24, 'University exam preparation session.', TIMESTAMP '2026-12-14 18:20:00'),
662 (230007, 26, 'Cannot attend because of work obligations.', TIMESTAMP '2026-02-09 16:30:00'),
663 (230006, 27, 'Personal obligation during the evaluation time.', TIMESTAMP '2026-02-23 20:00:00'),
664 (230005, 28, 'Sponsor meeting for another activity.', TIMESTAMP '2026-03-10 16:45:00'),
665 (230006, 29, 'Company meeting for sponsorship preparation.', TIMESTAMP '2026-05-18 13:00:00'),
666 (230002, 31, 'Faculty laboratory work at the same time.', TIMESTAMP '2026-10-05 19:00:00');
667
668INSERT INTO responsible_for (
669 student_index, as_id
670) VALUES
671 (230001, 1),
672 (230001, 2),
673 (230001, 3),
674 (230001, 4),
675 (230001, 5),
676 (230001, 6),
677 (230001, 7),
678 (230001, 8),
679 (230001, 9),
680 (230001, 13),
681 (230001, 24),
682 (230001, 26),
683 (230001, 27),
684 (230001, 28),
685 (230001, 29),
686 (230001, 30),
687 (230001, 31),
688 (230002, 14),
689 (230003, 14),
690 (230002, 15),
691 (230003, 15),
692 (230002, 16),
693 (230003, 16),
694 (230016, 12),
695 (230017, 17),
696 (230014, 23),
697 (230006, 18),
698 (230008, 11),
699 (230020, 22),
700 (230015, 10),
701 (230015, 8),
702 (230009, 19),
703 (230010, 20),
704 (230004, 21),
705 (230014, 21),
706 (230018, 21),
707 (230013, 25);
708
709INSERT INTO volunteers (
710 student_index, ee_id, es_no, volunteer_role
711) VALUES
712 (230019, 4, 2, 'stand support'),
713 (230020, 4, 2, 'stand support'),
714 (230021, 4, 3, 'student guide'),
715 (230022, 4, 1, 'guest welcome'),
716 (230023, 4, 5, 'closing support'),
717 (230010, 6, 5, 'group guide'),
718 (230013, 6, 6, 'social party organiser'),
719 (230016, 6, 7, 'trip logistics'),
720 (230018, 6, 2, 'observer of academic sessions'),
721 (230024, 7, 1, 'registration desk'),
722 (230019, 7, 2, 'observer support'),
723 (230020, 8, 2, 'technical support'),
724 (230021, 8, 3, 'break support'),
725 (230022, 8, 4, 'lunch support'),
726 (230023, 8, 7, 'closing speaker');
727
728INSERT INTO companies (c_id, c_name, naframa_reference) VALUES
729 (1, 'Netcetera', 'NAFRAMA-1001'),
730 (2, 'Endava', 'NAFRAMA-1002'),
731 (3, 'Seavus Education and Development Center', 'NAFRAMA-1003'),
732 (4, 'CodeWell', 'NAFRAMA-1004'),
733 (5, 'Slice', 'NAFRAMA-1005'),
734 (6, 'EVN Macedonia', 'NAFRAMA-1006');
735
736INSERT INTO cooperation (
737 c_id, ee_id, cooperation_type
738) VALUES
739 (1, 4, 'sponsor'),
740 (2, 4, 'participant'),
741 (3, 4, 'participant'),
742 (4, 4, 'participant'),
743 (1, 6, 'supporter'),
744 (5, 6, 'partner'),
745 (1, 8, 'partner'),
746 (2, 8, 'challenge_provider'),
747 (6, 3, 'supporter');
748
749COMMIT;