Venio Console: Informations on tags

Problem

Where is the records regarding tags, tag history, and tag logs.

Resolution

1. Table tbl_Ex_TagActionLog --> This is the tag history log. TagId in this tag refer the log for specific tag; TagOrUntaggedBy refers to user who performed this action.

2. Table tbl_ex_tag --> This is the main tag table with list of all tag in the project. TagId from (1) can be joined with table to get tagname

3. Table tbl_pj_userinfo --> this is the user table with all venio users in the environment. TagOrUntaggedBy column in (1) can be joined with this table (UserId column) get the specific username and other user details

4. table tbl_ex_TagHistory --> this is the detail log where every fileid that were tag/untagged in particular action is stored.  BatchId column in tbl_ex_tagactionlog table (1) can be joined with this table's batchid to get specific list of fileid tag/untagged.