Submission records: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 8: | Line 8: | ||
|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 | ||
|- | |- | ||
!type | !type | ||
|text | |text | ||
|Type description of the Submission record | |Type description of the Submission record | ||
|- | |- | ||
!content | !content | ||
|varchar(255) | |varchar(255) | ||
|Content of the submission record | |Content of the submission record | ||
|- | |- | ||
!operation | !operation | ||
|varchar(255) | |varchar(255) | ||
| | |Which operation was done, either submit/remove hyperlink, or submit/remove file | ||
|- | |- | ||
!team_id | !team_id | ||
| Line 40: | Line 32: | ||
|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 == | ||
Revision as of 02:51, 30 December 2022
The Submission Records table gives information regarding submissions done which are associated with a particular assignment ID.
Submission Records Variable Documentation
| Name | Datatype | Description |
|---|---|---|
| id | int(11) | Primary key of the entry in table, auto increments by default |
| type | text | Type description of the Submission record |
| content | varchar(255) | Content of the submission record |
| operation | varchar(255) | Which operation was done, either submit/remove hyperlink, or submit/remove file |
| team_id | int(11) | Team ID associated with this submission. |
| user | vharchar(255) | User who did the submission. |
| 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.