= UC0002 - Create Activity Session =

'''Initiating actor:''' Board Member

A Board Member creates an activity session and records who is responsible for it. The scenario creates a PR workshop connected to BEST Course in Summer 2026.

== Scenario ==

1. The Board Member opens the activity session creation form.

2. The application lists available activity types.

{{{#!sql
SELECT
    at_name,
    at_description
FROM activity_types
ORDER BY at_name;
}}}

3. The Board Member enters the activity session data.

4. The application stores the activity session.

{{{#!sql
INSERT INTO activity_sessions (
    at_name,
    as_start_time,
    as_location
)
VALUES (
    'PR Workshop',
    TIMESTAMP '2026-06-22 17:00:00',
    'Baraka 2.1'
);
}}}

5. The application records the responsible member.

{{{#!sql
INSERT INTO responsible_for (
    student_index,
    at_name,
    as_start_time,
    as_location
)
VALUES (
    230006,
    'PR Workshop',
    TIMESTAMP '2026-06-22 17:00:00',
    'Baraka 2.1'
);
}}}

6. The application links the activity session to BEST Course in Summer 2026.

{{{#!sql
INSERT INTO related_to (
    at_name,
    as_start_time,
    as_location,
    et_name,
    event_title,
    event_start_time
)
VALUES (
    'PR Workshop',
    TIMESTAMP '2026-06-22 17:00:00',
    'Baraka 2.1',
    'BEST Course in Summer',
    'BEST Course in Summer 2026',
    TIMESTAMP '2026-07-05 12:00:00'
);
}}}

7. The application shows the created activity session.

{{{#!sql
SELECT
    a.at_name,
    a.as_start_time,
    a.as_location,
    s.first_name || ' ' || s.last_name AS responsible_member,
    rt.et_name,
    rt.event_title
FROM activity_sessions a
JOIN responsible_for rf
    ON rf.at_name = a.at_name
   AND rf.as_start_time = a.as_start_time
   AND rf.as_location = a.as_location
JOIN students s
    ON s.student_index = rf.student_index
LEFT JOIN related_to rt
    ON rt.at_name = a.at_name
   AND rt.as_start_time = a.as_start_time
   AND rt.as_location = a.as_location
WHERE a.at_name = 'PR Workshop'
  AND a.as_start_time = TIMESTAMP '2026-06-22 17:00:00'
  AND a.as_location = 'Baraka 2.1';
}}}