Difference between revisions of "JCM Table: dbo.ADM UserReportCategory"
From Sherlock Software
(Created page with "===TABLE NAME: dbo.ADM_UserReportCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || UserID || smallint || |- | 2 || ReportCategoryID |...") |
|||
| Line 1: | Line 1: | ||
===TABLE NAME: dbo.ADM_UserReportCategory=== | ===TABLE NAME: dbo.ADM_UserReportCategory=== | ||
Record which report categories a user can access. | |||
{| 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 || ReportCategoryID || tinyint || | | 2 || ReportCategoryID || tinyint || ID of a report category | ||
|} | |} | ||
</br> | </br> | ||
Latest revision as of 23:39, 30 December 2021
TABLE NAME: dbo.ADM_UserReportCategory
Record which report categories a user can access.
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | UserID | smallint | ID of a user |
| 2 | ReportCategoryID | tinyint | ID of a report category |
Back to JCM Database tables
