qryDocumentItems


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
PointNo nvarchar 160 null
PublicNo nvarchar 100 null
sPointId uniqueidentifier 16 null
sPointNo nvarchar 160 null
Locked bit 1 null
DocumentId uniqueidentifier 16 null
Documents.DocumentId Implied Constraint R
ItemId uniqueidentifier 16 null
DocumentItems.ItemId Implied Constraint R
SampleId uniqueidentifier 16 null
Depth real 4 null
DocumentType nvarchar 40 null
Document nvarchar 100 null
SampleNo nvarchar 40 null
SampleType nvarchar 100 null
Depth1 real 4 null
Depth2 real 4 null
Length real 4 null
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R
Layer nvarchar 100 null
Color int 4 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views