SchemaSpy - Table a7e12882.emailman

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

date_entered

datetime

19

√

null

date_modified

datetime

19

√

null

user_id

char

36

√

null

id

int

11

√

campaign_id

char

36

√

null

Defined in XML R

marketing_id

char

36

√

null

list_id

char

36

√

null

send_date_time

datetime

19

√

null

modified_user_id

char

36

√

null

in_queue

bit

1

√

0

in_queue_date

datetime

19

√

null

send_attempts

int

11

√

0

deleted

bit

1

√

0

related_id

char

36

√

null

related_type

varchar

100

√

null

Analyzed at Tue Jun 30 08:03 UTC 2020

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
send_attempts	Performance	Asc	idx_emailman_send_attempts
send_date_time	Performance	Asc	idx_emailman_send_date_time
campaign_id	Performance	Asc	idx_eman_campaign_id
list_id + user_id + deleted	Performance	Asc/Asc/Asc	idx_eman_list
related_id + related_type + campaign_id	Performance	Asc/Asc/Asc	idx_eman_relid_reltype_id