qryProjectPhases


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
ProjectNo nvarchar 100 null
Title nvarchar 510 null
Locked bit 1 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
PhaseType nvarchar 240 null
Phase nvarchar 240 null
Description nvarchar 510 null
PhaseStart datetime 16 null
PhaseEnd datetime 16 null
PhaseCompanyId uniqueidentifier 16 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null
Active bit 1 null
FRef uniqueidentifier 16 null
Projection1 int 4 null
X1 float 8 null
Y1 float 8 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views