Database Relations in Acumen

From UA Libraries Digital Services Planning and Documentation
Revision as of 11:59, 5 July 2017 by Jlderidder (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Acumen has numerous tables, some of which I'm not even sure are in use. First I'll list the tables, and then I'll talk about the ones that I've worked with to sort out problems. Here's the tables (remember, this is from all 3 acumen databases -- one for live, one for staging, and one for dev). The ones in bold I will describe further:

| aauth_group_to_group | (empty)
| aauth_groups         | (3 entries; clearly Will or Tonio was hoping to set up multiple levels of access)
| aauth_login_attempts | (empty)
| aauth_perm_to_group  | (empty)
| aauth_perm_to_user   | (empty)
| aauth_perms          | (empty)
| aauth_pms            | (empty)
| aauth_user_to_group  | (2 entries)
| aauth_user_variables | (empty)
| aauth_users          | (1 entry)
| asset                |
| asset_orphan         | (empty)
| asset_type           |
| authority            |
| authority_type       |
| crowd_status         | (to be used if anyone bothered to review tags/transcripts and approve them)
| featured             |  (to be used with what Will was setting up in dev, to showcase collections)
| file                 |
| file_type            |
| note                 | (empty)
| note_type            | (empty)
| privilege            | only one entry
| privilege_type       | only one entry
| scan_task            | (empty)
| scratch              |  (not used often, and not sure how/why it's used)
| search_category      | (empty)
| status_type          |
| tags                 |
| tags_assets          |
| transcripts          |
| user                 | (two test entries)
| user_action          | (empty)
| user_action_type     | (empty)
Personal tools