Late policies: Difference between revisions
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) | ||
|The unique record id | |The unique record id | ||
|- | |- | ||
! | !penalty_unit | ||
| | |VARCHAR(255) | ||
|length of penalty period, expressed in minutes; e.g., if penalty is per hour, value | |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) | ||
|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 | ||
|- | |- | ||
!max_penalty | !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 | |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.