Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- action.circulation:
- Table "action.circulation"
- Column | Type | Modifiers | Storage | Stats target | Description
- ---------------------+--------------------------+------------------------------------------------------------------+----------+--------------+-------------
- id | bigint | not null default nextval('money.billable_xact_id_seq'::regclass) | plain | |
- usr | integer | not null | plain | |
- xact_start | timestamp with time zone | not null default now() | plain | |
- xact_finish | timestamp with time zone | | plain | |
- unrecovered | boolean | | plain | |
- target_copy | bigint | not null | plain | |
- circ_lib | integer | not null | plain | |
- circ_staff | integer | not null | plain | |
- checkin_staff | integer | | plain | |
- checkin_lib | integer | | plain | |
- renewal_remaining | integer | not null | plain | |
- due_date | timestamp with time zone | | plain | |
- stop_fines_time | timestamp with time zone | | plain | |
- checkin_time | timestamp with time zone | | plain | |
- duration | interval | | plain | |
- fine_interval | interval | not null default '1 day'::interval | plain | |
- recurring_fine | numeric(6,2) | | main | |
- max_fine | numeric(6,2) | | main | |
- phone_renewal | boolean | not null default false | plain | |
- desk_renewal | boolean | not null default false | plain | |
- opac_renewal | boolean | not null default false | plain | |
- duration_rule | text | not null | extended | |
- recurring_fine_rule | text | not null | extended | |
- max_fine_rule | text | not null | extended | |
- stop_fines | text | | extended | |
- create_time | timestamp with time zone | | plain | |
- workstation | integer | | plain | |
- parent_circ | bigint | | plain | |
- checkin_workstation | integer | | plain | |
- checkin_scan_time | timestamp with time zone | | plain | |
- grace_period | interval | not null | plain | |
- copy_location | integer | not null default 1 | plain | |
- Indexes:
- "circulation_pkey" PRIMARY KEY, btree (id)
- "circ_parent_idx" UNIQUE, btree (parent_circ) WHERE parent_circ IS NOT NULL
- "only_one_concurrent_checkout_per_copy" UNIQUE, btree (target_copy) WHERE checkin_time IS NULL
- "action_circulation_target_copy_idx" btree (target_copy)
- "circ_all_usr_idx" btree (usr)
- "circ_checkin_staff_idx" btree (checkin_staff)
- "circ_checkin_time" btree (checkin_time) WHERE checkin_time IS NOT NULL
- "circ_circ_lib_idx" btree (circ_lib)
- "circ_circ_lib_open_idx" btree (usr, circ_lib) WHERE xact_finish IS NULL
- "circ_circ_staff_idx" btree (circ_staff)
- "circ_copy_idx" btree (target_copy)
- "circ_open_date_idx" btree (xact_start) WHERE xact_finish IS NULL
- "circ_open_xacts_idx" btree (usr) WHERE xact_finish IS NULL
- "circ_outstanding_idx" btree (usr) WHERE checkin_time IS NULL
- "circ_usr_idx" btree (usr) CLUSTER
- Check constraints:
- "circulation_stop_fines_check" CHECK (stop_fines = ANY (ARRAY['CHECKIN'::text, 'CLAIMSRETURNED'::text, 'LOST'::text, 'MAXFINES'::text, 'RENEW'::text, 'LONGOVERDUE'::text, 'CLAIMSNEVERCHECKEDOUT'::text]))
- Foreign-key constraints:
- "action_circulation_circ_lib_fkey" FOREIGN KEY (circ_lib) REFERENCES actor.org_unit(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
- "action_circulation_usr_fkey" FOREIGN KEY (usr) REFERENCES actor.usr(id) DEFERRABLE INITIALLY DEFERRED
- "circulation_checkin_workstation_fkey" FOREIGN KEY (checkin_workstation) REFERENCES actor.workstation(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
- "circulation_copy_location_fkey" FOREIGN KEY (copy_location) REFERENCES asset.copy_location(id) DEFERRABLE INITIALLY DEFERRED
- "circulation_parent_circ_fkey" FOREIGN KEY (parent_circ) REFERENCES action.circulation(id) DEFERRABLE INITIALLY DEFERRED
- "circulation_workstation_fkey" FOREIGN KEY (workstation) REFERENCES actor.workstation(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
- Referenced by:
- TABLE "action.circulation_limit_group_map" CONSTRAINT "circulation_limit_group_map_circ_fkey" FOREIGN KEY (circ) REFERENCES action.circulation(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
- TABLE "action.circulation" CONSTRAINT "circulation_parent_circ_fkey" FOREIGN KEY (parent_circ) REFERENCES action.circulation(id) DEFERRABLE INITIALLY DEFERRED
- TABLE "action.usr_circ_history" CONSTRAINT "usr_circ_history_source_circ_fkey" FOREIGN KEY (source_circ) REFERENCES action.circulation(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
- Triggers:
- action_circulation_aging_tgr BEFORE DELETE ON action.circulation FOR EACH ROW EXECUTE PROCEDURE action.age_circ_on_delete()
- action_circulation_stop_fines_tgr BEFORE UPDATE ON action.circulation FOR EACH ROW EXECUTE PROCEDURE action.circulation_claims_returned()
- action_circulation_target_copy_trig AFTER INSERT OR UPDATE ON action.circulation FOR EACH ROW EXECUTE PROCEDURE fake_fkey_tgr('target_copy')
- age_parent_circ AFTER DELETE ON action.circulation FOR EACH ROW EXECUTE PROCEDURE action.age_parent_circ_on_delete()
- archive_stat_cats_tgr AFTER INSERT ON action.circulation FOR EACH ROW EXECUTE PROCEDURE action.archive_stat_cats()
- fill_circ_copy_location_tgr BEFORE INSERT ON action.circulation FOR EACH ROW EXECUTE PROCEDURE action.fill_circ_copy_location()
- maintain_usr_circ_history_tgr AFTER INSERT OR UPDATE ON action.circulation FOR EACH ROW EXECUTE PROCEDURE action.maintain_usr_circ_history()
- mat_summary_change_tgr AFTER UPDATE ON action.circulation FOR EACH ROW EXECUTE PROCEDURE money.mat_summary_update()
- mat_summary_create_tgr AFTER INSERT ON action.circulation FOR EACH ROW EXECUTE PROCEDURE money.mat_summary_create('circulation')
- mat_summary_remove_tgr AFTER DELETE ON action.circulation FOR EACH ROW EXECUTE PROCEDURE money.mat_summary_delete()
- push_due_date_tgr BEFORE INSERT OR UPDATE ON action.circulation FOR EACH ROW EXECUTE PROCEDURE action.push_circ_due_time()
- Inherits: money.billable_xact
- action.aged_circulation:
- Table "action.aged_circulation"
- Column | Type | Modifiers | Storage | Stats target | Description
- ---------------------+--------------------------+-----------+----------+--------------+-------------
- usr_post_code | text | | extended | |
- usr_home_ou | integer | not null | plain | |
- usr_profile | integer | not null | plain | |
- usr_birth_year | integer | | plain | |
- copy_call_number | integer | not null | plain | |
- copy_location | integer | not null | plain | |
- copy_owning_lib | integer | not null | plain | |
- copy_circ_lib | integer | not null | plain | |
- copy_bib_record | bigint | not null | plain | |
- id | bigint | not null | plain | |
- xact_start | timestamp with time zone | not null | plain | |
- xact_finish | timestamp with time zone | | plain | |
- target_copy | bigint | not null | plain | |
- circ_lib | integer | not null | plain | |
- circ_staff | integer | not null | plain | |
- checkin_staff | integer | | plain | |
- checkin_lib | integer | | plain | |
- renewal_remaining | integer | not null | plain | |
- due_date | timestamp with time zone | | plain | |
- stop_fines_time | timestamp with time zone | | plain | |
- checkin_time | timestamp with time zone | | plain | |
- duration | interval | | plain | |
- fine_interval | interval | not null | plain | |
- recurring_fine | numeric(6,2) | | main | |
- max_fine | numeric(6,2) | | main | |
- phone_renewal | boolean | not null | plain | |
- desk_renewal | boolean | not null | plain | |
- opac_renewal | boolean | not null | plain | |
- duration_rule | text | not null | extended | |
- recurring_fine_rule | text | not null | extended | |
- max_fine_rule | text | not null | extended | |
- stop_fines | text | | extended | |
- create_time | timestamp with time zone | | plain | |
- workstation | integer | | plain | |
- parent_circ | bigint | | plain | |
- checkin_workstation | integer | | plain | |
- checkin_scan_time | timestamp with time zone | | plain | |
- grace_period | interval | not null | plain | |
- Indexes:
- "aged_circulation_pkey" PRIMARY KEY, btree (id)
- "action_aged_circulation_parent_circ_idx" btree (parent_circ)
- "action_aged_circulation_target_copy_idx" btree (target_copy)
- "aged_circ_circ_lib_idx" btree (circ_lib)
- "aged_circ_copy_circ_lib_idx" btree (copy_circ_lib)
- "aged_circ_copy_location_idx" btree (copy_location)
- "aged_circ_copy_owning_lib_idx" btree (copy_owning_lib)
- "aged_circ_start_idx" btree (xact_start)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
