civicrm_report_instance


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_report_instance.drilldown_id FK_civicrm_report_instance_drilldown_id N

Report Instance ID

domain_id INT UNSIGNED 10 null
civicrm_domain.id FK_civicrm_report_instance_domain_id R

Which Domain is this instance for

title VARCHAR 255 null

Report Instance Title.

report_id VARCHAR 512 null

FK to civicrm_option_value for the report template

name VARCHAR 255 null

when combined with report_id/template uniquely identifies the instance

args VARCHAR 255 null

arguments that are passed in the url when invoking the instance

description VARCHAR 255 null

Report Instance description.

permission VARCHAR 255 null

permission required to be able to run this instance

grouprole VARCHAR 1024 null

role required to be able to run this instance

form_values TEXT 65535 null

Submitted form values for this report

is_active TINYINT 3 null

Is this entry active?

email_subject VARCHAR 255 null

Subject of email

email_to TEXT 65535 null

comma-separated list of email addresses to send the report to

email_cc TEXT 65535 null

comma-separated list of email addresses to send the report to

header TEXT 65535 null

comma-separated list of email addresses to send the report to

footer TEXT 65535 null

comma-separated list of email addresses to send the report to

navigation_id INT UNSIGNED 10 null
civicrm_navigation.id FK_civicrm_report_instance_navigation_id N

FK to navigation ID

drilldown_id INT UNSIGNED 10 null
civicrm_report_instance.id FK_civicrm_report_instance_drilldown_id N

FK to instance ID drilldown to

is_reserved TINYINT 3 0
created_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_report_instance_created_id N

FK to contact table.

owner_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_report_instance_owner_id N

FK to contact table.

Table contained 36 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_report_instance_created_id Performance Asc created_id
FK_civicrm_report_instance_domain_id Performance Asc domain_id
FK_civicrm_report_instance_drilldown_id Performance Asc drilldown_id
FK_civicrm_report_instance_navigation_id Performance Asc navigation_id
FK_civicrm_report_instance_owner_id Performance Asc owner_id

Relationships