title: "ObjectDowntime (table)" category: reference tags: [table, objectdowntime, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ObjectDowntime
Schema: dba
Aantal kolommen: 39
Zie ook de entity-pagina: ../entities/ObjectDowntime
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
ObjDwtId |
nvarchar(6) | Nee | — | — |
ObjDwtDescr |
nvarchar(200) | Ja | — | — |
ObjDwtContext |
bigint | Nee | ((0)) | — |
ObjDwtRecStatus |
int | Nee | ((0)) | — |
ObjDwtApprovedDate |
datetimeoffset(7) | Ja | — | — |
ObjDwtApprovedEmpId |
nvarchar(9) | Ja | — | — |
ObjDwtCanceledDate |
datetimeoffset(7) | Ja | — | — |
ObjDwtCanceledEmpId |
nvarchar(9) | Ja | — | — |
ObjDwtCcrId |
nvarchar(9) | Ja | — | — |
ObjDwtCompId |
nvarchar(6) | Ja | — | — |
ObjDwtConceptDate |
datetimeoffset(7) | Ja | — | — |
ObjDwtConceptEmpId |
nvarchar(9) | Ja | — | — |
ObjDwtDataProvider |
nvarchar(50) | Ja | — | — |
ObjDwtDepId |
nvarchar(11) | Ja | — | — |
ObjDwtEndDate |
datetimeoffset(7) | Ja | — | — |
ObjDwtEqmId |
nvarchar(24) | Ja | — | — |
ObjDwtExported |
smallint | Nee | ((0)) | — |
ObjDwtExternalId |
nvarchar(50) | Ja | — | — |
ObjDwtExternalStatus |
nvarchar(50) | Ja | — | — |
ObjDwtJobId |
nvarchar(12) | Ja | — | — |
ObjDwtObjDwtId |
nvarchar(6) | Ja | — | — |
ObjDwtPrfId |
nvarchar(50) | Ja | — | — |
ObjDwtProductionLossPerHour |
decimal(21,5) | Nee | ((0)) | — |
ObjDwtProviderMutDate |
datetimeoffset(7) | Ja | — | — |
ObjDwtRecCreateDate |
datetimeoffset(7) | Nee | (sysdatetimeoffset()) | — |
ObjDwtReportDate |
datetimeoffset(7) | Ja | — | — |
ObjDwtReportEmpId |
nvarchar(9) | Ja | — | — |
ObjDwtRequestedDate |
datetimeoffset(7) | Ja | — | — |
ObjDwtRequestedEmpId |
nvarchar(9) | Ja | — | — |
ObjDwtSetDowntimeOnChildren |
smallint | Nee | ((0)) | — |
ObjDwtSetDowntimeOnParents |
smallint | Nee | ((0)) | — |
ObjDwtSitId |
nvarchar(8) | Ja | — | — |
ObjDwtSolveDate |
datetimeoffset(7) | Ja | — | — |
ObjDwtSolveEmpId |
nvarchar(9) | Ja | — | — |
ObjDwtStartDate |
datetimeoffset(7) | Ja | — | — |
ObjDwtTransferNextTime |
smallint | Nee | ((0)) | — |
ObjDwtDuration |
decimal(21,0) | Nee | — | — |
ObjDwtProductionLoss |
decimal(38,6) | Nee | — | — |
ObjDwtRegistrationType |
smallint | Nee | ((0)) | — |
Computed columnsbewerken
ObjDwtDuration—(CONVERT([decimal](21,0),case when [ObjDwtEndDate] IS NULL OR [ObjDwtStartDate] IS NULL then (0) else datediff(minute,[ObjDwtStartDate],[ObjDwtEndDate]) end))ObjDwtProductionLoss—(CONVERT([decimal](21,2),case when [ObjDwtEndDate] IS NULL OR [ObjDwtStartDate] IS NULL then (0) else datediff(minute,[ObjDwtStartDate],[ObjDwtEndDate]) end)*([ObjDwtProductionLossPerHour]/(60)))
Trigger-gevulde kolommenbewerken
ObjDwtId← TRGI_Equipment, TRGI_ProcessFunction, TRGU_Equipment, TRGU_ProcessFunctionObjDwtContext← TRGI_Equipment, TRGI_ProcessFunctionObjDwtRecStatus← TRGI_Equipment, TRGI_ProcessFunctionObjDwtEqmId← TRGI_EquipmentObjDwtObjDwtId← TRGD_Equipment, TRGD_ProcessFunction, TRGI_Equipment, TRGI_ProcessFunctionObjDwtPrfId← TRGI_ProcessFunction
Brondatabewerken
- DB-schema —
lookup_table_schema("ObjectDowntime")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ObjectDowntime")· ../entities/ObjectDowntime Properties, contexts, statussen. Bron:Entities.xml.