notes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
assigned_user_id CHAR 36 √ null
users.id Defined in XMLR
id CHAR 36 null
securitygroups_records.record_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
name VARCHAR 255 √ null
file_mime_type VARCHAR 100 √ null
filename VARCHAR 255 √ null
parent_type VARCHAR 255 √ null
parent_id CHAR 36 √ null
opportunities.id Defined in XMLR
aop_case_updates.id Defined in XMLR
aos_contracts.id Defined in XMLR
prospects.id Defined in XMLR
tasks.id Defined in XMLR
emails.id Defined in XMLR
accounts.id Defined in XMLR
meetings.id Defined in XMLR
cases.id Defined in XMLR
leads.id Defined in XMLR
project.id Defined in XMLR
bugs.id Defined in XMLR
contacts.id Defined in XMLR
calls.id Defined in XMLR
project_task.id Defined in XMLR
contact_id CHAR 36 √ null
contacts.id Defined in XMLR
portal_flag BIT 1 √ null
embed_flag BIT 1 √ 0
description TEXT 65535 √ null
deleted BIT 1 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_note_contact Performance Asc contact_id
idx_note_name Performance Asc name
idx_notes_assigned_del Performance Asc/Asc deleted + assigned_user_id
idx_notes_parent Performance Asc/Asc parent_id + parent_type

Relationships

Close relationships within degrees of separation