Submission records: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 11: Line 11:
!type   
!type   
|text   
|text   
|Type description of the Submission record
|Type of submission record; this field may actually be unused
|-  
|-  
!content   
!content   
|varchar(255)   
|varchar(255)   
|Content of the submission record
|Either the filename or URL identifying what was submitted
|-  
|-  
!operation   
!operation   
Line 27: Line 27:
!user   
!user   
|vharchar(255)
|vharchar(255)
|User who did the submission.
|User who actually did the submission for their team
|-  
|-  
!assignment_id   
!assignment_id   

Latest revision as of 02:56, 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 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.