SchemaSpy - Table testsql_comments.z3950servers

connection information for the Z39.50 targets used in cataloging

Generated by
SchemaSpy

Legend:

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

int

√

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

√

null

port number used to connect to target

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

√

null

whether this target is checked by default (1 for yes, 0 for no)

rank

int

√

null

where this target appears in the list of targets

syntax

varchar

√

null

marc format provided by this target

timeout

int

number of seconds before Koha stops trying to access this server

servertype

enum

zed

zed means z39.50 server

encoding

text

65535

√

null

characters encoding provided by this target

recordtype

enum

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 Jun 26 10:02 NZST 2017

Indexes:

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