title: "Project (table)" category: reference tags: [table, project, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Project
Schema: dba
Aantal kolommen: 84
Zie ook de entity-pagina: ../entities/Project
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PrjId |
nvarchar(6) | Nee | — | — |
PrjDescr |
nvarchar(200) | Ja | — | — |
PrjContext |
bigint | Nee | ((1)) | — |
PrjRecStatus |
int | Nee | ((0)) | — |
PrjActDuration |
decimal(21,2) | Nee | ((0)) | — |
PrjActFinishDate |
datetimeoffset(7) | Ja | — | — |
PrjActiveDate |
datetimeoffset(7) | Ja | — | — |
PrjActiveEmpId |
nvarchar(9) | Ja | — | — |
PrjActStartDate |
datetimeoffset(7) | Ja | — | — |
PrjApprvDate |
datetimeoffset(7) | Ja | — | — |
PrjApprvEmpId |
nvarchar(9) | Ja | — | — |
PrjBudgetMutation |
decimal(21,5) | Nee | ((0)) | — |
PrjBudgetOrg |
decimal(21,5) | Nee | ((0)) | — |
PrjCcrId |
nvarchar(9) | Ja | — | — |
PrjChgId |
nvarchar(6) | Ja | — | — |
PrjCloseDate |
datetimeoffset(7) | Ja | — | — |
PrjCloseEmpId |
nvarchar(9) | Ja | — | — |
PrjCommentText |
nvarchar(max) | Ja | — | — |
PrjCompId |
nvarchar(6) | Nee | — | — |
PrjDataProvider |
nvarchar(50) | Ja | — | — |
PrjDefinitionText |
nvarchar(max) | Ja | — | — |
PrjEqmId |
nvarchar(24) | Ja | — | — |
PrjEqmInv |
decimal(21,5) | Nee | ((0)) | — |
PrjExported |
smallint | Nee | ((0)) | — |
PrjExtCalc |
decimal(21,5) | Nee | ((0)) | — |
PrjExtCost |
decimal(21,5) | Nee | ((0)) | — |
PrjExternalId |
nvarchar(50) | Ja | — | — |
PrjExternalStatus |
nvarchar(50) | Ja | — | — |
PrjExtInv |
decimal(21,5) | Nee | ((0)) | — |
PrjFinishDate |
datetimeoffset(7) | Ja | — | — |
PrjFinishEmpId |
nvarchar(9) | Ja | — | — |
PrjHours |
decimal(21,2) | Nee | ((0)) | — |
PrjHoursCalc |
decimal(21,2) | Nee | ((0)) | — |
PrjHoursInv |
decimal(21,2) | Nee | ((0)) | — |
PrjHoursToPlan |
decimal(21,2) | Nee | ((0)) | — |
PrjIOFixedPriceCost |
decimal(21,5) | Nee | ((0)) | — |
PrjIoTermCost |
decimal(21,5) | Nee | ((0)) | — |
PrjIoTermInv |
decimal(21,5) | Nee | ((0)) | — |
PrjLabCost |
decimal(21,5) | Nee | ((0)) | — |
PrjLabInv |
decimal(21,5) | Nee | ((0)) | — |
PrjMatCalc |
decimal(21,5) | Nee | ((0)) | — |
PrjMatCost |
decimal(21,5) | Nee | ((0)) | — |
PrjMatInv |
decimal(21,5) | Nee | ((0)) | — |
PrjMemorandumCost |
decimal(21,5) | Nee | ((0)) | — |
PrjMngrEmpId |
nvarchar(9) | Ja | — | — |
PrjPercComplete |
decimal(21,2) | Nee | ((0)) | — |
PrjPercCompleteCalcMethod |
smallint | Nee | ((0)) | — |
PrjPostpDate |
datetimeoffset(7) | Ja | — | — |
PrjPostpEmpId |
nvarchar(9) | Ja | — | — |
PrjPriId |
nvarchar(4) | Ja | — | — |
PrjProviderMutDate |
datetimeoffset(7) | Ja | — | — |
PrjPurchaseRequestCalc |
decimal(21,5) | Nee | ((0)) | — |
PrjPurchCalc |
decimal(21,5) | Nee | ((0)) | — |
PrjPurchCommit |
decimal(21,5) | Nee | ((0)) | — |
PrjPurchCost |
decimal(21,5) | Nee | ((0)) | — |
PrjPurchInv |
decimal(21,5) | Nee | ((0)) | — |
PrjRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PrjRequestDate |
datetimeoffset(7) | Ja | — | — |
PrjRequestEmpId |
nvarchar(9) | Ja | — | — |
PrjResCalc |
decimal(21,5) | Nee | ((0)) | — |
PrjSchDuration |
decimal(21,2) | Nee | ((0)) | — |
PrjSchFinishDate |
datetimeoffset(7) | Ja | — | — |
PrjSchStartDate |
datetimeoffset(7) | Ja | — | — |
PrjSearchForPrfId |
nvarchar(50) | Ja | — | — |
PrjSearchForSkcId |
nvarchar(9) | Ja | — | — |
PrjSearchForVdrId |
nvarchar(6) | Ja | — | — |
PrjSearchForWotId |
nvarchar(6) | Ja | — | — |
PrjSearchFromDate |
date | Ja | — | — |
PrjSearchPOJobs |
smallint | Nee | ((2)) | — |
PrjSearchTillDate |
date | Ja | — | — |
PrjTextValidations |
nvarchar(max) | Ja | — | — |
PrjTlsCalc |
decimal(21,5) | Nee | ((0)) | — |
PrjTlsCost |
decimal(21,5) | Nee | ((0)) | — |
PrjTlsInv |
decimal(21,5) | Nee | ((0)) | — |
PrjToSpendForeCast |
decimal(21,5) | Nee | ((0)) | — |
PrjTotalHoursPlanned |
decimal(21,2) | Nee | ((0)) | — |
PrjTransferNextTime |
smallint | Nee | ((0)) | — |
PrjBudgetTotal |
decimal(21,5) | Nee | — | — |
PrjCalcTotal |
decimal(21,5) | Nee | — | — |
PrjCostTotal |
decimal(21,5) | Nee | — | — |
PrjInvTotal |
decimal(21,5) | Nee | — | — |
PrjFileExtension |
nvarchar(5) | Nee | — | — |
PRJCOMMENTTEXT_FT |
varbinary(max) | Ja | — | — |
PRJDEFINITIONTEXT_FT |
varbinary(max) | Ja | — | — |
Computed columnsbewerken
PrjBudgetTotal—(CONVERT([decimal](21,5),[PrjBudgetOrg]+[PrjBudgetMutation]))PrjCalcTotal—(CONVERT([decimal](21,5),(((([PrjMatCalc]+[PrjExtCalc])+[PrjTlsCalc])+[PrjResCalc])+[PrjPurchaseRequestCalc])+[PrjPurchCalc]))PrjCostTotal—(CONVERT([decimal](21,5),(((([PrjMatCost]+[PrjExtCost])+[PrjTlsCost])+[PrjLabCost])+[PrjPurchCost])+[PrjMemorandumCost]))PrjInvTotal—(CONVERT([decimal](21,5),((((([PrjEqmInv]+[PrjMatInv])+[PrjExtInv])+[PrjTlsInv])+[PrjLabInv])+[PrjPurchInv])+[PrjIoTermInv]))PrjFileExtension—(N'.html')PRJCOMMENTTEXT_FT—(case when [PRJCOMMENTTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([PRJCOMMENTTEXT],(5))=N'<html' then [PRJCOMMENTTEXT] else N'<html lang="nl">'+[PRJCOMMENTTEXT] end) end)PRJDEFINITIONTEXT_FT—(case when [PRJDEFINITIONTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([PRJDEFINITIONTEXT],(5))=N'<html' then [PRJDEFINITIONTEXT] else N'<html lang="nl">'+[PRJDEFINITIONTEXT] end) end)
Trigger-gevulde kolommenbewerken
PrjBudgetMutation← TRSD_WORKORDER, TRSM_WORKORDERPrjBudgetOrg← TRSD_WORKORDER, TRSM_WORKORDERPrjEqmInv← TRSD_WORKORDER, TRSM_WORKORDERPrjExtCalc← TRSD_WORKORDER, TRSM_WORKORDERPrjExtCost← TRSD_WORKORDER, TRSM_WORKORDERPrjExtInv← TRSD_WORKORDER, TRSM_WORKORDERPrjHours← TRGU_WorkOrder, TRSD_WORKORDER, TRSM_WORKORDERPrjHoursCalc← TRSD_WORKORDER, TRSM_WORKORDERPrjHoursInv← TRSD_WORKORDER, TRSM_WORKORDERPrjHoursToPlan← TRSD_WORKORDER, TRSM_WORKORDERPrjIOFixedPriceCost← TRSD_WORKORDER, TRSM_WORKORDERPrjIoTermCost← TRSD_WORKORDER, TRSM_WORKORDERPrjIoTermInv← TRSD_WORKORDER, TRSM_WORKORDERPrjLabCost← TRSD_WORKORDER, TRSM_WORKORDERPrjLabInv← TRSD_WORKORDER, TRSM_WORKORDERPrjMatCalc← TRSD_WORKORDER, TRSM_WORKORDERPrjMatCost← TRSD_WORKORDER, TRSM_WORKORDERPrjMatInv← TRSD_WORKORDER, TRSM_WORKORDERPrjMemorandumCost← TRSD_WORKORDER, TRSM_WORKORDERPrjPercComplete← TRGU_ProjectPrjPurchaseRequestCalc← TRSD_WORKORDER, TRSM_WORKORDERPrjPurchCalc← TRSD_WORKORDER, TRSM_WORKORDERPrjPurchCommit← TRSD_WORKORDER, TRSM_WORKORDERPrjPurchCost← TRSD_COST, TRSD_WORKORDER, TRSM_COST, TRSM_WORKORDERPrjPurchInv← TRSD_WORKORDER, TRSM_WORKORDERPrjResCalc← TRSD_WORKORDER, TRSM_WORKORDERPrjTlsCalc← TRSD_WORKORDER, TRSM_WORKORDERPrjTlsCost← TRSD_WORKORDER, TRSM_WORKORDERPrjTlsInv← TRSD_WORKORDER, TRSM_WORKORDERPrjToSpendForeCast← TRSD_WORKORDER, TRSM_WORKORDERPrjTotalHoursPlanned← TRSD_WORKORDER, TRSM_WORKORDER
Brondatabewerken
- DB-schema —
lookup_table_schema("Project")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Project")· ../entities/Project Properties, contexts, statussen. Bron:Entities.xml.