Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| itemtype | VARCHAR | 10 |
|
|
unique key, a code associated with the item type |
|||||||||||||||||||||||||
| parent_type | VARCHAR | 10 | √ | null |
|
|
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
Close relationships within degrees of separation
