# RecordingChapters ## Documentation The chapters of the registrations: the timeline that ties the video to the agenda. Read from the export of the platform, 1 000 records per request, for every selected source: a full read of every source takes over 100 minutes at the rate limit of the platform, one source of 20 000 records some 20 seconds. Narrow it with use <source>@obv. - Catalog: `OpenBesluitvorming` - Schema: `Export` - Primary Keys: `recording_entity_id, start_seconds` The data in this table is partitioned per value of the `` column. This is a read-only table. The Open Besluitvorming API may not support changing the data or the Invantive UniversalSQL driver for Open Besluitvorming does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Open Besluitvorming API. ## Table Columns The columns of the table `RecordingChapters` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `agenda_item_id` | `varchar2` | | ☐ | The agenda item discussed. | | `end_seconds` | `decimal` | | ☐ | Where it ends. | | `recording_entity_id` | `varchar2` | | ☑ | The registration. | | `source_key` | `varchar2` | | ☑ | The source. | | `start_seconds` | `decimal` | | ☑ | Where the chapter starts, in seconds from the start. | | `title` | `varchar2` | | ☐ | The title, usually that of the agenda item. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `agenda_item_id` | [[Export-MeetingAgendaItems\|Export.MeetingAgendaItems]] | `agenda_item_id` | In words only: The agenda item a chapter of the registration discusses. | | `recording_entity_id` | [[Export-Recordings\|Export.Recordings]] | `entity_id` | Declared by the connector, not enforced by the platform |