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 | BIT | 0 | 0 |
|
|
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 |
|||||||||||||||||||||||||||||||||||
| bookable | BIT | 0 | 0 |
|
|
Activate bookable feature for items related to this item 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
