Additional/dbtehservice.sql

/****** Object:  Table [dbo].[Detail]    Script Date: 13.06.2024 11:49:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Detail](
	[IdDetail] [int] IDENTITY(1,1) NOT NULL,
	[Detail] [nvarchar](50) NULL,
 CONSTRAINT [PK_Detail] PRIMARY KEY CLUSTERED 
(
	[IdDetail] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ExecutionRequest]    Script Date: 13.06.2024 11:49:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ExecutionRequest](
	[IdExecution] [int] IDENTITY(1,1) NOT NULL,
	[IdRequest] [int] NOT NULL,
	[IdMaster] [int] NULL,
 CONSTRAINT [PK_ExecutionRequest] PRIMARY KEY CLUSTERED 
(
	[IdExecution] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Request]    Script Date: 13.06.2024 11:49:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Request](
	[IdRequest] [int] IDENTITY(1,1) NOT NULL,
	[IdStatus] [int] NOT NULL,
	[IdTypeDefect] [int] NOT NULL,
	[IdClient] [int] NOT NULL,
	[IdManager] [int] NULL,
	[DateAccepting] [date] NULL,
	[DateCompletion] [date] NULL,
	[EquipmentDefect] [nvarchar](100) NULL,
	[Description] [nvarchar](max) NULL,
	[Comment] [nvarchar](max) NULL,
 CONSTRAINT [PK_Request] PRIMARY KEY CLUSTERED 
(
	[IdRequest] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RequestDetail]    Script Date: 13.06.2024 11:49:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RequestDetail](
	[IdRequestDetail] [int] IDENTITY(1,1) NOT NULL,
	[IdRequest] [int] NOT NULL,
	[IdDetail] [int] NOT NULL,
 CONSTRAINT [PK_RequestDetail] PRIMARY KEY CLUSTERED 
(
	[IdRequestDetail] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Role]    Script Date: 13.06.2024 11:49:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Role](
	[IdRole] [int] IDENTITY(1,1) NOT NULL,
	[Role] [nvarchar](50) NULL,
 CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED 
(
	[IdRole] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Status]    Script Date: 13.06.2024 11:49:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Status](
	[IdStatus] [int] IDENTITY(1,1) NOT NULL,
	[Status] [nvarchar](50) NULL,
 CONSTRAINT [PK_Status] PRIMARY KEY CLUSTERED 
(
	[IdStatus] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TypeDefect]    Script Date: 13.06.2024 11:49:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TypeDefect](
	[IdTypeDefect] [int] IDENTITY(1,1) NOT NULL,
	[TypeDefect] [nvarchar](50) NULL,
 CONSTRAINT [PK_TypeDeffect] PRIMARY KEY CLUSTERED 
(
	[IdTypeDefect] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Users]    Script Date: 13.06.2024 11:49:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
	[IdUser] [int] IDENTITY(1,1) NOT NULL,
	[IdRole] [int] NOT NULL,
	[Surname] [nvarchar](50) NULL,
	[Name] [nvarchar](50) NULL,
	[Patronymic] [nvarchar](50) NULL,
	[Login] [nvarchar](50) NULL,
	[Password] [nvarchar](50) NULL,
 CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED 
(
	[IdUser] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Detail] ON 

INSERT [dbo].[Detail] ([IdDetail], [Detail]) VALUES (1, N'SSD')
INSERT [dbo].[Detail] ([IdDetail], [Detail]) VALUES (2, N'ОЗУ')
INSERT [dbo].[Detail] ([IdDetail], [Detail]) VALUES (3, N'HDD')
INSERT [dbo].[Detail] ([IdDetail], [Detail]) VALUES (4, N'Клавиатура')
SET IDENTITY_INSERT [dbo].[Detail] OFF
GO
SET IDENTITY_INSERT [dbo].[ExecutionRequest] ON 

INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (1, 1, 5)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (2, 2, 7)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (3, 3, 10)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (4, 4, 8)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (5, 5, 6)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (6, 6, 7)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (7, 7, 8)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (8, 8, 9)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (9, 9, 6)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (10, 1, 6)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (11, 2, 9)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (12, 3, 9)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (13, 4, 6)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (14, 5, 9)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (15, 6, 10)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (16, 7, 7)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (17, 8, 10)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (18, 9, 7)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (19, 13, 5)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (26, 14, 6)
INSERT [dbo].[ExecutionRequest] ([IdExecution], [IdRequest], [IdMaster]) VALUES (27, 14, 10)
SET IDENTITY_INSERT [dbo].[ExecutionRequest] OFF
GO
SET IDENTITY_INSERT [dbo].[Request] ON 

INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (1, 1, 1, 11, 1, CAST(N'2023-11-19' AS Date), CAST(N'2023-11-21' AS Date), N'Системный блок', N'Не загружается операционная система', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (2, 2, 2, 12, 2, CAST(N'2023-11-01' AS Date), CAST(N'2023-11-10' AS Date), N'Материнская плата', N'Перегрев процессора', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (3, 2, 2, 11, 4, CAST(N'2023-11-05' AS Date), CAST(N'2023-11-10' AS Date), N'Ноутбук', N'Не включается компьютер', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (4, 1, 1, 13, 3, CAST(N'2023-11-11' AS Date), CAST(N'2023-11-12' AS Date), N'Неттоп', N'Перезагрузка компьютера при загрузке операционной системы', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (5, 2, 1, 14, 4, CAST(N'2023-10-17' AS Date), CAST(N'2023-10-20' AS Date), N'Планшет', N'Не запускается ни одно приложение', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (6, 1, 1, 14, 1, CAST(N'2023-10-20' AS Date), CAST(N'2023-10-21' AS Date), N'Настольный компьютер', N'Загрузка возможна только в безопасном режиме', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (7, 3, 2, 13, 2, CAST(N'2023-10-01' AS Date), CAST(N'2023-10-05' AS Date), N'Корпус', N'Не работает кнопка Reset', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (8, 3, 1, 11, 2, CAST(N'2023-10-10' AS Date), CAST(N'2023-10-15' AS Date), N'Моноблок', N'Синий экран при загрузке компьютера', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (9, 3, 1, 11, 1, CAST(N'2024-05-22' AS Date), CAST(N'2024-06-17' AS Date), N'Микрокомпьютер', N'Очень медленная работа операционной системы', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (10, 2, 2, 12, 1, CAST(N'2024-06-08' AS Date), CAST(N'2024-06-08' AS Date), N'wesfdsdfsdfsdfs', N'dfsdsfdfsdsfdss', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (11, 1, 1, 11, 1, CAST(N'2024-06-08' AS Date), CAST(N'2024-06-08' AS Date), N'csdddsscdds', N'dcscdcdsscddccd', N'')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (12, 1, 1, 13, 1, CAST(N'2024-06-10' AS Date), CAST(N'2024-06-10' AS Date), N'123', N'123', NULL)
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (13, 3, 1, 14, 1, CAST(N'2024-06-10' AS Date), CAST(N'2024-06-10' AS Date), N'123', N'dskfhdskjhf', N'qhsdkfjhdfjkshdfdskhdfds')
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (14, 1, 1, 11, 1, CAST(N'2024-06-10' AS Date), CAST(N'2024-06-10' AS Date), N'123', N'123', NULL)
INSERT [dbo].[Request] ([IdRequest], [IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (15, 1, 1, 11, 1, CAST(N'2024-06-10' AS Date), CAST(N'2024-06-10' AS Date), N'123', N'123', NULL)
SET IDENTITY_INSERT [dbo].[Request] OFF
GO
SET IDENTITY_INSERT [dbo].[RequestDetail] ON 

INSERT [dbo].[RequestDetail] ([IdRequestDetail], [IdRequest], [IdDetail]) VALUES (4, 13, 1)
INSERT [dbo].[RequestDetail] ([IdRequestDetail], [IdRequest], [IdDetail]) VALUES (5, 13, 1)
SET IDENTITY_INSERT [dbo].[RequestDetail] OFF
GO
SET IDENTITY_INSERT [dbo].[Role] ON 

INSERT [dbo].[Role] ([IdRole], [Role]) VALUES (1, N'Менеджер')
INSERT [dbo].[Role] ([IdRole], [Role]) VALUES (2, N'Мастер')
INSERT [dbo].[Role] ([IdRole], [Role]) VALUES (3, N'Клиент')
SET IDENTITY_INSERT [dbo].[Role] OFF
GO
SET IDENTITY_INSERT [dbo].[Status] ON 

INSERT [dbo].[Status] ([IdStatus], [Status]) VALUES (1, N'В ожидании')
INSERT [dbo].[Status] ([IdStatus], [Status]) VALUES (2, N'В работе')
INSERT [dbo].[Status] ([IdStatus], [Status]) VALUES (3, N'Выполнено')
SET IDENTITY_INSERT [dbo].[Status] OFF
GO
SET IDENTITY_INSERT [dbo].[TypeDefect] ON 

INSERT [dbo].[TypeDefect] ([IdTypeDefect], [TypeDefect]) VALUES (1, N'Программная')
INSERT [dbo].[TypeDefect] ([IdTypeDefect], [TypeDefect]) VALUES (2, N'Аппаратная')
SET IDENTITY_INSERT [dbo].[TypeDefect] OFF
GO
SET IDENTITY_INSERT [dbo].[Users] ON 

INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (1, 1, N'Иванова', N'Анна', N'Петровна', N'm', N'm')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (2, 1, N'Егорова', N'Алла', N'Сергеевна', N'9eln76uth4iz@mail.com', N'uzWC67')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (3, 1, N'Антонова', N'Елена', N'Степановна', N'60f2ix5d4zbu@tutanota.com', N'8ntwUp')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (4, 1, N'Цветков', N'Андрей', N'Петрович', N'ridvnptec8ym@yahoo.com', N'YOyhfR')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (5, 2, N'Селезнев', N'Евгений', N'Павлович', N'r', N'r')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (6, 2, N'Заречный', N'Алексей', N'Степанович', N'co30fa4np6se@mail.com', N'rwVDh9')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (7, 2, N'Петров', N'Егор', N'Иванович', N'arucwkyzls62@outlook.com', N'LdNyos')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (8, 2, N'Семенов', N'Александр', N'Федорович', N'nmxos1diph5e@tutanota.com', N'gynQMT')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (9, 2, N'Олегов', N'Иван', N'Степанович', N'xbvi3ktjde7c@yahoo.com', N'AtnDjr')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (10, 2, N'Яковлев', N'Сергей', N'Иванович', N'lqgbwpmrc3do@tutanota.com', N'JlFRCZ')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (11, 3, N'Голубев', N'Иосиф', N'Тимофеевич', N'c', N'c')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (12, 3, N'Ермакова', N'Алла', N'Мироновна', N'c1', N'c1')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (13, 3, N'Агафонов', N'Юстиниан', N'Олегович', N'c2', N'c2')
INSERT [dbo].[Users] ([IdUser], [IdRole], [Surname], [Name], [Patronymic], [Login], [Password]) VALUES (14, 3, N'Новиков', N'Адриан', N'Аркадьевич', N'c3', N'c3')
SET IDENTITY_INSERT [dbo].[Users] OFF
GO
ALTER TABLE [dbo].[ExecutionRequest]  WITH CHECK ADD  CONSTRAINT [FK_ExecutionRequest_Request] FOREIGN KEY([IdRequest])
REFERENCES [dbo].[Request] ([IdRequest])
GO
ALTER TABLE [dbo].[ExecutionRequest] CHECK CONSTRAINT [FK_ExecutionRequest_Request]
GO
ALTER TABLE [dbo].[ExecutionRequest]  WITH CHECK ADD  CONSTRAINT [FK_ExecutionRequest_Users] FOREIGN KEY([IdMaster])
REFERENCES [dbo].[Users] ([IdUser])
GO
ALTER TABLE [dbo].[ExecutionRequest] CHECK CONSTRAINT [FK_ExecutionRequest_Users]
GO
ALTER TABLE [dbo].[Request]  WITH CHECK ADD  CONSTRAINT [FK_Request_Status] FOREIGN KEY([IdStatus])
REFERENCES [dbo].[Status] ([IdStatus])
GO
ALTER TABLE [dbo].[Request] CHECK CONSTRAINT [FK_Request_Status]
GO
ALTER TABLE [dbo].[Request]  WITH CHECK ADD  CONSTRAINT [FK_Request_TypeDeffect] FOREIGN KEY([IdTypeDefect])
REFERENCES [dbo].[TypeDefect] ([IdTypeDefect])
GO
ALTER TABLE [dbo].[Request] CHECK CONSTRAINT [FK_Request_TypeDeffect]
GO
ALTER TABLE [dbo].[Request]  WITH CHECK ADD  CONSTRAINT [FK_Request_Users] FOREIGN KEY([IdClient])
REFERENCES [dbo].[Users] ([IdUser])
GO
ALTER TABLE [dbo].[Request] CHECK CONSTRAINT [FK_Request_Users]
GO
ALTER TABLE [dbo].[Request]  WITH CHECK ADD  CONSTRAINT [FK_Request_Users1] FOREIGN KEY([IdManager])
REFERENCES [dbo].[Users] ([IdUser])
GO
ALTER TABLE [dbo].[Request] CHECK CONSTRAINT [FK_Request_Users1]
GO
ALTER TABLE [dbo].[RequestDetail]  WITH CHECK ADD  CONSTRAINT [FK_RequestDetail_Detail] FOREIGN KEY([IdDetail])
REFERENCES [dbo].[Detail] ([IdDetail])
GO
ALTER TABLE [dbo].[RequestDetail] CHECK CONSTRAINT [FK_RequestDetail_Detail]
GO
ALTER TABLE [dbo].[RequestDetail]  WITH CHECK ADD  CONSTRAINT [FK_RequestDetail_Request] FOREIGN KEY([IdRequest])
REFERENCES [dbo].[Request] ([IdRequest])
GO
ALTER TABLE [dbo].[RequestDetail] CHECK CONSTRAINT [FK_RequestDetail_Request]
GO
ALTER TABLE [dbo].[Users]  WITH CHECK ADD  CONSTRAINT [FK_Users_Role] FOREIGN KEY([IdRole])
REFERENCES [dbo].[Role] ([IdRole])
GO
ALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_Role]
GO