m_report_mailing_job

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_report_mailing_job_run_history.job_id m_report_mailing_job_run_history_ibfk_1R
name VARCHAR 100 null
description TEXT 65535 √ NULL
start_datetime DATETIME 19 null
recurrence VARCHAR 100 √ NULL
created_date DATE 10 null
createdby_id BIGINT 19 null
m_appuser.id m_report_mailing_job_ibfk_1R
lastmodified_date DATE 10 √ NULL
lastmodifiedby_id BIGINT 19 √ NULL
m_appuser.id m_report_mailing_job_ibfk_2R
email_recipients TEXT 65535 null
email_subject VARCHAR 100 null
email_message TEXT 65535 null
email_attachment_file_format VARCHAR 10 null
stretchy_report_id INT 10 null
stretchy_report.id m_report_mailing_job_ibfk_3R
stretchy_report_param_map TEXT 65535 √ NULL
previous_run_datetime DATETIME 19 √ NULL
next_run_datetime DATETIME 19 √ NULL
previous_run_status VARCHAR 10 √ NULL
previous_run_error_log TEXT 65535 √ NULL
previous_run_error_message TEXT 65535 √ NULL
number_of_runs INT 10 0
is_active BIT 1 b'0'
is_deleted BIT 1 b'0'
run_as_userid BIGINT 19 null
m_appuser.id m_report_mailing_job_ibfk_4R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_report_mailing_job_createdby Performance Asc createdby_id
name Must be unique Asc name
report_mailing_job_lastmodifiedby_id Performance Asc lastmodifiedby_id
run_as_userid Performance Asc run_as_userid
stretchy_report_id Performance Asc stretchy_report_id

Relationships

Close relationships within degrees of separation