subscriptions - sugar Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

CHAR

36

null

subscriptions_audit.parent_id

Defined in XMLR

activities_users.parent_id	Defined in XMLR
locked_field_bean_rel.bean_id	Defined in XMLR

date_entered

DATETIME

26

√

null

date_modified

DATETIME

26

√

null

modified_user_id

CHAR

36

√

null

users.id

Defined in XMLR

created_by

CHAR

36

√

null

users.id

Defined in XMLR

deleted

BIT

1

√

0

parent_type

VARCHAR

100

√

null

parent_id

CHAR

36

null

sync_key

VARCHAR

100

√

null

Showing 1 to 9 of 9 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
idx_subscriptions_del_d_e	Performance	Asc/Asc/Asc	deleted + date_entered + id
idx_subscriptions_del_d_m	Performance	Asc/Asc/Asc	deleted + date_modified + id
idx_subscriptions_id_del	Performance	Asc/Asc	id + deleted
idx_subscriptions_skey	Must be unique	Asc	sync_key
subscription_parent	Performance	Asc	parent_id

Showing 1 to 6 of 6 entries

Relationships

Close relationships within degrees of separation

One
Two degrees