Late policies: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 30: | Line 30: | ||
|Number of times this policy is referred | |Number of times this policy is referred | ||
|} | |} | ||
== E/R diagram for Parents Tables == | |||
Tables referred by the Assignment Table as Foreign Key Relationship. | |||
[[File:/Users/aayushi/Desktop/graphs/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:16, 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.
File:/Users/aayushi/Desktop/graphs/1.jpg
Back to Database Tables Main page.