Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| iso18626_requesting_agency_id | INT | 10 | √ | null |
|
|
Internal requesting agency number |
||||
| name | VARCHAR | 80 | √ | NULL |
|
|
Requesting agency name |
||||
| borrowernumber | INT | 10 | null |
|
|
foreign key, linking this to the borrowers table (ILL partner patron) |
|||||
| type | enum('DNUCNI', 'ICOLC', 'ISIL') | 6 | null |
|
|
ISO18626 agency type |
|||||
| account_id | VARCHAR | 80 | null |
|
|
Authentication: Requesting agency account ID |
|||||
| securityCode | VARCHAR | 80 | null |
|
|
Authentication: Requesting agency security code |
|||||
| callback_endpoint | MEDIUMTEXT | 16777215 | null |
|
|
Callback endpoint to send messages back to |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| iso18626_requesting_agencies_s_pk | Primary key | Asc | iso18626_requesting_agency_id |
| iso18626_requesting_agencies_bnfk | Performance | Asc | borrowernumber |
| PRIMARY | Must be unique | Asc | iso18626_requesting_agency_id |
| uniq_account_id | Must be unique | Asc | account_id |
| uniq_borrowernumber | Must be unique | Asc | borrowernumber |
Relationships
Close relationships within degrees of separation
