aqbooksellers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
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

primary key and unique identifier assigned by Koha
name LONGTEXT 2147483647 null

vendor name
address1 LONGTEXT 2147483647 √ null

first line of vendor physical address
address2 LONGTEXT 2147483647 √ null

second line of vendor physical address
address3 LONGTEXT 2147483647 √ null

third line of vendor physical address
address4 LONGTEXT 2147483647 √ null

fourth line of vendor physical address
phone VARCHAR 30 √ null

vendor phone number
accountnumber LONGTEXT 2147483647 √ null

unused in Koha
othersupplier LONGTEXT 2147483647 √ null
currency VARCHAR 10
currency.currency Implied Constraint R

unused in Koha
booksellerfax LONGTEXT 2147483647 √ null

vendor fax number
notes LONGTEXT 2147483647 √ null

order notes
bookselleremail LONGTEXT 2147483647 √ null

vendor email
booksellerurl LONGTEXT 2147483647 √ null

unused in Koha
postal LONGTEXT 2147483647 √ 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

Indexes

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

Relationships

Close relationships within degrees of separation