Skip to content

Instantly share code, notes, and snippets.

@iswanj
Last active April 13, 2018 02:37
Show Gist options
  • Save iswanj/370a1faa3259fab863cf47dabf44c9b7 to your computer and use it in GitHub Desktop.
Save iswanj/370a1faa3259fab863cf47dabf44c9b7 to your computer and use it in GitHub Desktop.
Database structure for sherminator 3.0
{
"attendance": {
"id": "454354sgs554s5z558z6z13",
"type": "in",
"date": "2018/03/15",
"time": "07:00",
"status": "approved", // ["pending", "approved", "rejected"]
"employee": "890s0fd900g9f7gga0ag0a80b"
}
}
{
"employee": {
"id": "890s0fd900g9f7gga0ag0a80b",
"firstName": "Iswan",
"lastName": "Jumat",
"birthday": "1987/12/03",
"position": "Senior Software Engineer",
"epfNo": 30,
"supervisor": "993j4k392lj4l24j4241bb23m",
"createdAt": "2014/06/26",
"casualLeaves": 7,
"annualLeaves": 14,
"sickLeaves": 7,
"email": "iswan@thinkcube.com",
"password": "abc123"
}
}
{
"leave": {
"id": "2243h24234k42l24jl2n423lt",
"date": "2018/4/17",
"halfday": true,
"assignee": "3240j4040834ja0a00v0zv08590",
"status": 20, // enum(assignee-approved: 20, pm-approved: 25, admin-approved: 30)
"employee": "890s0fd900g9f7gga0ag0a80b"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment