linked_documents


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
parent_id CHAR 36 null
contract_types.id Defined in XMLR
contracts.id Defined in XMLR
parent_type VARCHAR 25 null
document_id CHAR 36 null
documents.id Defined in XMLR
document_revision_id CHAR 36 null
date_modified DATETIME 19 null
deleted BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_parent_document Performance Asc/Asc/Asc parent_type + parent_id + document_id

Relationships