Bewerken: ReservationOccurrence

Sectie: Kolommen

Reden:

## Kolommen

| 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)) | — |