1## YAML Template.
2---
3
4Employee:
5  0: { firstName: myname1, lastName: last1, employeeId: 1, empNumber: 1 }
6  1: { firstName: myname2, lastName: last2, employeeId: 2, empNumber: 2 }
7
8UserRole:
9  0: {id: 1, name: 'Admin', display_name: Admin}
10
11SystemUser:
12  0: {id: 3, user_name: 'user3', user_role_id: 1}
13  1: {id: 4, user_name: 'user4', user_role_id: 1}
14
15Customer:
16  0: {customer_id: 1, name: 'user', description: 'main customer', is_deleted: 0 }
17  1: {customer_id: 2, name: 'user', description: 'main customer', is_deleted: 0 }
18  2: {customer_id: 3, name: 'user', description: 'main customer', is_deleted: 0 }
19
20Project:
21  0: {project_id: 1, customer_id: 1, name: 'OrangeHRM', description: 'firstproject', is_deleted: 0 }
22  1: {project_id: 2, customer_id: 2, name: 'OrangeHRM2', description: 'secondproject', is_deleted: 0 }
23  2: {project_id: 3, customer_id: 3, name: 'OrangeHRM3', description: 'thirdproject', is_deleted: 1 }
24
25ProjectActivity:
26  0: {activity_id: 1, project_id: 1, name: 'Activity1 For Pro1', is_deleted: 0 }
27  1: {activity_id: 2, project_id: 1, name: 'Activity2 For Pro1', is_deleted: 1 }
28
29Timesheet:
30  0: {timesheet_id: 1, employee_id: 1, state: 'CREATED', start_date: '2011-04-18',end_date: '2011-04-19'}
31  1: {timesheet_id: 2, employee_id: 2, state: 'SUBMITTED', start_date: '2011-04-22',end_date: '2011-04-19'}
32  2: {timesheet_id: 3, employee_id: 3, state: 'ACCEPTED', start_date: '2011-04-18',end_date: '2011-04-19'}
33  3: {timesheet_id: 4, employee_id: 4, state: 'REJECTED', start_date: '2011-04-18',end_date: '2011-05-19'}
34  4: {timesheet_id: 5, employee_id: 5, state: 'SUBMITTED', start_date: '2011-03-19',end_date: '2011-04-20'}
35  5: {timesheet_id: 6, employee_id: 6, state: 'SUPERVISOR APPROVED', start_date: '2011-03-19',end_date: '2011-04-07'}
36  6: {timesheet_id: 7, employee_id: 7, state: 'SUPERVISOR APPROVED', start_date: '2011-04-19',end_date: '2011-04-25'}
37  7: {timesheet_id: 8, employee_id: 1, state: 'ACCEPTED', start_date: '2011-04-22',end_date: '2011-04-28'}
38  8: {timesheet_id: 9, employee_id: 6, state: 'SUPERVISOR APPROVED', start_date: '2011-02-19',end_date: '2011-02-25'}
39  9: {timesheet_id: 10, employee_id: 8, state: 'CREATED', start_date: '2010-02-27',end_date: '2010-03-06'}
40  10: {timesheet_id: 11, employee_id: 2, state: 'ACCEPTED', start_date: '2011-04-18',end_date: '2011-04-28'}
41
42TimesheetItem:
43  0: {timesheet_item_id: 1, timesheet_id: 1, date: '2011-04-12', duration: 7200, comment: 'Good', project_id: 1, employee_id: 1, activity_id: 1}
44  1: {timesheet_item_id: 2, timesheet_id: 1, date: '2011-04-13', duration: 1000, comment: 'Very Good', project_id: 1, employee_id: 2, activity_id: 1}
45  2: {timesheet_item_id: 3, timesheet_id: 2, date: '2011-04-12', duration: 8000, comment: 'Not Bad', project_id: 1, employee_id: 1, activity_id: 1}
46  3: {timesheet_item_id: 4, timesheet_id: 3, date: '2011-04-12', duration: 3890, comment: 'Poor', project_id: 1, employee_id: 1, activity_id: 1}
47  4: {timesheet_item_id: 5, timesheet_id: 1, date: '2011-04-15', duration: 1000, comment: 'Good', project_id: 1, employee_id: 2, activity_id: 1}
48  5: {timesheet_item_id: 6, timesheet_id: 1, date: '2011-04-10', duration: 1000, comment: 'Poor', project_id: 1, employee_id: 2, activity_id: 1}
49  6: {timesheet_item_id: 7, timesheet_id: 10, date: '2011-04-10', duration: 1000, comment: 'Poor', project_id: 1, employee_id: 8, activity_id: 1}
50  7: {timesheet_item_id: 8, timesheet_id: 10, date: '2011-04-10', duration: 1000, comment: 'Poor', project_id: 1, employee_id: 8, activity_id: 1}
51  8: {timesheet_item_id: 9, timesheet_id: 10, date: '2011-04-10', duration: 1000, comment: 'Poor', project_id: 1, employee_id: 8, activity_id: 1}
52
53
54TimesheetActionLog:
55  0: {timesheet_action_log_id: 1, comment: 'ACCEPTED', date_time: '2011-04-18', performed_by: 3, timesheet_id: 1, action: 'ACCEPTED'}
56  1: {timesheet_action_log_id: 2, comment: 'REJECTED', date_time: '2011-04-19', performed_by: 4, timesheet_id: 1, action: 'REJECTED'}
57  2: {timesheet_action_log_id: 3, comment: 'REJECTED', date_time: '2011-04-21', performed_by: 3, timesheet_id: 2, action: 'REJECTED'}
58  3: {timesheet_action_log_id: 4, comment: 'ACCEPTED', date_time: '2011-04-24', performed_by: 3, timesheet_id: 3, action: 'ACCEPTED'}
59