Submission records: Difference between revisions
Jump to navigation
Jump to search
(Created page with "The Submission Records table gives information regarding controllers with each of their permissions associated to it. == Submission Records Variable Documentation == {| class="w...") |
|||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The Submission Records table gives information regarding | The Submission Records table gives information regarding submissions done which are associated with a particular assignment ID. | ||
== Submission Records Variable Documentation == | == Submission Records Variable Documentation (Reimplementation) == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !!Datatype !! | !Name !!Datatype !!Description | ||
|- | |- | ||
! | !id | ||
|int(11) | |int(11) | ||
|Primary key of the entry in table, auto increments by default | |Primary key of the entry in table, auto increments by default | ||
|- | |- | ||
! | !record_type | ||
| | |text | ||
| | |Type of submission record; this field may actually be unused (formerly type) | ||
|- | |- | ||
! | !content | ||
| | |varchar(255) | ||
| | |Either the filename or URL identifying what was submitted | ||
|- | |- | ||
! | !operation | ||
| | |varchar(255) | ||
| | |Which operation was done, either submit/remove hyperlink, or submit/remove file | ||
|- | |- | ||
! | !team_id | ||
|varchar(255) | |int(11) | ||
| | |id of the student's team who submitted this hyperlink or file | ||
|- | |- | ||
! | !submitted_by | ||
|varchar(255) | |varchar(255) | ||
| | |User who actually did the submission for their team (formerly user) | ||
|- | |} | ||
! | |||
|int(11) | == Submission Records Variable Documentation (2023 version) == | ||
| | |||
|- | {| class="wikitable" | ||
! | !Name !!Datatype !!Description | ||
|- | |||
!id | |||
|int(11) | |||
|Primary key of the entry in table, auto increments by default | |||
|- | |||
!type | |||
|text | |||
|Type of submission record; this field may actually be unused | |||
|- | |||
!content | |||
|varchar(255) | |||
|Either the filename or URL identifying what was submitted | |||
|- | |||
!operation | |||
|varchar(255) | |||
|Which operation was done, either submit/remove hyperlink, or submit/remove file | |||
|- | |||
!team_id | |||
|int(11) | |||
|id of the student's team who submitted this hyperlink or file | |||
|- | |||
!user | |||
|vharchar(255) | |vharchar(255) | ||
|User who did the submission | |User who actually did the submission for their team | ||
|- | |- | ||
! | !assignment_id | ||
|int(11) | |int(11) | ||
|ID of the assignment the submission is associated to. | |ID of the assignment the submission is associated to. | ||
|} | |} | ||
== E/R diagram for Parents Tables == | == E/R diagram for Parents Tables == | ||
Latest revision as of 03:37, 9 December 2025
The Submission Records table gives information regarding submissions done which are associated with a particular assignment ID.
Submission Records Variable Documentation (Reimplementation)
| Name | Datatype | Description |
|---|---|---|
| id | int(11) | Primary key of the entry in table, auto increments by default |
| record_type | text | Type of submission record; this field may actually be unused (formerly type) |
| content | varchar(255) | Either the filename or URL identifying what was submitted |
| operation | varchar(255) | Which operation was done, either submit/remove hyperlink, or submit/remove file |
| team_id | int(11) | id of the student's team who submitted this hyperlink or file |
| submitted_by | varchar(255) | User who actually did the submission for their team (formerly user) |
Submission Records Variable Documentation (2023 version)
| Name | Datatype | Description |
|---|---|---|
| id | int(11) | Primary key of the entry in table, auto increments by default |
| type | text | Type of submission record; this field may actually be unused |
| content | varchar(255) | Either the filename or URL identifying what was submitted |
| operation | varchar(255) | Which operation was done, either submit/remove hyperlink, or submit/remove file |
| team_id | int(11) | id of the student's team who submitted this hyperlink or file |
| user | vharchar(255) | User who actually did the submission for their team |
| assignment_id | int(11) | ID of the assignment the submission is associated to. |
E/R diagram for Parents Tables
No Tables were referred by the Submission Records Table as Foreign Key Relationship.
E/R diagram for Child Tables
No Tables were referred by the Submission Records Table as Foreign Key Relationship.
Back to Database Tables Main page.