Table testsql_comments.reports_dictionary 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  √ 
z3950servers
unique identifier assigned by Koha
name varchar 255  √  null
items_search_fields
name for this definition
description mediumtext 16777215  √  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 mediumtext 16777215  √  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 Mon Jul 16 08:37 NZST 2018

Indexes:
Column(s) Type Sort
id Primary key Asc
report_area Performance Asc

Close relationships: