| id |
INT |
10 |
|
√ |
null |
|
|
unique id for each group |
| parent_id |
INT |
10 |
√ |
|
null |
|
|
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_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 |
