Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| INT | 10 | √ | null |
|
|
unique identifier assigned by Koha |
|||||
| authid | BIGINT UNSIGNED | 20 | null |
|
|
unique identifier assigned to each koha record |
|||||
| identifier | VARCHAR | 255 | null |
|
|
OAI record identifier |
|||||
| repository | VARCHAR | 255 | null |
|
|
OAI repository |
|||||
| recordtype | enum('authority', 'biblio') | 9 | 'biblio' |
|
|
is the record bibliographic or authority |
|||||
| datestamp | VARCHAR | 255 | √ | NULL |
|
|
OAI set to harvest |
||||
| last_modified | TIMESTAMP | 19 | current_timestamp() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| import_oai_authorities_s_pk | Primary key | Asc | import_oai_authority_id |
| authid | Performance | Asc | authid |
| PRIMARY | Must be unique | Asc | import_oai_authority_id |
Relationships
Close relationships within degrees of separation
