Centurio Süsteem- & modulidokumendid
🏛️ Platvorm arhitektuur 🔑 Login
🏠 Kõik moodulid / crm_office / Aegakalendid & konverentsid
📘

Aegakalendid & konverentsid

calendar crm_office 🛡️ RLS Protected

Koodi- ja API-dokumendid

Fachliche Bestimmung: Kalendris ja konverentsides <unk> koodist saadud protsesside ja API-dokumendid.

⚡ Töövoogud ja elutsüklid

Kasutaja käsk: kalendriagent plan:command_calendar_agent

Kontrollitud püsivkava (durable_plan), algus: manuell_command.

1. calendar_agent
calendar_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: calendar_agent

🗄️ Andme mudelid & väljad

CalendarAttendees calendar_attendees RLS Aktiv
16 Kärgid / varud

Tabelle calendar_attendees

Feldname Andme tüüp Kohustus Schlüssel Tööandjapidamis
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 Kärgid / varud

Tabelle calendar_events

Feldname Andme tüüp Kohustus Schlüssel Tööandjapidamis
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 Kärgid / varud

Tabelle calendar_feed_tokens

Feldname Andme tüüp Kohustus Schlüssel Tööandjapidamis
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 Kärgid / varud

Tabelle meeting_rooms

Feldname Andme tüüp Kohustus Schlüssel Tööandjapidamis
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

🔌 Algsed punktid (UI ja API)

Art Teadus Lõpppunkt / tee Titel & Zweck Õigustamine
⚡ 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
kättesaadavuse
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
vastust
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

🛡️ Määruse ja vastavus

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • Töötlusvõime
  • Kliendi isolatsioon (postgreSQL RLS)