= 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;
}}}