qryDocuments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
DocumentId uniqueidentifier 16 null
Documents.DocumentId Implied Constraint R
DocumentType nvarchar 40 null
Document nvarchar 100 null
Client nvarchar 100 null
Description nvarchar 510 null
Archive nvarchar 240 null
DocumentFile nvarchar 510 null
Page int 4 null
Pages int 4 null
Image nvarchar 2147483647 null
Memo nvarchar 2147483647 null
ExecutedBy nvarchar 40 null
ExecutedDate datetime 16 null
CheckedBy nvarchar 100 null
CheckedDate datetime 16 null
ApprovedBy nvarchar 100 null
ApprovedDate datetime 16 null
DocumentActive bit 1 null
JupiterId int 4 null
FRef int 4 null
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
ProjectNo nvarchar 100 null
PointNo nvarchar 160 null
PublicNo nvarchar 100 null
sPointId uniqueidentifier 16 null
sPointNo nvarchar 160 null
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
DateEnd datetime 16 null
Projection1 int 4 null
X1 float 8 null
Y1 float 8 null
VerticalRefId1 nvarchar 100 null
Z1 real 4 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null
VerticalRefId2 nvarchar 100 null
Z2 real 4 null
Active bit 1 null
Locked bit 1 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views