/*
 Create new event for one or more calendars or users
 If calendars are provided, the event will be added to all calendars
 If usernames are provided, the event will be added to default calendars of the users
 If you are a manager creating events for your employees, you want to provide usernames
    If you are a user creating events for yourself, you want to provide calendars
 Note that you will be using mostly single calendar or username, array is more for future scenarios
 */
create or replace function api."AddCalendarEvent"(
    start_dt timestamptz
, calendars uuid[] -- either calendars or usernames
, usernames name[] -- either calendars or usernames
, event_location capitalshorttext
, event_type capitaltext
, end_dt timestamptz default null
, duration int default null
, notes text default null
, "data" jsonb default null
, out _event calendars.events
)