Table testsql_comments.reports_dictionary
definitions (or snippets of SQL) stored for use in 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 identifier assigned by Koha
name varchar 255  √  null
items_search_fields.name Implied Constraint R
name for this definition
description text 65535  √  null description for this definition
date_created datetime 19  √  null date and time this definition was created
date_modified datetime 19  √  null date and time this definition was last modified
saved_sql text 65535  √  null SQL snippet for us in reports
report_area varchar 6  √  null Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts)

Table contained 0 rows at Tue Dec 27 16:10 NZDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
report_area Performance Asc dictionary_area_idx

Close relationships: