-
Notifications
You must be signed in to change notification settings - Fork 276
Database Schema
bbalet edited this page Apr 1, 2014
·
1 revision
The Role field is a binary maskable value
| Binary mask | Role |
|---|---|
| 00000001 1 | Admin |
| 00000010 2 | User |
| 00000100 8 | HR Officier / Local HR Manager |
| 00001000 16 | HR Manager |
| 00010000 32 | General Manager |
| 00100000 34 | Global Manager |
For example :
- Someone can be Admin and HR Officer then its role number will be equal to 9 (in binary 00000101).
- An HR Officier will have a role value equal to 8 (in binary 00000100).
A user has a contract. The contract specifies the start and end date of the entitled days of a given year. For instance 1/1 for january the 1rst or 6/1 for june the 1rst of each year.
The entitleddays is a number related to a contract and specifies for a year the number of entitled days.