course_items

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ci_id INT 10 null
course_reserves.ci_id course_reserves_ibfk_2C

course item id

itemnumber INT 10 null
items.itemnumber course_items_ibfk_1C

items.itemnumber for the item on reserve

biblionumber INT 10 null
biblio.biblionumber fk_course_items_biblionumberC

biblio.biblionumber for the bibliographic record on reserve

itype VARCHAR 10 null

new itemtype for the item to have while on reserve (optional)

itype_enabled BIT 0 0

indicates if itype should be changed while on course reserve

itype_storage VARCHAR 10 null

a place to store the itype when item is on course reserve

ccode VARCHAR 80 null

new category code for the item to have while on reserve (optional)

ccode_enabled BIT 0 0

indicates if ccode should be changed while on course reserve

ccode_storage VARCHAR 80 null

a place to store the ccode when item is on course reserve

homebranch VARCHAR 10 null
branches.branchcode fk_course_items_homebranchC

new home branch for the item to have while on reserve (optional)

homebranch_enabled BIT 0 0

indicates if homebranch should be changed while on course reserve

homebranch_storage VARCHAR 10 null
branches.branchcode fk_course_items_homebranch_storageC

a place to store the homebranch when item is on course reserve

holdingbranch VARCHAR 10 null
branches.branchcode course_items_ibfk_2C

new holding branch for the item to have while on reserve (optional)

holdingbranch_enabled BIT 0 0

indicates if itype should be changed while on course reserve

holdingbranch_storage VARCHAR 10 null

a place to store the holdingbranch when item is on course reserve

location VARCHAR 80 null

new shelving location for the item to have while on reseve (optional)

location_enabled BIT 0 0

indicates if itype should be changed while on course reserve

location_storage VARCHAR 80 null

a place to store the location when the item is on course reserve

enabled enum('yes', 'no') 4 no

if at least one enabled course has this item on reseve, this field will be ‘yes’, otherwise it will be ‘no’

timestamp TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ci_id
fk_course_items_biblionumber Performance Asc biblionumber
fk_course_items_homebranch Performance Asc homebranch
fk_course_items_homebranch_storage Performance Asc homebranch_storage
holdingbranch Performance Asc holdingbranch
itemnumber Must be unique Asc itemnumber

Relationships