title: "BuildingFloor (table)" category: reference tags: [table, buildingfloor, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.BuildingFloor
Schema: dba
Aantal kolommen: 109
Zie ook de entity-pagina: ../entities/BuildingFloor
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
BldfBldId |
nvarchar(11) | Nee | — | — |
BldfBldpId |
nvarchar(11) | Nee | — | — |
BldfId |
nvarchar(23) | Nee | — | — |
BldfDescr |
nvarchar(200) | Ja | — | — |
BldfContext |
bigint | Nee | ((1)) | — |
BldfRecStatus |
int | Nee | ((0)) | — |
BldfCadDocId |
nvarchar(11) | Ja | — | — |
BldfCcrId |
nvarchar(9) | Ja | — | — |
BldfCompId |
nvarchar(6) | Nee | — | — |
BldfCostYear1 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear10 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear11 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear12 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear13 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear14 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear15 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear16 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear17 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear18 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear19 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear2 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear20 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear21 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear22 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear23 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear24 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear25 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear26 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear27 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear28 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear29 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear3 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear30 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear31 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear32 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear33 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear34 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear35 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear36 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear37 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear38 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear39 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear4 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear40 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear5 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear6 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear7 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear8 |
decimal(21,5) | Nee | ((0)) | — |
BldfCostYear9 |
decimal(21,5) | Nee | ((0)) | — |
BldfDataProvider |
nvarchar(50) | Ja | — | — |
BldfDepId |
nvarchar(11) | Ja | — | — |
BldfExported |
smallint | Nee | ((0)) | — |
BldfExternalId |
nvarchar(50) | Ja | — | — |
BldfExternalStatus |
nvarchar(50) | Ja | — | — |
BldfFloorGrossM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfFloorNettInstM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfFloorNettM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfFloorNettTrafHorM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfFloorNettTrafVertM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfFloorNettUsabM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfFloorTareM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfImageFile |
nvarchar(max) | Ja | — | — |
BldfProviderMutDate |
datetimeoffset(7) | Ja | — | — |
BldfPurId |
nvarchar(6) | Ja | — | — |
BldfRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
BldfSitId |
nvarchar(8) | Ja | — | — |
BldfText |
nvarchar(max) | Ja | — | — |
BldfTransferNextTime |
smallint | Nee | ((0)) | — |
BldfWallM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfYear1 |
smallint | Nee | ((0)) | — |
BldfYear10 |
smallint | Nee | ((0)) | — |
BldfYear11 |
smallint | Nee | ((0)) | — |
BldfYear12 |
smallint | Nee | ((0)) | — |
BldfYear13 |
smallint | Nee | ((0)) | — |
BldfYear14 |
smallint | Nee | ((0)) | — |
BldfYear15 |
smallint | Nee | ((0)) | — |
BldfYear16 |
smallint | Nee | ((0)) | — |
BldfYear17 |
smallint | Nee | ((0)) | — |
BldfYear18 |
smallint | Nee | ((0)) | — |
BldfYear19 |
smallint | Nee | ((0)) | — |
BldfYear2 |
smallint | Nee | ((0)) | — |
BldfYear20 |
smallint | Nee | ((0)) | — |
BldfYear21 |
smallint | Nee | ((0)) | — |
BldfYear22 |
smallint | Nee | ((0)) | — |
BldfYear23 |
smallint | Nee | ((0)) | — |
BldfYear24 |
smallint | Nee | ((0)) | — |
BldfYear25 |
smallint | Nee | ((0)) | — |
BldfYear26 |
smallint | Nee | ((0)) | — |
BldfYear27 |
smallint | Nee | ((0)) | — |
BldfYear28 |
smallint | Nee | ((0)) | — |
BldfYear29 |
smallint | Nee | ((0)) | — |
BldfYear3 |
smallint | Nee | ((0)) | — |
BldfYear30 |
smallint | Nee | ((0)) | — |
BldfYear31 |
smallint | Nee | ((0)) | — |
BldfYear32 |
smallint | Nee | ((0)) | — |
BldfYear33 |
smallint | Nee | ((0)) | — |
BldfYear34 |
smallint | Nee | ((0)) | — |
BldfYear35 |
smallint | Nee | ((0)) | — |
BldfYear36 |
smallint | Nee | ((0)) | — |
BldfYear37 |
smallint | Nee | ((0)) | — |
BldfYear38 |
smallint | Nee | ((0)) | — |
BldfYear39 |
smallint | Nee | ((0)) | — |
BldfYear4 |
smallint | Nee | ((0)) | — |
BldfYear40 |
smallint | Nee | ((0)) | — |
BldfYear5 |
smallint | Nee | ((0)) | — |
BldfYear6 |
smallint | Nee | ((0)) | — |
BldfYear7 |
smallint | Nee | ((0)) | — |
BldfYear8 |
smallint | Nee | ((0)) | — |
BldfYear9 |
smallint | Nee | ((0)) | — |
Trigger-gevulde kolommenbewerken
BldfCostYear1← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear10← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear11← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear12← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear13← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear14← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear15← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear16← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear17← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear18← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear19← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear2← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear20← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear21← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear22← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear23← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear24← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear25← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear26← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear27← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear28← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear29← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear3← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear30← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear31← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear32← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear33← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear34← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear35← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear36← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear37← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear38← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear39← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear4← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear40← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear5← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear6← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear7← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear8← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfCostYear9← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfFloorGrossM2← TRSD_SPACE, TRSM_SPACEBldfFloorNettInstM2← TRSD_SPACE, TRSM_SPACEBldfFloorNettM2← TRSD_SPACE, TRSM_SPACEBldfFloorNettTrafHorM2← TRSD_SPACE, TRSM_SPACEBldfFloorNettTrafVertM2← TRSD_SPACE, TRSM_SPACEBldfFloorNettUsabM2← TRSD_SPACE, TRSM_SPACEBldfFloorTareM2← TRSD_SPACE, TRSM_SPACEBldfSitId← TRGI_Building, TRGI_BuildingFloor, TRGU_Building, TRGU_BuildingFloorBldfWallM2← TRSD_SPACE, TRSM_SPACEBldfYear1← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear10← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear11← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear12← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear13← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear14← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear15← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear16← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear17← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear18← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear19← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear2← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear20← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear21← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear22← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear23← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear24← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear25← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear26← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear27← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear28← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear29← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear3← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear30← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear31← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear32← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear33← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear34← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear35← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear36← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear37← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear38← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear39← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear4← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear40← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear5← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear6← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear7← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear8← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCEBldfYear9← TRSD_SPACEMAINTENANCE, TRSM_SPACEMAINTENANCE
Brondatabewerken
- DB-schema —
lookup_table_schema("BuildingFloor")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("BuildingFloor")· ../entities/BuildingFloor Properties, contexts, statussen. Bron:Entities.xml.