Table testsql_comments.aqbooksellers
information about the vendors listed in acquisitions

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int 10  √ 
aqbasket.booksellerid aqbasket_ibfk_1 R
aqbasketgroups.booksellerid aqbasketgroups_ibfk_1 C
aqcontacts.booksellerid booksellerid_aqcontacts_fk C
aqcontract.booksellerid booksellerid_fk1 C
aqinvoices.booksellerid aqinvoices_fk_aqbooksellerid C
edifact_messages.vendor_id emfk_vendor C
vendor_edi_accounts.vendor_id vfk_vendor_id R
z3950servers.id Implied Constraint R
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
currency.currency Implied Constraint R
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 aqbooksellers_ibfk_1 C
currency code for list prices
invoiceprice varchar 10  √  null
currency.currency aqbooksellers_ibfk_2 C
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 Mon Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: