title: "BuildingSpctSum (table)" category: reference tags: [table, buildingspctsum, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.BuildingSpctSum
Schema: dba
Aantal kolommen: 15
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
BldssBldId |
nvarchar(11) | Nee | — | — |
BldssSpctId |
nvarchar(11) | Nee | — | — |
BldssContext |
bigint | Nee | ((0)) | — |
BldssRecStatus |
int | Nee | ((0)) | — |
BldssCompId |
nvarchar(6) | Nee | — | — |
BldssExported |
smallint | Nee | ((0)) | — |
BldssFloorGrossM2 |
decimal(21,2) | Nee | ((0)) | — |
BldssFloorNettInstM2 |
decimal(21,2) | Nee | ((0)) | — |
BldssFloorNettM2 |
decimal(21,2) | Nee | ((0)) | — |
BldssFloorNettTrafHorM2 |
decimal(21,2) | Nee | ((0)) | — |
BldssFloorNettTrafVertM2 |
decimal(21,2) | Nee | ((0)) | — |
BldssFloorNettUsabM2 |
decimal(21,2) | Nee | ((0)) | — |
BldssFloorTareM2 |
decimal(21,2) | Nee | ((0)) | — |
BldssRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
BldssWallM2 |
decimal(21,2) | Nee | ((0)) | — |
Trigger-gevulde kolommenbewerken
BldssBldId← TRSD_SPACE, TRSM_SPACEBldssSpctId← TRSD_SPACE, TRSM_SPACEBldssCompId← TRSD_SPACE, TRSM_SPACEBldssFloorGrossM2← TRGD_Building, TRGD_BuildingSpctSum, TRGI_BuildingSpctSum, TRGU_Building, TRGU_BuildingSpctSum, TRSD_SPACE, TRSM_SPACEBldssFloorNettInstM2← TRGD_Building, TRGD_BuildingSpctSum, TRGI_BuildingSpctSum, TRGU_Building, TRGU_BuildingSpctSum, TRSD_SPACE, TRSM_SPACEBldssFloorNettM2← TRGD_Building, TRGD_BuildingSpctSum, TRGI_BuildingSpctSum, TRGU_Building, TRGU_BuildingSpctSum, TRSD_SPACE, TRSM_SPACEBldssFloorNettTrafHorM2← TRGD_Building, TRGD_BuildingSpctSum, TRGI_BuildingSpctSum, TRGU_Building, TRGU_BuildingSpctSum, TRSD_SPACE, TRSM_SPACEBldssFloorNettTrafVertM2← TRGD_Building, TRGD_BuildingSpctSum, TRGI_BuildingSpctSum, TRGU_Building, TRGU_BuildingSpctSum, TRSD_SPACE, TRSM_SPACEBldssFloorNettUsabM2← TRGD_Building, TRGD_BuildingSpctSum, TRGI_BuildingSpctSum, TRGU_Building, TRGU_BuildingSpctSum, TRSD_SPACE, TRSM_SPACEBldssFloorTareM2← TRGD_Building, TRGD_BuildingSpctSum, TRGI_BuildingSpctSum, TRGU_Building, TRGU_BuildingSpctSum, TRSD_SPACE, TRSM_SPACEBldssWallM2← TRGD_Building, TRGD_BuildingSpctSum, TRGI_BuildingSpctSum, TRGU_Building, TRGU_BuildingSpctSum, TRSD_SPACE, TRSM_SPACE
Brondatabewerken
- DB-schema —
lookup_table_schema("BuildingSpctSum")Alle kolommen met types, triggers, computed. Bron:database-schema.json.