itemtypes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
itemtype VARCHAR 10
biblioitems.itemtype Implied ConstraintR
branch_transfer_limits.itemtype Implied ConstraintR
circulation_rules.itemtype circ_rules_ibfk_3C
deletedbiblioitems.itemtype Implied ConstraintR
itemtypes.parent_type itemtypes_ibfk_1C
itemtypes_branches.itemtype itemtypes_branches_ibfk_1C
old_reserves.itemtype old_reserves_ibfk_4N
pseudonymized_transactions.itemtype Implied ConstraintR
reserves.itemtype reserves_ibfk_5C
statistics.itemtype Implied ConstraintR
subscription.itemtype Implied ConstraintR

unique key, a code associated with the item type

parent_type VARCHAR 10 null
itemtypes.itemtype itemtypes_ibfk_1C

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

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