| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ordernumber | INT | 10 | √ | null |
|
|
primary key and unique identifier assigned by Koha to each line |
|||||||||||
| biblionumber | INT | 10 | √ | null |
|
|
links the order to the biblio being ordered (biblio.biblionumber) |
|||||||||||
| entrydate | DATE | 10 | √ | null |
|
|
the date the bib was added to the basket |
|||||||||||
| quantity | SMALLINT | 5 | √ | null |
|
|
the quantity ordered |
|||||||||||
| currency | VARCHAR | 10 | √ | null |
|
|
the currency used for the purchase |
|||||||||||
| listprice | DECIMAL | 28,6 | √ | null |
|
|
the vendor price for this line item |
|||||||||||
| datereceived | DATE | 10 | √ | null |
|
|
the date this order was received |
|||||||||||
| invoiceid | INT | 10 | √ | null |
|
|
id of invoice |
|||||||||||
| freight | DECIMAL | 28,6 | √ | null |
|
|
shipping costs (not used) |
|||||||||||
| unitprice | DECIMAL | 28,6 | √ | null |
|
|
the actual cost entered when receiving this line item |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | ordernumber |
| aqorders_created_by | Performance | Asc | created_by |
| aqorders_currency | Performance | Asc | currency |
| aqorders_ibfk_3 | Performance | Asc | invoiceid |
| aqorders_subscriptionid | Performance | Asc | subscriptionid |
| basketno | Performance | Asc | basketno |
| biblionumber | Performance | Asc | biblionumber |
| budget_id | Performance | Asc | budget_id |
| orderstatus | Performance | Asc | orderstatus |
| parent_ordernumber | Performance | Asc | parent_ordernumber |
