Database Properties
Database Type: PostgreSQL - 15.10 (Ubuntu 15.10-1.pgdg24.04+1)
Schema actor
Holds all tables pertaining to users and libraries (org units).
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| usr_setting | 0 | 2 | 4 | 283 | Table | User settings This table contains any arbitrary settings that a client program would like to save for a user. |
| passwd_type | 5 | 0 | 6 | -1 | Table | |
| usr_activity | 0 | 2 | 4 | -1 | Table | |
| stat_cat | 3 | 2 | 10 | -1 | Table | User Statistical Catagories Local data collected about Users is placed into a Statistical Catagory. Here’s where those catagories are defined. |
| search_filter_group_entry | 0 | 2 | 4 | -1 | Table | |
| stat_cat_entry_usr_map | 0 | 2 | 4 | -1 | Table | Statistical Catagory Entry to User map Records the stat_cat entries for each user. |
| org_unit_proximity | 0 | 0 | 4 | 991 | Table | |
| toolbar | 0 | 3 | 6 | -1 | Table | |
| card | 0 | 1 | 4 | 380 | Table | Library Cards Each User has one or more library cards. The current “main” card is linked to here from the actor.usr table, and it is up to the consortium policy whether more than one card can be active for any one user at a given time. |
| usr_standing_penalty | 0 | 5 | 8 | 98 | Table | User standing penalties |
| org_lasso_map | 0 | 2 | 3 | -1 | Table | |
| copy_alert_suppress | 0 | 2 | 3 | -1 | Table | |
| usr_address | 3 | 3 | 14 | 379 | Table | |
| org_unit_custom_tree | 1 | 0 | 3 | -1 | Table | |
| usr_org_unit_opt_in | 0 | 4 | 6 | -1 | Table | |
| org_unit | 132 | 7 | 13 | -1 | Table | |
| usr_privacy_waiver | 0 | 1 | 7 | -1 | Table | |
| org_lasso | 1 | 0 | 3 | -1 | Table | |
| org_unit_closed | 0 | 2 | 8 | 1091 | Table | |
| workstation | 10 | 1 | 3 | -1 | Table | |
| org_address | 4 | 2 | 14 | 70 | Table | |
| passwd | 0 | 2 | 7 | 137 | Table | |
| usr_password_reset | 0 | 1 | 5 | -1 | Table | Self-serve password reset requests |
| org_unit_proximity_adjustment | 0 | 6 | 10 | -1 | Table | |
| org_unit_type | 3 | 1 | 7 | -1 | Table | |
| stat_cat_entry | 1 | 2 | 4 | -1 | Table | User Statistical Catagory Entries Local data collected about Users is placed into a Statistical Catagory. Each library can create entries into any of its own stat_cats, its ancestors’ stat_cats, or its descendants’ stat_cats. |
| search_query | 1 | 0 | 3 | -1 | Table | |
| org_unit_setting | 0 | 2 | 4 | -1 | Table | Org Unit settings This table contains any arbitrary settings that a client program would like to save for an org unit. |
| workstation_setting | 0 | 2 | 4 | -1 | Table | |
| stat_cat_sip_fields | 1 | 0 | 3 | -1 | Table | Actor Statistical Category SIP Fields Contains the list of valid SIP Field identifiers for Statistical Categories. |
| usr_message | 1 | 3 | 12 | -1 | Table | |
| hours_of_operation | 0 | 1 | 22 | -1 | Table | When does this org_unit usually open and close? (Variations are expressed in the actor.org_unit_closed table.) |
| search_filter_group | 1 | 2 | 5 | -1 | Table | |
| stat_cat_entry_default | 0 | 3 | 4 | -1 | Table | User Statistical Category Default Entry A library may choose one of the stat_cat entries to be the default entry. |
| usr | 114 | 9 | 49 | 379 | Table | User objects This table contains the core User objects that describe both staff members and patrons. The difference between the two types of users is based on the user’s permissions. |
| address_alert | 0 | 2 | 14 | -1 | Table | |
| usr_saved_search | 0 | 1 | 7 | -1 | Table | |
| org_unit_custom_tree_node | 1 | 3 | 5 | -1 | Table | |
| usr_message_limited | 0 | 0 | 12 | 0 | View | |
| usr_message_penalty | 0 | 0 | 25 | 0 | View |