Bewerken: HourCode

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `HourId` | nvarchar(5) | Nee | — | — |
| `HourDescr` | nvarchar(200) | Ja | — | — |
| `HourContext` | bigint | Nee | ((1)) | — |
| `HourRecStatus` | int | Nee | ((0)) | — |
| `HourAbsPriority` | int | Nee | ((0)) | — |
| `HourAddCode` | smallint | Nee | ((0)) | — |
| `HourAddDlgCode` | smallint | Nee | ((0)) | — |
| `HourCsttId` | nvarchar(9) | Ja | — | — |
| `HourDataProvider` | nvarchar(50) | Ja | — | — |
| `HourDescr2` | nvarchar(51) | Ja | — | — |
| `HourDescr3` | nvarchar(51) | Ja | — | — |
| `HourExported` | smallint | Nee | ((0)) | — |
| `HourExternalId` | nvarchar(50) | Ja | — | — |
| `HourExternalStatus` | nvarchar(50) | Ja | — | — |
| `HourExtra1` | smallint | Nee | ((0)) | — |
| `HourExtra2` | int | Nee | ((0)) | — |
| `HourExtra3` | nvarchar(5) | Ja | — | — |
| `HourExtra4` | nvarchar(5) | Ja | — | — |
| `HourProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `HourRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `HourShowAsAbsence` | smallint | Nee | ((0)) | — |
| `HourTransferNextTime` | smallint | Nee | ((0)) | — |
| `HourSchedulerColor` | nvarchar(6) | Ja | — | — |