DocumentRevisions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DocumentId uniqueidentifier 16 null
Documents.DocumentId DocumentRevisions_Documents_ForeignKey C
RevisionId uniqueidentifier 16 null
qryDocumentRevisions.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

Indexes

Constraint Name Type Sort Column(s)
DocumentRevisions_PrimaryKey Primary key Asc RevisionId
DocumentRevisions_DocumentId_Index Performance Asc DocumentId
DocumentRevisions_RevisionId_Index Performance Asc RevisionId

Relationships