revenue_line_items_audit - sugar Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

CHAR

36

null

parent_id

CHAR

36

null

revenue_line_items.id

Defined in XMLR

event_id

CHAR

36

null

date_created

DATETIME

26

√

null

created_by

CHAR

36

√

null

date_updated

DATETIME

26

√

null

field_name

VARCHAR

100

√

null

data_type

VARCHAR

100

√

null

before_value_string

VARCHAR

255

√

null

after_value_string

VARCHAR

255

√

null

Showing 1 to 10 of 12 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
idx_revenue_line_items_audit_after_value	Performance	Asc	after_value_string
idx_revenue_line_items_audit_event_id	Performance	Asc	event_id
idx_revenue_line_items_audit_pa_ev_id	Performance	Asc/Asc	parent_id + event_id
idx_revenue_line_items_audit_parent_id	Performance	Asc	parent_id

Showing 1 to 5 of 5 entries

Relationships

Close relationships within degrees of separation

One
Two degrees