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