Difference between revisions of "JCM Table: dbo.AT Answer"
From Sherlock Software
(Created page with "===TABLE NAME: dbo.AT_Answer=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || AnswerID || int || |- | 2 || QuestionID || int || |- | 3 || Us...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
===TABLE NAME: dbo.AT_Answer=== | ===TABLE NAME: dbo.AT_Answer=== | ||
Record answers to the question of a user asked in a CRF. | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Col ID !! Name !! Data Type !! Description | ! Col ID !! Name !! Data Type !! Description | ||
|- | |- | ||
| 1 || AnswerID || int || | | 1 || AnswerID || int || Answer ID | ||
|- | |- | ||
| 2 || QuestionID || int || | | 2 || QuestionID || int || ID of the question | ||
|- | |- | ||
| 3 || UserID || int || | | 3 || UserID || int || ID of a user who provide the answer | ||
|- | |- | ||
| 4 || TimeAnswered || datetime || | | 4 || TimeAnswered || datetime || Date and time the answer was entered | ||
|- | |- | ||
| 5 || AnswerTypeID || tinyint || | | 5 || AnswerTypeID || tinyint || ID of answer type | ||
|- | |- | ||
| 6 || Answer || ntext | | 6 || Answer || ntext || Contents of the answer | ||
|} | |} | ||
</br> | </br> | ||
Latest revision as of 17:11, 3 January 2022
TABLE NAME: dbo.AT_Answer
Record answers to the question of a user asked in a CRF.
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | AnswerID | int | Answer ID |
| 2 | QuestionID | int | ID of the question |
| 3 | UserID | int | ID of a user who provide the answer |
| 4 | TimeAnswered | datetime | Date and time the answer was entered |
| 5 | AnswerTypeID | tinyint | ID of answer type |
| 6 | Answer | ntext | Contents of the answer |
Back to JCM Database tables
