Table testsql_comments.saved_sql
saved sql reports

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 10  √ 
fieldmapping.id Implied Constraint R
unique id and primary key assigned by Koha
borrowernumber int 10  √  null
patronimage.borrowernumber Implied Constraint R
the staff member who created this report (borrowers.borrowernumber)
date_created datetime 19  √  null the date this report was created
last_modified datetime 19  √  null the date this report was last edited
savedsql text 65535  √  null the SQL for this report
last_run datetime 19  √  null
report_name varchar 255 the name of this report
type varchar 255  √  null always 1 for tabular
notes text 65535  √  null the notes or description given to this report
cache_expiry int 10 300
public bit 0 0
report_area varchar 6  √  null
report_group varchar 80  √  null
report_subgroup varchar 80  √  null

Table contained 0 rows at Tue Dec 27 17:46 NZDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
borrowernumber Performance Asc boridx
report_group + report_subgroup Performance Asc/Asc sql_area_group_idx

Close relationships: