 |  | |
| HomePrev | Chapter 26. Database Schema | Next |
|---|---|---|
Columns:
| field name : datatype -- parameters, contraints and notes |
| id : bigint -- |
| creator : bigint -- |
| create_date : timestamp with time zone -- |
| editor : bigint -- |
| edit_date : timestamp with time zone -- |
| record : bigint -- |
| owning_lib : integer -- |
| label : text -- |
| deleted : boolean -- |
| label_class : bigint -- |
| label_sortkey : text -- |
| create_date_day : date -- |
| edit_date_day : date -- |
| create_date_hour : timestamp with time zone -- |
| edit_date_hour : timestamp with time zone -- |
| item_lang : text -- |
| item_type : text -- |
| item_form : text -- |
Columns:
| field name : datatype -- parameters, contraints and notes |
| id : bigint -- |
| usr : integer -- |
| xact_start : timestamp with time zone -- |
| xact_finish : timestamp with time zone -- |
| unrecovered : boolean -- |
| target_copy : bigint -- |
| circ_lib : integer -- |
| circ_staff : integer -- |
| checkin_staff : integer -- |
| checkin_lib : integer -- |
| renewal_remaining : integer -- |
| due_date : timestamp with time zone -- |
| stop_fines_time : timestamp with time zone -- |
| checkin_time : timestamp with time zone -- |
| create_time : timestamp with time zone -- |
| duration : interval -- |
| fine_interval : interval -- |
| recurring_fine : numeric(6,2) -- |
| max_fine : numeric(6,2) -- |
| phone_renewal : boolean -- |
| desk_renewal : boolean -- |
| opac_renewal : boolean -- |
| duration_rule : text -- |
| recurring_fine_rule : text -- |
| max_fine_rule : text -- |
| stop_fines : text -- |
| workstation : integer -- |
| checkin_workstation : integer -- |
| checkin_scan_time : timestamp with time zone -- |
| parent_circ : bigint -- |
| start_date_day : date -- |
| finish_date_day : date -- |
| start_date_hour : timestamp with time zone -- |
| finish_date_hour : timestamp with time zone -- |
| call_number_label : text -- |
| owning_lib : integer -- |
| item_lang : text -- |
| item_type : text -- |
| item_form : text -- |
Columns:
| field name : datatype -- parameters, contraints and notes |
| id : bigint -- |
| circ_lib : integer -- |
| creator : bigint -- |
| call_number : bigint -- |
| editor : bigint -- |
| create_date : timestamp with time zone -- |
| edit_date : timestamp with time zone -- |
| copy_number : integer -- |
| status : integer -- |
| location : integer -- |
| loan_duration : integer -- |
| fine_level : integer -- |
| age_protect : integer -- |
| circulate : boolean -- |
| deposit : boolean -- |
| ref : boolean -- |
| holdable : boolean -- |
| deposit_amount : numeric(6,2) -- |
| price : numeric(8,2) -- |
| barcode : text -- |
| circ_modifier : text -- |
| circ_as_type : text -- |
| dummy_title : text -- |
| dummy_author : text -- |
| alert_message : text -- |
| opac_visible : boolean -- |
| deleted : boolean -- |
| floating : boolean -- |
| dummy_isbn : text -- |
| status_changed_time : timestamp with time zone -- |
| mint_condition : boolean -- |
| cost : numeric(8,2) -- |
| create_date_day : date -- |
| edit_date_day : date -- |
| create_date_hour : timestamp with time zone -- |
| edit_date_hour : timestamp with time zone -- |
| call_number_label : text -- |
| owning_lib : integer -- |
| item_lang : text -- |
| item_type : text -- |
| item_form : text -- |