Areas


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProjectId uniqueidentifier 16 null
Projects.ProjectId Areas_Projects_ForeignKey C
AreaId uniqueidentifier 16 null
AreaVertices.AreaId AreaVertices_Areas_ForeignKey C
Points.AreaId Implied Constraint R
qryAreas.AreaId Implied Constraint R
qryAreaVertices.AreaId Implied Constraint R
qryPoints.AreaId Implied Constraint R
Area nvarchar 100 null
Description nvarchar 510 null
Projection int 4 null
XMin float 8 null
YMin float 8 null
XMax float 8 null
YMax float 8 null
sAreaId uniqueidentifier 16 null
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
SelectionId uniqueidentifier 16 null
Selections.SelectionId Implied Constraint R
Primary bit 1 null
ProjectPointsOnly bit 1 null
Overwrite bit 1 null
DBId2 uniqueidentifier 16 null
DrawingId uniqueidentifier 16 null
Report nvarchar 100 null
Enclosure nvarchar 100 null
LinkId int identity 4 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null
Active bit 1 null
FRef nvarchar 510 null
FRefProject nvarchar 100 null
FRefArea nvarchar 100 null

Table contained 36 rows

Indexes

Constraint Name Type Sort Column(s)
Areas_PrimaryKey Primary key Asc AreaId
Areas_AreaId_Index Performance Asc AreaId
Areas_FRef_Index Performance Asc FRef
Areas_FRefArea_Index Performance Asc FRefArea
Areas_FRefProject_Index Performance Asc FRefProject
Areas_ProjectId_Index Performance Asc ProjectId

Relationships