Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| oai_server_id | INT | 10 | √ | null |
|
|
unique identifier assigned by Koha |
|
| endpoint | VARCHAR | 255 | null |
|
|
OAI endpoint (host + port + path) |
||
| oai_set | VARCHAR | 255 | √ | NULL |
|
|
OAI set to harvest |
|
| servername | LONGTEXT | 2147483647 | null |
|
|
name given to the target by the library |
||
| dataformat | enum('oai_dc', 'marc-xml', 'marcxml') | 8 | 'oai_dc' |
|
|
data format |
||
| recordtype | enum('authority', 'biblio') | 9 | 'biblio' |
|
|
server contains bibliographic or authority records |
||
| add_xslt | LONGTEXT | 2147483647 | √ | NULL |
|
|
zero or more paths to XSLT files to be processed on the search results |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oai_servers_s_pk | Primary key | Asc | oai_server_id |
| PRIMARY | Must be unique | Asc | oai_server_id |
Relationships
Close relationships within degrees of separation
