Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| iso18626_request_id | INT | 10 | √ | null |
|
|
Internal request number |
||||
| supplyingAgencyId | VARCHAR | 80 | √ | NULL |
|
|
Supplying agency ID |
||||
| iso18626_requesting_agency_id | INT | 10 | null |
|
|
Associated ISO18626 requesting agency |
|||||
| created_on | TIMESTAMP | 19 | current_timestamp() |
|
|
Date and time the request was created |
|||||
| updated_on | TIMESTAMP | 19 | current_timestamp() |
|
|
Date and time the request was last updated |
|||||
| requestingAgencyRequestId | VARCHAR | 80 | √ | NULL |
|
|
Requesting agency request ID or number |
||||
| status | enum('RequestReceived', 'ExpectToSupply', 'WillSupply', 'Loaned', 'Overdue', 'Recalled', 'RetryPossible', 'Unfilled', 'HoldReturn', 'ReleaseHoldReturn', 'CopyCompleted', 'LoanCompleted', 'CompletedWithoutReturn', 'Cancelled') | 22 | √ | 'RequestReceived' |
|
|
Current ISO18626 status of request |
||||
| service_type | enum('Copy', 'Loan', 'CopyOrLoan') | 10 | null |
|
|
ISO18626 service type |
|||||
| pending_requesting_agency_action | enum('Cancel', 'Renew') | 6 | √ | NULL |
|
|
ISO18626 Requesting Agency action that requires a manual response (yes or no) |
||||
| hold_id | INT | 10 | √ | NULL |
|
|
ID of the hold related to this ISO18626 request |
||||
| issue_id | INT | 10 | √ | NULL |
|
|
ID of the checkout related to this ISO18626 request |
||||
| biblio_id | INT | 10 | √ | NULL |
|
|
ID of the biblio related to this ISO18626 request |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| iso18626_requests_s_pk | Primary key | Asc | iso18626_request_id |
| iso18626_bibfk | Performance | Asc | biblio_id |
| iso18626_rafk | Performance | Asc | iso18626_requesting_agency_id |
| PRIMARY | Must be unique | Asc | iso18626_request_id |
| uniq_issue_id | Must be unique | Asc | issue_id |
| uniq_reserve_id | Must be unique | Asc | hold_id |
Relationships
Close relationships within degrees of separation
