locked_field_bean_rel - sugar Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

CHAR

36

null

pd_id

CHAR

36

null

pmse_bpm_process_definition.id

Defined in XMLR

bean_id

CHAR

36

null

accounts.id	Defined in XMLR
acl_role_sets.id	Defined in XMLR
activities.id	Defined in XMLR
archive_runs.id	Defined in XMLR
bugs.id	Defined in XMLR
business_centers.id	Defined in XMLR
calls.id	Defined in XMLR
campaigns.id	Defined in XMLR
cases.id	Defined in XMLR
categories.id	Defined in XMLR
commentlog.id	Defined in XMLR
console_configuration.id	Defined in XMLR
contacts.id	Defined in XMLR
contract_types.id	Defined in XMLR
contracts.id	Defined in XMLR
dashboards.id	Defined in XMLR
data_archivers.id	Defined in XMLR
data_privacy.id	Defined in XMLR
documents.id	Defined in XMLR
eapm.id	Defined in XMLR
embedded_files.id	Defined in XMLR
filters.id	Defined in XMLR
forecast_manager_worksheets.id	Defined in XMLR
forecast_worksheets.id	Defined in XMLR
kbarticles.id	Defined in XMLR
kbcontent_templates.id	Defined in XMLR
kbcontents.id	Defined in XMLR
kbdocuments.id	Defined in XMLR
leads.id	Defined in XMLR
manufacturers.id	Defined in XMLR
meetings.id	Defined in XMLR
messages.id	Defined in XMLR
mobile_devices.id	Defined in XMLR
notes.id	Defined in XMLR
notifications.id	Defined in XMLR
oauth_consumer.id	Defined in XMLR
opportunities.id	Defined in XMLR
pdfmanager.id	Defined in XMLR
product_categories.id	Defined in XMLR
product_templates.id	Defined in XMLR
product_types.id	Defined in XMLR
products.id	Defined in XMLR
prospects.id	Defined in XMLR
purchased_line_items.id	Defined in XMLR
purchases.id	Defined in XMLR
push_notifications.id	Defined in XMLR
quotas.id	Defined in XMLR
quotes.id	Defined in XMLR
report_schedules.id	Defined in XMLR
revenue_line_items.id	Defined in XMLR
schedulers.id	Defined in XMLR
shift_exceptions.id	Defined in XMLR
shifts.id	Defined in XMLR
shippers.id	Defined in XMLR
styleguide.id	Defined in XMLR
subscriptions.id	Defined in XMLR
sugar_live.id	Defined in XMLR
sugarfavorites.id	Defined in XMLR
tags.id	Defined in XMLR
tasks.id	Defined in XMLR
taxrates.id	Defined in XMLR
teams.id	Defined in XMLR
users_signatures.id	Defined in XMLR
visual_pipeline.id	Defined in XMLR
weblogichooks.id	Defined in XMLR

bean_module

VARCHAR

100

√

null

date_modified

DATETIME

26

√

null

deleted

BIT

1

√

0

Showing 1 to 6 of 6 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
idx_locked_field_bean_rel_beanid_del_bean_module	Performance	Asc/Asc/Asc	bean_id + deleted + bean_module
idx_locked_field_bean_rel_del_bean_module_beanid	Performance	Asc/Asc	bean_module + deleted
idx_locked_fields_rel_pdid_beanid	Performance	Asc/Asc	pd_id + bean_id

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees