Documents


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId Documents_Points_ForeignKey C
DocumentId uniqueidentifier 16 null
DocumentItems.DocumentId DocumentItems_Documents_ForeignKey C
DocumentRevisions.DocumentId DocumentRevisions_Documents_ForeignKey C
qryDocumentItems.DocumentId Implied Constraint R
qryDocumentRevisions.DocumentId Implied Constraint R
qryDocuments.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

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
Documents_PrimaryKey Primary key Asc DocumentId
Documents_DocumentId_Index Performance Asc DocumentId
Documents_DocumentType_Index Performance Asc DocumentType
Documents_FRef_Index Performance Asc FRef
Documents_FRefBor_Index Performance Asc FRefBor
Documents_FRefCom_Index Performance Asc FRefCom
Documents_FRefJob_Index Performance Asc FRefJob
Documents_PointId_Index Performance Asc PointId

Relationships