Responses: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 1: | Line 1: | ||
Responses provide a means or communicating information from one user to another about the activity. A response uses a [[response_maps|response map]] to define the communication between a reviewer and a reviewee. | Responses provide a means or communicating information from one user to another about the activity. A response uses a [[response_maps|response map]] to define the communication between a reviewer and a reviewee. | ||
==Response variable documentation== | ==Response variable documentation (Reimplementation)== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Field Name !!Type !! | !Field Name !!Type !!Description | ||
|- | |||
!id | |||
|int(11) | |||
|The unique record id | |||
|- | |||
!response_map_id | |||
|int(11) | |||
|The ID of the [[response_maps|response map]] defining the relationship that this response applies to (formerly map_id) | |||
|- | |||
!additional_comment | |||
|text | |||
|An additional comment provided by the reviewer to support his/her response | |||
|- | |||
!updated_at | |||
|datetime | |||
|The timestamp indicating when this response was last modified | |||
|- | |||
!created_at | |||
|datetime | |||
|The timestamp indicating when this response was created | |||
|- | |||
!version_num | |||
|int(11) | |||
|The version of the review. | |||
|- | |||
!round | |||
|int(11) | |||
|The round the review is connected to. | |||
|- | |||
!is_submitted | |||
|tinyint(1) | |||
|Boolean Field to indicate whether the review is submitted. | |||
|} | |||
==Response variable documentation (2023 version)== | |||
{| class="wikitable" | |||
!Field Name !!Type !!Description | |||
|- | |- | ||
!id | !id | ||
| Line 32: | Line 70: | ||
!round | !round | ||
|int(11) | |int(11) | ||
|The round the review is connected to. | |The round the review is connected to. | ||
|- | |- | ||
!is_submitted | !is_submitted | ||
| Line 38: | Line 76: | ||
|Boolean Field to indicate whether the review is submitted. | |Boolean Field to indicate whether the review is submitted. | ||
|} | |} | ||
== E/R diagram for Parents Tables == | == E/R diagram for Parents Tables == | ||
Latest revision as of 03:27, 9 December 2025
Responses provide a means or communicating information from one user to another about the activity. A response uses a response map to define the communication between a reviewer and a reviewee.
Response variable documentation (Reimplementation)
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | The unique record id |
| response_map_id | int(11) | The ID of the response map defining the relationship that this response applies to (formerly map_id) |
| additional_comment | text | An additional comment provided by the reviewer to support his/her response |
| updated_at | datetime | The timestamp indicating when this response was last modified |
| created_at | datetime | The timestamp indicating when this response was created |
| version_num | int(11) | The version of the review. |
| round | int(11) | The round the review is connected to. |
| is_submitted | tinyint(1) | Boolean Field to indicate whether the review is submitted. |
Response variable documentation (2023 version)
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | The unique record id |
| map_id | int(11) | The ID of the response map defining the relationship that this response applies to |
| additional_comment | text | An additional comment provided by the reviewer to support his/her response |
| updated_at | datetime | The timestamp indicating when this response was last modified |
| created_at | datetime | The timestamp indicating when this response was created |
| version_num | int(11) | The version of the review. |
| round | int(11) | The round the review is connected to. |
| is_submitted | tinyint(1) | Boolean Field to indicate whether the review is submitted. |
E/R diagram for Parents Tables
No Tables were referred by the Resubmission times Table as Foreign Key Relationship.
E/R diagram for Child Tables
Tables referred by the Resubmission times Table as Foreign Key Relationship.
Back to Database Tables Main page.