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