{
	"task_id": 17,
	"query_logs": [
		{
			"id": 40694,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:09.610651+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "departments",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40695,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:10.079677+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "departments",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40696,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:10.555916+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "dept_emp",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40697,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:11.328103+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "dept_emp",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40698,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:11.805150+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "dept_manager",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40699,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:12.578185+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "dept_manager",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40700,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:12.865609+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "employees",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40701,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:14.004654+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "employees",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40702,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:14.385292+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "salaries",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40703,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:15.159798+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "salaries",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40704,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:15.540482+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "titles",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40705,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:00:16.470916+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "titles",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40738,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:04:52.783340+00:00",
			"db_object_type": "remarks",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 40739,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:04:53.918513+00:00",
			"db_object_type": "row_format",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 40740,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:04:54.396762+00:00",
			"db_object_type": "unique_constraint",
			"db_object_name": "departments.dept_name",
			"statement": "\n            ALTER TABLE `departments`\n            ADD CONSTRAINT `dept_name` UNIQUE (`dept_name`)\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40741,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:04:54.403119+00:00",
			"db_object_type": "unique_constraint",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 40742,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:04:58.170180+00:00",
			"db_object_type": "index",
			"db_object_name": "dept_emp.dept_no",
			"statement": "create index `dept_no` on `dept_emp`(`dept_no` ASC) ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40743,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:04:58.207538+00:00",
			"db_object_type": "index",
			"db_object_name": "dept_manager.dept_no",
			"statement": "create index `dept_no` on `dept_manager`(`dept_no` ASC) ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40744,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:04:58.213580+00:00",
			"db_object_type": "index",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 40745,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:02.668027+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "dept_emp.dept_emp_ibfk_1",
			"statement": "ALTER TABLE `dept_emp` ADD CONSTRAINT\n                `dept_emp_ibfk_1` FOREIGN KEY(`emp_no`)\n                REFERENCES `employees`(`emp_no`)\n                ON DELETE CASCADE\n                ON UPDATE RESTRICT\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40746,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:05.196237+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "dept_emp.dept_emp_ibfk_2",
			"statement": "ALTER TABLE `dept_emp` ADD CONSTRAINT\n                `dept_emp_ibfk_2` FOREIGN KEY(`dept_no`)\n                REFERENCES `departments`(`dept_no`)\n                ON DELETE CASCADE\n                ON UPDATE RESTRICT\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40747,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:05.284564+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "dept_manager.dept_manager_ibfk_1",
			"statement": "ALTER TABLE `dept_manager` ADD CONSTRAINT\n                `dept_manager_ibfk_1` FOREIGN KEY(`emp_no`)\n                REFERENCES `employees`(`emp_no`)\n                ON DELETE CASCADE\n                ON UPDATE RESTRICT\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40748,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:05.344577+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "dept_manager.dept_manager_ibfk_2",
			"statement": "ALTER TABLE `dept_manager` ADD CONSTRAINT\n                `dept_manager_ibfk_2` FOREIGN KEY(`dept_no`)\n                REFERENCES `departments`(`dept_no`)\n                ON DELETE CASCADE\n                ON UPDATE RESTRICT\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40749,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:24.912239+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "salaries.salaries_ibfk_1",
			"statement": "ALTER TABLE `salaries` ADD CONSTRAINT\n                `salaries_ibfk_1` FOREIGN KEY(`emp_no`)\n                REFERENCES `employees`(`emp_no`)\n                ON DELETE CASCADE\n                ON UPDATE RESTRICT\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40750,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:29.563100+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "titles.titles_ibfk_1",
			"statement": "ALTER TABLE `titles` ADD CONSTRAINT\n                `titles_ibfk_1` FOREIGN KEY(`emp_no`)\n                REFERENCES `employees`(`emp_no`)\n                ON DELETE CASCADE\n                ON UPDATE RESTRICT\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40751,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:29.571886+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 40752,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:36.366293+00:00",
			"db_object_type": "routine",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 40753,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:37.005276+00:00",
			"db_object_type": "view",
			"db_object_name": "current_dept_emp",
			"statement": "CREATE VIEW `current_dept_emp` AS select `l`.`emp_no` AS `emp_no`,`d`.`dept_no` AS `dept_no`,`l`.`from_date` AS `from_date`,`l`.`to_date` AS `to_date` from (`dept_emp` `d` join `dept_emp_latest_date` `l` on(((`d`.`emp_no` = `l`.`emp_no`) and (`d`.`from_date` = `l`.`from_date`) and (`l`.`to_date` = `d`.`to_date`))))",
			"status": "FAILED",
			"message": "{'code': 'f405', 'statement': 'CREATE VIEW `current_dept_emp` AS select `l`.`emp_no` AS `emp_no`,`d`.`dept_no` AS `dept_no`,`l`.`from_date` AS `from_date`,`l`.`to_date` AS `to_date` from (`dept_emp` `d` join `dept_emp_latest_date` `l` on(((`d`.`emp_no` = `l`.`emp_no`) and (`d`.`from_date` = `l`.`from_date`) and (`l`.`to_date` = `d`.`to_date`))))', 'params': {}, 'orig': ProgrammingError(1146, \\\"Table 'employees.dept_emp_latest_date' doesn't exist\\\"), 'ismulti': False, 'hide_parameters': False, 'detail': [], 'connection_invalidated': False}"
		},
		{
			"id": 40754,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:37.046953+00:00",
			"db_object_type": "view",
			"db_object_name": "dept_emp_latest_date",
			"statement": "CREATE VIEW `dept_emp_latest_date` AS select `dept_emp`.`emp_no` AS `emp_no`,max(`dept_emp`.`from_date`) AS `from_date`,max(`dept_emp`.`to_date`) AS `to_date` from `dept_emp` group by `dept_emp`.`emp_no`",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 40755,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:05:37.149972+00:00",
			"db_object_type": "view",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 40817,
			"db_id_id": 17,
			"created_at": "2021-07-26 18:06:39.651530+00:00",
			"db_object_type": "trigger",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		}
	]
}