Development

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DevelopmentId int identity 4 √ null
DevelopmentDeveloper.DevelopmentId FK_DevelopmentDeveloper_Development R
DevelopmentUse.DevelopmentId FK_DevelopmentUse_Development R
SchemeId int 4 null
Scheme.SchemeId FK_Development_Scheme R
DevelopmentName nvarchar 510 √ null
DevelopmentSizeGross decimal 20,8 √ null
DevelopmentSizeNet decimal 20,8 √ null
PlanningOccupancySizeNet decimal 20,8 √ null
PlanningOccupancySizeGross decimal 20,8 √ null
PlanningOccupancySizeLocal decimal 20,8 √ null
PlanningOccupancySizeSizeUnitId int 4 √ null
SizeUnit.SizeUnitId FK_Development_SizeUnit R
PlanningDevelopmentOccupancyStatusId int 4 √ null
DevelopmentOccupancyStatus.DevelopmentOccupancyStatusId FK_Development_DevelopmentOccupancy R
CompletionOccupancySizeNet decimal 20,8 √ null
CompletionOccupancySizeGross decimal 20,8 √ null
CompletionOccupancySizeLocal decimal 20,8 √ null
CompletionOccupancySizeSizeUnitId int 4 √ null
SizeUnit.SizeUnitId FK_Development_SizeUnitComp R
CompletionDevelopmentOccupancyStatusId int 4 √ null
DevelopmentOccupancyStatus.DevelopmentOccupancyStatusId FK_Development_DevelopmentOccupancyComp R
DevelopmentTypeId int 4 √ null
DevelopmentType.DevelopmentTypeId FK_Development_DevelopmentType R
DevelopmentStatusId int 4 √ null
DevelopmentStatus.DevelopmentStatusId FK_Development_DevelopmentStatus R
PlannedDate date 20 √ null
StartDate date 20 √ null
CompletionDate date 20 √ null
DevelopmentOrdinal int 4 null
ClosedDate date 20 √ null
CompletenessScore decimal 20,8 √ null
CompletenessScoreLastCalculated datetime 16,3 √ null
CreatedAt datetime 16,3 √ null
UpdatedAt datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_DevelopmentId Primary key Asc DevelopmentId
IX_Development_SchemeId_Complete Performance Asc SchemeId
IX_Development_SchemeId_TypeStatus Performance Asc SchemeId

Relationships

Close relationships within degrees of separation