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 |