qryDocumentRevisions


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
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
DateEnd datetime 16 null
Locked bit 1 null
DocumentType nvarchar 40 null
Document nvarchar 100 null
DocumentId uniqueidentifier 16 null
Documents.DocumentId Implied Constraint R
RevisionId uniqueidentifier 16 null
DocumentRevisions.RevisionId Implied Constraint R
Revision nvarchar 100 null
Description nvarchar 510 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

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views