| ID |
int(8)
|
|
|
|
| Name |
varchar(100)
|
latin1_swedish_ci
|
|
|
| Daily |
tinyint(1)
|
|
|
|
| Monday |
tinyint(1)
|
|
|
|
| Tuesday |
tinyint(1)
|
|
|
|
| Wednesday |
tinyint(1)
|
|
|
|
| Thursday |
tinyint(1)
|
|
|
|
| Friday |
tinyint(1)
|
|
|
|
| Saturday |
tinyint(1)
|
|
|
|
| Sunday |
tinyint(1)
|
|
|
|
| EveryWeek |
tinyint(1)
|
|
|
|
| EverySecondWeek |
tinyint(1)
|
|
|
|
| EveryThirdWeek |
tinyint(1)
|
|
|
|
| EveryFourthWeek |
tinyint(1)
|
|
|
|
| SecondWeekStart |
date
|
|
|
|
| ThirdWeekStart |
date
|
|
|
|
| FourthWeekStart |
date
|
|
|
|
| EveryNumOfMonth |
int(8)
|
|
|
|
| DutyDoneByEvery |
tinyint(1)
|
|
|
|
| ExplanationGeneral |
text
|
latin1_swedish_ci
|
|
|
| ExplanationAdvice |
text
|
latin1_swedish_ci
|
|
|
| ResponsibilityID |
int(8)
|
|
|
|
| EveryNumOfFollowingMonth |
int(8)
|
|
|
|
| January |
tinyint(1)
|
|
|
|
| February |
tinyint(1)
|
|
|
|
| March |
tinyint(1)
|
|
|
|
| April |
tinyint(1)
|
|
|
|
| May |
tinyint(1)
|
|
|
|
| June |
tinyint(1)
|
|
|
|
| July |
tinyint(1)
|
|
|
|
| August |
tinyint(1)
|
|
|
|
| September |
tinyint(1)
|
|
|
|
| October |
tinyint(1)
|
|
|
|
| November |
tinyint(1)
|
|
|
|
| December |
tinyint(1)
|
|
|
|
| IfNecessary |
tinyint(1)
|
|
|
|