title: "ShiftLogbook (table)" category: reference tags: [table, shiftlogbook, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ShiftLogbook
Schema: dba
Aantal kolommen: 18
Zie ook de entity-pagina: ../entities/ShiftLogbook
Kolommenbewerken
| 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 | — | — |
Trigger-gevulde kolommenbewerken
ShlbEquipmentQuantity← TRSD_OBJECTSHIFTLOGBOOK, TRSM_OBJECTSHIFTLOGBOOK
Brondatabewerken
- DB-schema —
lookup_table_schema("ShiftLogbook")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ShiftLogbook")· ../entities/ShiftLogbook Properties, contexts, statussen. Bron:Entities.xml.