Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
audit_id | int8 | 19 | √ | null |
|
|
||
audit_time | timestamptz | 35,6 | √ | null |
|
|
||
audit_action | text | 2147483647 | √ | null |
|
|
||
audit_user | int4 | 10 | √ | null |
|
|
||
audit_ws | int4 | 10 | √ | null |
|
|
||
id | int8 | 19 | √ | null |
|
|
||
circ_lib | int4 | 10 | √ | null |
|
|
||
creator | int8 | 19 | √ | null |
|
|
||
call_number | int8 | 19 | √ | null |
|
|
||
editor | int8 | 19 | √ | null |
|
|
||
create_date | timestamptz | 35,6 | √ | null |
|
|
||
edit_date | timestamptz | 35,6 | √ | null |
|
|
||
copy_number | int4 | 10 | √ | null |
|
|
||
status | int4 | 10 | √ | null |
|
|
||
location | int4 | 10 | √ | null |
|
|
||
loan_duration | int4 | 10 | √ | null |
|
|
||
fine_level | int4 | 10 | √ | null |
|
|
||
age_protect | int4 | 10 | √ | null |
|
|
||
circulate | bool | 1 | √ | null |
|
|
||
deposit | bool | 1 | √ | null |
|
|
||
ref | bool | 1 | √ | null |
|
|
||
holdable | bool | 1 | √ | null |
|
|
||
deposit_amount | numeric | 6,2 | √ | null |
|
|
||
price | numeric | 8,2 | √ | null |
|
|
||
barcode | text | 2147483647 | √ | null |
|
|
||
circ_modifier | text | 2147483647 | √ | null |
|
|
||
circ_as_type | text | 2147483647 | √ | null |
|
|
||
dummy_title | text | 2147483647 | √ | null |
|
|
||
text | 2147483647 | √ | null |
|
|
|||
alert_message | text | 2147483647 | √ | null |
|
|
||
opac_visible | bool | 1 | √ | null |
|
|
||
deleted | bool | 1 | √ | null |
|
|
||
floating | int4 | 10 | √ | null |
|
|
||
dummy_isbn | text | 2147483647 | √ | null |
|
|
||
status_changed_time | timestamptz | 35,6 | √ | null |
|
|
||
active_date | timestamptz | 35,6 | √ | null |
|
|
||
mint_condition | bool | 1 | √ | null |
|
|
||
cost | numeric | 8,2 | √ | null |
|
|
||
sort_key | text | 2147483647 | √ | null |
|
|
||
detailed_contents | text | 2147483647 | √ | null |
|
|
||
summary_contents | text | 2147483647 | √ | null |
|
|