| id | mediumint(8) unsigned |
|
|
|
| year | char(4) |
|
|
|
| begin | date |
|
|
|
| end | date |
|
|
|
| start | time |
|
|
|
| finish | time |
|
|
|
| hours | float(4,1) unsigned |
|
|
0.0
|
| backDate | datetime |
|
|
|
| type | varchar(30) |
|
|
|
| desc | text |
|
|
|
| status | varchar(30) |
|
|
|
| createdBy | char(30) |
|
|
|
| createdDate | datetime |
|
|
|
| reviewedBy | char(30) |
|
|
|
| reviewedDate | datetime |
|
|
|
| level | tinyint(3) |
|
|
|
| assignedTo | varchar(30) |
|
|
|
| reviewers | text |
|
|
|
| backReviewers | text |
|
|
|
