title: "Space (table)" category: reference tags: [table, space, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Space
Schema: dba
Aantal kolommen: 157
Zie ook de entity-pagina: ../entities/Space
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
SpcId |
nvarchar(40) | Nee | — | — |
SpcDescr |
nvarchar(200) | Ja | — | — |
SpcContext |
bigint | Nee | ((1)) | — |
SpcRecStatus |
int | Nee | ((0)) | — |
SpcAdrId |
nvarchar(9) | Ja | — | — |
SpcBimGuid |
nvarchar(50) | Ja | — | — |
SpcBldfId |
nvarchar(23) | Ja | — | — |
SpcBldId |
nvarchar(11) | Ja | — | — |
SpcBldpId |
nvarchar(11) | Ja | — | — |
SpcCadDocId |
nvarchar(11) | Ja | — | — |
SpcCadHandle |
decimal(20,0) | Nee | ((0)) | — |
SpcCadHandleDocId |
nvarchar(11) | Ja | — | — |
SpcCadIdHandle |
decimal(20,0) | Nee | ((0)) | — |
SpcCadReportColor |
nvarchar(6) | Ja | — | — |
SpcCadReportPatternAngle |
int | Nee | ((0)) | — |
SpcCadReportPatternScale |
decimal(21,2) | Nee | ((0)) | — |
SpcCapacity |
decimal(21,0) | Nee | ((0)) | — |
SpcCcrId |
nvarchar(9) | Ja | — | — |
SpcClass |
nvarchar(2) | Ja | — | — |
SpcCompId |
nvarchar(6) | Nee | — | — |
SpcCopyFromSpcId |
nvarchar(40) | Ja | — | — |
SpcCostYear1 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear10 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear11 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear12 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear13 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear14 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear15 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear16 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear17 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear18 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear19 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear2 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear20 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear21 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear22 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear23 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear24 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear25 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear26 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear27 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear28 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear29 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear3 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear30 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear31 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear32 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear33 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear34 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear35 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear36 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear37 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear38 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear39 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear4 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear40 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear5 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear6 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear7 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear8 |
decimal(21,5) | Nee | ((0)) | — |
SpcCostYear9 |
decimal(21,5) | Nee | ((0)) | — |
SpcCrptpId |
nvarchar(4) | Ja | — | — |
SpcDataProvider |
nvarchar(50) | Ja | — | — |
SpcDefCleaningTime |
int | Nee | ((0)) | — |
SpcDefPrepareTime |
int | Nee | ((0)) | — |
SpcDepId |
nvarchar(11) | Ja | — | — |
SpcEmailAddress |
nvarchar(80) | Ja | — | — |
SpcExchangePreviousPushMessageDate |
datetimeoffset(7) | Ja | — | — |
SpcExchangeSubscriptionId |
nvarchar(200) | Ja | — | — |
SpcExported |
smallint | Nee | ((0)) | — |
SpcExternalId |
nvarchar(50) | Ja | — | — |
SpcExternalStatus |
nvarchar(50) | Ja | — | — |
SpcFloorGrossM2 |
decimal(21,2) | Nee | ((0)) | — |
SpcFloorNettInstM2 |
decimal(21,2) | Nee | ((0)) | — |
SpcFloorNettM2 |
decimal(15,2) | Nee | ((0)) | — |
SpcFloorNettTrafHorM2 |
decimal(21,2) | Nee | ((0)) | — |
SpcFloorNettTrafVertM2 |
decimal(21,2) | Nee | ((0)) | — |
SpcFloorNettUsabM2 |
decimal(21,2) | Nee | ((0)) | — |
SpcFreeHeight |
decimal(21,2) | Nee | ((0)) | — |
SpcGrossHeight |
decimal(21,2) | Nee | ((0)) | — |
SpcHousenumberExtra |
nvarchar(6) | Ja | — | — |
SpcImageFile |
nvarchar(max) | Ja | — | — |
SpcImportReservationsFromExchange |
smallint | Nee | ((0)) | — |
SpcInvgId |
nvarchar(7) | Ja | — | — |
SpcIsDeliverySpace |
smallint | Nee | ((0)) | — |
SpcMinCapacity |
decimal(21,0) | Nee | ((0)) | — |
SpcNettHeight |
decimal(21,2) | Nee | ((0)) | — |
SpcProviderMutDate |
datetimeoffset(7) | Ja | — | — |
SpcPurId |
nvarchar(6) | Ja | — | — |
SpcRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
SpcRentable |
smallint | Nee | ((0)) | — |
SpcRentHourTariff |
decimal(21,5) | Nee | ((0)) | — |
SpcRentRealEstateStartDate |
date | Ja | — | — |
SpcReservable |
smallint | Nee | ((0)) | — |
SpcResoId |
nvarchar(11) | Ja | — | — |
SpcRnttId |
nvarchar(9) | Ja | — | — |
SpcRoomNr |
nvarchar(11) | Ja | — | — |
SpcSendReservationsToExchange |
smallint | Nee | ((0)) | — |
SpcSfcId |
nvarchar(6) | Ja | — | — |
SpcSitId |
nvarchar(8) | Ja | — | — |
SpcSpcstId |
nvarchar(11) | Ja | — | — |
SpcSpctId |
nvarchar(11) | Ja | — | — |
SpcStataId |
nvarchar(9) | Ja | — | — |
SpcTaxAdmCode |
nvarchar(14) | Ja | — | — |
SpcTaxAdmDisabledHousing |
smallint | Nee | ((0)) | — |
SpcTaxAdmLargeHousehold |
smallint | Nee | ((0)) | — |
SpcTaxAdmSpaceCode |
smallint | Nee | ((0)) | — |
SpcText |
nvarchar(max) | Ja | — | — |
SpcTransferNextTime |
smallint | Nee | ((0)) | — |
SpcVdrId |
nvarchar(6) | Ja | — | — |
SpcWallM2 |
decimal(21,2) | Nee | ((0)) | — |
SpcYear1 |
smallint | Nee | ((0)) | — |
SpcYear10 |
smallint | Nee | ((0)) | — |
SpcYear11 |
smallint | Nee | ((0)) | — |
SpcYear12 |
smallint | Nee | ((0)) | — |
SpcYear13 |
smallint | Nee | ((0)) | — |
SpcYear14 |
smallint | Nee | ((0)) | — |
SpcYear15 |
smallint | Nee | ((0)) | — |
SpcYear16 |
smallint | Nee | ((0)) | — |
SpcYear17 |
smallint | Nee | ((0)) | — |
SpcYear18 |
smallint | Nee | ((0)) | — |
SpcYear19 |
smallint | Nee | ((0)) | — |
SpcYear2 |
smallint | Nee | ((0)) | — |
SpcYear20 |
smallint | Nee | ((0)) | — |
SpcYear21 |
smallint | Nee | ((0)) | — |
SpcYear22 |
smallint | Nee | ((0)) | — |
SpcYear23 |
smallint | Nee | ((0)) | — |
SpcYear24 |
smallint | Nee | ((0)) | — |
SpcYear25 |
smallint | Nee | ((0)) | — |
SpcYear26 |
smallint | Nee | ((0)) | — |
SpcYear27 |
smallint | Nee | ((0)) | — |
SpcYear28 |
smallint | Nee | ((0)) | — |
SpcYear29 |
smallint | Nee | ((0)) | — |
SpcYear3 |
smallint | Nee | ((0)) | — |
SpcYear30 |
smallint | Nee | ((0)) | — |
SpcYear31 |
smallint | Nee | ((0)) | — |
SpcYear32 |
smallint | Nee | ((0)) | — |
SpcYear33 |
smallint | Nee | ((0)) | — |
SpcYear34 |
smallint | Nee | ((0)) | — |
SpcYear35 |
smallint | Nee | ((0)) | — |
SpcYear36 |
smallint | Nee | ((0)) | — |
SpcYear37 |
smallint | Nee | ((0)) | — |
SpcYear38 |
smallint | Nee | ((0)) | — |
SpcYear39 |
smallint | Nee | ((0)) | — |
SpcYear4 |
smallint | Nee | ((0)) | — |
SpcYear40 |
smallint | Nee | ((0)) | — |
SpcYear5 |
smallint | Nee | ((0)) | — |
SpcYear6 |
smallint | Nee | ((0)) | — |
SpcYear7 |
smallint | Nee | ((0)) | — |
SpcYear8 |
smallint | Nee | ((0)) | — |
SpcYear9 |
smallint | Nee | ((0)) | — |
SpcZonId |
nvarchar(6) | Ja | — | — |
SpcFloorTareM2 |
decimal(21,2) | Nee | — | — |
SpcFileExtension |
nvarchar(5) | Nee | — | — |
SPCTEXT_FT |
varbinary(max) | Ja | — | — |
SpcExchangeDeltaLink |
nvarchar(max) | Ja | — | — |
SpcExchangeClientState |
nvarchar(50) | Ja | — | — |
Computed columnsbewerken
SpcFloorTareM2—(CONVERT([decimal](21,2),case when (coalesce([SpcFloorGrossM2],(0))-coalesce([SpcFloorNettM2],(0)))>(0) then coalesce([SpcFloorGrossM2],(0))-coalesce([SpcFloorNettM2],(0)) else (0) end))SpcFileExtension—(N'.html')SPCTEXT_FT—(case when [SPCTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([SPCTEXT],(5))=N'<html' then [SPCTEXT] else N'<html lang="nl">'+[SPCTEXT] end) end)
Trigger-gevulde kolommenbewerken
SpcBldId← TRGI_ReservableObject, TRGU_ReservableObjectSpcCcrId← TRGI_ReservableObject, TRGU_ReservableObjectSpcCostYear1← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear10← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear11← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear12← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear13← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear14← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear15← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear16← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear17← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear18← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear19← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear2← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear20← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear21← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear22← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear23← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear24← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear25← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear26← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear27← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear28← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear29← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear3← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear30← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear31← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear32← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear33← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear34← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear35← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear36← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear37← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear38← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear39← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear4← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear40← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear5← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear6← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear7← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear8← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcCostYear9← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcDepId← TRGI_ReservableObject, TRGU_ReservableObjectSpcResoId← TRGU_ReservableObjectSpcSitId← TRGI_ReservableObject, TRGU_ReservableObjectSpcYear1← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear10← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear11← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear12← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear13← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear14← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear15← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear16← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear17← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear18← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear19← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear2← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear20← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear21← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear22← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear23← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear24← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear25← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear26← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear27← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear28← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear29← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear3← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear30← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear31← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear32← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear33← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear34← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear35← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear36← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear37← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear38← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear39← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear4← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear40← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear5← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear6← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear7← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear8← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCESpcYear9← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCE
Brondatabewerken
- DB-schema —
lookup_table_schema("Space")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Space")· ../entities/Space Properties, contexts, statussen. Bron:Entities.xml.