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