item_groups

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 6 of 6 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation