Centurio System and module documentation
๐Ÿ›๏ธ Platform architecture ๐Ÿ”‘ Login
๐Ÿ  All modules / crm_office / Calendar and conferences
๐Ÿ“˜

Calendar and conferences

calendar crm_office ๐Ÿ›ก๏ธ RLS Protected

Calendar of dates & conferences <unk> Process and API documentation derived from code.

Fachliche Bestimmung: Calendar & Conference <unk> Process and API documentation derived from code. It contains all registered processes, capabilities, state machines, APIs and tables for simulations and reviews.

โšก Workflows and life cycles

The following information shall be provided: plan:command_calendar_agent

The following is the list of the main functions of the system:

1. calendar_agent
calendar_agent
The following is the list of the products:
Aktionen: calendar_agent

๐Ÿ—„๏ธ Data models and fields

CalendarAttendees calendar_attendees RLS Aktiv
16 Fields and columns

Tabelle calendar_attendees

Feldname Type of data The Commission Schlรผssel The technical significance
event_id UUID Ja * FK โž” calendar_events.id Feld event_id
user_id UUID Nein FK โž” users.id Feld user_id
name VARCHAR(255) Nein - Feld name
email VARCHAR(320) Nein - Feld email
required BOOLEAN Ja * - Feld required
response VARCHAR(12) Ja * - Feld response
responded_at DATETIME Nein - Feld responded_at
id UUID Nein PK Feld id
tenant_id UUID Ja * FK โž” organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata
CalendarEvents calendar_events RLS Aktiv
33 Fields and columns

Tabelle calendar_events

Feldname Type of data The Commission Schlรผssel The technical significance
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
start_time DATETIME Ja * - Feld start_time
end_time DATETIME Ja * - Feld end_time
all_day BOOLEAN Ja * - Feld all_day
event_type VARCHAR(48) Ja * - Feld event_type
color VARCHAR(32) Nein - Feld color
location VARCHAR(255) Nein - Feld location
video_call_url VARCHAR(512) Nein - Feld video_call_url
video_call_provider VARCHAR(32) Ja * - Feld video_call_provider
assigned_user_id UUID Nein FK โž” users.id Feld assigned_user_id
customer_id UUID Nein FK โž” customers.id Feld customer_id
entity_type VARCHAR(64) Nein - Feld entity_type
entity_id UUID Nein - Feld entity_id
attendees JSONB Ja * - Feld attendees
organizer_id UUID Nein FK โž” users.id Feld organizer_id
recurrence JSONB Nein - Feld recurrence
reminder_minutes INTEGER Nein - Feld reminder_minutes
org_unit_id UUID Nein FK โž” org_units.id Feld org_unit_id
meeting_room_id UUID Nein FK โž” meeting_rooms.id Feld meeting_room_id
status VARCHAR(32) Ja * - Feld status
visibility VARCHAR(32) Ja * - Feld visibility
ical_uid VARCHAR(128) Ja * - Feld ical_uid
id UUID Nein PK Feld id
tenant_id UUID Ja * FK โž” organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata
deleted_at DATETIME Nein - Feld deleted_at
CalendarFeedTokens calendar_feed_tokens RLS Aktiv
14 Fields and columns

Tabelle calendar_feed_tokens

Feldname Type of data The Commission Schlรผssel The technical significance
user_id UUID Ja * FK โž” users.id Feld user_id
token_hash VARCHAR(64) Ja * - Feld token_hash
label VARCHAR(64) Nein - Feld label
last_used_at DATETIME Nein - Feld last_used_at
revoked_at DATETIME Nein - Feld revoked_at
id UUID Nein PK Feld id
tenant_id UUID Ja * FK โž” organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata
MeetingRooms meeting_rooms RLS Aktiv
18 Fields and columns

Tabelle meeting_rooms

Feldname Type of data The Commission Schlรผssel The technical significance
room_key VARCHAR(64) Ja * - Feld room_key
title VARCHAR(255) Ja * - Feld title
kind VARCHAR(8) Ja * - Feld kind
mode VARCHAR(8) Ja * - Feld mode
event_id UUID Nein FK โž” calendar_events.id Feld event_id
channel_id UUID Nein FK โž” chat_channels.id Feld channel_id
invited_user_ids JSONB Ja * - Feld invited_user_ids
invited_portal_user_ids JSONB Ja * - Feld invited_portal_user_ids
ended_at DATETIME Nein - Feld ended_at
id UUID Nein PK Feld id
tenant_id UUID Ja * FK โž” organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata

๐Ÿ”Œ The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

Art The method Endpoint / path Titel & Zweck The Commission shall adopt the following:
โšก REST API DELETE /api/v1/calendar/events/{event_id}
delete_event
Semantic binding: operator_surface; mutation=True
calendar
โšก REST API DELETE /api/v1/calendar/feed-tokens/{token_id}
revoke_feed_token
Semantic binding: operator_surface; mutation=True
calendar
โšก REST API GET /api/v1/calendar/availability
Availability
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /api/v1/calendar/events
list_events
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /api/v1/calendar/events/{event_id}
get_event
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /api/v1/calendar/feed-tokens
list_feed_tokens
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /calendar
calendar_page
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /calendar/feed.ics
calendar_ical_download
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /calendar/feed/{token}.ics
calendar_ical_subscription
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /calendar/meeting/{room_key}
legacy_meeting_route
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /kalender
calendar_page
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /kalender/feed.ics
calendar_ical_download
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /meeting/{room_key}
meeting_page
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API GET /portal/{slug}/termine
appointments_page
Semantic binding: inventory_only; mutation=False
calendar
โšก REST API PATCH /api/v1/calendar/events/{event_id}
update_event
Semantic binding: operator_surface; mutation=True
calendar
โšก REST API POST /api/v1/calendar/events
create_event
Semantic binding: operator_surface; mutation=True
calendar
โšก REST API POST /api/v1/calendar/events/{event_id}/respond
- to respond
Semantic binding: operator_surface; mutation=True
calendar
โšก REST API POST /api/v1/calendar/feed-tokens
create_feed_token
Semantic binding: operator_surface; mutation=True
calendar
โšก REST API POST /api/v1/calendar/meetings/quick-room
quick_room
Semantic binding: operator_surface; mutation=True
calendar
โšก REST API POST /portal/{slug}/termine/anfragen
appointment_request
Semantic binding: operator_surface; mutation=True
calendar
โšก REST API POST /portal/{slug}/termine/anfragen/{request_id}/stornieren
appointment_request_cancel
Semantic binding: operator_surface; mutation=True
calendar

๐Ÿ›ก๏ธ Regulatory and compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • The Commission shall adopt the following implementing acts:
  • The following information shall be provided: