notes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
notes.note_parent_id Defined in XMLR
locked_field_bean_rel.bean_id Defined in XMLR
emails_beans.bean_id Defined in XMLR
tag_bean_rel.bean_id Defined in XMLR
activities_users.parent_id Defined in XMLR
commentlog_rel.record_id Defined in XMLR
notes_audit.parent_id Defined in XMLR
name VARCHAR 255 √ null
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
description TEXT 65535 √ null
deleted BIT 1 √ 0
file_mime_type VARCHAR 100 √ null
file_ext VARCHAR 100 √ null
file_source VARCHAR 32 √ null
file_size INT 10 √ 0
filename VARCHAR 255 √ null
upload_id CHAR 36 √ null
email_type VARCHAR 255 √ null
email_id CHAR 36 √ null
emails.id Defined in XMLR
email_templates.id Defined in XMLR
note_parent_id CHAR 36 √ null
notes.id Defined in XMLR
parent_type VARCHAR 255 √ null
parent_id CHAR 36 √ null
bugs.id Defined in XMLR
tasks.id Defined in XMLR
job_queue.id Defined in XMLR
project_task.id Defined in XMLR
quotes.id Defined in XMLR
purchased_line_items.id Defined in XMLR
meetings.id Defined in XMLR
prospects.id Defined in XMLR
products.id Defined in XMLR
kbcontents.id Defined in XMLR
revenue_line_items.id Defined in XMLR
project.id Defined in XMLR
contacts.id Defined in XMLR
cases.id Defined in XMLR
leads.id Defined in XMLR
accounts.id Defined in XMLR
opportunities.id Defined in XMLR
calls.id Defined in XMLR
purchases.id Defined in XMLR
contracts.id Defined in XMLR
contact_id CHAR 36 √ null
contacts.id Defined in XMLR
portal_flag BIT 1 √ 1
embed_flag BIT 1 √ 0
entry_source VARCHAR 255 √ internal
attachment_flag BIT 1 √ 0
sync_key VARCHAR 100 √ null
assigned_user_id CHAR 36 √ null
users.id Defined in XMLR
team_id CHAR 36 √ null
teams.id Defined in XMLR
team_set_id CHAR 36 √ null
team_sets_teams.team_set_id Defined in XMLR
team_sets.id Defined in XMLR
acl_team_set_id CHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_note_contact Performance Asc contact_id
idx_note_email Performance Asc/Asc email_id + email_type
idx_note_email_id Performance Asc email_id
idx_note_email_type Performance Asc email_type
idx_note_name Performance Asc/Asc/Asc deleted + name + date_modified
idx_note_parent_id Performance Asc note_parent_id
idx_note_upload_id Performance Asc upload_id
idx_notes_acl_tmst_id Performance Asc/Asc acl_team_set_id + deleted
idx_notes_assigned_del Performance Asc/Asc assigned_user_id + deleted
idx_notes_del_d_e Performance Asc/Asc/Asc deleted + date_entered + id
idx_notes_del_d_m Performance Asc/Asc/Asc deleted + date_modified + id
idx_notes_id_del Performance Asc/Asc id + deleted
idx_notes_name_del Performance Asc/Asc name + deleted
idx_notes_parent Performance Asc/Asc parent_id + parent_type
idx_notes_skey Must be unique Asc sync_key
idx_notes_tmst_id Performance Asc/Asc team_set_id + deleted

Relationships

Close relationships within degrees of separation