= UC0005 - Create Event Edition and Event Functions =

'''Initiating actor:''' Board Member

A Board Member creates an event edition, adds its locations, and defines event functions. In this scenario, the Board Member is acting as the President.

== Scenario ==

1. The Board Member opens the create event edition page.

2. The application lists event types, event function types and locations.

{{{#!sql
SELECT
    et_id,
    et_name
FROM event_types
ORDER BY et_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 relevant information.

4. The application stores the event edition.

{{{#!sql
INSERT INTO event_editions (
    ee_id,
    et_id,
    ee_title,
    ee_start_time,
    ee_end_time
) VALUES (
    1001,
    2,
    'Job Fair 2027',
    TIMESTAMP '2027-03-22 09:00:00',
    TIMESTAMP '2027-03-26 18:00:00'
);
}}}

5. The application stores the event edition locations.

{{{#!sql
INSERT INTO event_edition_locations (ee_id, l_id) VALUES
    (1001, 12),
    (1001, 13),
    (1001, 14);
}}}

6. The application stores the event function slots.

{{{#!sql
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);
}}}

7. The application shows the created event edition, locations, and event functions.

{{{#!sql
SELECT
    ee.ee_id,
    et.et_name,
    ee.ee_title,
    ee.ee_start_time,
    ee.ee_end_time
FROM event_editions ee
JOIN event_types et
    ON et.et_id = ee.et_id
WHERE ee.ee_id = 1001;

SELECT
    l.l_id,
    l.l_name
FROM event_edition_locations eel
JOIN locations l
    ON l.l_id = eel.l_id
WHERE eel.ee_id = 1001
ORDER BY l.l_name;

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