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