Bewerken: ShiftLogbook

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ShlbId` | nvarchar(6) | Nee | — | — |
| `ShlbDescr` | nvarchar(200) | Ja | — | — |
| `ShlbContext` | bigint | Nee | ((0)) | — |
| `ShlbRecStatus` | int | Nee | ((0)) | — |
| `ShlbCompId` | nvarchar(6) | Nee | — | — |
| `ShlbDepId` | nvarchar(11) | Ja | — | — |
| `ShlbExported` | smallint | Nee | ((0)) | — |
| `ShlbPrfId` | nvarchar(50) | Ja | — | — |
| `ShlbRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ShlbSitId` | nvarchar(8) | Ja | — | — |
| `ShlbEmailAddressForFeedback` | nvarchar(100) | Ja | — | — |
| `ShlbAutoCloseAndCreateShiftLog` | smallint | Nee | ((0)) | — |
| `ShlbEquipmentQuantity` | int | Nee | ((0)) | — |
| `ShlbDataProvider` | nvarchar(50) | Ja | — | — |
| `ShlbProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ShlbTransferNextTime` | smallint | Nee | ((0)) | — |
| `ShlbExternalId` | nvarchar(50) | Ja | — | — |
| `ShlbExternalStatus` | nvarchar(50) | Ja | — | — |