Table testsql_comments.aqbasket Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
basketno int 10  √ 
aqbasketusers
aqorders
edifact_messages
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
aqcontract
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
aqbooksellers
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
basketgroupid int 10  √  null
aqbasketgroups
links this basket to its group (aqbasketgroups.id)
deliveryplace varchar 10  √  null basket delivery place
billingplace varchar 10  √  null basket billing place
branch varchar 10  √  null
branches
basket branch
is_standing bit 0 0 orders in this basket are standing
create_items enum 11  √  null when items should be created for orders in this basket

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Indexes:
Column(s) Type Sort
basketno Primary key Asc
branch Performance Asc
authorisedby Performance Asc
basketgroupid Performance Asc
booksellerid Performance Asc
contractnumber Performance Asc

Close relationships  within of separation: