Table testsql_comments.library_groups Generated by
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  √ 
library_groups.parent_id library_groups_ibfk_1 C Implied Constraint R
parent_id int 10  √  null library_groups_ibfk_1 C
branchcode varchar 10  √  null
branches.branchcode library_groups_ibfk_2 C
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

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

Close relationships  within of separation: