Table testsql_comments.z3950servers
connection information for the Z39.50 targets used in cataloging

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int 10  √ 
account_offsets.id Implied Constraint R
additional_field_values.id Implied Constraint R
additional_fields.id Implied Constraint R
aqbasketgroups.id Implied Constraint R
aqbooksellers.id Implied Constraint R
aqcontacts.id Implied Constraint R
article_requests.id Implied Constraint R
audio_alerts.id Implied Constraint R
authorised_values.id Implied Constraint R
biblio_metadata.id Implied Constraint R
borrower_attributes.id Implied Constraint R
club_enrollment_fields.id Implied Constraint R
club_enrollments.id Implied Constraint R
club_fields.id Implied Constraint R
club_template_enrollment_fields.id Implied Constraint R
club_template_fields.id Implied Constraint R
club_templates.id Implied Constraint R
clubs.id Implied Constraint R
deletedbiblio_metadata.id Implied Constraint R
edifact_messages.id Implied Constraint R
fieldmapping.id Implied Constraint R
housebound_visit.id Implied Constraint R
item_circulation_alert_preferences.id Implied Constraint R
items_last_borrower.id Implied Constraint R
language_descriptions.id Implied Constraint R
language_rfc4646_to_iso639.id Implied Constraint R
language_subtag_registry.id Implied Constraint R
linktracker.id Implied Constraint R
need_merge_authorities.id Implied Constraint R
oai_sets.id Implied Constraint R
overduerules_transport_types.id Implied Constraint R
quotes.id Implied Constraint R
repeatable_holidays.id Implied Constraint R
reports_dictionary.id Implied Constraint R
saved_reports.id Implied Constraint R
saved_sql.id Implied Constraint R
search_field.id Implied Constraint R
search_history.id Implied Constraint R
search_marc_map.id Implied Constraint R
sms_providers.id Implied Constraint R
special_holidays.id Implied Constraint R
subscription_frequencies.id Implied Constraint R
subscription_numberpatterns.id Implied Constraint R
uploaded_files.id Implied Constraint R
vendor_edi_accounts.id Implied Constraint R
virtualshelfshares.id Implied Constraint R
zebraqueue.id Implied Constraint R
unique identifier assigned by Koha
host varchar 255  √  null target's host name
port int 10  √  null port number used to connect to target
db varchar 255  √  null target's database name
userid varchar 255  √  null username needed to log in to target
password varchar 255  √  null password needed to log in to target
servername mediumtext 16777215 name given to the target by the library
checked smallint 5  √  null whether this target is checked by default (1 for yes, 0 for no)
rank int 10  √  null where this target appears in the list of targets
syntax varchar 80  √  null marc format provided by this target
timeout int 10 0 number of seconds before Koha stops trying to access this server
servertype enum 4 zed zed means z39.50 server
encoding text 65535  √  null characters encoding provided by this target
recordtype enum 10 biblio server contains bibliographic or authority records
sru_options varchar 255  √  null options like sru=get, sru_version=1.1; will be passed to the server via ZOOM
sru_fields mediumtext 16777215  √  null contains the mapping between the Z3950 search fields and the specific SRU server indexes
add_xslt mediumtext 16777215  √  null zero or more paths to XSLT files to be processed on the search results

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY

Close relationships: