notes

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

CHAR

36

null

notes.note_parent_id	Defined in XMLR
notes_audit.parent_id	Defined in XMLR

tag_bean_rel.bean_id	Defined in XMLR
commentlog_rel.record_id	Defined in XMLR
emails_beans.bean_id	Defined in XMLR
locked_field_bean_rel.bean_id	Defined in XMLR
activities_users.parent_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

Defined in XMLR

created_by

CHAR

36

√

null

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

Defined in XMLR

parent_type

VARCHAR

255

√

null

parent_id

CHAR

36

√

null

tasks.id	Defined in XMLR
products.id	Defined in XMLR
contacts.id	Defined in XMLR
quotes.id	Defined in XMLR
bugs.id	Defined in XMLR
prospects.id	Defined in XMLR
project.id	Defined in XMLR
job_queue.id	Defined in XMLR
accounts.id	Defined in XMLR
escalations.id	Defined in XMLR
contracts.id	Defined in XMLR
leads.id	Defined in XMLR
opportunities.id	Defined in XMLR
calls.id	Defined in XMLR
kbcontents.id	Defined in XMLR
meetings.id	Defined in XMLR
cases.id	Defined in XMLR
project_task.id	Defined in XMLR
purchased_line_items.id	Defined in XMLR
purchases.id	Defined in XMLR
revenue_line_items.id	Defined in XMLR

contact_id

CHAR

36

√

null

Defined in XMLR

portal_flag

BIT

1

√

1

embed_flag

BIT

1

√

0

external_id

CHAR

36

√

null

external_users.id

Defined in XMLR

entry_source

VARCHAR

255

√

internal

attachment_flag

BIT

1

√

0

sync_key

VARCHAR

100

√

null

assigned_user_id

CHAR

36

√

null

Defined in XMLR

team_id

CHAR

36

√

null

Defined in XMLR

team_set_id

CHAR

36

√

null

team_sets.id	Defined in XMLR
team_sets_teams.team_set_id	Defined in XMLR

acl_team_set_id

CHAR

36

√

null

source_id

VARCHAR

255

√

null

source_type

VARCHAR

255

√

null

source_meta

TEXT

65535

√

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_type	Performance	Asc	email_type
idx_note_external_user	Performance	Asc	external_id
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

One
Two degrees