Changes between Version 1 and Version 2 of UseCase0006

Timestamp:

09/02/26 17:52:21 (4 days ago)

Author:

236024

Comment:

--

UseCase0006

@@ -7 +7 @@
 == Scenario ==
 
-1. The Student opens the Hackathon participation application form.
+1. The Student opens the application page.
 
 2. The application lists event editions that accept participation applications.
@@ -13 +13 @@
 {{{#!sql
 SELECT
-    ee.et_name,
-    ee.event_title,
-    ee.event_start_time,
-    ee.event_end_time
+    ee.ee_id,
+    et.et_name,
+    ee.ee_title,
+    ee.ee_start_time,
+    ee.ee_end_time
 FROM event_editions ee
-WHERE ee.et_name IN ('Hackathon', 'BEST Course in Summer')
-ORDER BY ee.event_start_time;
+JOIN event_types et
+    ON et.et_id = ee.et_id
+WHERE et.et_name IN ('Hackathon', 'BEST Course in Summer')
+  AND ee.ee_start_time >= CURRENT_TIMESTAMP
+ORDER BY ee.ee_start_time;
 }}}
 
@@ -37 +41 @@
     email,
     phone_number
-)
-VALUES (
+) VALUES (
     230033,
     'Martina',
@@ -51 +54 @@
 }}}
 
-5. The Student enters a motivational letter.
-
-6. The application stores the submitted application.
+5. The application stores the submitted application.
 
 {{{#!sql
 INSERT INTO applications (
     student_index,
-    et_name,
-    event_title,
-    event_start_time,
-    function_name,
+    ee_id,
+    ef_no,
     motivational_letter,
     application_type,
     application_status
-)
-VALUES (
+) VALUES (
     230033,
-    'Hackathon',
-    'Impact Hackathon 2026',
-    TIMESTAMP '2026-12-12 09:00:00',
+    8,
     NULL,
     'I want to participate in the hackathon because I want to solve a real challenge with a team and improve my practical skills.',
@@ -78 +74 @@
 }}}
 
-7. The application shows the submitted application.
+6. The application shows the submitted application.
 
 {{{#!sql
@@ -85 +81 @@
     s.first_name,
     s.last_name,
-    a.et_name,
-    a.event_title,
-    a.function_name,
+    et.et_name,
+    ee.ee_title,
     a.application_type,
     a.application_status
@@ -93 +88 @@
 JOIN students s
     ON s.student_index = a.student_index
-WHERE s.email = 'martina.ilievska@student.ukim.mk'
-  AND a.et_name = 'Hackathon'
-  AND a.event_title = 'Impact Hackathon 2026'
-  AND a.event_start_time = TIMESTAMP '2026-12-12 09:00:00';
+JOIN event_editions ee
+    ON ee.ee_id = a.ee_id
+JOIN event_types et
+    ON et.et_id = ee.et_id
+WHERE a.student_index = 230033
+  AND a.ee_id = 8;
 }}}