Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| usr_post_code | text | 2147483647 | √ | null |
|
|
||
| usr_home_ou | int4 | 10 | √ | null |
|
|
||
| usr_profile | int4 | 10 | √ | null |
|
|
||
| usr_birth_year | int4 | 10 | √ | null |
|
|
||
| staff_placed | bool | 1 | √ | null |
|
|
||
| id | int4 | 10 | √ | null |
|
|
||
| request_time | timestamptz | 35,6 | √ | null |
|
|
||
| capture_time | timestamptz | 35,6 | √ | null |
|
|
||
| fulfillment_time | timestamptz | 35,6 | √ | null |
|
|
||
| checkin_time | timestamptz | 35,6 | √ | null |
|
|
||
| return_time | timestamptz | 35,6 | √ | null |
|
|
||
| prev_check_time | timestamptz | 35,6 | √ | null |
|
|
||
| expire_time | timestamptz | 35,6 | √ | null |
|
|
||
| cancel_time | timestamptz | 35,6 | √ | null |
|
|
||
| cancel_cause | int4 | 10 | √ | null |
|
|
||
| cancel_note | text | 2147483647 | √ | null |
|
|
||
| target | int8 | 19 | √ | null |
|
|
||
| current_copy | int8 | 19 | √ | null |
|
|
||
| fulfillment_staff | int4 | 10 | √ | null |
|
|
||
| fulfillment_lib | int4 | 10 | √ | null |
|
|
||
| request_lib | int4 | 10 | √ | null |
|
|
||
| selection_ou | int4 | 10 | √ | null |
|
|
||
| selection_depth | int4 | 10 | √ | null |
|
|
||
| pickup_lib | int4 | 10 | √ | null |
|
|
||
| hold_type | text | 2147483647 | √ | null |
|
|
||
| holdable_formats | text | 2147483647 | √ | null |
|
|
||
| phone_notify | bool | 1 | √ | null |
|
|
||
| email_notify | bool | 1 | √ | null |
|
|
||
| sms_notify | bool | 1 | √ | null |
|
|
||
| frozen | bool | 1 | √ | null |
|
|
||
| thaw_date | timestamptz | 35,6 | √ | null |
|
|
||
| shelf_time | timestamptz | 35,6 | √ | null |
|
|
||
| cut_in_line | bool | 1 | √ | null |
|
|
||
| mint_condition | bool | 1 | √ | null |
|
|
||
| shelf_expire_time | timestamptz | 35,6 | √ | null |
|
|
||
| current_shelf_lib | int4 | 10 | √ | null |
|
|
||
| behind_desk | bool | 1 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
