TABLES
31
VIEWS
2
COLUMNS
230
Constraints
64
Anomalies
0
Routines
41
Database Properties
Database Type: PostgreSQL - 15.10 (Ubuntu 15.10-1.pgdg24.04+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| course_module_course | 3 | 1 | 6 | -1 | Table | |
| course_module_course_users | 0 | 3 | 4 | -1 | Table | |
| call_number_suffix | 1 | 1 | 4 | -1 | Table | |
| stat_cat_entry_copy_map | 0 | 2 | 4 | -1 | Table | |
| course_module_course_materials | 0 | 8 | 11 | -1 | Table | |
| copy_location | 11 | 1 | 12 | 89 | Table | |
| stat_cat | 2 | 2 | 8 | -1 | Table | |
| copy_location_group | 2 | 1 | 6 | -1 | Table | |
| call_number | 8 | 7 | 13 | 1822 | Table | |
| uri | 2 | 0 | 5 | -1 | Table | |
| copy_location_group_map | 0 | 2 | 3 | -1 | Table | |
| course_module_role | 1 | 0 | 3 | -1 | Table | |
| copy_tag_copy_map | 0 | 1 | 3 | -1 | Table | |
| copy_inventory | 0 | 1 | 4 | -1 | Table | |
| call_number_note | 0 | 2 | 7 | -1 | Table | |
| copy_alert | 0 | 3 | 9 | -1 | Table | |
| copy_tag | 1 | 2 | 9 | -1 | Table | |
| stat_cat_entry | 1 | 2 | 4 | -1 | Table | |
| copy_template | 2 | 7 | 25 | -1 | Table | |
| call_number_class | 1 | 0 | 4 | -1 | Table | Defines the call number normalization database functions in the “normalizer” column and the tag/subfield combinations to use to lookup the call number in the “field” column for a given classification scheme. Tag/subfield combinations are delimited by commas. |
| copy_location_order | 0 | 2 | 4 | -1 | Table | |
| copy | 1 | 8 | 33 | 4852 | Table | |
| copy_note | 0 | 1 | 7 | -1 | Table | |
| stat_cat_sip_fields | 1 | 0 | 3 | -1 | Table | Asset Statistical Category SIP Fields Contains the list of valid SIP Field identifiers for Statistical Categories. |
| stat_cat_entry_transparency_map | 0 | 0 | 4 | -1 | Table | |
| copy_vis_attr_cache | 0 | 0 | 4 | 4862 | Table | |
| uri_call_number_map | 0 | 2 | 3 | -1 | Table | |
| course_module_term | 1 | 1 | 5 | -1 | Table | |
| copy_part_map | 0 | 1 | 3 | -1 | Table | |
| call_number_prefix | 1 | 1 | 4 | -1 | Table | |
| course_module_term_course_map | 0 | 2 | 3 | -1 | Table | |
| latest_inventory | 0 | 0 | 4 | 0 | View | |
| active_copy_alert | 0 | 0 | 9 | 0 | View |