SchemaSpy Analysis of testsql_comments - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Tue Dec 27 17:18 NZDT 2016 |
| ||||||
|
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 | 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 | 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 | 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 | 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 | |||
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 | |||
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 |