Difference between revisions of "JCM Table: dbo.ADM GroupedReportUsers"

From Sherlock Software
 
Line 1: Line 1:
===TABLE NAME: dbo.ADM_GroupedReportUsers===
===TABLE NAME: dbo.ADM_GroupedReportUsers===
Determine which user group can access the report.
Record which user groups the user has joined.
{| class="wikitable"
{| class="wikitable"
|-
|-
! Col ID !! Name !! Data Type !! Description
! Col ID !! Name !! Data Type !! Description
|-
|-
| 1 || userID || smallint ||  
| 1 || userID || smallint || ID of a user
|-
|-
| 2 || userGroupID || smallint ||  
| 2 || userGroupID || smallint || The ID of a user group that the user joined
|}
|}
</br>
</br>

Latest revision as of 23:29, 30 December 2021

TABLE NAME: dbo.ADM_GroupedReportUsers

Record which user groups the user has joined.

Col ID Name Data Type Description
1 userID smallint ID of a user
2 userGroupID smallint The ID of a user group that the user joined



Back to JCM Database tables