tag_bean_rel


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
tag_id CHAR 36 null
tags.id Defined in XMLR
bean_id CHAR 36 null
accounts.id Defined in XMLR
acl_role_sets.id Defined in XMLR
bugs.id Defined in XMLR
calls.id Defined in XMLR
cases.id Defined in XMLR
commentlog.id Defined in XMLR
contacts.id Defined in XMLR
contract_types.id Defined in XMLR
contracts.id Defined in XMLR
data_privacy.id Defined in XMLR
emails.id Defined in XMLR
kbcontents.id Defined in XMLR
leads.id Defined in XMLR
manufacturers.id Defined in XMLR
meetings.id Defined in XMLR
notes.id Defined in XMLR
opportunities.id Defined in XMLR
product_templates.id Defined in XMLR
product_types.id Defined in XMLR
products.id Defined in XMLR
prospect_lists.id Defined in XMLR
prospects.id Defined in XMLR
quotes.id Defined in XMLR
revenue_line_items.id Defined in XMLR
saved_reports.id Defined in XMLR
shippers.id Defined in XMLR
tasks.id Defined in XMLR
taxrates.id Defined in XMLR
users_signatures.id Defined in XMLR
bean_module VARCHAR 100 √ null
date_modified DATETIME 26 √ null
deleted BIT 1 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_bid_tid_bm_del Performance Asc/Asc/Asc/Asc bean_id + tag_id + bean_module + deleted
idx_del_tagid_beanid Performance Asc/Asc/Asc deleted + tag_id + bean_id
idx_tag_bean_rel_del_bean_module_beanid Performance Asc/Asc/Asc deleted + bean_module + bean_id
idx_tagsrel_tagid_beanid Performance Asc/Asc tag_id + bean_id

Relationships

Close relationships within degrees of separation