m_report_mailing_job

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_report_mailing_job_run_history.job_id m_report_mailing_job_run_history_ibfk_1 R
name varchar 100 null
description text 2147483647 √ null
start_datetime timestamp 29,6 null
recurrence varchar 100 √ null
created_date date 13 null
createdby_id int8 19 null
m_appuser.id m_report_mailing_job_ibfk_1 R
lastmodified_date date 13 √ null
lastmodifiedby_id int8 19 √ null
m_appuser.id m_report_mailing_job_ibfk_2 R
email_recipients text 2147483647 null
email_subject varchar 100 null
email_message text 2147483647 null
email_attachment_file_format varchar 10 null
stretchy_report_id int4 10 null
stretchy_report.id m_report_mailing_job_ibfk_3 R
stretchy_report_param_map text 2147483647 √ null
previous_run_datetime timestamp 29,6 √ null
next_run_datetime timestamp 29,6 √ null
previous_run_status varchar 10 √ null
previous_run_error_log text 2147483647 √ null
previous_run_error_message text 2147483647 √ null
number_of_runs int4 10 0
is_active bool 1 false
is_deleted bool 1 false
run_as_userid int8 19 null
m_appuser.id m_report_mailing_job_ibfk_4 R

Indexes

Constraint Name Type Sort Column(s)
m_report_mailing_job_pkey Primary key Asc id
fk_report_mailing_job_createdby Performance Asc createdby_id
m_report_mailing_job_name_key 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