saved_sql


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

unique id and primary key assigned by Koha

borrowernumber INT 10 null

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 MEDIUMTEXT 16777215 null

the SQL for this report

last_run DATETIME 19 null
report_name VARCHAR 255
items_search_fields.name Implied Constraint R

the name of this report

type VARCHAR 255 null

always 1 for tabular

notes MEDIUMTEXT 16777215 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

Indexes

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

Relationships