Table d47civi_0z3xa.civicrm_report_instance Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_report_instance.drilldown_id FK_civicrm_report_instance_drilldown_id N
Report Instance ID
domain_id int unsigned 10
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 64 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?
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.
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

Table contained 38 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: