Changes between Version 2 and Version 3 of UseCase0005

Timestamp:

09/02/26 20:32:36 (4 days ago)

Author:

236024

Comment:

--

UseCase0005

@@ -9 +9 @@
 1. The Board Member opens the create event edition page.
 
-2. The application lists event types and locations.
+2. The application lists event types, event function types and locations.
 
 {{{#!sql
-SELECT et_id, et_name
+SELECT
+    et_id,
+    et_name
 FROM event_types
 ORDER BY et_name;
 
-SELECT l_id, l_name
+SELECT
+    eft_id,
+    eft_name
+FROM event_function_types
+ORDER BY eft_name;
+
+SELECT
+    l_id,
+    l_name
 FROM locations
 ORDER BY l_name;
 }}}
 
-3. The Board Member enters Job Fair 2027 with the selected event type and dates.
+3. The Board Member enters Job Fair 2027 with the relevant information.
 
 4. The application stores the event edition.
@@ -53 +63 @@
 
 {{{#!sql
-INSERT INTO event_functions (ee_id, ef_no, ef_name) VALUES
-    (1001, 1, 'Main Organiser 1'),
-    (1001, 2, 'Main Organiser 2'),
-    (1001, 3, 'Corporate Relations Responsible 1'),
-    (1001, 4, 'Corporate Relations Responsible 2'),
-    (1001, 5, 'Logistics Responsible'),
-    (1001, 6, 'PR Responsible'),
-    (1001, 7, 'FR Responsible'),
-    (1001, 8, 'IT Responsible'),
-    (1001, 9, 'Design Responsible');
+INSERT INTO event_functions (
+    ee_id,
+    ef_no,
+    eft_id
+)
+VALUES
+    (1001, 1, 1),
+    (1001, 2, 1),
+    (1001, 3, 2),
+    (1001, 4, 2),
+    (1001, 5, 3),
+    (1001, 6, 4),
+    (1001, 7, 5),
+    (1001, 8, 6),
+    (1001, 9, 7);
 }}}
 
@@ -88 +103 @@
 ORDER BY l.l_name;
 
-SELECT ef_no, ef_name
-FROM event_functions
-WHERE ee_id = 1001
-ORDER BY ef_no;
+SELECT
+    ef.ef_no,
+    eft.eft_name
+FROM event_functions ef
+JOIN event_function_types eft
+    ON eft.eft_id = ef.eft_id
+WHERE ef.ee_id = 1001
+ORDER BY ef.ef_no;
 }}}