documents_revenuelineitems

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

CHAR

36

null

date_modified

DATETIME

26

√

null

deleted

BIT

1

√

0

document_id

CHAR

36

√

null

Defined in XMLR

rli_id

CHAR

36

√

null

revenue_line_items.id

Defined in XMLR

Showing 1 to 5 of 5 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
documents_revenuelineitems_document_id	Performance	Asc/Asc	document_id + rli_id
documents_revenuelineitems_revenuelineitem_id	Performance	Asc/Asc	rli_id + document_id

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees