Late policies: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 25: | Line 25: | ||
|VARCHAR(255) | |VARCHAR(255) | ||
|name of the policy used | |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.