team_sets_teams


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
team_set_id CHAR 36 null
accounts.team_set_id Defined in XMLR
bugs.team_set_id Defined in XMLR
business_centers.team_set_id Defined in XMLR
calendar.team_set_id Defined in XMLR
calls.team_set_id Defined in XMLR
campaigns.team_set_id Defined in XMLR
cases.team_set_id Defined in XMLR
cj_forms.team_set_id Defined in XMLR
cj_web_hooks.team_set_id Defined in XMLR
contacts.team_set_id Defined in XMLR
contracts.team_set_id Defined in XMLR
custom_queries.team_set_id Defined in XMLR
dashboards.team_set_id Defined in XMLR
data_privacy.team_set_id Defined in XMLR
data_sets.team_set_id Defined in XMLR
document_merges.team_set_id Defined in XMLR
document_templates.team_set_id Defined in XMLR
documents.team_set_id Defined in XMLR
docusign_envelopes.team_set_id Defined in XMLR
dri_subworkflow_templates.team_set_id Defined in XMLR
dri_subworkflows.team_set_id Defined in XMLR
dri_workflow_task_templates.team_set_id Defined in XMLR
dri_workflow_templates.team_set_id Defined in XMLR
dri_workflows.team_set_id Defined in XMLR
email_templates.team_set_id Defined in XMLR
emails.team_set_id Defined in XMLR
escalations.team_set_id Defined in XMLR
external_users.team_set_id Defined in XMLR
filters.team_set_id Defined in XMLR
forecast_manager_worksheets.team_set_id Defined in XMLR
forecast_worksheets.team_set_id Defined in XMLR
hint_accountsets.team_set_id Defined in XMLR
inbound_email.team_set_id Defined in XMLR
kbarticles.team_set_id Defined in XMLR
kbcontent_templates.team_set_id Defined in XMLR
kbcontents.team_set_id Defined in XMLR
kbdocuments.team_set_id Defined in XMLR
leads.team_set_id Defined in XMLR
meetings.team_set_id Defined in XMLR
messages.team_set_id Defined in XMLR
metrics.team_set_id Defined in XMLR
notes.team_set_id Defined in XMLR
opportunities.team_set_id Defined in XMLR
outbound_email.team_set_id Defined in XMLR
pdfmanager.team_set_id Defined in XMLR
pmse_business_rules.team_set_id Defined in XMLR
pmse_emails_templates.team_set_id Defined in XMLR
pmse_inbox.team_set_id Defined in XMLR
pmse_project.team_set_id Defined in XMLR
product_bundles.team_set_id Defined in XMLR
product_templates.team_set_id Defined in XMLR
products.team_set_id Defined in XMLR
project.team_set_id Defined in XMLR
project_task.team_set_id Defined in XMLR
prospect_lists.team_set_id Defined in XMLR
prospects.team_set_id Defined in XMLR
purchased_line_items.team_set_id Defined in XMLR
purchases.team_set_id Defined in XMLR
quotes.team_set_id Defined in XMLR
report_maker.team_set_id Defined in XMLR
report_schedules.team_set_id Defined in XMLR
revenue_line_items.team_set_id Defined in XMLR
saved_reports.team_set_id Defined in XMLR
saved_search.team_set_id Defined in XMLR
shift_exceptions.team_set_id Defined in XMLR
shifts.team_set_id Defined in XMLR
tasks.team_set_id Defined in XMLR
team_notices.team_set_id Defined in XMLR
team_sets.id Defined in XMLR
users.team_set_id Defined in XMLR
team_id CHAR 36 null
teams.id Defined in XMLR
date_modified DATETIME 19 √ null
deleted BIT 1 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_ud_set_id Must be unique Asc/Asc team_set_id + team_id
idx_ud_team_id Performance Asc team_id
idx_ud_team_id_team_set_id Performance Asc/Asc team_id + team_set_id
idx_ud_team_set_id Performance Asc team_set_id

Relationships

Close relationships within degrees of separation