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 |