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.

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.

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.

INSERT INTO event_edition_locations (ee_id, l_id) VALUES
    (1001, 12),
    (1001, 13),
    (1001, 14);

6. The application stores the event function slots.

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.

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;