title: "BuildingPart (table)" category: reference tags: [table, buildingpart, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.BuildingPart
Schema: dba
Aantal kolommen: 120
Zie ook de entity-pagina: ../entities/BuildingPart
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
BldpBldId |
nvarchar(11) | Nee | — | — |
BldpId |
nvarchar(11) | Nee | — | — |
BldpDescr |
nvarchar(200) | Ja | — | — |
BldpContext |
bigint | Nee | ((1)) | — |
BldpRecStatus |
int | Nee | ((0)) | — |
BldpAddressLine1 |
nvarchar(100) | Ja | — | — |
BldpAddressLine2 |
nvarchar(100) | Ja | — | — |
BldpCadDocId |
nvarchar(11) | Ja | — | — |
BldpCcrId |
nvarchar(9) | Ja | — | — |
BldpCity |
nvarchar(40) | Ja | — | — |
BldpCntrId |
nvarchar(9) | Ja | — | — |
BldpCompId |
nvarchar(6) | Nee | — | — |
BldpConstructionYear |
int | Nee | ((0)) | — |
BldpCostYear1 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear10 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear11 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear12 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear13 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear14 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear15 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear16 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear17 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear18 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear19 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear2 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear20 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear21 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear22 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear23 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear24 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear25 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear26 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear27 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear28 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear29 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear3 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear30 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear31 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear32 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear33 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear34 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear35 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear36 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear37 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear38 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear39 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear4 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear40 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear5 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear6 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear7 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear8 |
decimal(21,5) | Nee | ((0)) | — |
BldpCostYear9 |
decimal(21,5) | Nee | ((0)) | — |
BldpDataProvider |
nvarchar(50) | Ja | — | — |
BldpDepId |
nvarchar(11) | Ja | — | — |
BldpExported |
smallint | Nee | ((0)) | — |
BldpExternalId |
nvarchar(50) | Ja | — | — |
BldpExternalStatus |
nvarchar(50) | Ja | — | — |
BldpFloorGrossM2 |
decimal(21,2) | Nee | ((0)) | — |
BldpFloorNettInstM2 |
decimal(21,2) | Nee | ((0)) | — |
BldpFloorNettM2 |
decimal(21,2) | Nee | ((0)) | — |
BldpFloorNettTrafHorM2 |
decimal(21,2) | Nee | ((0)) | — |
BldpFloorNettTrafVertM2 |
decimal(21,2) | Nee | ((0)) | — |
BldpFloorNettUsabM2 |
decimal(21,2) | Nee | ((0)) | — |
BldpFloorTareM2 |
decimal(21,2) | Nee | ((0)) | — |
BldpGeocodeX |
decimal(21,10) | Nee | ((0)) | — |
BldpGeocodeY |
decimal(21,10) | Nee | ((0)) | — |
BldpImageFile |
nvarchar(max) | Ja | — | — |
BldpParkingState |
int | Nee | ((0)) | — |
BldpProviderMutDate |
datetimeoffset(7) | Ja | — | — |
BldpProvinceStateRegion |
nvarchar(40) | Ja | — | — |
BldpPurId |
nvarchar(6) | Ja | — | — |
BldpQty |
decimal(21,2) | Nee | ((0)) | — |
BldpQtyUntId |
nvarchar(6) | Ja | — | — |
BldpRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
BldpSitId |
nvarchar(8) | Ja | — | — |
BldpText |
nvarchar(max) | Ja | — | — |
BldpTransferNextTime |
smallint | Nee | ((0)) | — |
BldpWallM2 |
decimal(21,2) | Nee | ((0)) | — |
BldpYear1 |
smallint | Nee | ((0)) | — |
BldpYear10 |
smallint | Nee | ((0)) | — |
BldpYear11 |
smallint | Nee | ((0)) | — |
BldpYear12 |
smallint | Nee | ((0)) | — |
BldpYear13 |
smallint | Nee | ((0)) | — |
BldpYear14 |
smallint | Nee | ((0)) | — |
BldpYear15 |
smallint | Nee | ((0)) | — |
BldpYear16 |
smallint | Nee | ((0)) | — |
BldpYear17 |
smallint | Nee | ((0)) | — |
BldpYear18 |
smallint | Nee | ((0)) | — |
BldpYear19 |
smallint | Nee | ((0)) | — |
BldpYear2 |
smallint | Nee | ((0)) | — |
BldpYear20 |
smallint | Nee | ((0)) | — |
BldpYear21 |
smallint | Nee | ((0)) | — |
BldpYear22 |
smallint | Nee | ((0)) | — |
BldpYear23 |
smallint | Nee | ((0)) | — |
BldpYear24 |
smallint | Nee | ((0)) | — |
BldpYear25 |
smallint | Nee | ((0)) | — |
BldpYear26 |
smallint | Nee | ((0)) | — |
BldpYear27 |
smallint | Nee | ((0)) | — |
BldpYear28 |
smallint | Nee | ((0)) | — |
BldpYear29 |
smallint | Nee | ((0)) | — |
BldpYear3 |
smallint | Nee | ((0)) | — |
BldpYear30 |
smallint | Nee | ((0)) | — |
BldpYear31 |
smallint | Nee | ((0)) | — |
BldpYear32 |
smallint | Nee | ((0)) | — |
BldpYear33 |
smallint | Nee | ((0)) | — |
BldpYear34 |
smallint | Nee | ((0)) | — |
BldpYear35 |
smallint | Nee | ((0)) | — |
BldpYear36 |
smallint | Nee | ((0)) | — |
BldpYear37 |
smallint | Nee | ((0)) | — |
BldpYear38 |
smallint | Nee | ((0)) | — |
BldpYear39 |
smallint | Nee | ((0)) | — |
BldpYear4 |
smallint | Nee | ((0)) | — |
BldpYear40 |
smallint | Nee | ((0)) | — |
BldpYear5 |
smallint | Nee | ((0)) | — |
BldpYear6 |
smallint | Nee | ((0)) | — |
BldpYear7 |
smallint | Nee | ((0)) | — |
BldpYear8 |
smallint | Nee | ((0)) | — |
BldpYear9 |
smallint | Nee | ((0)) | — |
BldpZipCode |
nvarchar(10) | Ja | — | — |
Trigger-gevulde kolommenbewerken
BldpCostYear1← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear10← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear11← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear12← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear13← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear14← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear15← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear16← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear17← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear18← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear19← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear2← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear20← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear21← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear22← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear23← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear24← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear25← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear26← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear27← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear28← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear29← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear3← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear30← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear31← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear32← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear33← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear34← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear35← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear36← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear37← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear38← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear39← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear4← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear40← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear5← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear6← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear7← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear8← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpCostYear9← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpFloorGrossM2← TRSD_SPACE, TRSM_SPACEBldpFloorNettInstM2← TRSD_SPACE, TRSM_SPACEBldpFloorNettM2← TRSD_SPACE, TRSM_SPACEBldpFloorNettTrafHorM2← TRSD_SPACE, TRSM_SPACEBldpFloorNettTrafVertM2← TRSD_SPACE, TRSM_SPACEBldpFloorNettUsabM2← TRSD_SPACE, TRSM_SPACEBldpFloorTareM2← TRSD_SPACE, TRSM_SPACEBldpSitId← TRGI_Building, TRGI_BuildingPart, TRGU_Building, TRGU_BuildingPartBldpWallM2← TRSD_SPACE, TRSM_SPACEBldpYear1← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear10← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear11← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear12← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear13← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear14← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear15← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear16← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear17← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear18← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear19← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear2← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear20← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear21← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear22← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear23← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear24← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear25← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear26← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear27← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear28← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear29← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear3← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear30← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear31← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear32← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear33← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear34← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear35← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear36← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear37← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear38← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear39← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear4← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear40← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear5← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear6← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear7← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear8← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldpYear9← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCE
Brondatabewerken
- DB-schema —
lookup_table_schema("BuildingPart")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("BuildingPart")· ../entities/BuildingPart Properties, contexts, statussen. Bron:Entities.xml.