Difference between revisions of "JCM Table: dbo.AT QuestionCategory"

From Sherlock Software
(Created page with "===TABLE NAME: dbo.AT_QuestionCategory=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || CategoryID || smallint || |- | 2 || Category || varch...")
 
 
Line 1: Line 1:
===TABLE NAME: dbo.AT_QuestionCategory===
===TABLE NAME: dbo.AT_QuestionCategory===
Question category control table.
{| class="wikitable"
{| class="wikitable"
|-
|-
! Col ID !! Name !! Data Type !! Description
! Col ID !! Name !! Data Type !! Description
|-
|-
| 1 || CategoryID || smallint ||  
| 1 || CategoryID || smallint || Category ID
|-
|-
| 2 || Category || varchar(50) ||  
| 2 || Category || varchar(50) || Category
|-
|-
| 3 || CategoryName || nvarchar(100) ||  
| 3 || CategoryName || nvarchar(100) || Category name
|-
|-
| 4 || CategoryNameZh || nvarchar(100) ||  
| 4 || CategoryNameZh || nvarchar(100) || Category name (in Chinese)
|}
|}
</br>
</br>

Latest revision as of 18:02, 3 January 2022

TABLE NAME: dbo.AT_QuestionCategory

Question category control table.

Col ID Name Data Type Description
1 CategoryID smallint Category ID
2 Category varchar(50) Category
3 CategoryName nvarchar(100) Category name
4 CategoryNameZh nvarchar(100) Category name (in Chinese)



Back to JCM Database tables