title: "ReservationOccurrence (table)" category: reference tags: [table, reservationoccurrence, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ReservationOccurrence
Schema: dba
Aantal kolommen: 40
Zie ook de entity-pagina: ../entities/ReservationOccurrence
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
ResocResId |
nvarchar(6) | Nee | — | — |
ResocId |
nvarchar(4) | Nee | — | — |
ResocContext |
bigint | Nee | ((0)) | — |
ResocRecStatus |
int | Nee | ((0)) | — |
ResocApplicantEmpId |
nvarchar(9) | Ja | — | — |
ResocCanceledDate |
datetimeoffset(7) | Ja | — | — |
ResocCanceledEmpId |
nvarchar(9) | Ja | — | — |
ResocCompId |
nvarchar(6) | Nee | — | — |
ResocCreatedDate |
datetimeoffset(7) | Ja | — | — |
ResocCreatedEmpId |
nvarchar(9) | Ja | — | — |
ResocDataProvider |
nvarchar(50) | Ja | — | — |
ResocEndDate |
datetimeoffset(7) | Ja | — | — |
ResocExchangeFailCount |
int | Nee | ((0)) | — |
ResocExported |
smallint | Nee | ((0)) | — |
ResocExternalId |
nvarchar(50) | Ja | — | — |
ResocExternalStatus |
nvarchar(50) | Ja | — | — |
ResocLastChange |
datetimeoffset(7) | Ja | — | — |
ResocLastEmailDate |
datetimeoffset(7) | Ja | — | — |
ResocNoShow |
smallint | Nee | ((0)) | — |
ResocNoShowReason |
nvarchar(100) | Ja | — | — |
ResocNumberOfPersons |
int | Nee | ((0)) | — |
ResocPartiallyProcessedConflictDate |
datetimeoffset(7) | Ja | — | — |
ResocPartiallyProcessedConflictEmpId |
nvarchar(9) | Ja | — | — |
ResocPartiallyProcessedDate |
datetimeoffset(7) | Ja | — | — |
ResocPartiallyProcessedEmpId |
nvarchar(9) | Ja | — | — |
ResocProcessedConflictDate |
datetimeoffset(7) | Ja | — | — |
ResocProcessedConflictEmpId |
nvarchar(9) | Ja | — | — |
ResocProcessedDate |
datetimeoffset(7) | Ja | — | — |
ResocProcessedEmpId |
nvarchar(9) | Ja | — | — |
ResocProviderMutDate |
datetimeoffset(7) | Ja | — | — |
ResocRecChangeDate |
datetimeoffset(7) | Ja | — | — |
ResocRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
ResocRequestedConflictDate |
datetimeoffset(7) | Ja | — | — |
ResocRequestedConflictEmpId |
nvarchar(9) | Ja | — | — |
ResocRequestedDate |
datetimeoffset(7) | Ja | — | — |
ResocRequestedEmpId |
nvarchar(9) | Ja | — | — |
ResocSitId |
nvarchar(8) | Ja | — | — |
ResocStartDate |
datetimeoffset(7) | Ja | — | — |
ResocText |
nvarchar(max) | Ja | — | — |
ResocTransferNextTime |
smallint | Nee | ((0)) | — |
Trigger-gevulde kolommenbewerken
ResocRecChangeDate← TR_RESERVATIONOCCURRENCE
Brondatabewerken
- DB-schema —
lookup_table_schema("ReservationOccurrence")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ReservationOccurrence")· ../entities/ReservationOccurrence Properties, contexts, statussen. Bron:Entities.xml.