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

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


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