scheduled_email_messages_outbound

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
group_id BIGINT 19 √ NULL
m_group.id SEFKGROUP000000001R
client_id BIGINT 19 √ NULL
m_client.id SEFKCLIENT00000001R
staff_id BIGINT 19 √ NULL
m_staff.id SEFKSTAFF000000001R
email_campaign_id BIGINT 19 √ NULL
scheduled_email_campaign.id fk_schedule_email_campign1R
status_enum INT 10 100
email_address VARCHAR 50 null
email_subject VARCHAR 50 null
message TEXT 65535 null
campaign_name VARCHAR 200 √ NULL
submittedon_date DATE 10 √ NULL
error_message TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_schedule_email_campign1 Performance Asc email_campaign_id
SEFKCLIENT00000001 Performance Asc client_id
SEFKGROUP000000001 Performance Asc group_id
SEFKSTAFF000000001 Performance Asc staff_id

Relationships

Close relationships within degrees of separation