Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /****** Object: Table [dbo].[DefaultSchedule] Script Date: 07.06.2017 23:20:08 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[DefaultSchedule](
- [ScheduleId] [int] NOT NULL,
- [SubjectId] [int] NOT NULL,
- [GroupId] [int] NOT NULL,
- [DayOfWeek] [int] NOT NULL,
- [LecturerId] [int] NOT NULL,
- [PairNumber] [int] NOT NULL,
- [Denominator] [int] NULL,
- CONSTRAINT [PK_DefaultSchedule] PRIMARY KEY CLUSTERED
- (
- [ScheduleId] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Groups] Script Date: 07.06.2017 23:20:08 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Groups](
- [Id] [int] NOT NULL,
- [GroupKey] [nvarchar](50) NOT NULL,
- [SpecialityId] [int] NOT NULL,
- [Course] [int] NOT NULL,
- CONSTRAINT [PK_Groups] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Lecturers] Script Date: 07.06.2017 23:20:08 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Lecturers](
- [Id] [int] NOT NULL,
- [Surname] [nvarchar](50) NOT NULL,
- [Name] [nvarchar](50) NOT NULL,
- [Patronymic] [nvarchar](50) NOT NULL,
- CONSTRAINT [PK_Lecturers] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[LecturersSubjects] Script Date: 07.06.2017 23:20:08 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[LecturersSubjects](
- [LecturerId] [int] NOT NULL,
- [SubjectId] [int] NOT NULL,
- CONSTRAINT [PK_LecturersSubjects] PRIMARY KEY CLUSTERED
- (
- [LecturerId] ASC,
- [SubjectId] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[PairsTime] Script Date: 07.06.2017 23:20:08 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[PairsTime](
- [Number] [int] NOT NULL,
- [StartTime] [time](7) NOT NULL,
- [EndTime] [time](7) NOT NULL,
- CONSTRAINT [PK_PairsTime] PRIMARY KEY CLUSTERED
- (
- [Number] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Praepostors] Script Date: 07.06.2017 23:20:08 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Praepostors](
- [Id] [int] NOT NULL,
- [StudentId] [int] NOT NULL,
- [GroupId] [int] NOT NULL,
- CONSTRAINT [PK_Praepostors] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Specialities] Script Date: 07.06.2017 23:20:08 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Specialities](
- [Id] [int] NOT NULL,
- [Name] [nvarchar](50) NOT NULL,
- CONSTRAINT [PK_Specialities] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Students] Script Date: 07.06.2017 23:20:08 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Students](
- [Id] [int] NOT NULL,
- [Surname] [nvarchar](50) NOT NULL,
- [Name] [nvarchar](50) NOT NULL,
- [Patronymic] [nvarchar](50) NOT NULL,
- [GroupId] [int] NOT NULL,
- [Email] [nvarchar](50) NULL,
- [StudentNumber] [nvarchar](50) NOT NULL,
- CONSTRAINT [PK_Students] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[Subjects] Script Date: 07.06.2017 23:20:08 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[Subjects](
- [Id] [int] NOT NULL,
- [Subject] [nvarchar](50) NOT NULL,
- CONSTRAINT [PK_Subjects] PRIMARY KEY CLUSTERED
- (
- [Id] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (1, 3, 1, 1, 4, 2, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (3, 3, 1, 1, 5, 3, 1)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (4, 1, 1, 2, 1, 1, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (5, 4, 1, 2, 6, 2, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (6, 1, 1, 2, 1, 3, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (7, 5, 1, 3, 3, 1, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (8, 6, 1, 3, 7, 2, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (9, 2, 1, 4, 2, 4, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (10, 8, 1, 4, 2, 3, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (11, 7, 1, 4, 8, 2, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (12, 5, 1, 5, 3, 1, 1)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (13, 2, 1, 5, 2, 2, NULL)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (14, 5, 2, 1, 3, 1, 0)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (15, 3, 1, 1, 4, 3, 0)
- GO
- INSERT [dbo].[DefaultSchedule] ([ScheduleId], [SubjectId], [GroupId], [DayOfWeek], [LecturerId], [PairNumber], [Denominator]) VALUES (16, 4, 1, 1, 6, 1, 0)
- GO
- INSERT [dbo].[Groups] ([Id], [GroupKey], [SpecialityId], [Course]) VALUES (1, N'КБ-41-СО', 1, 4)
- GO
- INSERT [dbo].[Groups] ([Id], [GroupKey], [SpecialityId], [Course]) VALUES (2, N'КБ-51-СО', 1, 5)
- GO
- INSERT [dbo].[Groups] ([Id], [GroupKey], [SpecialityId], [Course]) VALUES (3, N'КБ-31-НЕСО', 2, 3)
- GO
- INSERT [dbo].[Groups] ([Id], [GroupKey], [SpecialityId], [Course]) VALUES (4, N'КБ-31-СО', 1, 3)
- GO
- INSERT [dbo].[Lecturers] ([Id], [Surname], [Name], [Patronymic]) VALUES (1, N'Якимова', N'Ольга', N'Павловна')
- GO
- INSERT [dbo].[Lecturers] ([Id], [Surname], [Name], [Patronymic]) VALUES (2, N'Дурнев', N'Валерий', N'Георгиевич')
- GO
- INSERT [dbo].[Lecturers] ([Id], [Surname], [Name], [Patronymic]) VALUES (3, N'Яблокова', N'Светлана', N'Ивановна')
- GO
- INSERT [dbo].[Lecturers] ([Id], [Surname], [Name], [Patronymic]) VALUES (4, N'Иванова', N'Наталья', N'Александровна')
- GO
- INSERT [dbo].[Lecturers] ([Id], [Surname], [Name], [Patronymic]) VALUES (5, N'Власова', N'Ольга', N'Владимировна')
- GO
- INSERT [dbo].[Lecturers] ([Id], [Surname], [Name], [Patronymic]) VALUES (6, N'Иванова', N'Имя', N'Отчество')
- GO
- INSERT [dbo].[Lecturers] ([Id], [Surname], [Name], [Patronymic]) VALUES (7, N'Иванов', N'Имя', N'Отчество')
- GO
- INSERT [dbo].[Lecturers] ([Id], [Surname], [Name], [Patronymic]) VALUES (8, N'Мурин', N'Дмитрий', N'Михайлович')
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (1, 1)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (2, 2)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (2, 4)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (2, 8)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (3, 4)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (3, 5)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (4, 3)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (4, 4)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (5, 2)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (5, 3)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (6, 2)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (6, 3)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (6, 4)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (7, 3)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (7, 4)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (7, 6)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (8, 4)
- GO
- INSERT [dbo].[LecturersSubjects] ([LecturerId], [SubjectId]) VALUES (8, 7)
- GO
- INSERT [dbo].[PairsTime] ([Number], [StartTime], [EndTime]) VALUES (1, CAST(N'09:00:00' AS Time), CAST(N'10:35:00' AS Time))
- GO
- INSERT [dbo].[PairsTime] ([Number], [StartTime], [EndTime]) VALUES (2, CAST(N'10:45:00' AS Time), CAST(N'12:20:00' AS Time))
- GO
- INSERT [dbo].[PairsTime] ([Number], [StartTime], [EndTime]) VALUES (3, CAST(N'12:30:00' AS Time), CAST(N'14:05:00' AS Time))
- GO
- INSERT [dbo].[PairsTime] ([Number], [StartTime], [EndTime]) VALUES (4, CAST(N'14:15:00' AS Time), CAST(N'15:50:00' AS Time))
- GO
- INSERT [dbo].[PairsTime] ([Number], [StartTime], [EndTime]) VALUES (5, CAST(N'16:00:00' AS Time), CAST(N'17:30:00' AS Time))
- GO
- INSERT [dbo].[Praepostors] ([Id], [StudentId], [GroupId]) VALUES (1, 4, 1)
- GO
- INSERT [dbo].[Specialities] ([Id], [Name]) VALUES (1, N'Компьютерная безопасность')
- GO
- INSERT [dbo].[Specialities] ([Id], [Name]) VALUES (2, N'Специальность Мяу')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (1, N'Карачев', N'Дмитрий', N'Александрович', 1, N'karachevdmk@gmail.com', N'1010116')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (2, N'Из', N'Кто-то', N'КБ51ане из кб 41 опять из кб 51', 2, N'withEmail@mail.ru', N'1010117')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (3, N'Бекташи', N'Руслан', N'Валерьевич', 1, NULL, N'1010118')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (4, N'Мищенко', N'Наталья', N'Извини', 1, NULL, N'1010119')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (10, N'Пасхина', N'Полина', N'Лалаа', 1, N'pash@mail.ru', N'1010125')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (11, N'Дюдюкин', N'Павел', N'Привет', 1, N'pasha@mail.ru', N'1010126')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (12, N'Белов', N'Александр', N'Да', 1, NULL, N'1010127')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (14, N'Смолина', N'Анастасия', N'Извини', 1, NULL, N'1010120')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (16, N'Привет', N'А я', N'Из КБ51', 2, N'ЛАЛАЛА@Meow.ru', N'1010130')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (17, N'Карачев', N'Дмитрий', N'Из Будующего =))))))0', 2, N'НесуществуюшийЭмэйл', N'101010101010')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (18, N'МЯу', N'Дмитрий', N'Мур', 1, NULL, N'123')
- GO
- INSERT [dbo].[Students] ([Id], [Surname], [Name], [Patronymic], [GroupId], [Email], [StudentNumber]) VALUES (19, N'Елаев', N'Иван', N'Иванович', 4, N'dmdmd@mddm.ru', N'10101023')
- GO
- INSERT [dbo].[Subjects] ([Id], [Subject]) VALUES (1, N'ASP.NET')
- GO
- INSERT [dbo].[Subjects] ([Id], [Subject]) VALUES (2, N'КМЗИ')
- GO
- INSERT [dbo].[Subjects] ([Id], [Subject]) VALUES (3, N'СУБД')
- GO
- INSERT [dbo].[Subjects] ([Id], [Subject]) VALUES (4, N'Алгебра')
- GO
- INSERT [dbo].[Subjects] ([Id], [Subject]) VALUES (5, N'Алгоритмика')
- GO
- INSERT [dbo].[Subjects] ([Id], [Subject]) VALUES (6, N'Безопасность')
- GO
- INSERT [dbo].[Subjects] ([Id], [Subject]) VALUES (7, N'Предмет Мурина')
- GO
- INSERT [dbo].[Subjects] ([Id], [Subject]) VALUES (8, N'Второй предмет Дурнева')
- GO
- ALTER TABLE [dbo].[DefaultSchedule] WITH CHECK ADD CONSTRAINT [FK_DefaultSchedule_Groups] FOREIGN KEY([GroupId])
- REFERENCES [dbo].[Groups] ([Id])
- GO
- ALTER TABLE [dbo].[DefaultSchedule] CHECK CONSTRAINT [FK_DefaultSchedule_Groups]
- GO
- ALTER TABLE [dbo].[DefaultSchedule] WITH CHECK ADD CONSTRAINT [FK_DefaultSchedule_Lecturers] FOREIGN KEY([LecturerId])
- REFERENCES [dbo].[Lecturers] ([Id])
- GO
- ALTER TABLE [dbo].[DefaultSchedule] CHECK CONSTRAINT [FK_DefaultSchedule_Lecturers]
- GO
- ALTER TABLE [dbo].[DefaultSchedule] WITH CHECK ADD CONSTRAINT [FK_DefaultSchedule_PairsTime] FOREIGN KEY([PairNumber])
- REFERENCES [dbo].[PairsTime] ([Number])
- GO
- ALTER TABLE [dbo].[DefaultSchedule] CHECK CONSTRAINT [FK_DefaultSchedule_PairsTime]
- GO
- ALTER TABLE [dbo].[DefaultSchedule] WITH CHECK ADD CONSTRAINT [FK_DefaultSchedule_Subjects] FOREIGN KEY([SubjectId])
- REFERENCES [dbo].[Subjects] ([Id])
- GO
- ALTER TABLE [dbo].[DefaultSchedule] CHECK CONSTRAINT [FK_DefaultSchedule_Subjects]
- GO
- ALTER TABLE [dbo].[Groups] WITH CHECK ADD CONSTRAINT [FK_Groups_Specialities] FOREIGN KEY([SpecialityId])
- REFERENCES [dbo].[Specialities] ([Id])
- GO
- ALTER TABLE [dbo].[Groups] CHECK CONSTRAINT [FK_Groups_Specialities]
- GO
- ALTER TABLE [dbo].[LecturersSubjects] WITH CHECK ADD CONSTRAINT [FK_LecturersSubjects_Lecturers] FOREIGN KEY([LecturerId])
- REFERENCES [dbo].[Lecturers] ([Id])
- GO
- ALTER TABLE [dbo].[LecturersSubjects] CHECK CONSTRAINT [FK_LecturersSubjects_Lecturers]
- GO
- ALTER TABLE [dbo].[LecturersSubjects] WITH CHECK ADD CONSTRAINT [FK_LecturersSubjects_Subjects] FOREIGN KEY([SubjectId])
- REFERENCES [dbo].[Subjects] ([Id])
- GO
- ALTER TABLE [dbo].[LecturersSubjects] CHECK CONSTRAINT [FK_LecturersSubjects_Subjects]
- GO
- ALTER TABLE [dbo].[Praepostors] WITH CHECK ADD CONSTRAINT [FK_Praepostors_Groups] FOREIGN KEY([GroupId])
- REFERENCES [dbo].[Groups] ([Id])
- GO
- ALTER TABLE [dbo].[Praepostors] CHECK CONSTRAINT [FK_Praepostors_Groups]
- GO
- ALTER TABLE [dbo].[Praepostors] WITH CHECK ADD CONSTRAINT [FK_Praepostors_Students] FOREIGN KEY([StudentId])
- REFERENCES [dbo].[Students] ([Id])
- GO
- ALTER TABLE [dbo].[Praepostors] CHECK CONSTRAINT [FK_Praepostors_Students]
- GO
- ALTER TABLE [dbo].[Students] WITH CHECK ADD CONSTRAINT [FK_Students_Groups] FOREIGN KEY([GroupId])
- REFERENCES [dbo].[Groups] ([Id])
- GO
- ALTER TABLE [dbo].[Students] CHECK CONSTRAINT [FK_Students_Groups]
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement