outbound_email


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
eapm_id CHAR 36 √ null
name VARCHAR 255 √ null
type VARCHAR 15 √ user
user_id CHAR 36 null
email_address_id CHAR 36 √ null
email_addresses.id Defined in XMLR
authorized_account VARCHAR 255 √ null
mail_authtype VARCHAR 10 √ null
reply_to_name VARCHAR 255 √ null
reply_to_email_address_id CHAR 36 √ null
email_addresses.id Defined in XMLR
mail_sendtype VARCHAR 8 √ SMTP
mail_smtptype VARCHAR 20 √ other
mail_smtpserver VARCHAR 100 √ null
mail_smtpport INT 10 √ 465
mail_smtpuser VARCHAR 100 √ null
mail_smtppass VARCHAR 255 √ null
mail_smtpauth_req BIT 1 √ 0
mail_smtpssl INT 10 √ 1
deleted BIT 1 √ 0
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_outbound_email_acl_tmst_id Performance Asc/Asc acl_team_set_id + deleted
idx_outbound_email_tmst_id Performance Asc/Asc team_set_id + deleted
oe_type_idx Performance Asc type
oe_user_id_idx Performance Asc/Asc id + user_id

Relationships

Close relationships within degrees of separation