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.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 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 Constraint Name
id Primary key Asc PRIMARY
report_area Performance Asc dictionary_area_idx

Close relationships: