aqbasket

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
basketno INT 10 √ null
aqbasketusers.basketno aqbasketusers_ibfk_1 C
aqorders.basketno aqorders_ibfk_1 C
edifact_messages.basketno emfk_basketno C

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.contractnumber aqbasket_ibfk_2 R

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.id aqbasket_ibfk_1 R

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.id aqbasket_ibfk_3 R

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.branchcode aqbasket_ibfk_4 N

basket branch
is_standing TINYINT 3 0

orders in this basket are standing
create_items enum('ordering', 'receiving', 'cataloguing') 11 √ NULL

when items should be created for orders in this basket

Indexes

Constraint Name Type Sort Column(s)
aqbasket_s_pk 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
PRIMARY Must be unique Asc basketno

Relationships

Close relationships within degrees of separation