Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | varchar | 36 | null |
|
|
|||||
| awaiting_pickup_request_closed_date | timestamptz | 35,6 | √ | null |
|
|
||||
| cancellation_additional_information | varchar | 362 | √ | null |
|
|
||||
| cancellation_reason_id | varchar | 36 | √ | null |
|
|
||||
| cancelled_by_user_id | varchar | 36 | √ | null |
|
|
||||
| cancelled_date | timestamptz | 35,6 | √ | null |
|
|
||||
| fulfilment_preference | varchar | 10 | √ | null |
|
|
||||
| hold_shelf_expiration_date | timestamptz | 35,6 | √ | null |
|
|
||||
| item_id | varchar | 36 | √ | null |
|
|
||||
| patron_comments | varchar | 201 | √ | null |
|
|
||||
| pickup_service_point_id | varchar | 36 | √ | null |
|
|
||||
| position | int8 | 19 | √ | null |
|
|
||||
| request_date | timestamptz | 35,6 | √ | null |
|
|
||||
| request_expiration_date | timestamptz | 35,6 | √ | null |
|
|
||||
| request_type | varchar | 6 | √ | null |
|
|
||||
| requester_id | varchar | 36 | √ | null |
|
|
||||
| status | varchar | 23 | √ | null |
|
|
||||
| data | json | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| circulation_requests_pkey | Primary key | Asc | id |
| circulation_requests_awaiting_pickup_request_closed_date_idx | Performance | Asc | awaiting_pickup_request_closed_date |
| circulation_requests_cancellation_additional_information_idx | Performance | Asc | cancellation_additional_information |
| circulation_requests_cancellation_reason_id_idx | Performance | Asc | cancellation_reason_id |
| circulation_requests_cancelled_by_user_id_idx | Performance | Asc | cancelled_by_user_id |
| circulation_requests_cancelled_date_idx | Performance | Asc | cancelled_date |
| circulation_requests_fulfilment_preference_idx | Performance | Asc | fulfilment_preference |
| circulation_requests_hold_shelf_expiration_date_idx | Performance | Asc | hold_shelf_expiration_date |
| circulation_requests_item_id_idx | Performance | Asc | item_id |
| circulation_requests_patron_comments_idx | Performance | Asc | patron_comments |
| circulation_requests_pickup_service_point_id_idx | Performance | Asc | pickup_service_point_id |
| circulation_requests_position_idx | Performance | Asc | position |
| circulation_requests_request_date_idx | Performance | Asc | request_date |
| circulation_requests_request_expiration_date_idx | Performance | Asc | request_expiration_date |
| circulation_requests_request_type_idx | Performance | Asc | request_type |
| circulation_requests_requester_id_idx | Performance | Asc | requester_id |
| circulation_requests_status_idx | Performance | Asc | status |
Relationships
Close relationships within degrees of separation
