linked_documents

Columns

Related columns Constraint Comments

Search:

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

Defined in XMLR

document_revision_id

CHAR

36

√

null

date_modified

DATETIME

26

√

null

deleted

BIT

1

√

0

Showing 1 to 7 of 7 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees