library_groups

0 rows


Columns

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

unique id for each group

parent_id INT 10 null
library_groups.id library_groups_ibfk_1C

if this is a child group, the id of the parent group

branchcode VARCHAR 10 null
branches.branchcode library_groups_ibfk_2C

The branchcode of a branch belonging to the parent group

title VARCHAR 100 null

Short description of the goup

description MEDIUMTEXT 16777215 null

Longer explanation of the group, if necessary

ft_hide_patron_info BIT 0 0

Turn on the feature ‘Hide patron’s info’ for this group

ft_limit_item_editing BIT 0 0

Turn on the feature “Limit item editing by group” 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

Date and time of creation

updated_on TIMESTAMP 19 current_timestamp()

Date and time of last

Indexes

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

Relationships