item_groups

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
item_group_id INT 10 √ null
item_group_items.item_group_id item_group_items_gifk_1 C
old_reserves.item_group_id old_reserves_ibfk_ig N
reserves.item_group_id reserves_ibfk_ig N

id for the items group
biblio_id INT 10 null
biblio.biblionumber item_groups_ibfk_1 C

id for the bibliographic record the group belongs to
display_order INT 10 0

The ‘sort order’ for item_groups
description MEDIUMTEXT 16777215 √ NULL

A group description
created_on TIMESTAMP 19 √ NULL

Time and date the group was created
updated_on TIMESTAMP 19 current_timestamp()

Time and date of the latest change on the group

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc item_group_id
item_groups_ibfk_1 Performance Asc biblio_id

Relationships

Close relationships within degrees of separation