| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Report Instance ID |
|||
| domain_id | INT UNSIGNED | 10 | null |
|
|
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 |
|
|
FK to navigation ID |
|||
| drilldown_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to instance ID drilldown to |
|||
| is_reserved | TINYINT | 3 | √ | 0 |
|
|
||||
| created_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to contact table. |
|||
| owner_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to contact table. |
| 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 |
