{
	"task_id": 54,
	"query_logs": [
		{
			"id": 87457,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:12.044874+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[authors]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87458,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:12.226094+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[authors]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87459,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:12.458497+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[publishers]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87460,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:12.561623+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[publishers]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87461,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:12.809436+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[titles]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87462,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:12.994562+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[titles]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87463,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:13.274393+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[titleauthor]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87464,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:13.361911+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[titleauthor]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87465,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:13.595558+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[stores]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87466,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:13.712768+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[stores]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87467,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:13.986913+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[sales]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87468,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:14.100607+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[sales]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87469,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:14.515338+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[roysched]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87470,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:14.595807+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[roysched]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87471,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:14.839033+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[discounts]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87472,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:14.939347+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[discounts]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87473,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:15.176071+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[jobs]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87474,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:15.256204+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[jobs]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87475,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:15.501920+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[pub_info]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87476,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:15.568619+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[pub_info]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87477,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:15.829887+00:00",
			"db_object_type": "onload_source_table",
			"db_object_name": "[dbo].[employee]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87478,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:50:15.980255+00:00",
			"db_object_type": "offload_target_table",
			"db_object_name": "[dbo].[employee]",
			"statement": "NA",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87479,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.093516+00:00",
			"db_object_type": "udt",
			"db_object_name": "dbo.empid",
			"statement": "\n            CREATE TYPE [dbo].[empid] FROM char(9) NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87480,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.105778+00:00",
			"db_object_type": "udt",
			"db_object_name": "dbo.id",
			"statement": "\n            CREATE TYPE [dbo].[id] FROM varchar(11) NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87481,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.118042+00:00",
			"db_object_type": "udt",
			"db_object_name": "dbo.tid",
			"statement": "\n            CREATE TYPE [dbo].[tid] FROM varchar(6) NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87482,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.123869+00:00",
			"db_object_type": "udt",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87483,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.567008+00:00",
			"db_object_type": "udt_column",
			"db_object_name": "[dbo].[authors].au_id",
			"statement": "\n            ALTER TABLE [dbo].[authors]\n            ALTER COLUMN [au_id] [dbo].[id] NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87484,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.581165+00:00",
			"db_object_type": "udt_column",
			"db_object_name": "[dbo].[titles].title_id",
			"statement": "\n            ALTER TABLE [dbo].[titles]\n            ALTER COLUMN [title_id] [dbo].[tid] NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87485,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.710112+00:00",
			"db_object_type": "udt_column",
			"db_object_name": "[dbo].[titleauthor].au_id",
			"statement": "\n            ALTER TABLE [dbo].[titleauthor]\n            ALTER COLUMN [au_id] [dbo].[id] NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87486,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.726062+00:00",
			"db_object_type": "udt_column",
			"db_object_name": "[dbo].[titleauthor].title_id",
			"statement": "\n            ALTER TABLE [dbo].[titleauthor]\n            ALTER COLUMN [title_id] [dbo].[tid] NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87487,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.740351+00:00",
			"db_object_type": "udt_column",
			"db_object_name": "[dbo].[sales].title_id",
			"statement": "\n            ALTER TABLE [dbo].[sales]\n            ALTER COLUMN [title_id] [dbo].[tid] NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87488,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.753237+00:00",
			"db_object_type": "udt_column",
			"db_object_name": "[dbo].[roysched].title_id",
			"statement": "\n            ALTER TABLE [dbo].[roysched]\n            ALTER COLUMN [title_id] [dbo].[tid] NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87489,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.766045+00:00",
			"db_object_type": "udt_column",
			"db_object_name": "[dbo].[employee].emp_id",
			"statement": "\n            ALTER TABLE [dbo].[employee]\n            ALTER COLUMN [emp_id] [dbo].[empid] NOT NULL\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87490,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:21.772057+00:00",
			"db_object_type": "udt_column",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87491,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.029634+00:00",
			"db_object_type": "drop_primary_key",
			"db_object_name": "UPKCL_sales",
			"statement": "\n            ALTER TABLE [dbo].[sales]\n            DROP CONSTRAINT [UPKCL_sales]\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87492,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.048510+00:00",
			"db_object_type": "primary_key",
			"db_object_name": "[dbo].[sales].UPKCL_sales",
			"statement": "\n            ALTER TABLE [dbo].[sales]\n            ADD CONSTRAINT [UPKCL_sales] PRIMARY KEY  ([stor_id] ASC, [ord_num] ASC, [title_id] ASC)\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87493,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.062713+00:00",
			"db_object_type": "drop_primary_key",
			"db_object_name": "PK_emp_id",
			"statement": "\n            ALTER TABLE [dbo].[employee]\n            DROP CONSTRAINT [PK_emp_id]\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87494,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.079033+00:00",
			"db_object_type": "primary_key",
			"db_object_name": "[dbo].[employee].PK_emp_id",
			"statement": "\n            ALTER TABLE [dbo].[employee]\n            ADD CONSTRAINT [PK_emp_id] PRIMARY KEY NONCLUSTERED ([emp_id] ASC)\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87495,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.085192+00:00",
			"db_object_type": "primary_key",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87496,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.158025+00:00",
			"db_object_type": "default_value",
			"db_object_name": "[dbo].[authors].DF__authors__phone__24927208",
			"statement": " ALTER TABLE [dbo].[authors]\n                        ADD CONSTRAINT [DF__authors__phone__24927208]\n                        DEFAULT ('UNKNOWN') FOR [phone];",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87497,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.224364+00:00",
			"db_object_type": "default_value",
			"db_object_name": "[dbo].[publishers].DF__publisher__count__29572725",
			"statement": " ALTER TABLE [dbo].[publishers]\n                        ADD CONSTRAINT [DF__publisher__count__29572725]\n                        DEFAULT ('USA') FOR [country];",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87498,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.286281+00:00",
			"db_object_type": "default_value",
			"db_object_name": "[dbo].[titles].DF__titles__type__2C3393D0",
			"statement": " ALTER TABLE [dbo].[titles]\n                        ADD CONSTRAINT [DF__titles__type__2C3393D0]\n                        DEFAULT ('UNDECIDED') FOR [type];",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87499,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.344735+00:00",
			"db_object_type": "default_value",
			"db_object_name": "[dbo].[titles].DF__titles__pubdate__2E1BDC42",
			"statement": " ALTER TABLE [dbo].[titles]\n                        ADD CONSTRAINT [DF__titles__pubdate__2E1BDC42]\n                        DEFAULT (getdate()) FOR [pubdate];",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87500,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.446649+00:00",
			"db_object_type": "default_value",
			"db_object_name": "[dbo].[jobs].DF__jobs__job_desc__3E52440B",
			"statement": " ALTER TABLE [dbo].[jobs]\n                        ADD CONSTRAINT [DF__jobs__job_desc__3E52440B]\n                        DEFAULT ('New Position - title not formalized yet') FOR [job_desc];",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87501,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.517326+00:00",
			"db_object_type": "default_value",
			"db_object_name": "[dbo].[employee].DF__employee__job_id__46E78A0C",
			"statement": " ALTER TABLE [dbo].[employee]\n                        ADD CONSTRAINT [DF__employee__job_id__46E78A0C]\n                        DEFAULT ((1)) FOR [job_id];",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87502,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.575367+00:00",
			"db_object_type": "default_value",
			"db_object_name": "[dbo].[employee].DF__employee__job_lv__48CFD27E",
			"statement": " ALTER TABLE [dbo].[employee]\n                        ADD CONSTRAINT [DF__employee__job_lv__48CFD27E]\n                        DEFAULT ((10)) FOR [job_lvl];",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87503,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.629191+00:00",
			"db_object_type": "default_value",
			"db_object_name": "[dbo].[employee].DF__employee__pub_id__49C3F6B7",
			"statement": " ALTER TABLE [dbo].[employee]\n                        ADD CONSTRAINT [DF__employee__pub_id__49C3F6B7]\n                        DEFAULT ('9952') FOR [pub_id];",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87504,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.779654+00:00",
			"db_object_type": "default_value",
			"db_object_name": "[dbo].[employee].DF__employee__hire_d__4BAC3F29",
			"statement": " ALTER TABLE [dbo].[employee]\n                        ADD CONSTRAINT [DF__employee__hire_d__4BAC3F29]\n                        DEFAULT (getdate()) FOR [hire_date];",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87505,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.785579+00:00",
			"db_object_type": "default_value",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87506,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:22.802317+00:00",
			"db_object_type": "synonym",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87507,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.111027+00:00",
			"db_object_type": "index",
			"db_object_name": "[dbo].[authors].[aunmind]",
			"statement": "create index [aunmind] on [dbo].[authors] ([au_lname] ASC, [au_fname] ASC) ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87508,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.125613+00:00",
			"db_object_type": "index",
			"db_object_name": "[dbo].[titles].[titleind]",
			"statement": "create index [titleind] on [dbo].[titles] ([title] ASC) ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87509,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.140170+00:00",
			"db_object_type": "index",
			"db_object_name": "[dbo].[titleauthor].[auidind]",
			"statement": "create index [auidind] on [dbo].[titleauthor] ([au_id] ASC) ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87510,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.157214+00:00",
			"db_object_type": "index",
			"db_object_name": "[dbo].[titleauthor].[titleidind]",
			"statement": "create index [titleidind] on [dbo].[titleauthor] ([title_id] ASC) ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87511,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.172574+00:00",
			"db_object_type": "index",
			"db_object_name": "[dbo].[sales].[titleidind]",
			"statement": "create index [titleidind] on [dbo].[sales] ([title_id] ASC) ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87512,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.186811+00:00",
			"db_object_type": "index",
			"db_object_name": "[dbo].[roysched].[titleidind]",
			"statement": "create index [titleidind] on [dbo].[roysched] ([title_id] ASC) ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87513,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.204170+00:00",
			"db_object_type": "index",
			"db_object_name": "[dbo].[employee].[employee_ind]",
			"statement": "create clustered index [employee_ind] on [dbo].[employee] ([lname] ASC, [fname] ASC, [minit] ASC) ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87514,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.209942+00:00",
			"db_object_type": "index",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87515,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.262730+00:00",
			"db_object_type": "add_check_constraint",
			"db_object_name": "[dbo].[authors].CK__authors__au_id__239E4DCF",
			"statement": "\n            ALTER TABLE [dbo].[authors]\n            ADD CONSTRAINT [CK__authors__au_id__239E4DCF]\n            CHECK ([au_id] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]')\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87516,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.275897+00:00",
			"db_object_type": "add_check_constraint",
			"db_object_name": "[dbo].[authors].CK__authors__zip__25869641",
			"statement": "\n            ALTER TABLE [dbo].[authors]\n            ADD CONSTRAINT [CK__authors__zip__25869641]\n            CHECK ([zip] like '[0-9][0-9][0-9][0-9][0-9]')\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87517,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.289361+00:00",
			"db_object_type": "add_check_constraint",
			"db_object_name": "[dbo].[jobs].CK__jobs__max_lvl__403A8C7D",
			"statement": "\n            ALTER TABLE [dbo].[jobs]\n            ADD CONSTRAINT [CK__jobs__max_lvl__403A8C7D]\n            CHECK ([max_lvl]<=(250))\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87518,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.384450+00:00",
			"db_object_type": "add_check_constraint",
			"db_object_name": "[dbo].[jobs].CK__jobs__min_lvl__3F466844",
			"statement": "\n            ALTER TABLE [dbo].[jobs]\n            ADD CONSTRAINT [CK__jobs__min_lvl__3F466844]\n            CHECK ([min_lvl]>=(10))\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87519,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.398404+00:00",
			"db_object_type": "add_check_constraint",
			"db_object_name": "[dbo].[publishers].CK__publisher__pub_i__286302EC",
			"statement": "\n            ALTER TABLE [dbo].[publishers]\n            ADD CONSTRAINT [CK__publisher__pub_i__286302EC]\n            CHECK ([pub_id]='1756' OR [pub_id]='1622' OR [pub_id]='0877' OR [pub_id]='0736' OR [pub_id]='1389' OR [pub_id] like '99[0-9][0-9]')\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87520,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.411925+00:00",
			"db_object_type": "add_check_constraint",
			"db_object_name": "[dbo].[employee].CK_emp_id",
			"statement": "\n            ALTER TABLE [dbo].[employee]\n            ADD CONSTRAINT [CK_emp_id]\n            CHECK ([emp_id] like '[A-Z][A-Z][A-Z][1-9][0-9][0-9][0-9][0-9][FM]' OR [emp_id] like '[A-Z]-[A-Z][1-9][0-9][0-9][0-9][0-9][FM]')\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87521,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.417512+00:00",
			"db_object_type": "check_constraint",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87522,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.571448+00:00",
			"db_object_type": "unique_constraint",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87523,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:23.592458+00:00",
			"db_object_type": "fill_factor",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87524,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.348057+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[titles].FK__titles__pub_id__2D27B809",
			"statement": "ALTER TABLE [dbo].[titles] ADD CONSTRAINT\n                [FK__titles__pub_id__2D27B809] FOREIGN KEY([pub_id])\n                REFERENCES [dbo].[publishers]([pub_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87525,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.363706+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[titleauthor].FK__titleauth__au_id__30F848ED",
			"statement": "ALTER TABLE [dbo].[titleauthor] ADD CONSTRAINT\n                [FK__titleauth__au_id__30F848ED] FOREIGN KEY([au_id])\n                REFERENCES [dbo].[authors]([au_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87526,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.377844+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[titleauthor].FK__titleauth__title__31EC6D26",
			"statement": "ALTER TABLE [dbo].[titleauthor] ADD CONSTRAINT\n                [FK__titleauth__title__31EC6D26] FOREIGN KEY([title_id])\n                REFERENCES [dbo].[titles]([title_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87527,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.392172+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[sales].FK__sales__stor_id__36B12243",
			"statement": "ALTER TABLE [dbo].[sales] ADD CONSTRAINT\n                [FK__sales__stor_id__36B12243] FOREIGN KEY([stor_id])\n                REFERENCES [dbo].[stores]([stor_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87528,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.405078+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[sales].FK__sales__title_id__37A5467C",
			"statement": "ALTER TABLE [dbo].[sales] ADD CONSTRAINT\n                [FK__sales__title_id__37A5467C] FOREIGN KEY([title_id])\n                REFERENCES [dbo].[titles]([title_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87529,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.417822+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[roysched].FK__roysched__title___398D8EEE",
			"statement": "ALTER TABLE [dbo].[roysched] ADD CONSTRAINT\n                [FK__roysched__title___398D8EEE] FOREIGN KEY([title_id])\n                REFERENCES [dbo].[titles]([title_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87530,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.431379+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[discounts].FK__discounts__stor___3B75D760",
			"statement": "ALTER TABLE [dbo].[discounts] ADD CONSTRAINT\n                [FK__discounts__stor___3B75D760] FOREIGN KEY([stor_id])\n                REFERENCES [dbo].[stores]([stor_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87531,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.445760+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[pub_info].FK__pub_info__pub_id__4316F928",
			"statement": "ALTER TABLE [dbo].[pub_info] ADD CONSTRAINT\n                [FK__pub_info__pub_id__4316F928] FOREIGN KEY([pub_id])\n                REFERENCES [dbo].[publishers]([pub_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87532,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.460320+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[employee].FK__employee__job_id__47DBAE45",
			"statement": "ALTER TABLE [dbo].[employee] ADD CONSTRAINT\n                [FK__employee__job_id__47DBAE45] FOREIGN KEY([job_id])\n                REFERENCES [dbo].[jobs]([job_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87533,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.474093+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "[dbo].[employee].FK__employee__pub_id__4AB81AF0",
			"statement": "ALTER TABLE [dbo].[employee] ADD CONSTRAINT\n                [FK__employee__pub_id__4AB81AF0] FOREIGN KEY([pub_id])\n                REFERENCES [dbo].[publishers]([pub_id])\n                ON DELETE NO ACTION\n                ON UPDATE NO ACTION\n            ",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87534,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.480160+00:00",
			"db_object_type": "foreign_key",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87535,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.841058+00:00",
			"db_object_type": "routine",
			"db_object_name": "[dbo].[reptq3]",
			"statement": "\r\nCREATE PROCEDURE reptq3 @lolimit money, @hilimit money,\r\n@type char(12)\r\nAS\r\nselect \r\n\tcase when grouping(pub_id) = 1 then 'ALL' else pub_id end as pub_id, \r\n\tcase when grouping(type) = 1 then 'ALL' else type end as type, \r\n\tcount(title_id) as cnt\r\nfrom titles\r\nwhere price >@lolimit AND price <@hilimit AND type = @type OR type LIKE '%cook%'\r\ngroup by pub_id, type with rollup\r\n\r\n",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87536,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.865135+00:00",
			"db_object_type": "routine",
			"db_object_name": "[dbo].[reptq2]",
			"statement": "\r\nCREATE PROCEDURE reptq2 AS\r\nselect \r\n\tcase when grouping(type) = 1 then 'ALL' else type end as type, \r\n\tcase when grouping(pub_id) = 1 then 'ALL' else pub_id end as pub_id, \r\n\tavg(ytd_sales) as avg_ytd_sales\r\nfrom titles\r\nwhere pub_id is NOT NULL\r\ngroup by pub_id, type with rollup\r\n\r\n",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87537,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.888744+00:00",
			"db_object_type": "routine",
			"db_object_name": "[dbo].[reptq1]",
			"statement": "\r\nCREATE PROCEDURE reptq1 AS\r\nselect \r\n\tcase when grouping(pub_id) = 1 then 'ALL' else pub_id end as pub_id, \r\n\tavg(price) as avg_price\r\nfrom titles\r\nwhere price is NOT NULL\r\ngroup by pub_id with rollup\r\norder by pub_id\r\n\r\n",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87538,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.911636+00:00",
			"db_object_type": "routine",
			"db_object_name": "[dbo].[byroyalty]",
			"statement": "\r\nCREATE PROCEDURE byroyalty @percentage int\r\nAS\r\nselect au_id from titleauthor\r\nwhere titleauthor.royaltyper = @percentage\r\n\r\n",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87539,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.923487+00:00",
			"db_object_type": "routine",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87540,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:24.991170+00:00",
			"db_object_type": "view",
			"db_object_name": "[dbo].[titleview]",
			"statement": "\r\nCREATE VIEW titleview\r\nAS\r\nselect title, au_ord, au_lname, price, ytd_sales, pub_id\r\nfrom authors, titles, titleauthor\r\nwhere authors.au_id = titleauthor.au_id\r\n   AND titles.title_id = titleauthor.title_id\r\n\r\n",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87541,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:25.003356+00:00",
			"db_object_type": "view",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87542,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:33.984536+00:00",
			"db_object_type": "trigger",
			"db_object_name": "[dbo].[employee_insupd]",
			"statement": "\r\nCREATE TRIGGER employee_insupd\r\nON employee\r\nFOR insert, UPDATE\r\nAS\r\n--Get the range of level for this job type from the jobs table.\r\ndeclare @min_lvl tinyint,\r\n   @max_lvl tinyint,\r\n   @emp_lvl tinyint,\r\n   @job_id smallint\r\nselect @min_lvl = min_lvl,\r\n   @max_lvl = max_lvl,\r\n   @emp_lvl = i.job_lvl,\r\n   @job_id = i.job_id\r\nfrom employee e, jobs j, inserted i\r\nwhere e.emp_id = i.emp_id AND i.job_id = j.job_id\r\nIF (@job_id = 1) and (@emp_lvl <> 10)\r\nbegin\r\n   raiserror ('Job id 1 expects the default level of 10.',16,1)\r\n   ROLLBACK TRANSACTION\r\nend\r\nELSE\r\nIF NOT (@emp_lvl BETWEEN @min_lvl AND @max_lvl)\r\nbegin\r\n   raiserror ('The level for job_id:%d should be between %d and %d.',\r\n      16, 1, @job_id, @min_lvl, @max_lvl)\r\n   ROLLBACK TRANSACTION\r\nend\r\n\r\n",
			"status": "PASSED",
			"message": "operation successfull"
		},
		{
			"id": 87543,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:33.996802+00:00",
			"db_object_type": "trigger",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		},
		{
			"id": 87544,
			"db_id_id": 59,
			"created_at": "2021-07-28 13:52:34.370427+00:00",
			"db_object_type": "nullability",
			"db_object_name": "-ALL-",
			"statement": "NA",
			"status": "COMPLETED",
			"message": "operation successfull"
		}
	]
}