aqbooksellers

0 rows


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
aqbookseller_aliases.vendor_id aqbookseller_aliases_ibfk_1 C
aqbookseller_interfaces.vendor_id aqbookseller_interfaces_ibfk_1 C
aqbookseller_issues.vendor_id aqbookseller_issues_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
erm_agreements.vendor_id erm_agreements_ibfk_1 N
erm_eholdings_packages.vendor_id erm_eholdings_packages_ibfk_1 N
erm_eholdings_resources.vendor_id erm_eholdings_resources_ibfk_3 N
erm_licenses.vendor_id erm_licenses_ibfk_1 N
marc_order_accounts.vendor_id marc_ordering_account_ibfk_1 C
subscription.aqbooksellerid subscription_ibfk_4 N
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

vendor account number
type VARCHAR 255 √ NULL
notes LONGTEXT 2147483647 √ NULL

order notes
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
external_id VARCHAR 255 √ NULL

external id of the vendor
payment_method VARCHAR 255 √ NULL

the payment method for the vendor

Indexes

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

Relationships

Close relationships within degrees of separation