Late policies: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 34: Line 34:
Tables referred by the Assignment Table as Foreign Key Relationship.
Tables referred by the Assignment Table as Foreign Key Relationship.


[[https://ibb.co/k3KOKH]]
[[File:1.jpg]]


Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Revision as of 21:18, 25 April 2018

Field Name Type Description
id INT(11) The unique record id
penalty_unit VARCHAR(255) length of penalty period, expressed in minutes; e.g., if penalty is per hour, then value would be hour
penalty_per_unit INT(11) how many points or how many percent deducted for each unit (above) late
max_penalty INT(11) The maximum penalty for not doing the work for this deadline; a value of 0 here means that the maximum penalty is a score of 0 on the assignment; a negative value means that the penalty is unlimited
instructor_id INT(11) unique id to identify the instructor
policy_name VARCHAR(255) name of the policy used
times_used INT(11) Number of times this policy is referred

E/R diagram for Parents Tables

Tables referred by the Assignment Table as Foreign Key Relationship.

Back to Database Tables Main page.