itemtypes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
itemtype VARCHAR 10
biblioitems.itemtype Implied Constraint R
branch_transfer_limits.itemtype Implied Constraint R
circulation_rules.itemtype circ_rules_ibfk_3 C
deletedbiblioitems.itemtype Implied Constraint R
itemtypes_branches.itemtype itemtypes_branches_ibfk_1 C
old_reserves.itemtype old_reserves_ibfk_4 N
reserves.itemtype reserves_ibfk_5 C
statistics.itemtype Implied Constraint R
subscription.itemtype Implied Constraint R

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_daily_calendar BIT 0 1

controls if the daily retnal fee is calculated directly or using finesCalendar

rentalcharge_hourly DECIMAL 28,6 null

the amount charged for each hour between checkout date and due date

rentalcharge_hourly_calendar BIT 0 1

controls if the hourly retnal fee is calculated directly or using finesCalendar

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