| 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) |
||||||||||||||||
| deleted_biblionumber | INT | 10 | √ | null |
|
|
links the order to the deleted bibliographic record (deletedbiblio.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) |
| 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_invoice_currency | Performance | Asc | invoice_currency |
| aqorders_subscriptionid | Performance | Asc | subscriptionid |
| basketno | Performance | Asc | basketno |
| biblionumber | Performance | Asc | biblionumber |
| budget_id | Performance | Asc | budget_id |
| orderstatus | Performance | Asc | orderstatus |
