SchemaSpy Analysis of testsql_comments - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Dec 27 17:18 NZDT 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

testsql_comments contains 1724 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
auth_types auth_tag_to_report varchar 3
authorised_values authorised_value varchar 80
additional_fields authorised_value_category varchar 16
auth_header authtypecode varchar 10
auth_subfield_structure authtypecode varchar 10
auth_tag_structure authtypecode varchar 10
auth_types authtypecode varchar 10
auth_types authtypetext varchar 255
serial biblionumber varchar 100
borrowers branchcode varchar 10
branches branchcode varchar 10
branchrelations branchcode varchar 10
deletedborrowers branchcode varchar 10
issuingrules branchcode varchar 10
letter branchcode varchar 10
message_transports branchcode varchar 10
overduerules branchcode varchar 10
refund_lost_item_fee_rules branchcode varchar 10
repeatable_holidays branchcode varchar 10
special_holidays branchcode varchar 10
subscription branchcode varchar 10
authorised_values category varchar 32
authorised_value_categories category_name varchar 32
borrowers categorycode varchar 10
branchcategories categorycode varchar 10
branchrelations categorycode varchar 10
categories categorycode varchar 10
deletedborrowers categorycode varchar 10
issuingrules categorycode varchar 10
overduerules categorycode varchar 10
cities city_name varchar 100
borrower_attribute_types class varchar 255
class_sort_rules class_sort_rule varchar 10
class_sources class_sort_rule varchar 10
class_sources cn_source varchar 10
letter code varchar 20
marc_matchers code varchar 10
permissions code varchar 64
collections colTitle varchar 100
aqbooksellers currency varchar 10
currency currency varchar 10
marc_matchers description varchar 255
import_records encoding varchar 40
tags entry varchar 255
alert externalid varchar 20
auth_subfield_structure frameworkcode varchar 10
biblio frameworkcode varchar 4
biblio_framework frameworkcode varchar 4
deletedbiblio frameworkcode varchar 4
fieldmapping frameworkcode char 4
marc_subfield_structure frameworkcode varchar 4
marc_tag_structure frameworkcode varchar 4
biblio_framework frameworktext varchar 255
branchtransfers frombranch varchar 10
issuingrules itemtype varchar 10
itemtypes itemtype varchar 10
auth_subfield_structure kohafield varchar 45  √ 
opac_news lang varchar 25
message_transports letter_code varchar 20
message_transports letter_module varchar 20
auth_subfield_structure liblibrarian varchar 255
auth_tag_structure liblibrarian varchar 255
marc_subfield_structure liblibrarian varchar 255
marc_tag_structure liblibrarian varchar 255
auth_subfield_structure libopac varchar 255
auth_tag_structure libopac varchar 255
marc_subfield_structure libopac varchar 255
marc_tag_structure libopac varchar 255
subscription librarian varchar 100  √ 
subscriptionhistory librariannote varchar 150
subscription location varchar 80  √ 
additional_fields marcfield varchar 16
message_attributes message_name varchar 40
notifys method varchar 20
letter module varchar 20
additional_fields name varchar 255
letter name varchar 100
matchpoint_component_norms norm_routine varchar 50
subscriptionhistory opacnote varchar 150
zebraqueue operation char 20
vendor_edi_accounts plugin varchar 256
printers printername varchar 40
saved_sql report_name varchar 255
matchpoints search_index varchar 30
serial serialseq varchar 100
zebraqueue server char 20
services_throttle service_type varchar 10
class_sort_rules sort_routine varchar 30
subscription status varchar 100
suggestions STATUS varchar 10
matchpoint_components subfields varchar 40
serial subscriptionid varchar 100
additional_fields tablename varchar 255
matchpoint_components tag varchar 3
auth_subfield_structure tagfield varchar 3
auth_tag_structure tagfield varchar 3
marc_subfield_structure tagfield varchar 3
marc_tag_structure tagfield varchar 3
auth_subfield_structure tagsubfield varchar 1
marc_subfield_structure tagsubfield varchar 1
letter title varchar 200
opac_news title varchar 250
repeatable_holidays title varchar 50
special_holidays title varchar 50
marc_modification_template_actions to_regex_modifiers varchar 8  √ 
branchtransfers tobranch varchar 10
alert type varchar 10
additional_field_values value varchar 255
systempreferences variable varchar 50
borrower_modifications verification_token varchar 255
categories BlockExpiredPatronOpacActions bit 0 -1
accountlines accountno smallint 5 0
accountoffsets accountno smallint 5 0
aqcontacts acqprimary bit 0 0
virtualshelves allow_add bit 0  √  0
virtualshelves allow_delete_other bit 0  √  0
reviews approved tinyint 3  √  0
tags_approval approved int 10 0
subscription aqbooksellerid int 10  √  0
subscription aqbudgetid int 10  √  0
currency archived bit 0  √  0
vendor_edi_accounts auto_orders bit 0 0
issues auto_renew bit 0  √  0
issuingrules auto_renew bit 0  √  0
old_issues auto_renew bit 0  √  0
zebraqueue biblio_auth_number bigint unsigned 20 0
deletedbiblioitems biblioitemnumber int 10 0
deleteditems biblioitemnumber int 10 0
items biblioitemnumber int 10 0
biblioitems biblionumber int 10 0
deletedbiblioitems biblionumber int 10 0
deleteditems biblionumber int 10 0
items biblionumber int 10 0
reserves biblionumber int 10 0
subscription biblionumber int 10 0
subscriptionhistory biblionumber int 10 0
virtualshelfcontents biblionumber int 10 0
userflags bit int 10 0
borrower_message_transport_preferences borrower_message_preference_id int 10 0
accountlines borrowernumber int 10 0
accountoffsets borrowernumber int 10 0
alert borrowernumber int 10 0
borrower_modifications borrowernumber int 10 0
deletedborrowers borrowernumber int 10 0
notifys borrowernumber int 10 0
reserves borrowernumber int 10 0
user_permissions borrowernumber int 10 0
aqbudgetperiods budget_period_active bit 0  √  0
aqbudgets budget_permission int 10  √  0
creator_layouts callnum_split int 10  √  0
columns_settings cannot_be_toggled int 10 0
issuingrules cap_fine_to_replacement_price bit 0 0
issuingrules chargeperiod_charge_at bit 0 0
aqcontacts claimacquisition bit 0 0
aqcontacts claimissues bit 0 0
aqorders claims_count int 10  √  0
serial claims_count int 10  √  0
subscription closed int 10 0
creator_templates col_gap float 12 0
collections_tracking colId int 10 0
creator_templates cols int 10 0
marc_modification_template_actions conditional_regex bit 0 0
subscription cost int 10  √  0
printers_profile creep_horz float 12 0
printers_profile creep_vert float 12 0
deleteditems damaged bit 0 0
items damaged bit 0 0
special_holidays day smallint 5 0
borrower_message_preferences days_in_advance int 10  √  0
overduerules debarred1 varchar 1  √  0
overduerules debarred2 varchar 1  √  0
overduerules debarred3 int 10  √  0
edifact_messages deleted bit 0 0
transport_cost disable_transfer bit 0 0
borrower_attribute_types display_checkout bit 0 0
need_merge_authorities done tinyint 3  √  0
zebraqueue done int 10 0
search_marc_to_field facet bit 0  √  0
marc_modification_template_actions field_number smallint 5 0
subscription graceperiod int 10 0
creator_layouts guidebox int 10  √  0
issuingrules hardduedatecompare tinyint 3 0
import_biblios has_items bit 0 0
auth_subfield_structure hidden tinyint 3 0
itemtypes hideinopac bit 0 0
categories hidelostitems bit 0 0
housebound_role housebound_chooser bit 0 0
housebound_role housebound_deliverer bit 0 0
subscription innerloop1 int 10  √  0
subscription innerloop2 int 10  √  0
subscription innerloop3 int 10  √  0
vendor_edi_accounts invoices_enabled bit 0 0
message_transports is_digest bit 0 0
columns_settings is_hidden int 10 0
letter is_html bit 0  √  0
aqbasket is_standing bit 0 0
hold_fill_targets item_level_request tinyint 3 0
tmp_holdsqueue item_level_request tinyint 3 0
deleteditems itemlost bit 0 0
items itemlost bit 0 0
branchtransfers itemnumber int 10 0
collections_tracking itemnumber int 10 0
deleteditems itemnumber int 10 0
notifys itemnumber int 10 0
creator_templates label_height float 12 0
creator_templates label_width float 12 0
creator_templates left_margin float 12 0
creator_templates left_text_margin float 12 0
matchpoint_components length int 10 0
auth_subfield_structure linkid bit 0 0
auth_subfield_structure mandatory tinyint 3 0
auth_tag_structure mandatory tinyint 3 0
marc_subfield_structure mandatory tinyint 3 0
marc_tag_structure mandatory tinyint 3 0
subscription manualhistory bit 0 0
borrower_message_preferences message_attribute_id int 10  √  0
borrower_message_transport_preferences message_transport_type varchar 20 0
permissions module_bit int 10 0
user_permissions module_bit int 10 0
special_holidays month smallint 5 0
subscription monthlength int 10  √  0
deleteditems notforloan bit 0 0
items notforloan bit 0 0
accountlines notify_id int 10 0
notifys notify_id int 10 0
accountlines notify_level int 10 0
notifys notify_level int 10 0
import_batches num_items int 10 0
import_batches num_records int 10 0
subscription numberlength int 10  √  0
matchpoint_components offset int 10 0
printers_profile offset_horz float 12 0
printers_profile offset_vert float 12 0
accountoffsets offsetaccount smallint 5 0
issuingrules onshelfholds bit 0 0
issues onsite_checkout int 10 0
old_issues onsite_checkout int 10 0
borrower_attribute_types opac_display bit 0 0
aqcontacts orderacquisition bit 0 0
vendor_edi_accounts orders_enabled bit 0 0
creator_templates page_height float 12 0
creator_templates page_width float 12 0
borrowers privacy_guarantor_checkouts bit 0 0
deletedborrowers privacy_guarantor_checkouts bit 0 0
saved_sql public bit 0 0
suggestions publicationyear smallint 5  √  0
aqorders quantityreceived smallint 5 0
vendor_edi_accounts quotes_enabled bit 0 0
import_records record_sequence int 10 0
refund_lost_item_fee_rules refund bit 0 0
issuingrules renewalsallowed smallint 5 0
auth_subfield_structure repeatable tinyint 3 0
auth_tag_structure repeatable tinyint 3 0
borrower_attribute_types repeatable bit 0 0
marc_subfield_structure repeatable tinyint 3 0
marc_tag_structure repeatable tinyint 3 0
issuingrules reservesallowed smallint 5 0
vendor_edi_accounts responses_enabled bit 0 0
creator_templates row_gap float 12 0
creator_templates rows int 10 0
import_record_matches score int 10 0
matchpoints score int 10 0
additional_fields searchable bit 0 0
matchpoint_component_norms sequence int 10 0
matchpoint_components sequence int 10 0
subscription serialsadditems bit 0 0
aqcontacts serialsprimary bit 0 0
virtualshelfcontents shelfnumber int 10 0
branchcategories show_in_pulldown bit 0 0
subscription skip_serialseq bit 0 0
borrower_attribute_types staff_searchable bit 0 0
serial status tinyint 3 0
subscriptionhistory subscriptionid int 10 0
suggestions suggestedby int 10 0
search_marc_to_field suggestible bit 0  √  0
old_reserves suspend bit 0 0
reserves suspend bit 0 0
borrower_sync sync bit 0 0
message_attributes takes_days bit 0 0
printers_profile template_id int 10 0
marc_matchers threshold int 10 0
z3950servers timeout int 10 0
creator_templates top_margin float 12 0
creator_templates top_text_margin float 12 0
borrower_attribute_types unique_id bit 0 0
class_sources used tinyint 3 0
action_logs user int 10 0
borrower_message_preferences wants_digest bit 0 0
subscription weeklength int 10  √  0
tags weight bigint 19 0
deleteditems withdrawn bit 0 0
items withdrawn bit 0 0
special_holidays year smallint 5 0
aqbudgets budget_amount decimal 28,6  √  0.000000
aqbudgets budget_encumb decimal 28,6  √  0.000000
aqbudgets budget_expend decimal 28,6  √  0.000000
virtualshelves allow_delete_own bit 0  √  1
creator_batches batch_id int 10 1
aqbasket booksellerid int 10 1
subscription countissuesperunit int 10 1
aqbudgets_planning display bit 0  √  1
issuingrules holds_per_record smallint 5 1
special_holidays isexception smallint 5 1
subscription_frequencies issuesperunit int 10 1
overduerules_transport_types letternumber int 10 1
creator_layouts oblique_title int 10  √  1
borrowers privacy int 10 1
deletedborrowers privacy int 10 1
creator_layouts start_label int 10 1
subscription_frequencies unitsperissue int 10 1
tags_index weight int 10 1
tags_approval weight_total int 10 1
creator_layouts font_size int 10 10
edifact_ean id_code_qualifier varchar 3 14
vendor_edi_accounts id_code_qualifier varchar 3  √  14
saved_sql cache_expiry int 10 300
marc_subfield_structure maxlength int 10 9999
categories category_type varchar 1 A
import_batches item_action enum 20 always_add
branch_item_rules hold_fulfillment_policy enum 13 any
default_branch_circ_rules hold_fulfillment_policy enum 13 any
default_branch_item_rules hold_fulfillment_policy enum 13 any
default_circ_rules hold_fulfillment_policy enum 13 any
creator_layouts printing_type char 32 BAR
creator_layouts format_string varchar 210 barcode
import_batches batch_type enum 10 batch
import_batches record_type enum 8 biblio
import_records record_type enum 8 biblio
marc_matchers record_type varchar 10 biblio
z3950servers recordtype enum 10 biblio
search_history type varchar 16 biblio
printers_profile paper_bin varchar 20 Bypass
creator_layouts barcode_type char 100 CODE39
import_batches nomatch_action enum 11 create_new
import_batches overlay_action enum 12 create_new
borrower_debarments created timestamp 19 CURRENT_TIMESTAMP
article_requests created_on timestamp 19 CURRENT_TIMESTAMP
items_last_borrower created_on timestamp 19 CURRENT_TIMESTAMP
suggestions date timestamp 19 CURRENT_TIMESTAMP
borrower_files date_uploaded timestamp 19 CURRENT_TIMESTAMP
misc_files date_uploaded timestamp 19 CURRENT_TIMESTAMP
virtualshelfcontents dateadded timestamp 19 CURRENT_TIMESTAMP
uploaded_files dtcreated timestamp 19 CURRENT_TIMESTAMP
virtualshelves lastmodified timestamp 19 CURRENT_TIMESTAMP
messages message_date timestamp 19 CURRENT_TIMESTAMP
auth_header modification_time timestamp 19 CURRENT_TIMESTAMP
search_history time timestamp 19 CURRENT_TIMESTAMP
zebraqueue time timestamp 19 CURRENT_TIMESTAMP
message_queue time_queued timestamp 19 CURRENT_TIMESTAMP
accountlines timestamp timestamp 19 CURRENT_TIMESTAMP
accountoffsets timestamp timestamp 19 CURRENT_TIMESTAMP
action_logs timestamp timestamp 19 CURRENT_TIMESTAMP
aqbudgets timestamp timestamp 19 CURRENT_TIMESTAMP
aqorders timestamp timestamp 19 CURRENT_TIMESTAMP
aqorders_items timestamp timestamp 19 CURRENT_TIMESTAMP
aqorders_transfers timestamp timestamp 19 CURRENT_TIMESTAMP
biblio timestamp timestamp 19 CURRENT_TIMESTAMP
biblioitems timestamp timestamp 19 CURRENT_TIMESTAMP
borrower_modifications timestamp timestamp 19 CURRENT_TIMESTAMP
course_items timestamp timestamp 19 CURRENT_TIMESTAMP
course_reserves timestamp timestamp 19 CURRENT_TIMESTAMP
courses timestamp timestamp 19 CURRENT_TIMESTAMP
creator_batches timestamp timestamp 19 CURRENT_TIMESTAMP
currency timestamp timestamp 19 CURRENT_TIMESTAMP
deletedbiblio timestamp timestamp 19 CURRENT_TIMESTAMP
deletedbiblioitems timestamp timestamp 19 CURRENT_TIMESTAMP
deleteditems timestamp timestamp 19 CURRENT_TIMESTAMP
issues timestamp timestamp 19 CURRENT_TIMESTAMP
items timestamp timestamp 19 CURRENT_TIMESTAMP
old_issues timestamp timestamp 19 CURRENT_TIMESTAMP
old_reserves timestamp timestamp 19 CURRENT_TIMESTAMP
opac_news timestamp timestamp 19 CURRENT_TIMESTAMP
pending_offline_operations timestamp timestamp 19 CURRENT_TIMESTAMP
ratings timestamp timestamp 19 CURRENT_TIMESTAMP
reserves timestamp timestamp 19 CURRENT_TIMESTAMP
borrowers updated_on timestamp 19 CURRENT_TIMESTAMP
deletedborrowers updated_on timestamp 19 CURRENT_TIMESTAMP
import_batches upload_timestamp timestamp 19 CURRENT_TIMESTAMP
import_records upload_timestamp timestamp 19 CURRENT_TIMESTAMP
borrower_password_recovery valid_until timestamp 19 CURRENT_TIMESTAMP
issuingrules lengthunit varchar 10  √  days
categories default_privacy enum 8 default
creator_images image_name char 20 DEFAULT
creator_layouts layout_name char 25 DEFAULT
creator_templates template_desc char 100 Default description
printers_profile printer_name varchar 40 Default Printer
creator_templates template_code char 100 DEFAULT TEMPLATE
letter message_transport_type varchar 20 email
overduerules_transport_types message_transport_type varchar 20 email
oai_sets_mappings operator varchar 8 equal
vendor_edi_accounts transport varchar 6  √  FTP
borrowers checkprevcheckout varchar 7 inherit
categories checkprevcheckout varchar 7 inherit
deletedborrowers checkprevcheckout varchar 7 inherit
creator_layouts text_justify char 1 L
creator_batches creator char 15 Labels
creator_layouts creator char 15 Labels
creator_templates creator char 15 Labels
printers_profile creator char 15 Labels
borrower_debarments type enum 11 MANUAL
export_format type varchar 255  √  marc
itemtypes checkinmsgtype char 16 message
issuingrules opacitemholds char 1 N
creator_batches branch_code varchar 10 NB
aqorders orderstatus varchar 16  √  new
issuingrules article_requests enum 9 no
course_items enabled enum 4 no
import_records overlay_status enum 13 no_match
sessions a_session mediumtext 16777215
biblio abstract mediumtext 16777215  √  null
deletedbiblio abstract mediumtext 16777215  √  null
suggestions acceptedby int 10  √  null
suggestions accepteddate date 10  √  null
accountlines accountlines_id int 10  √ 
aqbooksellers accountnumber mediumtext 16777215  √  null
issuingrules accountsent int 10  √  null
accountlines accounttype varchar 5  √  null
action_logs action text 65535  √  null
marc_modification_template_actions action enum 22
pending_offline_operations action varchar 10
action_logs action_id int 10  √ 
aqbooksellers active tinyint 3  √  null
currency active bit 0  √  null
subscription_numberpatterns add1 int 10  √  null
subscription_numberpatterns add2 int 10  √  null
subscription_numberpatterns add3 int 10  √  null
z3950servers add_xslt mediumtext 16777215  √  null
language_subtag_registry added date 10  √  null
borrower_modifications address mediumtext 16777215  √  null
borrowers address mediumtext 16777215
deletedborrowers address mediumtext 16777215
aqbooksellers address1 mediumtext 16777215  √  null
aqbooksellers address2 mediumtext 16777215  √  null
borrower_modifications address2 text 65535  √  null
borrowers address2 text 65535  √  null
deletedborrowers address2 text 65535  √  null
aqbooksellers address3 mediumtext 16777215  √  null
aqbooksellers address4 mediumtext 16777215  √  null
biblioitems agerestriction varchar 255  √  null
deletedbiblioitems agerestriction varchar 255  √  null
alert alertid int 10  √ 
borrower_modifications altcontactaddress1 varchar 255  √  null
borrowers altcontactaddress1 varchar 255  √  null
deletedborrowers altcontactaddress1 varchar 255  √  null
borrower_modifications altcontactaddress2 varchar 255  √  null
borrowers altcontactaddress2 varchar 255  √  null
deletedborrowers altcontactaddress2 varchar 255  √  null
borrower_modifications altcontactaddress3 varchar 255  √  null
borrowers altcontactaddress3 varchar 255  √  null
deletedborrowers altcontactaddress3 varchar 255  √  null
borrower_modifications altcontactcountry text 65535  √  null
borrowers altcontactcountry text 65535  √  null
deletedborrowers altcontactcountry text 65535  √  null
borrower_modifications altcontactfirstname varchar 255  √  null
borrowers altcontactfirstname varchar 255  √  null
deletedborrowers altcontactfirstname varchar 255  √  null
borrower_modifications altcontactphone varchar 50  √  null
borrowers altcontactphone varchar 50  √  null
deletedborrowers altcontactphone varchar 50  √  null
borrower_modifications altcontactstate text 65535  √  null
borrowers altcontactstate text 65535  √  null
deletedborrowers altcontactstate text 65535  √  null
borrower_modifications altcontactsurname varchar 255  √  null
borrowers altcontactsurname varchar 255  √  null
deletedborrowers altcontactsurname varchar 255  √  null
borrower_modifications altcontactzipcode varchar 50  √  null
borrowers altcontactzipcode varchar 50  √  null
deletedborrowers altcontactzipcode varchar 50  √  null
aqcontacts altphone varchar 100  √  null
accountlines amount decimal 28,6  √  null
pending_offline_operations amount decimal 28,6  √  null
accountlines amountoutstanding decimal 28,6  √  null
housebound_visit appointment_date date 10  √  null
tags_approval approved_by int 10  √  null
statistics associatedborrower int 10  √  null
borrower_attributes attribute varchar 255  √  null
aqbudgets_planning authcat varchar 30
auth_header authid bigint unsigned 20  √ 
need_merge_authorities authid bigint 19
article_requests author text 65535  √  null
biblio author mediumtext 16777215  √  null
deletedbiblio author mediumtext 16777215  √  null
import_biblios author varchar 80  √  null
suggestions author varchar 80  √  null
auth_subfield_structure authorised_value varchar 10  √  null
auth_tag_structure authorised_value varchar 10  √  null
marc_subfield_structure authorised_value varchar 32  √  null
marc_tag_structure authorised_value varchar 10  √  null
borrower_attribute_types authorised_value_category varchar 32  √  null
items_search_fields authorised_values_category varchar 32  √  null
aqbasket authorisedby varchar 10  √  null
import_auths authorized_heading varchar 128  √  null
auth_header authtrees mediumtext 16777215  √  null
marc_subfield_structure authtypecode varchar 20  √  null
aqbudgets_planning authvalue varchar 30
authorised_values_branches av_id int 10
borrower_modifications B_address varchar 100  √  null
borrowers B_address varchar 100  √  null
deletedborrowers B_address varchar 100  √  null
borrower_modifications B_address2 text 65535  √  null
borrowers B_address2 text 65535  √  null
deletedborrowers B_address2 text 65535  √  null
borrower_attribute_types_branches b_branchcode varchar 10  √  null
borrower_modifications B_city mediumtext 16777215  √  null
borrowers B_city mediumtext 16777215  √  null
deletedborrowers B_city mediumtext 16777215  √  null
borrower_modifications B_country text 65535  √  null
borrowers B_country text 65535  √  null
deletedborrowers B_country text 65535  √  null
borrower_modifications B_email text 65535  √  null
borrowers B_email text 65535  √  null
deletedborrowers B_email text 65535  √  null
borrower_modifications B_phone mediumtext 16777215  √  null
borrowers B_phone mediumtext 16777215  √  null
deletedborrowers B_phone mediumtext 16777215  √  null
borrower_modifications B_state text 65535  √  null
borrowers B_state text 65535  √  null
deletedborrowers B_state text 65535  √  null
borrower_modifications B_streetnumber varchar 10  √  null
borrowers B_streetnumber varchar 10  √  null
deletedborrowers B_streetnumber varchar 10  √  null
borrower_modifications B_streettype varchar 50  √  null
borrowers B_streettype varchar 50  √  null
deletedborrowers B_streettype varchar 50  √  null
borrower_modifications B_zipcode varchar 25  √  null
borrowers B_zipcode varchar 25  √  null
deletedborrowers B_zipcode varchar 25  √  null
deleteditems barcode varchar 20  √  null
items barcode varchar 20  √  null
pending_offline_operations barcode varchar 20  √  null
tmp_holdsqueue barcode varchar 20  √  null
aqbasket basketgroupid int 10  √  null
aqbasket basketname varchar 50  √  null
aqbasket basketno int 10  √ 
aqbasketusers basketno int 10
aqorders basketno int 10  √  null
edifact_messages basketno int 10  √  null
borrower_attribute_types_branches bat_code varchar 10  √  null
biblioitems biblioitemnumber int 10  √ 
aqorders biblionumber int 10  √  null
article_requests biblionumber int 10
biblio biblionumber int 10  √ 
biblioimages biblionumber int 10
deletedbiblio biblionumber int 10  √ 
hold_fill_targets biblionumber int 10
linktracker biblionumber int 10  √  null
oai_sets_biblios biblionumber int 10
old_reserves biblionumber int 10  √  null
ratings biblionumber int 10
reviews biblionumber int 10  √  null
suggestions biblionumber int 10  √  null
tags_all biblionumber int 10
tags_index biblionumber int 10
tmp_holdsqueue biblionumber int 10  √  null
language_script_bidi bidi varchar 3  √  null
aqinvoices billingdate date 10  √  null
aqbasket billingplace varchar 10  √  null
aqbasketgroups billingplace varchar 10  √  null
aqbooksellers bookselleremail mediumtext 16777215  √  null
aqbooksellers booksellerfax mediumtext 16777215  √  null
aqbasketgroups booksellerid int 10
aqcontacts booksellerid int 10
aqcontract booksellerid int 10
aqinvoices booksellerid int 10
deleteditems booksellerid mediumtext 16777215  √  null
items booksellerid mediumtext 16777215  √  null
aqbasket booksellerinvoicenumber mediumtext 16777215  √  null
aqbasket booksellernote mediumtext 16777215  √  null
aqbooksellers booksellerurl mediumtext 16777215  √  null
discharges borrower int 10  √  null
borrower_debarments borrower_debarment_id int 10  √ 
borrower_message_preferences borrower_message_preference_id int 10  √ 
creator_batches borrower_number int 10  √  null
borrower_modifications borrowernotes mediumtext 16777215  √  null
borrowers borrowernotes mediumtext 16777215  √  null
deletedborrowers borrowernotes mediumtext 16777215  √  null
aqbasketusers borrowernumber int 10
aqbudgetborrowers borrowernumber int 10
aqorder_users borrowernumber int 10
article_requests borrowernumber int 10
borrower_attributes borrowernumber int 10
borrower_debarments borrowernumber int 10
borrower_files borrowernumber int 10
borrower_message_preferences borrowernumber int 10  √  null
borrower_password_recovery borrowernumber int 10
borrower_sync borrowernumber int 10
borrowers borrowernumber int 10  √ 
course_instructors borrowernumber int 10
hold_fill_targets borrowernumber int 10
housebound_profile borrowernumber int 10
housebound_visit borrowernumber int 10
issues borrowernumber int 10  √  null
items_last_borrower borrowernumber int 10
linktracker borrowernumber int 10  √  null
message_queue borrowernumber int 10  √  null
messages borrowernumber int 10
old_issues borrowernumber int 10  √  null
old_reserves borrowernumber int 10  √  null
opac_news borrowernumber int 10  √  null
patron_list_patrons borrowernumber int 10
patronimage borrowernumber int 10
ratings borrowernumber int 10
reviews borrowernumber int 10  √  null
saved_sql borrowernumber int 10  √  null
statistics borrowernumber int 10  √  null
subscriptionroutinglist borrowernumber int 10
tags_all borrowernumber int 10  √  null
tmp_holdsqueue borrowernumber int 10
virtualshelfcontents borrowernumber int 10  √  null
virtualshelfshares borrowernumber int 10  √  null
housebound_role borrowernumber_id int 10
borrower_sync borrowersyncid int 10  √ 
aqbasket branch varchar 10  √  null
statistics branch varchar 10  √  null
branches branchaddress1 mediumtext 16777215  √  null
branches branchaddress2 mediumtext 16777215  √  null
branches branchaddress3 mediumtext 16777215  √  null
branches branchcity mediumtext 16777215  √  null
article_requests branchcode varchar 10  √  null
authorised_values_branches branchcode varchar 10
borrower_modifications branchcode varchar 10  √  null
branch_borrower_circ_rules branchcode varchar 10
branch_item_rules branchcode varchar 10
categories_branches branchcode varchar 10  √  null
default_branch_circ_rules branchcode varchar 10
edifact_ean branchcode varchar 10
import_batches branchcode varchar 10  √  null
import_items branchcode varchar 10  √  null
import_records branchcode varchar 10  √  null
issues branchcode varchar 10  √  null
item_circulation_alert_preferences branchcode varchar 10
messages branchcode varchar 10  √  null
old_issues branchcode varchar 10  √  null
old_reserves branchcode varchar 10  √  null
opac_news branchcode varchar 10  √  null
pending_offline_operations branchcode varchar 10
reserves branchcode varchar 10  √  null
suggestions branchcode varchar 10  √  null
branches branchcountry text 65535  √  null
branches branchemail mediumtext 16777215  √  null
branches branchfax mediumtext 16777215  √  null
branches branchip varchar 15  √  null
branches branchname mediumtext 16777215
branches branchnotes mediumtext 16777215  √  null
branches branchphone mediumtext 16777215  √  null
branches branchprinter varchar 100  √  null
branches branchreplyto mediumtext 16777215  √  null
branches branchreturnpath mediumtext 16777215  √  null
branches branchstate mediumtext 16777215  √  null
branches branchurl mediumtext 16777215  √  null
branches branchzip varchar 25  √  null
aqbudgets budget_branchcode varchar 10  √  null
aqbudgets budget_code varchar 30  √  null
aqbudgetborrowers budget_id int 10
aqbudgets budget_id int 10  √ 
aqbudgets_planning budget_id int 10
aqorders budget_id int 10
aqbudgets budget_name varchar 80  √  null
aqbudgets budget_notes mediumtext 16777215  √  null
aqbudgets budget_owner_id int 10  √  null
aqbudgets budget_parent_id int 10  √  null
aqbudgetperiods budget_period_description mediumtext 16777215  √  null
aqbudgetperiods budget_period_enddate date 10
aqbudgetperiods budget_period_id int 10  √ 
aqbudgets budget_period_id int 10  √  null
aqbudgets_planning budget_period_id int 10
aqbudgetperiods budget_period_locked bit 0  √  null
aqbudgetperiods budget_period_startdate date 10
aqbudgetperiods budget_period_total decimal 28,6  √  null
aqorders budgetdate date 10  √  null
suggestions budgetid int 10  √  null
categories bulk bit 0  √  null
subscription callnumber text 65535  √  null
old_reserves cancellationdate date 10  √  null
reserves cancellationdate date 10  √  null
aqorders cancellationreason text 65535  √  null
import_record_matches candidate_match_id int 10
borrower_modifications cardnumber varchar 16  √  null
borrowers cardnumber varchar 16  √  null
deletedborrowers cardnumber varchar 16  √  null
pending_offline_operations cardnumber varchar 16  √  null
tmp_holdsqueue cardnumber varchar 16  √  null
virtualshelves category varchar 1  √  null
borrower_attribute_types category_code varchar 10  √  null
borrower_message_preferences categorycode varchar 10  √  null
borrower_modifications categorycode varchar 10  √  null
branch_borrower_circ_rules categorycode varchar 10
categories_branches categorycode varchar 10  √  null
default_borrower_circ_rules categorycode varchar 10
item_circulation_alert_preferences categorycode varchar 10
branchcategories categoryname varchar 32  √  null
branchcategories categorytype varchar 16  √  null
branch_transfer_limits ccode varchar 10  √  null
course_items ccode varchar 10  √  null
deleteditems ccode varchar 10  √  null
items ccode varchar 10  √  null
statistics ccode varchar 10  √  null
article_requests chapters text 65535  √  null
issuingrules chargename varchar 100  √  null
issuingrules chargeperiod int 10  √  null
z3950servers checked smallint 5  √  null
itemtypes checkinmsg varchar 255  √  null
housebound_visit chooser_brwnumber int 10  √  null
course_items ci_id int 10  √ 
course_reserves ci_id int 10
borrower_modifications city mediumtext 16777215  √  null
borrowers city mediumtext 16777215
deletedborrowers city mediumtext 16777215
cities city_country varchar 100  √  null
cities city_state varchar 100  √  null
cities city_zipcode varchar 20  √  null
cities cityid int 10  √ 
serial claimdate date 10  √  null
aqorders claimed_date date 10  √  null
browser classification varchar 20
aqbasketgroups closed bit 0  √  null
aqbasket closedate date 10  √  null
aqinvoices closedate date 10  √  null
biblioitems cn_class varchar 30  √  null
deletedbiblioitems cn_class varchar 30  √  null
biblioitems cn_item varchar 10  √  null
deletedbiblioitems cn_item varchar 10  √  null
biblioitems cn_sort varchar 255  √  null
deletedbiblioitems cn_sort varchar 255  √  null
deleteditems cn_sort varchar 255  √  null
items cn_sort varchar 255  √  null
biblioitems cn_source varchar 10  √  null
deletedbiblioitems cn_source varchar 10  √  null
deleteditems cn_source varchar 10  √  null
items cn_source varchar 10  √  null
biblioitems cn_suffix varchar 10  √  null
deletedbiblioitems cn_suffix varchar 10  √  null
borrower_attribute_types code varchar 10
borrower_attributes code varchar 10
localization code varchar 64
user_permissions code varchar 64  √  null
deleteditems coded_location_qualifier varchar 10  √  null
items coded_location_qualifier varchar 10  √  null
branchcategories codedescription mediumtext 16777215  √  null
collections colBranchcode varchar 10  √  null
collections colDesc text 65535
collections colId int 10  √ 
biblioitems collectionissn text 65535  √  null
deletedbiblioitems collectionissn text 65535  √  null
collections_tracking collections_tracking_id int 10  √ 
biblioitems collectiontitle mediumtext 16777215  √  null
deletedbiblioitems collectiontitle mediumtext 16777215  √  null
suggestions collectiontitle text 65535  √  null
biblioitems collectionvolume mediumtext 16777215  √  null
deletedbiblioitems collectionvolume mediumtext 16777215  √  null
columns_settings columnname varchar 255
borrower_debarments comment text 65535  √  null
branchtransfers comments mediumtext 16777215  √  null
import_batches comments mediumtext 16777215  √  null
marc_modification_template_actions conditional enum 6  √  null
marc_modification_template_actions conditional_comparison enum 10  √  null
marc_modification_template_actions conditional_field varchar 3  √  null
marc_modification_template_actions conditional_subfield varchar 1  √  null
marc_modification_template_actions conditional_value text 65535  √  null
borrower_modifications contactfirstname text 65535  √  null
borrowers contactfirstname text 65535  √  null
deletedborrowers contactfirstname text 65535  √  null
borrower_modifications contactname mediumtext 16777215  √  null
borrowers contactname mediumtext 16777215  √  null
deletedborrowers contactname mediumtext 16777215  √  null
borrower_modifications contactnote varchar 255  √  null
borrowers contactnote varchar 255  √  null
deletedborrowers contactnote varchar 255  √  null
borrower_modifications contacttitle text 65535  √  null
borrowers contacttitle text 65535  √  null
deletedborrowers contacttitle text 65535  √  null
export_format content mediumtext 16777215
letter content text 65535  √  null
message_queue content text 65535  √  null
message_queue content_type text 65535  √  null
aqcontract contractdescription mediumtext 16777215  √  null
aqcontract contractenddate date 10  √  null
aqcontract contractname varchar 50  √  null
aqbasket contractnumber int 10  √  null
aqcontract contractnumber int 10  √ 
aqcontract contractstartdate date 10  √  null
import_auths control_number varchar 25  √  null
import_biblios control_number varchar 25  √  null
deleteditems copynumber varchar 32  √  null
items copynumber varchar 32  √  null
biblio copyrightdate smallint 5  √  null
deletedbiblio copyrightdate smallint 5  √  null
suggestions copyrightdate smallint 5  √  null
transport_cost cost decimal 6,2
borrower_modifications country text 65535  √  null
borrowers country text 65535  √  null
deletedborrowers country text 65535  √  null
course_instructors course_id int 10
course_reserves course_id int 10
courses course_id int 10  √ 
courses course_name varchar 255  √  null
courses course_number varchar 255  √  null
course_reserves cr_id int 10  √ 
virtualshelves created_on datetime 19
aqbasket creationdate date 10  √  null
export_format csv_separator varchar 2
aqorders currency varchar 10  √  null
suggestions currency varchar 10  √  null
accountlines date date 10  √  null
article_requests date text 65535  √  null
tags_approval date_approved datetime 19  √  null
reports_dictionary date_created datetime 19  √  null
saved_sql date_created datetime 19  √  null
tags_all date_created datetime 19
issues date_due datetime 19  √  null
old_issues date_due datetime 19  √  null
reports_dictionary date_modified datetime 19  √  null
saved_reports date_run datetime 19  √  null
deleteditems dateaccessioned date 10  √  null
items dateaccessioned date 10  √  null
branchtransfers datearrived datetime 19  √  null
aqorders datecancellationprinted date 10  √  null
auth_header datecreated date 10  √  null
biblio datecreated date 10
deletedbiblio datecreated date 10
borrower_modifications dateenrolled date 10  √  null
borrowers dateenrolled date 10  √  null
deletedborrowers dateenrolled date 10  √  null
borrower_modifications dateexpiry date 10  √  null
borrowers dateexpiry date 10  √  null
deletedborrowers dateexpiry date 10  √  null
deleteditems datelastborrowed date 10  √  null
items datelastborrowed date 10  √  null
deleteditems datelastseen date 10  √  null
items datelastseen date 10  √  null
borrower_modifications dateofbirth date 10  √  null
borrowers dateofbirth date 10  √  null
deletedborrowers dateofbirth date 10  √  null
categories dateofbirthrequired bit 0  √  null
aqorders datereceived date 10  √  null
reviews datereviewed datetime 19  √  null
branchtransfers datesent datetime 19  √  null
statistics datetime datetime 19  √  null
housebound_profile day text 65535
repeatable_holidays day smallint 5  √  null
housebound_visit day_segment varchar 10  √  null
z3950servers db varchar 255  √  null
borrower_modifications debarred date 10  √  null
borrowers debarred date 10  √  null
deletedborrowers debarred date 10  √  null
borrower_modifications debarredcomment varchar 255  √  null
borrowers debarredcomment varchar 255  √  null
deletedborrowers debarredcomment varchar 255  √  null
userflags defaulton int 10  √  null
auth_subfield_structure defaultvalue text 65535  √  null
marc_subfield_structure defaultvalue text 65535  √  null
overduerules delay1 int 10  √  null
overduerules delay2 int 10  √  null
overduerules delay3 int 10  √  null
housebound_visit deliverer_brwnumber int 10  √  null
aqbasketgroups deliverycomment varchar 255  √  null
aqbasket deliveryplace varchar 10  √  null
aqbasketgroups deliveryplace varchar 10  √  null
aqbooksellers deliverytime int 10  √  null
courses department varchar 80  √  null
accountlines description mediumtext 16777215  √  null
borrower_attribute_types description varchar 255
browser description varchar 255
categories description mediumtext 16777215  √  null
class_sort_rules description mediumtext 16777215  √  null
class_sources description mediumtext 16777215  √  null
edifact_ean description varchar 128  √  null
export_format description mediumtext 16777215
itemtypes description mediumtext 16777215  √  null
language_descriptions description varchar 255  √  null
language_subtag_registry description varchar 25  √  null
marc_modification_template_actions description text 65535  √  null
oai_sets_descriptions description varchar 255
permissions description varchar 255  √  null
repeatable_holidays description text 65535
reports_dictionary description text 65535  √  null
special_holidays description text 65535
subscription_frequencies description text 65535
subscription_numberpatterns description text 65535
vendor_edi_accounts description text 65535
uploaded_files dir text 65535
discharges discharge_id int 10  √ 
aqbooksellers discount float 6,4  √  null
aqorders discount float 6,4  √  null
subscription_frequencies displayorder int 10  √  null
subscription_numberpatterns displayorder int 10  √  null
accountlines dispute mediumtext 16777215  √  null
subscription distributedto text 65535  √  null
sms_providers domain varchar 255
vendor_edi_accounts download_directory text 65535  √  null
biblioitems ean varchar 13  √  null
deletedbiblioitems ean varchar 13  √  null
edifact_ean ean varchar 15
aqorders ecost decimal 13,2  √  null
aqorders ecost_tax_excluded decimal 28,6  √  null
aqorders ecost_tax_included decimal 28,6  √  null
edifact_messages edi_acct int 10  √  null
biblioitems editionresponsibility text 65535  √  null
deletedbiblioitems editionresponsibility text 65535  √  null
biblioitems editionstatement text 65535  √  null
deletedbiblioitems editionstatement text 65535  √  null
edifact_ean ee_id int 10  √ 
aqcontacts email varchar 100  √  null
borrower_modifications email mediumtext 16777215  √  null
borrowers email mediumtext 16777215  √  null
deletedborrowers email mediumtext 16777215  √  null
borrower_modifications emailpro text 65535  √  null
borrowers emailpro text 65535  √  null
deletedborrowers emailpro text 65535  √  null
export_format encoding varchar 255
z3950servers encoding text 65535  √  null
subscription enddate date 10  √  null
browser endnode tinyint 3
categories enrolmentfee decimal 28,6  √  null
categories enrolmentperiod smallint 5  √  null
categories enrolmentperioddate date 10  √  null
localization entity varchar 16
aqorders entrydate date 10  √  null
deleteditems enumchron text 65535  √  null
items enumchron text 65535  √  null
aqbudgets_planning estimated_amount decimal 28,6  √  null
subscription_numberpatterns every1 int 10  √  null
subscription_numberpatterns every2 int 10  √  null
subscription_numberpatterns every3 int 10  √  null
borrower_debarments expiration date 10  √  null
old_reserves expirationdate date 10  √  null
opac_news expirationdate date 10  √  null
reserves expirationdate date 10  √  null
systempreferences explanation text 65535  √  null
export_format export_format_id int 10  √ 
housebound_profile fav_authors text 65535  √  null
housebound_profile fav_itemtypes text 65535  √  null
housebound_profile fav_subjects text 65535  √  null
aqbooksellers fax varchar 50  √  null
aqcontacts fax varchar 100  √  null
borrower_modifications fax mediumtext 16777215  √  null
borrowers fax mediumtext 16777215  √  null
deletedborrowers fax mediumtext 16777215  √  null
fieldmapping field varchar 255
additional_field_values field_id int 10
export_format field_separator varchar 2
marc_modification_template_actions field_value varchar 100  √  null
fieldmapping fieldcode char 3
borrower_files file_content longblob 2147483647
misc_files file_content longblob 2147483647
borrower_files file_description varchar 255  √  null
misc_files file_description varchar 255  √  null
borrower_files file_id int 10  √ 
misc_files file_id int 10  √ 
borrower_files file_name varchar 255
import_batches file_name varchar 100  √  null
misc_files file_name varchar 255
borrower_files file_type varchar 255
misc_files file_type varchar 255
edifact_messages filename text 65535  √  null
uploaded_files filename text 65535
uploaded_files filesize int 10  √  null
issuingrules fine decimal 28,6  √  null
issuingrules finedays int 10  √  null
categories finetype varchar 30  √  null
subscription firstacquidate date 10  √  null
borrower_modifications firstname text 65535  √  null
borrowers firstname text 65535  √  null
deletedborrowers firstname text 65535  √  null
tmp_holdsqueue firstname text 65535  √  null
issuingrules firstremind int 10  √  null
userflags flag varchar 30  √  null
userflags flagdesc varchar 255  √  null
borrower_modifications flags int 10  √  null
borrowers flags int 10  √  null
deletedborrowers flags int 10  √  null
virtualshelfcontents flags int 10  √  null
old_reserves found varchar 1  √  null
reserves found varchar 1  √  null
aqbasketgroups freedeliveryplace text 65535  √  null
aqorders freight decimal 28,6  √  null
housebound_profile frequency text 65535
message_queue from_address mediumtext 16777215  √  null
marc_modification_template_actions from_field varchar 3
marc_modification_template_actions from_subfield varchar 1  √  null
branch_transfer_limits fromBranch varchar 10
transport_cost frombranch varchar 10
borrower_modifications gonenoaddress bit 0  √  null
borrowers gonenoaddress bit 0  √  null
deletedborrowers gonenoaddress bit 0  √  null
aqbooksellers gstreg tinyint 3  √  null
borrower_modifications guarantorid int 10  √  null
borrowers guarantorid int 10  √  null
deletedborrowers guarantorid int 10  √  null
issuingrules hardduedate date 10  √  null
borrower_sync hashed_pin varchar 64  √  null
uploaded_files hashvalue char 40
marc_subfield_structure hidden bit 0  √  null
subscriptionhistory histenddate date 10  √  null
subscriptionhistory histstartdate date 10  √  null
branch_item_rules holdallowed bit 0  √  null
default_branch_circ_rules holdallowed bit 0  √  null
default_branch_item_rules holdallowed bit 0  √  null
default_circ_rules holdallowed int 10  √  null
course_items holdingbranch varchar 10  √  null
deleteditems holdingbranch varchar 10  √  null
items holdingbranch varchar 10  √  null
tmp_holdsqueue holdingbranch varchar 10  √  null
deleteditems homebranch varchar 10  √  null
items homebranch varchar 10  √  null
vendor_edi_accounts host varchar 40  √  null
z3950servers host varchar 255  √  null
additional_field_values id int 10  √ 
additional_fields id int 10  √ 
aqbasketgroups id int 10  √ 
aqbooksellers id int 10  √ 
aqcontacts id int 10  √ 
article_requests id int 10  √ 
audio_alerts id int 10  √ 
authorised_values id int 10  √ 
edifact_messages id int 10  √ 
fieldmapping id int 10  √ 
housebound_visit id int 10  √ 
item_circulation_alert_preferences id int 10  √ 
items_last_borrower id int 10  √ 
language_descriptions id int 10  √ 
language_rfc4646_to_iso639 id int 10  √ 
language_subtag_registry id int 10  √ 
linktracker id int 10  √ 
need_merge_authorities id int 10  √ 
oai_sets id int 10  √ 
overduerules_transport_types id int 10  √ 
quotes id int 10  √ 
repeatable_holidays id int 10  √ 
reports_dictionary id int 10  √ 
saved_reports id int 10  √ 
saved_sql id int 10  √ 
search_field id int 10  √ 
search_history id int 10  √ 
search_marc_map id int 10  √ 
sessions id varchar 32
sms_providers id int 10  √ 
special_holidays id int 10  √ 
subscription_frequencies id int 10  √ 
subscription_numberpatterns id int 10  √ 
uploaded_files id int 10  √ 
vendor_edi_accounts id int 10  √ 
virtualshelfshares id int 10  √ 
z3950servers id int 10  √ 
zebraqueue id int 10  √ 
opac_news idnew int unsigned 10  √ 
biblioitems illus varchar 255  √  null
deletedbiblioitems illus varchar 255  √  null
creator_images image_id int 10  √ 
biblioimages imagefile mediumblob 16777215
creator_images imagefile mediumblob 16777215  √  null
patronimage imagefile mediumblob 16777215
biblioimages imagenumber int 10  √ 
authorised_values imageurl varchar 200  √  null
itemtypes imageurl varchar 200  √  null
import_batches import_batch_id int 10  √ 
import_records import_batch_id int 10
import_records import_date date 10  √  null
import_items import_error mediumtext 16777215  √  null
import_records import_error mediumtext 16777215  √  null
import_items import_items_id int 10  √ 
import_auths import_record_id int 10
import_biblios import_record_id int 10
import_items import_record_id int 10
import_record_matches import_record_id int 10
import_records import_record_id int 10  √ 
search_marc_map index_name enum 11
action_logs info text 65535  √  null
borrower_modifications initials text 65535  √  null
borrowers initials text 65535  √  null
deletedborrowers initials text 65535  √  null
action_logs interface varchar 30  √  null
subscription internalnotes longtext 2147483647  √  null
virtualshelfshares invitekey varchar 10  √  null
aqinvoices invoiceid int 10  √ 
aqorders invoiceid int 10  √  null
aqbooksellers invoiceincgst tinyint 3  √  null
aqinvoices invoicenumber mediumtext 16777215
aqbooksellers invoiceprice varchar 10  √  null
subscription irregularity text 65535  √  null
biblioitems isbn mediumtext 16777215  √  null
deletedbiblioitems isbn mediumtext 16777215  √  null
import_biblios isbn varchar 30  √  null
social_data isbn varchar 30
suggestions isbn varchar 30  √  null
language_rfc4646_to_iso639 iso639_2_code varchar 25  √  null
currency isocode varchar 5  √  null
biblioitems issn mediumtext 16777215  √  null
deletedbiblioitems issn mediumtext 16777215  √  null
import_biblios issn varchar 9  √  null
article_requests issue text 65535  √  null
accountlines issue_id int 10  √  null
issues issue_id int 10  √ 
old_issues issue_id int 10
issues issuedate datetime 19  √  null
old_issues issuedate datetime 19  √  null
issuingrules issuelength int 10  √  null
categories issuelimit smallint 5  √  null
deleteditems issues smallint 5  √  null
items issues smallint 5  √  null
branches issuing tinyint 3  √  null
auth_subfield_structure isurl bit 0  √  null
marc_subfield_structure isurl bit 0  √  null
creator_batches item_number int 10  √  null
item_circulation_alert_preferences item_type varchar 10
deleteditems itemcallnumber varchar 255  √  null
items itemcallnumber varchar 255  √  null
tmp_holdsqueue itemcallnumber varchar 255  √  null
deleteditems itemlost_on datetime 19  √  null
items itemlost_on datetime 19  √  null
deleteditems itemnotes mediumtext 16777215  √  null
items itemnotes mediumtext 16777215  √  null
deleteditems itemnotes_nonpublic mediumtext 16777215  √  null
items itemnotes_nonpublic mediumtext 16777215  √  null
accountlines itemnumber int 10  √  null
aqorders_items itemnumber int 10
article_requests itemnumber int 10  √  null
course_items itemnumber int 10
hold_fill_targets itemnumber int 10
import_items itemnumber int 10  √  null
issues itemnumber int 10  √  null
items itemnumber int 10  √ 
items_last_borrower itemnumber int 10
linktracker itemnumber int 10  √  null
old_issues itemnumber int 10  √  null
old_reserves itemnumber int 10  √  null
reserves itemnumber int 10  √  null
serialitems itemnumber int 10
statistics itemnumber int 10  √  null
tmp_holdsqueue itemnumber int 10  √  null
biblioitems itemtype varchar 10  √  null
branch_item_rules itemtype varchar 10
branch_transfer_limits itemtype varchar 10  √  null
default_branch_item_rules itemtype varchar 10
deletedbiblioitems itemtype varchar 10  √  null
old_reserves itemtype varchar 10  √  null
reserves itemtype varchar 10  √  null
statistics itemtype varchar 10  √  null
subscription itemtype varchar 10  √  null
suggestions itemtype varchar 30  √  null
course_items itype varchar 10  √  null
deleteditems itype varchar 10  √  null
items itype varchar 10  √  null
marc_subfield_structure kohafield varchar 40  √  null
items_search_fields label varchar 255
search_field label varchar 255
subscription_numberpatterns label varchar 255
subscription_numberpatterns label1 varchar 255  √  null
subscription_numberpatterns label2 varchar 255  √  null
subscription_numberpatterns label3 varchar 255  √  null
creator_batches label_id int 10  √ 
language_descriptions lang varchar 25  √  null
localization lang varchar 25
tags_all language int 10  √  null
language_script_mapping language_subtag varchar 25  √  null
vendor_edi_accounts last_activity date 10  √  null
saved_sql last_modified datetime 19  √  null
saved_sql last_run datetime 19  √  null
subscription lastbranch varchar 10  √  null
accountlines lastincrement decimal 28,6  √  null
issues lastreneweddate datetime 19  √  null
old_issues lastreneweddate datetime 19  √  null
borrowers lastseen datetime 19  √  null
deletedborrowers lastseen datetime 19  √  null
borrower_sync lastsync varchar 50  √  null
subscription lastvalue1 int 10  √  null
subscription lastvalue2 int 10  √  null
subscription lastvalue3 int 10  √  null
creator_layouts layout_id int 10  √ 
creator_layouts layout_xml text 65535
biblioitems lccn varchar 25  √  null
deletedbiblioitems lccn varchar 25  √  null
subscription letter varchar 20  √  null
overduerules letter1 varchar 20  √  null
overduerules letter2 varchar 20  √  null
overduerules letter3 varchar 20  √  null
message_queue letter_code varchar 64  √  null
browser level int 10
authorised_values lib varchar 200  √  null
authorised_values lib_opac varchar 200  √  null
branch_transfer_limits limitId int 10  √ 
aqorders line_item_id varchar 35  √  null
marc_subfield_structure link varchar 80  √  null
auth_header linkid bigint 19  √  null
aqbooksellers listincgst tinyint 3  √  null
aqbooksellers listprice varchar 10  √  null
aqorders listprice decimal 28,6  √  null
subscription locale varchar 80  √  null
localization localization_id int 10  √ 
course_items location varchar 80  √  null
deleteditems location varchar 80  √  null
items location varchar 80  √  null
borrower_modifications lost bit 0  √  null
borrowers lost bit 0  √  null
deletedborrowers lost bit 0  √  null
old_reserves lowestPriority bit 0
reserves lowestPriority bit 0
suggestions managedby int 10  √  null
suggestions manageddate date 10  √  null
accountlines manager_id int 10  √  null
borrower_debarments manager_id int 10  √  null
messages manager_id int 10  √  null
auth_header marc blob 65535  √  null
import_records marc longblob 2147483647
search_marc_map marc_field varchar 255
search_marc_map marc_type enum 7
oai_sets_mappings marcfield char 3
oai_sets_mappings marcsubfield char 1
oai_sets_mappings marcvalue varchar 80
auth_header marcxml longtext 2147483647
biblioitems marcxml longtext 2147483647  √  null
deletedbiblioitems marcxml longtext 2147483647  √  null
import_items marcxml longtext 2147483647
import_records marcxml longtext 2147483647
import_records marcxml_old longtext 2147483647
matchchecks matchcheck_id int 10  √ 
import_auths matched_authid int 10  √  null
import_biblios matched_biblionumber int 10  √  null
import_batches matcher_id int 10  √  null
marc_matchers matcher_id int 10  √ 
matchchecks matcher_id int 10
matcher_matchpoints matcher_id int 10
matchpoints matcher_id int 10
matchpoint_component_norms matchpoint_component_id int 10
matchpoint_components matchpoint_component_id int 10  √ 
matcher_matchpoints matchpoint_id int 10
matchpoint_components matchpoint_id int 10
matchpoints matchpoint_id int 10  √ 
deleteditems materials text 65535  √  null
items materials text 65535  √  null
branch_borrower_circ_rules maxissueqty int 10  √  null
default_borrower_circ_rules maxissueqty int 10  √  null
default_branch_circ_rules maxissueqty int 10  √  null
default_circ_rules maxissueqty int 10  √  null
issuingrules maxissueqty int 10  √  null
branch_borrower_circ_rules maxonsiteissueqty int 10  √  null
default_borrower_circ_rules maxonsiteissueqty int 10  √  null
default_branch_circ_rules maxonsiteissueqty int 10  √  null
default_circ_rules maxonsiteissueqty int 10  √  null
issuingrules maxonsiteissueqty int 10  √  null
issuingrules maxsuspensiondays int 10  √  null
messages message text 65535
message_attributes message_attribute_id int 10  √ 
message_transports message_attribute_id int 10
aqinvoices message_id int 10  √  null
message_queue message_id int 10  √ 
messages message_id int 10  √ 
message_queue message_transport_type varchar 20
message_transport_types message_transport_type varchar 20
message_transports message_transport_type varchar 20
edifact_messages message_type varchar 10
messages message_type varchar 1
message_queue metadata text 65535  √  null
biblioimages mimetype varchar 15
patronimage mimetype varchar 15
subscriptionhistory missinglist longtext 2147483647
marc_modification_template_actions mmta_id int 10  √ 
borrower_modifications mobile varchar 50  √  null
borrowers mobile varchar 50  √  null
deletedborrowers mobile varchar 50  √  null
action_logs module text 65535  √  null
columns_settings module varchar 255
repeatable_holidays month smallint 5  √  null
deleteditems more_subfields_xml longtext 2147483647  √  null
items more_subfields_xml longtext 2147483647  √  null
aqbasketgroups name varchar 50  √  null
aqbooksellers name mediumtext 16777215
aqcontacts name varchar 100  √  null
items_search_fields name varchar 255
marc_modification_templates name text 65535
oai_sets name varchar 80
patron_lists name varchar 255
reports_dictionary name varchar 255  √  null
search_field name varchar 255
sms_providers name varchar 255
discharges needed timestamp 19  √  null
opac_news new text 65535
deleteditems new_status varchar 32  √  null
items new_status varchar 32  √  null
issuingrules no_auto_renewal_after int 10  √  null
issuingrules norenewalbefore int 10  √  null
accountlines note text 65535  √  null
aqbasket note mediumtext 16777215  √  null
suggestions note mediumtext 16777215  √  null
aqbooksellers notes mediumtext 16777215  √  null
aqcontacts notes mediumtext 16777215  √  null
article_requests notes text 65535  √  null
biblio notes mediumtext 16777215  √  null
biblioitems notes mediumtext 16777215  √  null
deletedbiblio notes mediumtext 16777215  √  null
deletedbiblioitems notes mediumtext 16777215  √  null
housebound_profile notes text 65535  √  null
saved_sql notes text 65535  √  null
serial notes text 65535  √  null
subscription notes mediumtext 16777215  √  null
tmp_holdsqueue notes text 65535  √  null
itemtypes notforloan smallint 5  √  null
item_circulation_alert_preferences notification varchar 16
old_reserves notificationdate date 10  √  null
reserves notificationdate date 10  √  null
notifys notify_date date 10  √  null
notifys notify_send_date date 10  √  null
social_data num_critics int 10  √  null
social_data num_critics_pro int 10  √  null
social_data num_quotations int 10  √  null
social_data num_scores int 10  √  null
social_data num_videos int 10  √  null
biblioitems number mediumtext 16777215  √  null
browser number bigint 19
deletedbiblioitems number mediumtext 16777215  √  null
opac_news number int 10  √  null
subscription_numberpatterns numbering1 varchar 255  √  null
subscription_numberpatterns numbering2 varchar 255  √  null
subscription_numberpatterns numbering3 varchar 255  √  null
subscription_numberpatterns numberingmethod varchar 255
subscription numberpattern int 10  √  null
action_logs object int 10  √  null
accountoffsets offsetamount decimal 28,6  √  null
deleteditems onloan date 10  √  null
items onloan date 10  √  null
branches opac_info text 65535  √  null
subscription opacdisplaycount varchar 10  √  null
borrower_modifications opacnote mediumtext 16777215  √  null
borrowers opacnote mediumtext 16777215  √  null
deletedborrowers opacnote mediumtext 16777215  √  null
pending_offline_operations operationid int 10  √ 
systempreferences options mediumtext 16777215  √  null
aqorders order_internalnote mediumtext 16777215  √  null
aqorders order_vendornote mediumtext 16777215  √  null
marc_modification_template_actions ordering int 10
aqorder_users ordernumber int 10
aqorders ordernumber int 10  √ 
aqorders_items ordernumber int 10
aqorders_transfers ordernumber_from int 10  √  null
aqorders_transfers ordernumber_to int 10  √  null
import_auths original_source varchar 25  √  null
import_biblios original_source varchar 25  √  null
auth_header origincode varchar 20  √  null
statistics other mediumtext 16777215  √  null
borrower_modifications othernames mediumtext 16777215  √  null
borrowers othernames mediumtext 16777215  √  null
deletedborrowers othernames mediumtext 16777215  √  null
aqbooksellers othersupplier mediumtext 16777215  √  null
issuingrules overduefinescap decimal 28,6  √  null
categories overduenoticerequired bit 0  √  null
overduerules overduerules_id int 10  √ 
overduerules_transport_types overduerules_id int 10
patron_lists owner int 10
uploaded_files owner int 10  √  null
virtualshelves owner int 10  √  null
columns_settings page varchar 255
article_requests pages text 65535  √  null
biblioitems pages varchar 255  √  null
deletedbiblioitems pages varchar 255  √  null
deleteditems paidfor mediumtext 16777215  √  null
items paidfor mediumtext 16777215  √  null
aqorders parent_ordernumber int 10  √  null
borrower_modifications password varchar 30  √  null
borrowers password varchar 60  √  null
deletedborrowers password varchar 60  √  null
vendor_edi_accounts password varchar 40  √  null
z3950servers password varchar 255  √  null
patron_list_patrons patron_list_id int 10
patron_lists patron_list_id int 10  √ 
patron_list_patrons patron_list_patron_id int 10  √ 
article_requests patron_notes text 65535  √  null
suggestions patronreason text 65535  √  null
subscription periodicity int 10  √  null
uploaded_files permanent tinyint 3  √  null
deleteditems permanent_location varchar 80  √  null
items permanent_location varchar 80  √  null
aqbooksellers phone varchar 30  √  null
aqcontacts phone varchar 100  √  null
borrower_modifications phone text 65535  √  null
borrowers phone text 65535  √  null
deletedborrowers phone text 65535  √  null
tmp_holdsqueue phone text 65535  √  null
borrower_modifications phonepro text 65535  √  null
borrowers phonepro text 65535  √  null
deletedborrowers phonepro text 65535  √  null
tmp_holdsqueue pickbranch varchar 10  √  null
biblioitems place varchar 255  √  null
deletedbiblioitems place varchar 255  √  null
suggestions place varchar 255  √  null
aqbudgets_planning plan_id int 10  √ 
serial planneddate date 10  √  null
plugin_data plugin_class varchar 255
plugin_data plugin_key varchar 255
plugin_data plugin_value text 65535  √  null
z3950servers port int 10  √  null
aqcontacts position varchar 100  √  null
aqbooksellers postal mediumtext 16777215  √  null
audio_alerts precedence smallint unsigned 5
subscription previousitemtype varchar 10  √  null
deleteditems price decimal 8,2  √  null
items price decimal 8,2  √  null
suggestions price decimal 28,6  √  null
printers printqueue varchar 20  √  null
printers printtype varchar 20  √  null
old_reserves priority smallint 5  √  null
reserves priority smallint 5  √  null
borrower_modifications privacy int 10  √  null
statistics proccode varchar 4  √  null
export_format profile varchar 255
creator_templates profile_id int 10  √  null
printers_profile profile_id int 10  √ 
uploaded_files public tinyint 3  √  null
course_reserves public_note mediumtext 16777215  √  null
courses public_note mediumtext 16777215  √  null
biblioitems publicationyear text 65535  √  null
deletedbiblioitems publicationyear text 65535  √  null
serial publisheddate date 10  √  null
serial publisheddatetext varchar 100  √  null
biblioitems publishercode varchar 255  √  null
deletedbiblioitems publishercode varchar 255  √  null
suggestions publishercode varchar 255  √  null
aqorders purchaseordernumber mediumtext 16777215  √  null
aqorders quantity smallint 5  √  null
suggestions quantity smallint 5  √  null
search_history query_cgi text 65535
search_history query_desc varchar 255
z3950servers rank int 10  √  null
subscriptionroutinglist ranking int 10  √  null
currency rate float 15,5  √  null
ratings rating_value bit 0
edifact_messages raw_msg mediumtext 16777215  √  null
suggestions reason text 65535  √  null
subscriptionhistory recievedlist longtext 2147483647
additional_field_values record_id int 10
misc_files record_id int 10
housebound_profile referral text 65535  √  null
suggestions rejectedby int 10  √  null
suggestions rejecteddate date 10  √  null
borrower_modifications relationship varchar 100  √  null
borrowers relationship varchar 100  √  null
deletedborrowers relationship varchar 100  √  null
old_reserves reminderdate date 10  √  null
reserves reminderdate date 10  √  null
issuingrules renewalperiod int 10  √  null
deleteditems renewals smallint 5  √  null
issues renewals tinyint 3  √  null
items renewals smallint 5  √  null
old_issues renewals tinyint 3  √  null
subscription reneweddate date 10  √  null
itemtypes rentalcharge double 16,4  √  null
issuingrules rentaldiscount decimal 28,6  √  null
deleteditems replacementprice decimal 8,2  √  null
items replacementprice decimal 8,2  √  null
deleteditems replacementpricedate date 10  √  null
items replacementpricedate date 10  √  null
saved_reports report longtext 2147483647  √  null
reports_dictionary report_area varchar 6  √  null
saved_sql report_area varchar 6  √  null
saved_sql report_group varchar 80  √  null
saved_reports report_id int 10  √  null
saved_sql report_subgroup varchar 80  √  null
old_reserves reserve_id int 10
reserves reserve_id int 10  √ 
issuingrules reservecharge decimal 28,6  √  null
old_reserves reservedate date 10  √  null
reserves reservedate date 10  √  null
tmp_holdsqueue reservedate date 10  √  null
categories reservefee decimal 28,6  √  null
old_reserves reservenotes mediumtext 16777215  √  null
reserves reservenotes mediumtext 16777215  √  null
deleteditems reserves smallint 5  √  null
items reserves smallint 5  √  null
deleteditems restricted bit 0  √  null
items restricted bit 0  √  null
issuingrules restrictedtype bit 0  √  null
issues return varchar 4  √  null
old_issues return varchar 4  √  null
branch_item_rules returnbranch varchar 15  √  null
default_branch_circ_rules returnbranch varchar 15  √  null
default_branch_item_rules returnbranch varchar 15  √  null
default_circ_rules returnbranch varchar 15  √  null
issues returndate datetime 19  √  null
old_issues returndate datetime 19  √  null
reviews review text 65535  √  null
reviews reviewid int 10  √ 
language_rfc4646_to_iso639 rfc4646_subtag varchar 25  √  null
language_script_bidi rfc4646_subtag varchar 25  √  null
subscriptionroutinglist routingid int 10  √ 
serial routingnotes text 65535  √  null
aqorders rrp decimal 13,2  √  null
aqorders rrp_tax_excluded decimal 28,6  √  null
aqorders rrp_tax_included decimal 28,6  √  null
vendor_edi_accounts san varchar 20  √  null
reports_dictionary saved_sql text 65535  √  null
saved_sql savedsql text 65535  √  null
social_data score_avg decimal 5,2  √  null
language_script_mapping script_subtag varchar 25  √  null
search_marc_to_field search_field_id int 10
search_marc_to_field search_marc_map_id int 10
itemtypes searchcategory varchar 80  √  null
courses section varchar 255  √  null
auth_subfield_structure seealso varchar 255  √  null
marc_subfield_structure seealso varchar 1100  √  null
audio_alerts selector varchar 255
biblio serial bit 0  √  null
deletedbiblio serial bit 0  √  null
serial serialid int 10  √ 
serialitems serialid int 10
serial serialseq_x varchar 100  √  null
serial serialseq_y varchar 100  √  null
serial serialseq_z varchar 100  √  null
biblio seriestitle mediumtext 16777215  √  null
deletedbiblio seriestitle mediumtext 16777215  √  null
z3950servers servername mediumtext 16777215
services_throttle service_count varchar 45  √  null
search_history sessionid varchar 32
oai_sets_biblios set_id int 10
oai_sets_descriptions set_id int 10
oai_sets_mappings set_id int 10
subscription_numberpatterns setto1 int 10  √  null
subscription_numberpatterns setto2 int 10  √  null
subscription_numberpatterns setto3 int 10  √  null
borrower_modifications sex varchar 1  √  null
borrowers sex varchar 1  √  null
deletedborrowers sex varchar 1  √  null
virtualshelfshares sharedate datetime 19  √  null
virtualshelves shelfname varchar 255  √  null
virtualshelfshares shelfnumber int 10
virtualshelves shelfnumber int 10  √ 
vendor_edi_accounts shipment_budget int 10  √  null
aqinvoices shipmentcost decimal 28,6  √  null
aqinvoices shipmentcost_budgetid int 10  √  null
aqinvoices shipmentdate date 10  √  null
itemtypes sip_media_type varchar 3  √  null
biblioitems size varchar 255  √  null
deletedbiblioitems size varchar 255  √  null
borrowers sms_provider_id int 10  √  null
deletedborrowers sms_provider_id int 10  √  null
borrower_modifications smsalertnumber varchar 50  √  null
borrowers smsalertnumber varchar 50  √  null
deletedborrowers smsalertnumber varchar 50  √  null
search_marc_to_field sort bit 0  √  null
aqorders sort1 varchar 80  √  null
borrower_modifications sort1 varchar 80  √  null
borrowers sort1 varchar 80  √  null
deletedborrowers sort1 varchar 80  √  null
aqbudgetperiods sort1_authcat varchar 10  √  null
aqbudgets sort1_authcat varchar 80  √  null
aqorders sort1_authcat varchar 10  √  null
aqorders sort2 varchar 80  √  null
borrower_modifications sort2 varchar 80  √  null
borrowers sort2 varchar 80  √  null
deletedborrowers sort2 varchar 80  √  null
aqbudgetperiods sort2_authcat varchar 10  √  null
aqbudgets sort2_authcat varchar 80  √  null
aqorders sort2_authcat varchar 10  √  null
audio_alerts sound varchar 255
quotes source text 65535  √  null
hold_fill_targets source_branchcode varchar 10  √  null
matchchecks source_matchpoint_id int 10
oai_sets spec varchar 80
z3950servers sru_fields mediumtext 16777215  √  null
z3950servers sru_options varchar 255  √  null
deleteditems stack bit 0  √  null
items stack bit 0  √  null
course_reserves staff_note mediumtext 16777215  √  null
courses staff_note mediumtext 16777215  √  null
subscription staffdisplaycount varchar 10  √  null
subscription startdate date 10  √  null
borrower_modifications state text 65535  √  null
borrowers state text 65535  √  null
deletedborrowers state text 65535  √  null
edifact_messages status text 65535  √  null
deleteditems stocknumber varchar 32  √  null
items stocknumber varchar 32  √  null
borrower_modifications streetnumber varchar 10  √  null
borrowers streetnumber varchar 10  √  null
deletedborrowers streetnumber varchar 10  √  null
borrower_modifications streettype varchar 50  √  null
borrowers streettype varchar 50  √  null
deletedborrowers streettype varchar 50  √  null
courses students_count varchar 20  √  null
export_format subfield_separator varchar 2
fieldmapping subfieldcode char 1
message_queue subject text 65535  √  null
aqorders subscriptionid int 10  √  null
subscription subscriptionid int 10  √ 
subscriptionroutinglist subscriptionid int 10
language_descriptions subtag varchar 25  √  null
language_subtag_registry subtag varchar 25  √  null
suggestions suggesteddate date 10
suggestions suggestionid int 10  √ 
auth_types summary mediumtext 16777215
itemtypes summary text 65535  √  null
aqorders suppliers_reference_number varchar 35  √  null
aqorders suppliers_reference_qualifier varchar 3  √  null
aqorders suppliers_report text 65535  √  null
borrower_modifications surname mediumtext 16777215  √  null
borrowers surname mediumtext 16777215
deletedborrowers surname mediumtext 16777215
tmp_holdsqueue surname mediumtext 16777215
old_reserves suspend_until datetime 19  √  null
reserves suspend_until datetime 19  √  null
currency symbol varchar 5  √  null
borrower_sync syncstatus varchar 10  √  null
borrower_sync synctype varchar 32
z3950servers syntax varchar 80  √  null
auth_subfield_structure tab bit 0  √  null
marc_subfield_structure tab bit 0  √  null
misc_files table_tag varchar 255
columns_settings tablename varchar 255
tags_all tag_id int 10  √ 
items_search_fields tagfield char 3
items_search_fields tagsubfield char 1  √  null
matchchecks target_matchpoint_id int 10
aqbooksellers tax_rate decimal 6,4  √  null
aqorders tax_rate_bak decimal 6,4  √  null
aqorders tax_rate_on_ordering decimal 6,4  √  null
aqorders tax_rate_on_receiving decimal 6,4  √  null
aqorders tax_value_bak decimal 28,6  √  null
aqorders tax_value_on_ordering decimal 28,6  √  null
aqorders tax_value_on_receiving decimal 28,6  √  null
creator_templates template_id int 10  √ 
import_batches template_id int 10  √  null
marc_modification_template_actions template_id int 10
marc_modification_templates template_id int 10  √ 
courses term varchar 80  √  null
tags_all term varchar 255
tags_approval term varchar 255
tags_index term varchar 255
quotes text mediumtext 16777215
biblioimages thumbnail mediumblob 16777215
linktracker timeclicked datetime 19  √  null
quotes timestamp datetime 19
article_requests title text 65535  √  null
biblio title mediumtext 16777215  √  null
borrower_modifications title mediumtext 16777215  √  null
borrowers title mediumtext 16777215  √  null
deletedbiblio title mediumtext 16777215  √  null
deletedborrowers title mediumtext 16777215  √  null
import_biblios title varchar 128  √  null
suggestions title varchar 255  √  null
tmp_holdsqueue title mediumtext 16777215  √  null
message_queue to_address mediumtext 16777215  √  null
marc_modification_template_actions to_field varchar 3  √  null
marc_modification_template_actions to_regex_replace text 65535  √  null
marc_modification_template_actions to_regex_search text 65535  √  null
marc_modification_template_actions to_subfield varchar 1  √  null
branch_transfer_limits toBranch varchar 10
transport_cost tobranch varchar 10
search_history total int 10
suggestions total decimal 28,6  √  null
biblioitems totalissues int 10  √  null
deletedbiblioitems totalissues int 10  √  null
edifact_messages transfer_date date 10  √  null
localization translation text 65535  √  null
language_descriptions type varchar 25  √  null
language_subtag_registry type varchar 25  √  null
saved_sql type varchar 255  √  null
search_field type enum 7
statistics type varchar 16  √  null
systempreferences type varchar 20  √  null
aqorders uncertainprice bit 0  √  null
subscription_frequencies unit enum 5  √  null
biblio unititle mediumtext 16777215  √  null
deletedbiblio unititle mediumtext 16777215  √  null
aqorders unitprice decimal 28,6  √  null
aqorders unitprice_tax_excluded decimal 28,6  √  null
aqorders unitprice_tax_included decimal 28,6  √  null
borrower_debarments updated timestamp 19  √  null
article_requests updated_on timestamp 19  √  null
vendor_edi_accounts upload_directory text 65535  √  null
uploaded_files uploadcategorycode tinytext 255  √  null
categories upperagelimit smallint 5  √  null
deleteditems uri varchar 255  √  null
items uri varchar 255  √  null
aqbooksellers url varchar 255  √  null
biblioitems url text 65535  √  null
deletedbiblioitems url text 65535  √  null
linktracker url text 65535  √  null
statistics usercode varchar 10  √  null
borrower_modifications userid varchar 75  √  null
borrowers userid varchar 75  √  null
deletedborrowers userid varchar 75  √  null
pending_offline_operations userid varchar 30
search_history userid int 10
z3950servers userid varchar 255  √  null
vendor_edi_accounts username varchar 40  √  null
borrower_password_recovery uuid varchar 128
discharges validated timestamp 19  √  null
statistics value double 16,4  √  null
systempreferences value text 65535  √  null
auth_subfield_structure value_builder varchar 80  √  null
marc_subfield_structure value_builder varchar 80  √  null
edifact_messages vendor_id int 10  √  null
vendor_edi_accounts vendor_id int 10  √  null
article_requests volume text 65535  √  null
biblioitems volume mediumtext 16777215  √  null
deletedbiblioitems volume mediumtext 16777215  √  null
biblioitems volumedate date 10  √  null
deletedbiblioitems volumedate date 10  √  null
biblioitems volumedesc text 65535  √  null
deletedbiblioitems volumedesc text 65535  √  null
suggestions volumedesc varchar 255  √  null
old_reserves waitingdate date 10  √  null
reserves waitingdate date 10  √  null
repeatable_holidays weekday smallint 5  √  null
subscription_numberpatterns whenmorethan1 int 10  √  null
subscription_numberpatterns whenmorethan2 int 10  √  null
subscription_numberpatterns whenmorethan3 int 10  √  null
deleteditems withdrawn_on datetime 19  √  null
items withdrawn_on datetime 19  √  null
import_records z3950random varchar 40  √  null
borrower_modifications zipcode varchar 25  √  null
borrowers zipcode varchar 25  √  null
deletedborrowers zipcode varchar 25  √  null
article_requests status enum 10 PENDING
message_queue status enum 7 pending
creator_layouts units char 20 POINT
creator_templates units char 20 POINT
printers_profile units char 20 POINT
default_circ_rules singleton enum 10 singleton
import_items status enum 8 staged
import_records status enum 14 staged
import_batches import_status enum 9 staging
virtualshelves sortfield varchar 16  √  title
creator_layouts font char 10 TR
courses enabled enum 4 yes
z3950servers servertype enum 4 zed