prospect_lists_prospects

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

CHAR

36

null

prospect_list_id

CHAR

36

√

null

prospect_lists.id

Defined in XMLR

related_id

CHAR

36

√

null

accounts.id	Defined in XMLR
contacts.id	Defined in XMLR
leads.id	Defined in XMLR
prospects.id	Defined in XMLR
users.id	Defined in XMLR

related_type

VARCHAR

25

√

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_plp_pro_id	Performance	Asc/Asc	prospect_list_id + deleted
idx_plp_rel_id	Performance	Asc/Asc/Asc	related_id + related_type + prospect_list_id

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees