| 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 |
