Difference between revisions of "JCM Table: dbo.ADM ReportsByCategory"
From Sherlock Software
(Created page with "===TABLE NAME: dbo.ADM_ReportsByCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || categoryID || tinyint || |- | 2 || reportID || smal...") |
|||
| Line 1: | Line 1: | ||
===TABLE NAME: dbo.ADM_ReportsByCategory=== | ===TABLE NAME: dbo.ADM_ReportsByCategory=== | ||
Stores relationship among reports, report categories, and institutions. | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Col ID !! Name !! Data Type !! Description | ! Col ID !! Name !! Data Type !! Description | ||
|- | |- | ||
| 1 || categoryID || tinyint || | | 1 || categoryID || tinyint || ID of report category | ||
|- | |- | ||
| 2 || reportID || smallint || | | 2 || reportID || smallint || ID of report | ||
|- | |- | ||
| 3 || institutionAbbrev || char(5) || | | 3 || institutionAbbrev || char(5) || Abbreviation of institution | ||
|- | |- | ||
| 4 || sortOrder || tinyint || | | 4 || sortOrder || tinyint || Display sort order | ||
|} | |} | ||
</br> | </br> | ||
Latest revision as of 17:06, 3 January 2022
TABLE NAME: dbo.ADM_ReportsByCategory
Stores relationship among reports, report categories, and institutions.
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | categoryID | tinyint | ID of report category |
| 2 | reportID | smallint | ID of report |
| 3 | institutionAbbrev | char(5) | Abbreviation of institution |
| 4 | sortOrder | tinyint | Display sort order |
Back to JCM Database tables
