Tables


SchemaSpy Analysis of egdb3_12_9.action

Generated on Fri Dec 20 11:01 CST 2024

Evergreen 3.12.9 load-concerto-enhanced

XML Representation
Insertion Order Deletion Order
TABLES 35
VIEWS 12
COLUMNS 571
Constraints 77
Anomalies 0
Routines 47

Database Properties

Database Type: PostgreSQL - 15.10 (Ubuntu 15.10-1.pgdg24.04+1)

Tables

Table / View Children Parents Columns Rows Type Comments
reservation_transit_copy 0 2 12 -1 Table
emergency_closing_reservation 0 2 5 -1 Table
hold_request 6 12 37 265 Table
hold_request_note 0 1 7 152 Table
non_cat_in_house_use 0 4 6 -1 Table
emergency_closing_hold 0 2 5 -1 Table
aged_circulation 0 0 41 -1 Table
emergency_closing 4 1 6 -1 Table
usr_circ_history 0 2 7 -1 Table
survey_question 2 1 3 -1 Table
circulation_limit_group_map 0 2 2 -1 Table
aged_hold_request 0 0 38 -1 Table
hold_transit_copy 0 1 12 -1 Table
hold_request_cancel_cause 1 0 3 -1 Table
survey_response 0 3 8 613 Table
emergency_closing_circulation 0 2 5 -1 Table
circulation 4 6 34 486 Table
hold_notification 0 2 6 -1 Table
transit_copy 1 5 11 -1 Table
batch_hold_event_map 0 2 3 -1 Table
survey_answer 1 1 3 -1 Table
fieldset_group 2 3 11 -1 Table
survey 2 1 10 -1 Table
fieldset 1 4 13 -1 Table
in_house_use 0 3 6 -1 Table
curbside 0 4 10 -1 Table
batch_hold_event 1 2 7 -1 Table
fieldset_col_val 0 1 4 -1 Table
archive_actor_stat_cat 0 0 4 -1 Table
hold_copy_map 0 1 4 3341 Table
ingest_queue 1 1 8 -1 Table
unfulfilled_hold_list 0 0 5 2884 Table
archive_asset_stat_cat 0 0 4 -1 Table
non_cataloged_circulation 0 4 6 -1 Table
ingest_queue_entry 1 2 10 -1 Table
unfulfilled_hold_innermost_loop 0 0 3 0 View
all_circulation_slim 0 0 34 0 View
all_circulation_combined_types 0 0 7 0 View
billable_circulations 0 0 34 0 View
open_circulation 0 0 34 0 View
unfulfilled_hold_min_loop 0 0 2 0 View
emergency_closing_status 0 0 12 0 View
unfulfilled_hold_loops 0 0 3 0 View
all_circulation 0 0 41 0 View
open_non_cataloged_circulation 0 0 6 0 View
unfulfilled_hold_max_loop 0 0 2 0 View
all_hold_request 0 0 37 0 View