Submission records

From Expertiza_Wiki
Jump to navigation Jump to search

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.