Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
||
| usr | int4 | 10 | √ | null |
|
|
||
| xact_start | timestamptz | 35,6 | √ | null |
|
|
||
| xact_finish | timestamptz | 35,6 | √ | null |
|
|
||
| unrecovered | bool | 1 | √ | null |
|
|
||
| target_copy | int8 | 19 | √ | null |
|
|
||
| circ_lib | int4 | 10 | √ | null |
|
|
||
| circ_staff | int4 | 10 | √ | null |
|
|
||
| checkin_staff | int4 | 10 | √ | null |
|
|
||
| checkin_lib | int4 | 10 | √ | null |
|
|
||
| renewal_remaining | int4 | 10 | √ | null |
|
|
||
| grace_period | interval | 49,6 | √ | null |
|
|
||
| due_date | timestamptz | 35,6 | √ | null |
|
|
||
| stop_fines_time | timestamptz | 35,6 | √ | null |
|
|
||
| checkin_time | timestamptz | 35,6 | √ | null |
|
|
||
| create_time | timestamptz | 35,6 | √ | null |
|
|
||
| duration | interval | 49,6 | √ | null |
|
|
||
| fine_interval | interval | 49,6 | √ | null |
|
|
||
| recurring_fine | numeric | 6,2 | √ | null |
|
|
||
| max_fine | numeric | 6,2 | √ | null |
|
|
||
| phone_renewal | bool | 1 | √ | null |
|
|
||
| desk_renewal | bool | 1 | √ | null |
|
|
||
| opac_renewal | bool | 1 | √ | null |
|
|
||
| duration_rule | text | 2147483647 | √ | null |
|
|
||
| recurring_fine_rule | text | 2147483647 | √ | null |
|
|
||
| max_fine_rule | text | 2147483647 | √ | null |
|
|
||
| stop_fines | text | 2147483647 | √ | null |
|
|
||
| workstation | int4 | 10 | √ | null |
|
|
||
| checkin_workstation | int4 | 10 | √ | null |
|
|
||
| copy_location | int4 | 10 | √ | null |
|
|
||
| checkin_scan_time | timestamptz | 35,6 | √ | null |
|
|
||
| auto_renewal | bool | 1 | √ | null |
|
|
||
| auto_renewal_remaining | int4 | 10 | √ | null |
|
|
||
| parent_circ | int8 | 19 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
