0 rows


Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
library_groups.parent_id library_groups_ibfk_1C
parent_id INT 10 null library_groups_ibfk_1C
branchcode VARCHAR 10 null
branches.branchcode library_groups_ibfk_2C

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

ft_local_hold_group BIT 0 0

Use this group to identify libraries as pick up location for holds

created_on TIMESTAMP 19 null
updated_on TIMESTAMP 19 current_timestamp()

Date and time of last


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
branchcode Performance Asc branchcode
library_groups_uniq_2 Must be unique Asc/Asc parent_id + branchcode
title Must be unique Asc title