itemtypes

0 rows


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.parent_type itemtypes_ibfk_1 R
itemtypes_branches.itemtype itemtypes_branches_ibfk_1 C
old_reserves.itemtype old_reserves_ibfk_4 N
pseudonymized_transactions.itemtype Implied Constraint R
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
parent_type VARCHAR 10 √ null
itemtypes.itemtype itemtypes_ibfk_1 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 rental 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 rental 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
automatic_checkin BIT 0 0

If automatic checkin is enabled for items of this type

Indexes

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

Relationships

Close relationships within degrees of separation