Changes between Initial Version and Version 1 of UseCase0005

Timestamp:

08/29/26 18:56:43 (8 days ago)

Author:

236024

Comment:

--

UseCase0005

@@ +1 @@
+= UC0005 - Create Event Edition and Programme =
+
+'''Initiating actor:''' Board Member
+
+A Board Member creates an event edition and defines its main data. The scenario creates Job Fair 2027 with locations, function slots, and programme sessions.
+
+== Scenario ==
+
+1. The Board Member opens the event administration page.
+
+2. The application lists event types.
+
+{{{#!sql
+SELECT
+    et_name,
+    et_description
+FROM event_types
+ORDER BY et_name;
+}}}
+
+3. The Board Member enters the event edition data.
+
+4. The application stores the event edition.
+
+{{{#!sql
+INSERT INTO event_editions (
+    et_name,
+    event_title,
+    event_start_time,
+    event_end_time
+)
+VALUES (
+    'Job Fair',
+    'Job Fair 2027',
+    TIMESTAMP '2027-03-22 09:00:00',
+    TIMESTAMP '2027-03-26 18:00:00'
+);
+}}}
+
+5. The Board Member enters the event locations.
+
+6. The application stores the event locations.
+
+{{{#!sql
+INSERT INTO event_edition_locations (
+    et_name,
+    event_title,
+    event_start_time,
+    location
+)
+VALUES
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'INNOFEIT'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'FEEIT'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'MFS');
+}}}
+
+7. The Board Member enters the planned event function slots.
+
+8. The application stores the event function slots.
+
+{{{#!sql
+INSERT INTO core_team_functions (
+    et_name,
+    event_title,
+    event_start_time,
+    function_name
+)
+VALUES
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Main Organiser 1'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Main Organiser 2'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Corporate Relations Responsible 1'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Corporate Relations Responsible 2'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Logistics Responsible'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'PR Responsible'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'FR Responsible'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'IT Responsible'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Design Responsible');
+}}}
+
+9. The Board Member enters programme sessions.
+
+10. The application stores the programme sessions.
+
+{{{#!sql
+INSERT INTO event_sessions (
+    et_name,
+    event_title,
+    event_start_time,
+    est_name,
+    es_start_time,
+    location,
+    es_title
+)
+VALUES
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00',
+     'Official Opening', TIMESTAMP '2027-03-22 10:00:00', 'INNOFEIT', 'Job Fair Opening Ceremony'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00',
+     'Company Stands', TIMESTAMP '2027-03-23 10:00:00', 'FEEIT', 'Technical Companies Stands'),
+    ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00',
+     'Company Stands', TIMESTAMP '2027-03-23 10:00:00', 'MFS', 'Engineering Companies Stands');
+}}}
+
+11. The application shows the programme for Job Fair 2027.
+
+{{{#!sql
+SELECT
+    es.est_name,
+    es.es_start_time,
+    es.location,
+    es.es_title
+FROM event_sessions es
+WHERE es.et_name = 'Job Fair'
+  AND es.event_title = 'Job Fair 2027'
+  AND es.event_start_time = TIMESTAMP '2027-03-22 09:00:00'
+ORDER BY es.es_start_time, es.location, es.est_name;
+}}}
+
+12. The application shows the function slots for Job Fair 2027.
+
+{{{#!sql
+SELECT
+    ctf.function_name
+FROM core_team_functions ctf
+WHERE ctf.et_name = 'Job Fair'
+  AND ctf.event_title = 'Job Fair 2027'
+  AND ctf.event_start_time = TIMESTAMP '2027-03-22 09:00:00'
+ORDER BY ctf.function_name;
+}}}