Submission records: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
 
Line 15: Line 15:
!content   
!content   
|varchar(255)   
|varchar(255)   
|Content of the submission record
|Either the filename or URL identifying what was submitted
|-  
|-  
!operation   
!operation   

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.