HVC Services — Data

• Project: hvc-services

Overview

The service reads/writes these main tables (per tenant DB):

Table	Usage
emailOutboxEntries	Emails queued for sending; polled by EmailSenderService
MediaFile	Media records created when a recording is stored
FileShare	Share records created alongside media
ScheduledEvents	Event rows updated with hasRecording after a recording is stored

Email outbox

• The email sender polls emailOutboxEntries in batches, sending new entries and tracking the cursor (lastId/prevId).
• Retries/back-off apply per entry; failure reasons are recorded on the entry.

Recordings

• Recording files are identified by the env__eventId__tenantId__... filename convention.
• After download, the service creates MediaFile + FileShare rows and sets hasRecording on the matching ScheduledEvents row.

Related

• Workers
• Data model overview