Late policies: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
(Created page with "{| class="wikitable" !Field Name !!Type !!Description |- !id |int(11) |The unique record id |- !penalty_period_in_minutes |int(11) |length of penalty period, express...")
 
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 3: Line 3:
|-  
|-  
!id   
!id   
|int(11)   
|INT(11)   
|The unique record id
|The unique record id
|-  
|-  
!penalty_period_in_minutes 
!penalty_unit 
|int(11)
|VARCHAR(255)
|length of penalty period, expressed in minutes; e.g., if penalty is per hour, value here is 60
|length of penalty period, expressed in minutes; e.g., if penalty is per hour, then value would be hour
|-  
|-  
!penalty_per_unit   
!penalty_per_unit   
|int(11)   
|INT(11)   
|how many points or how many percent deducted for each unit (above) late
|how many points or how many percent deducted for each unit (above) late
|-
!expressed_as_percentage 
|tinyint(1) 
|if false, then penalty is expressed in (absolute) points
|-  
|-  
!max_penalty   
!max_penalty   
|int(11)
|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
|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.
[[File:late_policies.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.

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