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