title: "BuildingFloorSpctSum (table)" category: reference tags: [table, buildingfloorspctsum, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.BuildingFloorSpctSum
Schema: dba
Aantal kolommen: 17
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
BldfssBldId |
nvarchar(11) | Nee | — | — |
BldfssBldpId |
nvarchar(11) | Nee | — | — |
BldfssBldfId |
nvarchar(23) | Nee | — | — |
BldfssSpctId |
nvarchar(11) | Nee | — | — |
BldfssContext |
bigint | Nee | ((0)) | — |
BldfssRecStatus |
int | Nee | ((0)) | — |
BldfssCompId |
nvarchar(6) | Nee | — | — |
BldfssExported |
smallint | Nee | ((0)) | — |
BldfssFloorGrossM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfssFloorNettInstM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfssFloorNettM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfssFloorNettTrafHorM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfssFloorNettTrafVertM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfssFloorNettUsabM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfssFloorTareM2 |
decimal(21,2) | Nee | ((0)) | — |
BldfssRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
BldfssWallM2 |
decimal(21,2) | Nee | ((0)) | — |
Trigger-gevulde kolommenbewerken
BldfssBldId← TRSD_SPACE, TRSM_SPACEBldfssBldpId← TRSD_SPACE, TRSM_SPACEBldfssBldfId← TRSD_SPACE, TRSM_SPACEBldfssSpctId← TRSD_SPACE, TRSM_SPACEBldfssCompId← TRSD_SPACE, TRSM_SPACEBldfssFloorGrossM2← TRSD_SPACE, TRSM_SPACEBldfssFloorNettInstM2← TRSD_SPACE, TRSM_SPACEBldfssFloorNettM2← TRSD_SPACE, TRSM_SPACEBldfssFloorNettTrafHorM2← TRSD_SPACE, TRSM_SPACEBldfssFloorNettTrafVertM2← TRSD_SPACE, TRSM_SPACEBldfssFloorNettUsabM2← TRSD_SPACE, TRSM_SPACEBldfssFloorTareM2← TRSD_SPACE, TRSM_SPACEBldfssWallM2← TRSD_SPACE, TRSM_SPACE
Brondatabewerken
- DB-schema —
lookup_table_schema("BuildingFloorSpctSum")Alle kolommen met types, triggers, computed. Bron:database-schema.json.