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