Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
library_groups.parent_id library_groups_ibfk_1 C
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


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