title: "SpaceMaintenance (table)" category: reference tags: [table, spacemaintenance, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.SpaceMaintenance
Schema: dba
Aantal kolommen: 106
Zie ook de entity-pagina: ../entities/SpaceMaintenance
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
SpcmId |
nvarchar(14) | Nee | — | — |
SpcmContext |
bigint | Nee | ((1)) | — |
SpcmRecStatus |
int | Nee | ((0)) | — |
SpcmBldfId |
nvarchar(23) | Ja | — | — |
SpcmBldId |
nvarchar(11) | Ja | — | — |
SpcmBldpId |
nvarchar(11) | Ja | — | — |
SpcmCompId |
nvarchar(6) | Nee | — | — |
SpcmCostYear1 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear10 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear11 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear12 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear13 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear14 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear15 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear16 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear17 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear18 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear19 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear2 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear20 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear21 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear22 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear23 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear24 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear25 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear26 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear27 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear28 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear29 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear3 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear30 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear31 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear32 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear33 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear34 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear35 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear36 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear37 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear38 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear39 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear4 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear40 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear5 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear6 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear7 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear8 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCostYear9 |
decimal(21,5) | Nee | ((0)) | — |
SpcmCurrentMntsId |
nvarchar(11) | Ja | — | — |
SpcmDataProvider |
nvarchar(50) | Ja | — | — |
SpcmDeletedByInspector |
smallint | Nee | ((0)) | — |
SpcmElementQty |
decimal(21,2) | Nee | ((0)) | — |
SpcmEqmId |
nvarchar(24) | Ja | — | — |
SpcmExistByInspector |
smallint | Nee | ((1)) | — |
SpcmExported |
smallint | Nee | ((0)) | — |
SpcmExternalId |
nvarchar(50) | Ja | — | — |
SpcmExternalStatus |
nvarchar(50) | Ja | — | — |
SpcmLocation |
nvarchar(100) | Ja | — | — |
SpcmLtaId |
nvarchar(10) | Ja | — | — |
SpcmMntpId |
nvarchar(11) | Ja | — | — |
SpcmProviderMutDate |
datetimeoffset(7) | Ja | — | — |
SpcmQty |
decimal(21,2) | Nee | ((0)) | — |
SpcmRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
SpcmSpcId |
nvarchar(40) | Ja | — | — |
SpcmText |
nvarchar(max) | Ja | — | — |
SpcmTransferNextTime |
smallint | Nee | ((0)) | — |
SpcmWantedMntsId |
nvarchar(11) | Ja | — | — |
SpcmYear1 |
smallint | Nee | ((0)) | — |
SpcmYear10 |
smallint | Nee | ((0)) | — |
SpcmYear11 |
smallint | Nee | ((0)) | — |
SpcmYear12 |
smallint | Nee | ((0)) | — |
SpcmYear13 |
smallint | Nee | ((0)) | — |
SpcmYear14 |
smallint | Nee | ((0)) | — |
SpcmYear15 |
smallint | Nee | ((0)) | — |
SpcmYear16 |
smallint | Nee | ((0)) | — |
SpcmYear17 |
smallint | Nee | ((0)) | — |
SpcmYear18 |
smallint | Nee | ((0)) | — |
SpcmYear19 |
smallint | Nee | ((0)) | — |
SpcmYear2 |
smallint | Nee | ((0)) | — |
SpcmYear20 |
smallint | Nee | ((0)) | — |
SpcmYear21 |
smallint | Nee | ((0)) | — |
SpcmYear22 |
smallint | Nee | ((0)) | — |
SpcmYear23 |
smallint | Nee | ((0)) | — |
SpcmYear24 |
smallint | Nee | ((0)) | — |
SpcmYear25 |
smallint | Nee | ((0)) | — |
SpcmYear26 |
smallint | Nee | ((0)) | — |
SpcmYear27 |
smallint | Nee | ((0)) | — |
SpcmYear28 |
smallint | Nee | ((0)) | — |
SpcmYear29 |
smallint | Nee | ((0)) | — |
SpcmYear3 |
smallint | Nee | ((0)) | — |
SpcmYear30 |
smallint | Nee | ((0)) | — |
SpcmYear31 |
smallint | Nee | ((0)) | — |
SpcmYear32 |
smallint | Nee | ((0)) | — |
SpcmYear33 |
smallint | Nee | ((0)) | — |
SpcmYear34 |
smallint | Nee | ((0)) | — |
SpcmYear35 |
smallint | Nee | ((0)) | — |
SpcmYear36 |
smallint | Nee | ((0)) | — |
SpcmYear37 |
smallint | Nee | ((0)) | — |
SpcmYear38 |
smallint | Nee | ((0)) | — |
SpcmYear39 |
smallint | Nee | ((0)) | — |
SpcmYear4 |
smallint | Nee | ((0)) | — |
SpcmYear40 |
smallint | Nee | ((0)) | — |
SpcmYear5 |
smallint | Nee | ((0)) | — |
SpcmYear6 |
smallint | Nee | ((0)) | — |
SpcmYear7 |
smallint | Nee | ((0)) | — |
SpcmYear8 |
smallint | Nee | ((0)) | — |
SpcmYear9 |
smallint | Nee | ((0)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("SpaceMaintenance")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("SpaceMaintenance")· ../entities/SpaceMaintenance Properties, contexts, statussen. Bron:Entities.xml.