Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
basketno | INT | 10 | √ | null |
|
|
primary key, Koha defined number |
|||||||
basketname | VARCHAR | 50 | √ | null |
|
|
name given to the basket at creation |
|||||||
note | LONGTEXT | 2147483647 | √ | null |
|
|
the internal note added at basket creation |
|||||||
booksellernote | LONGTEXT | 2147483647 | √ | null |
|
|
the vendor note added at basket creation |
|||||||
contractnumber | INT | 10 | √ | null |
|
|
links this basket to the aqcontract table (aqcontract.contractnumber) |
|||||||
creationdate | DATE | 10 | √ | null |
|
|
the date the basket was created |
|||||||
closedate | DATE | 10 | √ | null |
|
|
the date the basket was closed |
|||||||
booksellerid | INT | 10 | 1 |
|
|
the Koha assigned ID for the vendor (aqbooksellers.id) |
||||||||
authorisedby | VARCHAR | 10 | √ | null |
|
|
the borrowernumber of the person who created the basket |
|||||||
booksellerinvoicenumber | LONGTEXT | 2147483647 | √ | null |
|
|
appears to always be NULL |
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | basketno |
aqbasket_ibfk_4 | Performance | Asc | branch |
authorisedby | Performance | Asc | authorisedby |
basketgroupid | Performance | Asc | basketgroupid |
booksellerid | Performance | Asc | booksellerid |
contractnumber | Performance | Asc | contractnumber |