Database Relations in Acumen

From UA Libraries Digital Services Planning and Documentation
(Difference between revisions)
Jump to: navigation, search
(Created page with " 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 probl...")
 
Line 35: Line 35:
 
  | user_action          | (empty)
 
  | user_action          | (empty)
 
  | user_action_type    | (empty)
 
  | user_action_type    | (empty)
 +
 +
==Tables of Interest==
 +
*asset
 +
*asset_type
 +
*authority
 +
*authority_type
 +
*file
 +
*file_type
 +
*status_type
 +
*tags
 +
*tags_assets
 +
*transcripts
 +
 +
===asset_type table===
 +
This table lists the types of digital content (apart from metadata) that we currently support in Acumen, with the extensions to be expected for the delivery file and the extensions to be expected for the thumbnails.  Each type of asset has an assigned ID:
 +
 +
| id | type    | asset_tails              | thumb_tails                    | parent_folder |
 +
+----+----------+---------------------------+---------------------------------+---------------+
 +
|  1 | image    | .tif,.tiff,_2048.jpg      | _512.jpg,_128.jpg,.txt,.ocr.txt | NULL          |
 +
|  3 | video    | _512kb.mp4,.mp4          | _128v.jpg,_800s.jpg            | NULL          |
 +
|  4 | audio    | _64kb.mp3,_256kb.mp3,.mp3 | .txt,.ocr.txt                  | NULL          |
 +
|  2 | document | .pdf                      | _128c.jpg                      | NULL          |
 +
|  6 | ignore  | .icon.jpg                |                                | NULL          |

Revision as of 12:04, 5 July 2017

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)

Tables of Interest

  • asset
  • asset_type
  • authority
  • authority_type
  • file
  • file_type
  • status_type
  • tags
  • tags_assets
  • transcripts

asset_type table

This table lists the types of digital content (apart from metadata) that we currently support in Acumen, with the extensions to be expected for the delivery file and the extensions to be expected for the thumbnails. Each type of asset has an assigned ID:

| id | type     | asset_tails               | thumb_tails                     | parent_folder |
+----+----------+---------------------------+---------------------------------+---------------+
|  1 | image    | .tif,.tiff,_2048.jpg      | _512.jpg,_128.jpg,.txt,.ocr.txt | NULL          |
|  3 | video    | _512kb.mp4,.mp4           | _128v.jpg,_800s.jpg             | NULL          |
|  4 | audio    | _64kb.mp3,_256kb.mp3,.mp3 | .txt,.ocr.txt                   | NULL          |
|  2 | document | .pdf                      | _128c.jpg                       | NULL          |
|  6 | ignore   | .icon.jpg                 |                                 | NULL          |
Personal tools