Phone Call Schema

Call direction

Phone number of the caller

Phone number that was called

Digits-only search key derived from callerNumber (internal)

Digits-only search key derived from calledNumber (internal)

Total call duration in seconds

Linked party (customer/contact)

Linked contact person

User who handled the call

Users whose phone rang during this call. Populated for inbound PBX calls (Starface CALLFLOW with CALLED_TYPE=USER) so missed calls show up under "my calls" for everyone whose extension rang, not just the (non-existent) handler.

DEPRECATED (ADR 0386) — legacy single ticket link, superseded by `linkedEntities`. No UI ever wrote it; only read by the activity consumer, which now prefers `linkedEntities`.

DEPRECATED (ADR 0386) — legacy single opportunity link, superseded by `linkedEntities`. Still READ (existing calls keep showing their link) and cleared when the user removes that chip, but never written for new links. Do not add new consumers.

Free-form cross-entity links (ADR 0386). A call is a touchpoint that can concern several records at once — two tickets, a complaint and the opportunity it came from — so this replaces the single-valued `ticketId`/`opportunityId` fields.

Free-text note about the call

Manual 1-5 star rating of how the conversation went. Aggregated per contact person on the party detail page.

Manual tone assessment of the conversation (freundlich / neutral / schwierig)

Free-text note on the counterpart ("gut erreichbar", "entscheidet nicht selbst"). Kept separate from `note` (what was discussed) so the assessment can be permission-gated later without hiding the call content.

Internal user id (`users._id`) who left the assessment

When the assessment was last changed

Whether a callback was requested

When the call started (ISO 8601 on the wire; stored as BSON Date)

When the call ended (ISO 8601 on the wire; stored as BSON Date)

Caller name from PBX

Called party name from PBX

PBX account ID of the caller (-1 for external)

Whether the call was answered

Whether this was an internal call

Whether the call was picked up by another user

External PBX call UUID (e.g. Starface CALL_UUID)

Source of the call record

Microsoft Graph call record ID

Teams call type: peer-to-peer calling or group meeting

Teams meeting join URL (for meeting-type calls)

Teams call participants

Communication modalities used (audio, video, screen share)

Detailed call routing steps from PBX

Time the caller waited before pickup or abandonment (INBOUND only)

Raw webhook payload for future analysis

Time record ID created from this call (marks call as booked)

FreeSWITCH call UUID

SIP trunk used

Extension that handled the call

ACD queue if routed through queue

pbx_recording entity ID

Call transcript from STT

AI-generated call summary

Sentiment score -1 (negative) to 1 (positive)