itemtypes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
itemtype VARCHAR 10
branch_item_rules.itemtype branch_item_rules_ibfk_1 C
circulation_rules.itemtype circ_rules_ibfk_3 C
default_branch_item_rules.itemtype default_branch_item_rules_ibfk_1 C
old_reserves.itemtype old_reserves_ibfk_4 N
reserves.itemtype reserves_ibfk_5 C

unique key, a code associated with the item type
description LONGTEXT 2147483647 √ null

a plain text explanation of the item type
rentalcharge DECIMAL 28,6 √ null

the amount charged when this item is checked out/issued
rentalcharge_daily DECIMAL 28,6 √ null

the amount charged for each day between checkout date and due date
rentalcharge_hourly DECIMAL 28,6 √ null

the amount charged for each hour between checkout date and due date
defaultreplacecost DECIMAL 28,6 √ null

default replacement cost
processfee DECIMAL 28,6 √ null

default text be recorded in the column note when the processing fee is applied
notforloan SMALLINT 5 √ null

1 if the item is not for loan, 0 if the item is available for loan
imageurl VARCHAR 200 √ null

URL for the item type icon
summary MEDIUMTEXT 16777215 √ null

information from the summary field, may include HTML
checkinmsg VARCHAR 255 √ null

message that is displayed when an item with the given item type is checked in
checkinmsgtype CHAR 16 message

type (CSS class) for the checkinmsg, can be "alert" or "message"
sip_media_type VARCHAR 3 √ null

SIP2 protocol media type for this itemtype
hideinopac BIT 0 0

Hide the item type from the search options in OPAC
searchcategory VARCHAR 80 √ null

Group this item type with others with the same value on OPAC search options

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc itemtype
itemtype Must be unique Asc itemtype

Relationships

Close relationships within degrees of separation