Table testsql_comments.library_groups Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int 10  √ 
library_groups
parent_id int 10  √  null
library_groups
branchcode varchar 10  √  null
branches
The branchcode of a branch belonging to the parent group
title varchar 100  √  null
description mediumtext 16777215  √  null
ft_hide_patron_info bit 0 0 Turn on the feature "Hide patron's info" for this group
ft_search_groups_opac bit 0 0 Use this group for staff side search groups
ft_search_groups_staff bit 0 0 Use this group for opac side search groups
created_on timestamp 19  √  null
updated_on timestamp 19 CURRENT_TIMESTAMP Date and time of last

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Indexes:
Column(s) Type Sort Anomalies
id Primary key Asc  
branchcode Performance Asc  
parent_id Performance Asc  
title Must be unique Asc This unique column is also nullable

Close relationships  within of separation: