|
Lines 957-962
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
| 957 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
957 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
| 958 |
description LONGTEXT, -- a plain text explanation of the item type |
958 |
description LONGTEXT, -- a plain text explanation of the item type |
| 959 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
959 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
|
|
960 |
rental_charge_daily decimal(28,6) default NULL, -- the amount charged for each day between checkout date and due date |
| 960 |
defaultreplacecost decimal(28,6) default NULL, -- default replacement cost |
961 |
defaultreplacecost decimal(28,6) default NULL, -- default replacement cost |
| 961 |
processfee decimal(28,6) default NULL, -- default text be recorded in the column note when the processing fee is applied |
962 |
processfee decimal(28,6) default NULL, -- default text be recorded in the column note when the processing fee is applied |
| 962 |
notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan |
963 |
notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan |
| 963 |
- |
|
|