HVC Sink Api — Data

• Project: hvc-sinkapi

Tenant DB

Table	Usage
virtualMeetingRooms	Rooms assigned to events; read for matching, cleared after use (assignedOn = null, eventId = 0)
ScheduledEvents	Marked isCompleted = 1, hasLedger = 1, status = 'completed' + duration notes
scheduledEventLogEntries	Per-participant joined/left logs + started/ended
eventInstances	One row per finalized conference (pexipConferenceId)
pexipDataEntries	Holds the generated SQL for later execution by the tenant sync service
contacts	Read for specialty/department enrichment of meetings

Admin DB

Table	Usage
Meetings	Created per finalized conference (participantCount, duration, hasRecording, hasRapidConnect, specialist/department)
MeetingParticipants	Per-participant rows (callQuality, name, duration, vendor, source, disconnectReason, start/end time)

The mapping between the two DBs uses tenants.externalTenantId (tenant DB) → tenants.id (admin DB).

Related

• Workers
• Data model overview