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 |