title: "Building (table)" category: reference tags: [table, building, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Building
Schema: dba
Aantal kolommen: 150
Zie ook de entity-pagina: ../entities/Building
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
BldId |
nvarchar(11) | Nee | — | — |
BldDescr |
nvarchar(200) | Ja | — | — |
BldContext |
bigint | Nee | ((1)) | — |
BldRecStatus |
int | Nee | ((0)) | — |
BldAddressLine1 |
nvarchar(100) | Ja | — | — |
BldAddressLine2 |
nvarchar(100) | Ja | — | — |
BldBldtId |
nvarchar(5) | Ja | — | — |
BldBuildingBSV |
decimal(21,5) | Nee | ((0)) | — |
BldBusinessCost |
decimal(21,5) | Nee | ((0)) | — |
BldCadDocId |
nvarchar(11) | Ja | — | — |
BldCcrId |
nvarchar(9) | Ja | — | — |
BldChargesOnFixedAssets |
decimal(21,5) | Nee | ((0)) | — |
BldCity |
nvarchar(40) | Ja | — | — |
BldCityPart |
nvarchar(40) | Ja | — | — |
BldCntrId |
nvarchar(9) | Ja | — | — |
BldCompId |
nvarchar(6) | Nee | — | — |
BldComplexBldId |
nvarchar(11) | Ja | — | — |
BldConstructionYear |
int | Nee | ((0)) | — |
BldCostYear1 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear10 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear11 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear12 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear13 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear14 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear15 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear16 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear17 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear18 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear19 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear2 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear20 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear21 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear22 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear23 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear24 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear25 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear26 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear27 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear28 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear29 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear3 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear30 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear31 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear32 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear33 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear34 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear35 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear36 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear37 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear38 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear39 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear4 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear40 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear5 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear6 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear7 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear8 |
decimal(21,5) | Nee | ((0)) | — |
BldCostYear9 |
decimal(21,5) | Nee | ((0)) | — |
BldCusId |
nvarchar(6) | Ja | — | — |
BldDataProvider |
nvarchar(50) | Ja | — | — |
BldDateUserState |
datetimeoffset(7) | Ja | — | — |
BldDecId |
nvarchar(15) | Ja | — | — |
BldDepId |
nvarchar(11) | Ja | — | — |
BldExported |
smallint | Nee | ((0)) | — |
BldExternalId |
nvarchar(50) | Ja | — | — |
BldExternalStatus |
nvarchar(50) | Ja | — | — |
BldFloorGrossM2 |
decimal(21,2) | Nee | ((0)) | — |
BldFloorNettInstM2 |
decimal(21,2) | Nee | ((0)) | — |
BldFloorNettM2 |
decimal(21,2) | Nee | ((0)) | — |
BldFloorNettTrafHorM2 |
decimal(21,2) | Nee | ((0)) | — |
BldFloorNettTrafVertM2 |
decimal(21,2) | Nee | ((0)) | — |
BldFloorNettUsabM2 |
decimal(21,2) | Nee | ((0)) | — |
BldFloorTareM2 |
decimal(21,2) | Nee | ((0)) | — |
BldGeocodeX |
decimal(21,10) | Nee | ((0)) | — |
BldGeocodeY |
decimal(21,10) | Nee | ((0)) | — |
BldImageFile |
nvarchar(max) | Ja | — | — |
BldInsetDate |
date | Ja | — | — |
BldInstallationBSV |
decimal(21,5) | Nee | ((0)) | — |
BldLandedProperty |
smallint | Nee | ((0)) | — |
BldLandedPropertyBSV |
decimal(21,5) | Nee | ((0)) | — |
BldLtaId |
nvarchar(10) | Ja | — | — |
BldManualFloorGrossM2 |
decimal(21,2) | Nee | ((0)) | — |
BldManualFloorNettM2 |
decimal(21,2) | Nee | ((0)) | — |
BldManualGrossM3 |
decimal(21,2) | Nee | ((0)) | — |
BldManualNettM3 |
decimal(21,2) | Nee | ((0)) | — |
BldManualOutsideArea1M2 |
decimal(21,2) | Nee | ((0)) | — |
BldManualOutsideArea2M2 |
decimal(21,2) | Nee | ((0)) | — |
BldManualOutsideArea3M2 |
decimal(21,2) | Nee | ((0)) | — |
BldManualOutsideArea4M2 |
decimal(21,2) | Nee | ((0)) | — |
BldMarketValue |
decimal(21,5) | Nee | ((0)) | — |
BldMaxUserState |
int | Nee | ((0)) | — |
BldNeighborhood |
nvarchar(40) | Ja | — | — |
BldParkingState |
int | Nee | ((0)) | — |
BldPartOfBldId |
nvarchar(11) | Ja | — | — |
BldPrfId |
nvarchar(50) | Ja | — | — |
BldProviderMutDate |
datetimeoffset(7) | Ja | — | — |
BldProvinceStateRegion |
nvarchar(40) | Ja | — | — |
BldPurId |
nvarchar(6) | Ja | — | — |
BldRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
BldReplacementValue |
decimal(21,5) | Nee | ((0)) | — |
BldSitId |
nvarchar(8) | Ja | — | — |
BldText |
nvarchar(max) | Ja | — | — |
BldTransferNextTime |
smallint | Nee | ((0)) | — |
BldUserState |
int | Nee | ((0)) | — |
BldVdrId |
nvarchar(6) | Ja | — | — |
BldWallM2 |
decimal(21,2) | Nee | ((0)) | — |
BldYear1 |
smallint | Nee | ((0)) | — |
BldYear10 |
smallint | Nee | ((0)) | — |
BldYear11 |
smallint | Nee | ((0)) | — |
BldYear12 |
smallint | Nee | ((0)) | — |
BldYear13 |
smallint | Nee | ((0)) | — |
BldYear14 |
smallint | Nee | ((0)) | — |
BldYear15 |
smallint | Nee | ((0)) | — |
BldYear16 |
smallint | Nee | ((0)) | — |
BldYear17 |
smallint | Nee | ((0)) | — |
BldYear18 |
smallint | Nee | ((0)) | — |
BldYear19 |
smallint | Nee | ((0)) | — |
BldYear2 |
smallint | Nee | ((0)) | — |
BldYear20 |
smallint | Nee | ((0)) | — |
BldYear21 |
smallint | Nee | ((0)) | — |
BldYear22 |
smallint | Nee | ((0)) | — |
BldYear23 |
smallint | Nee | ((0)) | — |
BldYear24 |
smallint | Nee | ((0)) | — |
BldYear25 |
smallint | Nee | ((0)) | — |
BldYear26 |
smallint | Nee | ((0)) | — |
BldYear27 |
smallint | Nee | ((0)) | — |
BldYear28 |
smallint | Nee | ((0)) | — |
BldYear29 |
smallint | Nee | ((0)) | — |
BldYear3 |
smallint | Nee | ((0)) | — |
BldYear30 |
smallint | Nee | ((0)) | — |
BldYear31 |
smallint | Nee | ((0)) | — |
BldYear32 |
smallint | Nee | ((0)) | — |
BldYear33 |
smallint | Nee | ((0)) | — |
BldYear34 |
smallint | Nee | ((0)) | — |
BldYear35 |
smallint | Nee | ((0)) | — |
BldYear36 |
smallint | Nee | ((0)) | — |
BldYear37 |
smallint | Nee | ((0)) | — |
BldYear38 |
smallint | Nee | ((0)) | — |
BldYear39 |
smallint | Nee | ((0)) | — |
BldYear4 |
smallint | Nee | ((0)) | — |
BldYear40 |
smallint | Nee | ((0)) | — |
BldYear5 |
smallint | Nee | ((0)) | — |
BldYear6 |
smallint | Nee | ((0)) | — |
BldYear7 |
smallint | Nee | ((0)) | — |
BldYear8 |
smallint | Nee | ((0)) | — |
BldYear9 |
smallint | Nee | ((0)) | — |
BldZipCode |
nvarchar(10) | Ja | — | — |
BldBuildingTotalBSV |
decimal(21,5) | Nee | — | — |
BldFileExtension |
nvarchar(5) | Nee | — | — |
BldText_FT |
varbinary(max) | Ja | — | — |
Computed columnsbewerken
BldBuildingTotalBSV—(CONVERT([decimal](21,5),([BldBuildingBSV]+[BldLandedPropertyBSV])+[BldInstallationBSV]))BldFileExtension—(N'.html')BldText_FT—(case when [BldText] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([BldText],(5))=N'<html' then [BldText] else N'<html lang="nl">'+[BldText] end) end)
Trigger-gevulde kolommenbewerken
BldCostYear1← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear10← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear11← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear12← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear13← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear14← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear15← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear16← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear17← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear18← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear19← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear2← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear20← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear21← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear22← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear23← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear24← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear25← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear26← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear27← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear28← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear29← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear3← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear30← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear31← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear32← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear33← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear34← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear35← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear36← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear37← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear38← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear39← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear4← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear40← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear5← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear6← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear7← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear8← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldCostYear9← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldFloorGrossM2← TRSD_SPACE, TRSM_SPACEBldFloorNettInstM2← TRSD_SPACE, TRSM_SPACEBldFloorNettM2← TRSD_SPACE, TRSM_SPACEBldFloorNettTrafHorM2← TRSD_SPACE, TRSM_SPACEBldFloorNettTrafVertM2← TRSD_SPACE, TRSM_SPACEBldFloorNettUsabM2← TRSD_SPACE, TRSM_SPACEBldFloorTareM2← TRSD_SPACE, TRSM_SPACEBldWallM2← TRSD_SPACE, TRSM_SPACEBldYear1← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear10← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear11← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear12← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear13← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear14← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear15← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear16← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear17← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear18← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear19← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear2← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear20← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear21← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear22← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear23← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear24← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear25← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear26← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear27← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear28← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear29← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear3← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear30← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear31← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear32← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear33← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear34← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear35← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear36← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear37← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear38← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear39← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear4← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear40← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear5← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear6← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear7← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear8← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldYear9← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCE
Brondatabewerken
- DB-schema —
lookup_table_schema("Building")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Building")· ../entities/Building Properties, contexts, statussen. Bron:Entities.xml.