Table testsql_comments.aqbooksellers
information about the vendors listed in acquisitions

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
id int 10  √ 
aqbasket
aqbasketgroups
aqcontacts
aqcontract
aqinvoices
edifact_messages
vendor_edi_accounts
primary key and unique identifier assigned by Koha
name mediumtext 16777215 vendor name
address1 mediumtext 16777215  √  null first line of vendor physical address
address2 mediumtext 16777215  √  null second line of vendor physical address
address3 mediumtext 16777215  √  null third line of vendor physical address
address4 mediumtext 16777215  √  null fourth line of vendor physical address
phone varchar 30  √  null vendor phone number
accountnumber mediumtext 16777215  √  null unused in Koha
othersupplier mediumtext 16777215  √  null
currency varchar 10
unused in Koha
booksellerfax mediumtext 16777215  √  null vendor fax number
notes mediumtext 16777215  √  null order notes
bookselleremail mediumtext 16777215  √  null vendor email
booksellerurl mediumtext 16777215  √  null unused in Koha
postal mediumtext 16777215  √  null vendor postal address (all lines)
url varchar 255  √  null vendor web address
active tinyint 3  √  null is this vendor active (1 for yes, 0 for no)
listprice varchar 10  √  null
currency
currency code for list prices
invoiceprice varchar 10  √  null
currency
currency code for invoice prices
gstreg tinyint 3  √  null is your library charged tax (1 for yes, 0 for no)
listincgst tinyint 3  √  null is tax included in list prices (1 for yes, 0 for no)
invoiceincgst tinyint 3  √  null is tax included in invoice prices (1 for yes, 0 for no)
tax_rate decimal 6,4  √  null the tax rate the library is charged
discount float 6,4  √  null discount offered on all items ordered from this vendor
fax varchar 50  √  null vendor fax number
deliverytime int 10  √  null vendor delivery time

Table contained 0 rows at Tue Dec 27 17:18 NZDT 2016

Indexes:
Column(s) Type Sort
id Primary key Asc
invoiceprice Performance Asc
listprice Performance Asc
name Performance Asc

Close relationships  within of separation: