Table testsql_comments.z3950servers Generated by
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  √ 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 Tue Dec 27 18:01 NZDT 2016

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

Close relationships: