· 8 years ago · Dec 08, 2017, 10:24 AM
1SET ANSI_NULLS ON
2GO
3SET QUOTED_IDENTIFIER ON
4GO
5IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LoginTypes]') AND type in (N'U'))
6BEGIN
7CREATE TABLE [dbo].[LoginTypes](
8 [ID] [int] IDENTITY(1,1) NOT NULL,
9 [Name] [varchar](255) NULL,
10PRIMARY KEY CLUSTERED
11(
12 [ID] ASC
13)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
14) ON [PRIMARY]
15END
16GO
17SET ANSI_NULLS ON
18GO
19SET QUOTED_IDENTIFIER ON
20GO
21IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Evaluation Activity]') AND type in (N'U'))
22BEGIN
23CREATE TABLE [dbo].[Evaluation Activity](
24 [ID] [int] IDENTITY(1,1) NOT NULL,
25 [Type] [varchar](255) NULL,
26 [Weight] [int] NULL,
27PRIMARY KEY CLUSTERED
28(
29 [ID] ASC
30)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
31) ON [PRIMARY]
32END
33GO
34SET ANSI_NULLS ON
35GO
36SET QUOTED_IDENTIFIER ON
37GO
38IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Group]') AND type in (N'U'))
39BEGIN
40CREATE TABLE [dbo].[Group](
41 [ID] [int] IDENTITY(1,1) NOT NULL,
42 [Name] [nvarchar](50) NULL,
43 CONSTRAINT [PK_Group] PRIMARY KEY CLUSTERED
44(
45 [ID] ASC
46)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
47) ON [PRIMARY]
48END
49GO
50SET ANSI_NULLS ON
51GO
52SET QUOTED_IDENTIFIER ON
53GO
54IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Admins]') AND type in (N'U'))
55BEGIN
56CREATE TABLE [dbo].[Admins](
57 [id] [int] IDENTITY(1,1) NOT NULL,
58 [name] [nchar](50) NOT NULL,
59 CONSTRAINT [PK_Admins] PRIMARY KEY CLUSTERED
60(
61 [id] ASC
62)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
63) ON [PRIMARY]
64END
65GO
66SET ANSI_NULLS ON
67GO
68SET QUOTED_IDENTIFIER ON
69GO
70IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Solution]') AND type in (N'U'))
71BEGIN
72CREATE TABLE [dbo].[Solution](
73 [ID] [int] IDENTITY(1,1) NOT NULL,
74 [Content] [varchar](255) NULL,
75PRIMARY KEY CLUSTERED
76(
77 [ID] ASC
78)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
79) ON [PRIMARY]
80END
81GO
82SET ANSI_NULLS ON
83GO
84SET QUOTED_IDENTIFIER ON
85GO
86IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Syllabus]') AND type in (N'U'))
87BEGIN
88CREATE TABLE [dbo].[Syllabus](
89 [ID] [int] IDENTITY(1,1) NOT NULL,
90 [Grading scheme] [varchar](255) NULL,
91 [Course objectives] [varchar](255) NULL,
92 [Course assigments] [varchar](255) NULL,
93PRIMARY KEY CLUSTERED
94(
95 [ID] ASC
96)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
97) ON [PRIMARY]
98END
99GO
100SET ANSI_NULLS ON
101GO
102SET QUOTED_IDENTIFIER ON
103GO
104IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[University]') AND type in (N'U'))
105BEGIN
106CREATE TABLE [dbo].[University](
107 [ID] [int] IDENTITY(1,1) NOT NULL,
108 [Name] [varchar](255) NULL,
109PRIMARY KEY CLUSTERED
110(
111 [ID] ASC
112)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
113) ON [PRIMARY]
114END
115GO
116SET ANSI_NULLS ON
117GO
118SET QUOTED_IDENTIFIER ON
119GO
120IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Login]') AND type in (N'U'))
121BEGIN
122CREATE TABLE [dbo].[Login](
123 [Username] [varchar](255) NOT NULL,
124 [Password] [varchar](255) NOT NULL,
125 [LoginTypesID] [int] NOT NULL,
126 [teacherid] [int] NULL,
127 [studentid] [int] NULL,
128 [adminid] [int] NULL,
129 CONSTRAINT [PK_Login_1] PRIMARY KEY CLUSTERED
130(
131 [Username] ASC
132)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
133) ON [PRIMARY]
134END
135GO
136SET ANSI_NULLS ON
137GO
138SET QUOTED_IDENTIFIER ON
139GO
140IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Course_EvaluationActivity]') AND type in (N'U'))
141BEGIN
142CREATE TABLE [dbo].[Course_EvaluationActivity](
143 [CourseID] [int] NOT NULL,
144 [EvalID] [int] NOT NULL,
145 CONSTRAINT [PK_Course_EvaluationActivity] PRIMARY KEY CLUSTERED
146(
147 [CourseID] ASC,
148 [EvalID] ASC
149)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
150) ON [PRIMARY]
151END
152GO
153SET ANSI_NULLS ON
154GO
155SET QUOTED_IDENTIFIER ON
156GO
157IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Contract_Course]') AND type in (N'U'))
158BEGIN
159CREATE TABLE [dbo].[Contract_Course](
160 [ContractID] [int] NOT NULL,
161 [CourseID] [int] NOT NULL,
162PRIMARY KEY CLUSTERED
163(
164 [ContractID] ASC,
165 [CourseID] ASC
166)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
167) ON [PRIMARY]
168END
169GO
170SET ANSI_NULLS ON
171GO
172SET QUOTED_IDENTIFIER ON
173GO
174IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Student]') AND type in (N'U'))
175BEGIN
176CREATE TABLE [dbo].[Student](
177 [ID] [int] IDENTITY(1,1) NOT NULL,
178 [Name] [varchar](255) NULL,
179 [GroupID] [int] NULL,
180PRIMARY KEY CLUSTERED
181(
182 [ID] ASC
183)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
184) ON [PRIMARY]
185END
186GO
187SET ANSI_NULLS ON
188GO
189SET QUOTED_IDENTIFIER ON
190GO
191IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Department]') AND type in (N'U'))
192BEGIN
193CREATE TABLE [dbo].[Department](
194 [ID] [int] IDENTITY(1,1) NOT NULL,
195 [FacultyID] [int] NULL,
196 [Name] [varchar](255) NULL,
197 [Type] [varchar](255) NULL,
198PRIMARY KEY CLUSTERED
199(
200 [ID] ASC
201)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
202) ON [PRIMARY]
203END
204GO
205SET ANSI_NULLS ON
206GO
207SET QUOTED_IDENTIFIER ON
208GO
209IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Lecture]') AND type in (N'U'))
210BEGIN
211CREATE TABLE [dbo].[Lecture](
212 [ID] [int] IDENTITY(1,1) NOT NULL,
213 [Topic] [varchar](255) NULL,
214 [CourseID] [int] NOT NULL,
215PRIMARY KEY CLUSTERED
216(
217 [ID] ASC
218)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
219) ON [PRIMARY]
220END
221GO
222SET ANSI_NULLS ON
223GO
224SET QUOTED_IDENTIFIER ON
225GO
226IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Assignment]') AND type in (N'U'))
227BEGIN
228CREATE TABLE [dbo].[Assignment](
229 [ID] [int] IDENTITY(1,1) NOT NULL,
230 [Type] [varchar](255) NULL,
231 [Deadline] [datetime] NULL,
232 [Statement] [varchar](255) NULL,
233 [Date] [datetime] NULL,
234 [CourseID] [int] NOT NULL,
235PRIMARY KEY CLUSTERED
236(
237 [ID] ASC
238)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
239) ON [PRIMARY]
240END
241GO
242SET ANSI_NULLS ON
243GO
244SET QUOTED_IDENTIFIER ON
245GO
246IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CourseMaterial]') AND type in (N'U'))
247BEGIN
248CREATE TABLE [dbo].[CourseMaterial](
249 [id] [int] IDENTITY(1,1) NOT NULL,
250 [CourseMaterial] [nchar](255) NOT NULL,
251 [name] [nchar](255) NOT NULL,
252 [courseID] [int] NOT NULL,
253 CONSTRAINT [PK_CourseMaterials] PRIMARY KEY CLUSTERED
254(
255 [id] ASC
256)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
257) ON [PRIMARY]
258END
259GO
260SET ANSI_NULLS ON
261GO
262SET QUOTED_IDENTIFIER ON
263GO
264IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Teacher_Course]') AND type in (N'U'))
265BEGIN
266CREATE TABLE [dbo].[Teacher_Course](
267 [TeacherID] [int] NOT NULL,
268 [CourseID] [int] NOT NULL,
269PRIMARY KEY CLUSTERED
270(
271 [TeacherID] ASC,
272 [CourseID] ASC
273)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
274) ON [PRIMARY]
275END
276GO
277SET ANSI_NULLS ON
278GO
279SET QUOTED_IDENTIFIER ON
280GO
281IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Student_Course]') AND type in (N'U'))
282BEGIN
283CREATE TABLE [dbo].[Student_Course](
284 [StudentID] [int] NOT NULL,
285 [CourseID] [int] NOT NULL,
286 [Grade] [int] NULL,
287PRIMARY KEY CLUSTERED
288(
289 [StudentID] ASC,
290 [CourseID] ASC
291)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
292) ON [PRIMARY]
293END
294GO
295SET ANSI_NULLS ON
296GO
297SET QUOTED_IDENTIFIER ON
298GO
299IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Test_Lecture]') AND type in (N'U'))
300BEGIN
301CREATE TABLE [dbo].[Test_Lecture](
302 [TestID] [int] NOT NULL,
303 [LectureID] [int] NOT NULL,
304PRIMARY KEY CLUSTERED
305(
306 [TestID] ASC,
307 [LectureID] ASC
308)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
309) ON [PRIMARY]
310END
311GO
312SET ANSI_NULLS ON
313GO
314SET QUOTED_IDENTIFIER ON
315GO
316IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Student_Test]') AND type in (N'U'))
317BEGIN
318CREATE TABLE [dbo].[Student_Test](
319 [StudentID] [int] NOT NULL,
320 [TestID] [int] NOT NULL,
321 [Grade] [int] NULL,
322PRIMARY KEY CLUSTERED
323(
324 [StudentID] ASC,
325 [TestID] ASC
326)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
327) ON [PRIMARY]
328END
329GO
330SET ANSI_NULLS ON
331GO
332SET QUOTED_IDENTIFIER ON
333GO
334IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Test_Question]') AND type in (N'U'))
335BEGIN
336CREATE TABLE [dbo].[Test_Question](
337 [TestID] [int] NOT NULL,
338 [QuestionID] [int] NOT NULL,
339PRIMARY KEY CLUSTERED
340(
341 [TestID] ASC,
342 [QuestionID] ASC
343)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
344) ON [PRIMARY]
345END
346GO
347SET ANSI_NULLS ON
348GO
349SET QUOTED_IDENTIFIER ON
350GO
351IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Teacher_Test]') AND type in (N'U'))
352BEGIN
353CREATE TABLE [dbo].[Teacher_Test](
354 [teacherid] [int] NOT NULL,
355 [testid] [int] NOT NULL,
356 CONSTRAINT [PK_Teacher_Test] PRIMARY KEY CLUSTERED
357(
358 [teacherid] ASC,
359 [testid] ASC
360)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
361) ON [PRIMARY]
362END
363GO
364SET ANSI_NULLS ON
365GO
366SET QUOTED_IDENTIFIER ON
367GO
368IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Curriculum]') AND type in (N'U'))
369BEGIN
370CREATE TABLE [dbo].[Curriculum](
371 [ID] [int] IDENTITY(1,1) NOT NULL,
372 [Year] [varchar](255) NULL,
373 [ProgramID] [int] NOT NULL,
374PRIMARY KEY CLUSTERED
375(
376 [ID] ASC
377)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
378) ON [PRIMARY]
379END
380GO
381SET ANSI_NULLS ON
382GO
383SET QUOTED_IDENTIFIER ON
384GO
385IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Student_Program]') AND type in (N'U'))
386BEGIN
387CREATE TABLE [dbo].[Student_Program](
388 [StudentID] [int] NOT NULL,
389 [ProgramID] [int] NOT NULL,
390PRIMARY KEY CLUSTERED
391(
392 [StudentID] ASC,
393 [ProgramID] ASC
394)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
395) ON [PRIMARY]
396END
397GO
398SET ANSI_NULLS ON
399GO
400SET QUOTED_IDENTIFIER ON
401GO
402IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Teacher]') AND type in (N'U'))
403BEGIN
404CREATE TABLE [dbo].[Teacher](
405 [ID] [int] IDENTITY(1,1) NOT NULL,
406 [Name] [varchar](255) NOT NULL,
407 [ChairID] [int] NOT NULL,
408 CONSTRAINT [PK__Teacher__173876EA] PRIMARY KEY CLUSTERED
409(
410 [ID] ASC
411)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
412) ON [PRIMARY]
413END
414GO
415SET ANSI_NULLS ON
416GO
417SET QUOTED_IDENTIFIER ON
418GO
419IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Course]') AND type in (N'U'))
420BEGIN
421CREATE TABLE [dbo].[Course](
422 [ID] [int] IDENTITY(1,1) NOT NULL,
423 [SyllabusID] [int] NOT NULL,
424 [Name] [varchar](255) NULL,
425 [Type] [varchar](255) NULL,
426 [Announcements] [varchar](2555) NULL,
427 [CurriculumID] [int] NOT NULL,
428 CONSTRAINT [PK__Course__15502E78] PRIMARY KEY CLUSTERED
429(
430 [ID] ASC
431)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
432) ON [PRIMARY]
433END
434GO
435SET ANSI_NULLS ON
436GO
437SET QUOTED_IDENTIFIER ON
438GO
439IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Question_Lecture]') AND type in (N'U'))
440BEGIN
441CREATE TABLE [dbo].[Question_Lecture](
442 [QuestionID] [int] NOT NULL,
443 [LectureID] [int] NOT NULL,
444PRIMARY KEY CLUSTERED
445(
446 [QuestionID] ASC,
447 [LectureID] ASC
448)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
449) ON [PRIMARY]
450END
451GO
452SET ANSI_NULLS ON
453GO
454SET QUOTED_IDENTIFIER ON
455GO
456IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Assignment_Lecture]') AND type in (N'U'))
457BEGIN
458CREATE TABLE [dbo].[Assignment_Lecture](
459 [AssignmentID] [int] NOT NULL,
460 [LectureID] [int] NOT NULL,
461PRIMARY KEY CLUSTERED
462(
463 [AssignmentID] ASC,
464 [LectureID] ASC
465)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
466) ON [PRIMARY]
467END
468GO
469SET ANSI_NULLS ON
470GO
471SET QUOTED_IDENTIFIER ON
472GO
473IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Student_Assignment]') AND type in (N'U'))
474BEGIN
475CREATE TABLE [dbo].[Student_Assignment](
476 [StudentID] [int] NOT NULL,
477 [AssignmentID] [int] NOT NULL,
478 [Grade] [int] NULL,
479 [Solution] [nchar](255) NOT NULL,
480 CONSTRAINT [PK__Student_Assignme__117F9D94] PRIMARY KEY CLUSTERED
481(
482 [StudentID] ASC,
483 [AssignmentID] ASC
484)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
485) ON [PRIMARY]
486END
487GO
488SET ANSI_NULLS ON
489GO
490SET QUOTED_IDENTIFIER ON
491GO
492IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Answer]') AND type in (N'U'))
493BEGIN
494CREATE TABLE [dbo].[Answer](
495 [ID] [int] IDENTITY(1,1) NOT NULL,
496 [QuestionID] [int] NULL,
497 [Statement] [varchar](255) NULL,
498 [Type] [varchar](255) NULL,
499PRIMARY KEY CLUSTERED
500(
501 [ID] ASC
502)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
503) ON [PRIMARY]
504END
505GO
506SET ANSI_NULLS ON
507GO
508SET QUOTED_IDENTIFIER ON
509GO
510IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Contract]') AND type in (N'U'))
511BEGIN
512CREATE TABLE [dbo].[Contract](
513 [ID] [int] IDENTITY(1,1) NOT NULL,
514 [StudentID] [int] NOT NULL,
515 [Description] [varchar](255) NULL,
516PRIMARY KEY CLUSTERED
517(
518 [ID] ASC
519)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
520) ON [PRIMARY]
521END
522GO
523SET ANSI_NULLS ON
524GO
525SET QUOTED_IDENTIFIER ON
526GO
527IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Program]') AND type in (N'U'))
528BEGIN
529CREATE TABLE [dbo].[Program](
530 [ID] [int] IDENTITY(1,1) NOT NULL,
531 [DepartmentID] [int] NULL,
532 [Name] [varchar](255) NULL,
533 [Level] [varchar](255) NULL,
534PRIMARY KEY CLUSTERED
535(
536 [ID] ASC
537)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
538) ON [PRIMARY]
539END
540GO
541SET ANSI_NULLS ON
542GO
543SET QUOTED_IDENTIFIER ON
544GO
545IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Chairs]') AND type in (N'U'))
546BEGIN
547CREATE TABLE [dbo].[Chairs](
548 [ID] [int] NOT NULL,
549 [Name] [nvarchar](50) NULL,
550 [DepartmentID] [int] NULL,
551 CONSTRAINT [PK_Chairs] PRIMARY KEY CLUSTERED
552(
553 [ID] ASC
554)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
555) ON [PRIMARY]
556END
557GO
558SET ANSI_NULLS ON
559GO
560SET QUOTED_IDENTIFIER ON
561GO
562IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Question]') AND type in (N'U'))
563BEGIN
564CREATE TABLE [dbo].[Question](
565 [ID] [int] IDENTITY(1,1) NOT NULL,
566 [Statement] [varchar](255) NULL,
567 [TeacherID] [int] NOT NULL,
568PRIMARY KEY CLUSTERED
569(
570 [ID] ASC
571)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
572) ON [PRIMARY]
573END
574GO
575SET ANSI_NULLS ON
576GO
577SET QUOTED_IDENTIFIER ON
578GO
579IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Test]') AND type in (N'U'))
580BEGIN
581CREATE TABLE [dbo].[Test](
582 [ID] [int] IDENTITY(1,1) NOT NULL,
583 [SolutionID] [int] NOT NULL,
584 [Type] [varchar](255) NULL,
585PRIMARY KEY CLUSTERED
586(
587 [ID] ASC
588)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
589) ON [PRIMARY]
590END
591GO
592SET ANSI_NULLS ON
593GO
594SET QUOTED_IDENTIFIER ON
595GO
596IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Faculty]') AND type in (N'U'))
597BEGIN
598CREATE TABLE [dbo].[Faculty](
599 [ID] [int] IDENTITY(1,1) NOT NULL,
600 [Name] [nvarchar](50) NULL,
601 [UniversityID] [int] NULL,
602 CONSTRAINT [PK_Faculty] PRIMARY KEY CLUSTERED
603(
604 [ID] ASC
605)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
606) ON [PRIMARY]
607END
608GO
609IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Login_Admins]') AND parent_object_id = OBJECT_ID(N'[dbo].[Login]'))
610ALTER TABLE [dbo].[Login] WITH CHECK ADD CONSTRAINT [FK_Login_Admins] FOREIGN KEY([adminid])
611REFERENCES [dbo].[Admins] ([id])
612GO
613ALTER TABLE [dbo].[Login] CHECK CONSTRAINT [FK_Login_Admins]
614GO
615IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Login_Student]') AND parent_object_id = OBJECT_ID(N'[dbo].[Login]'))
616ALTER TABLE [dbo].[Login] WITH CHECK ADD CONSTRAINT [FK_Login_Student] FOREIGN KEY([studentid])
617REFERENCES [dbo].[Student] ([ID])
618GO
619ALTER TABLE [dbo].[Login] CHECK CONSTRAINT [FK_Login_Student]
620GO
621IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Login_Teacher]') AND parent_object_id = OBJECT_ID(N'[dbo].[Login]'))
622ALTER TABLE [dbo].[Login] WITH CHECK ADD CONSTRAINT [FK_Login_Teacher] FOREIGN KEY([teacherid])
623REFERENCES [dbo].[Teacher] ([ID])
624GO
625ALTER TABLE [dbo].[Login] CHECK CONSTRAINT [FK_Login_Teacher]
626GO
627IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKLogin342095]') AND parent_object_id = OBJECT_ID(N'[dbo].[Login]'))
628ALTER TABLE [dbo].[Login] WITH CHECK ADD CONSTRAINT [FKLogin342095] FOREIGN KEY([LoginTypesID])
629REFERENCES [dbo].[LoginTypes] ([ID])
630GO
631ALTER TABLE [dbo].[Login] CHECK CONSTRAINT [FKLogin342095]
632GO
633IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Course_EvaluationActivity_Course]') AND parent_object_id = OBJECT_ID(N'[dbo].[Course_EvaluationActivity]'))
634ALTER TABLE [dbo].[Course_EvaluationActivity] WITH CHECK ADD CONSTRAINT [FK_Course_EvaluationActivity_Course] FOREIGN KEY([CourseID])
635REFERENCES [dbo].[Course] ([ID])
636GO
637ALTER TABLE [dbo].[Course_EvaluationActivity] CHECK CONSTRAINT [FK_Course_EvaluationActivity_Course]
638GO
639IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Course_EvaluationActivity_Evaluation Activity]') AND parent_object_id = OBJECT_ID(N'[dbo].[Course_EvaluationActivity]'))
640ALTER TABLE [dbo].[Course_EvaluationActivity] WITH CHECK ADD CONSTRAINT [FK_Course_EvaluationActivity_Evaluation Activity] FOREIGN KEY([EvalID])
641REFERENCES [dbo].[Evaluation Activity] ([ID])
642GO
643ALTER TABLE [dbo].[Course_EvaluationActivity] CHECK CONSTRAINT [FK_Course_EvaluationActivity_Evaluation Activity]
644GO
645IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKContract_C831911]') AND parent_object_id = OBJECT_ID(N'[dbo].[Contract_Course]'))
646ALTER TABLE [dbo].[Contract_Course] WITH CHECK ADD CONSTRAINT [FKContract_C831911] FOREIGN KEY([ContractID])
647REFERENCES [dbo].[Contract] ([ID])
648GO
649ALTER TABLE [dbo].[Contract_Course] CHECK CONSTRAINT [FKContract_C831911]
650GO
651IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKContract_C981166]') AND parent_object_id = OBJECT_ID(N'[dbo].[Contract_Course]'))
652ALTER TABLE [dbo].[Contract_Course] WITH CHECK ADD CONSTRAINT [FKContract_C981166] FOREIGN KEY([CourseID])
653REFERENCES [dbo].[Course] ([ID])
654GO
655ALTER TABLE [dbo].[Contract_Course] CHECK CONSTRAINT [FKContract_C981166]
656GO
657IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Student_Group]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student]'))
658ALTER TABLE [dbo].[Student] WITH CHECK ADD CONSTRAINT [FK_Student_Group] FOREIGN KEY([GroupID])
659REFERENCES [dbo].[Group] ([ID])
660GO
661ALTER TABLE [dbo].[Student] CHECK CONSTRAINT [FK_Student_Group]
662GO
663IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKDepartment574577]') AND parent_object_id = OBJECT_ID(N'[dbo].[Department]'))
664ALTER TABLE [dbo].[Department] WITH CHECK ADD CONSTRAINT [FKDepartment574577] FOREIGN KEY([FacultyID])
665REFERENCES [dbo].[Faculty] ([ID])
666GO
667ALTER TABLE [dbo].[Department] CHECK CONSTRAINT [FKDepartment574577]
668GO
669IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKLecture69071]') AND parent_object_id = OBJECT_ID(N'[dbo].[Lecture]'))
670ALTER TABLE [dbo].[Lecture] WITH CHECK ADD CONSTRAINT [FKLecture69071] FOREIGN KEY([CourseID])
671REFERENCES [dbo].[Course] ([ID])
672GO
673ALTER TABLE [dbo].[Lecture] CHECK CONSTRAINT [FKLecture69071]
674GO
675IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKAssignment312150]') AND parent_object_id = OBJECT_ID(N'[dbo].[Assignment]'))
676ALTER TABLE [dbo].[Assignment] WITH CHECK ADD CONSTRAINT [FKAssignment312150] FOREIGN KEY([CourseID])
677REFERENCES [dbo].[Course] ([ID])
678GO
679ALTER TABLE [dbo].[Assignment] CHECK CONSTRAINT [FKAssignment312150]
680GO
681IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_CourseMaterials_Course]') AND parent_object_id = OBJECT_ID(N'[dbo].[CourseMaterial]'))
682ALTER TABLE [dbo].[CourseMaterial] WITH CHECK ADD CONSTRAINT [FK_CourseMaterials_Course] FOREIGN KEY([courseID])
683REFERENCES [dbo].[Course] ([ID])
684GO
685ALTER TABLE [dbo].[CourseMaterial] CHECK CONSTRAINT [FK_CourseMaterials_Course]
686GO
687IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKTeacher_Co127617]') AND parent_object_id = OBJECT_ID(N'[dbo].[Teacher_Course]'))
688ALTER TABLE [dbo].[Teacher_Course] WITH CHECK ADD CONSTRAINT [FKTeacher_Co127617] FOREIGN KEY([TeacherID])
689REFERENCES [dbo].[Teacher] ([ID])
690GO
691ALTER TABLE [dbo].[Teacher_Course] CHECK CONSTRAINT [FKTeacher_Co127617]
692GO
693IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKTeacher_Co771260]') AND parent_object_id = OBJECT_ID(N'[dbo].[Teacher_Course]'))
694ALTER TABLE [dbo].[Teacher_Course] WITH CHECK ADD CONSTRAINT [FKTeacher_Co771260] FOREIGN KEY([CourseID])
695REFERENCES [dbo].[Course] ([ID])
696GO
697ALTER TABLE [dbo].[Teacher_Course] CHECK CONSTRAINT [FKTeacher_Co771260]
698GO
699IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKStudent_Co41710]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student_Course]'))
700ALTER TABLE [dbo].[Student_Course] WITH CHECK ADD CONSTRAINT [FKStudent_Co41710] FOREIGN KEY([CourseID])
701REFERENCES [dbo].[Course] ([ID])
702GO
703ALTER TABLE [dbo].[Student_Course] CHECK CONSTRAINT [FKStudent_Co41710]
704GO
705IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKStudent_Co886952]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student_Course]'))
706ALTER TABLE [dbo].[Student_Course] WITH CHECK ADD CONSTRAINT [FKStudent_Co886952] FOREIGN KEY([StudentID])
707REFERENCES [dbo].[Student] ([ID])
708GO
709ALTER TABLE [dbo].[Student_Course] CHECK CONSTRAINT [FKStudent_Co886952]
710GO
711IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKTest_Lectu317804]') AND parent_object_id = OBJECT_ID(N'[dbo].[Test_Lecture]'))
712ALTER TABLE [dbo].[Test_Lecture] WITH CHECK ADD CONSTRAINT [FKTest_Lectu317804] FOREIGN KEY([LectureID])
713REFERENCES [dbo].[Lecture] ([ID])
714GO
715ALTER TABLE [dbo].[Test_Lecture] CHECK CONSTRAINT [FKTest_Lectu317804]
716GO
717IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKTest_Lectu77761]') AND parent_object_id = OBJECT_ID(N'[dbo].[Test_Lecture]'))
718ALTER TABLE [dbo].[Test_Lecture] WITH CHECK ADD CONSTRAINT [FKTest_Lectu77761] FOREIGN KEY([TestID])
719REFERENCES [dbo].[Test] ([ID])
720GO
721ALTER TABLE [dbo].[Test_Lecture] CHECK CONSTRAINT [FKTest_Lectu77761]
722GO
723IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKStudent_Te888484]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student_Test]'))
724ALTER TABLE [dbo].[Student_Test] WITH CHECK ADD CONSTRAINT [FKStudent_Te888484] FOREIGN KEY([StudentID])
725REFERENCES [dbo].[Student] ([ID])
726GO
727ALTER TABLE [dbo].[Student_Test] CHECK CONSTRAINT [FKStudent_Te888484]
728GO
729IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKStudent_Te98174]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student_Test]'))
730ALTER TABLE [dbo].[Student_Test] WITH CHECK ADD CONSTRAINT [FKStudent_Te98174] FOREIGN KEY([TestID])
731REFERENCES [dbo].[Test] ([ID])
732GO
733ALTER TABLE [dbo].[Student_Test] CHECK CONSTRAINT [FKStudent_Te98174]
734GO
735IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKTest_Quest260171]') AND parent_object_id = OBJECT_ID(N'[dbo].[Test_Question]'))
736ALTER TABLE [dbo].[Test_Question] WITH CHECK ADD CONSTRAINT [FKTest_Quest260171] FOREIGN KEY([TestID])
737REFERENCES [dbo].[Test] ([ID])
738GO
739ALTER TABLE [dbo].[Test_Question] CHECK CONSTRAINT [FKTest_Quest260171]
740GO
741IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKTest_Quest474511]') AND parent_object_id = OBJECT_ID(N'[dbo].[Test_Question]'))
742ALTER TABLE [dbo].[Test_Question] WITH CHECK ADD CONSTRAINT [FKTest_Quest474511] FOREIGN KEY([QuestionID])
743REFERENCES [dbo].[Question] ([ID])
744GO
745ALTER TABLE [dbo].[Test_Question] CHECK CONSTRAINT [FKTest_Quest474511]
746GO
747IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Teacher_Test_Teacher]') AND parent_object_id = OBJECT_ID(N'[dbo].[Teacher_Test]'))
748ALTER TABLE [dbo].[Teacher_Test] WITH CHECK ADD CONSTRAINT [FK_Teacher_Test_Teacher] FOREIGN KEY([teacherid])
749REFERENCES [dbo].[Teacher] ([ID])
750GO
751ALTER TABLE [dbo].[Teacher_Test] CHECK CONSTRAINT [FK_Teacher_Test_Teacher]
752GO
753IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Teacher_Test_Test]') AND parent_object_id = OBJECT_ID(N'[dbo].[Teacher_Test]'))
754ALTER TABLE [dbo].[Teacher_Test] WITH CHECK ADD CONSTRAINT [FK_Teacher_Test_Test] FOREIGN KEY([testid])
755REFERENCES [dbo].[Test] ([ID])
756GO
757ALTER TABLE [dbo].[Teacher_Test] CHECK CONSTRAINT [FK_Teacher_Test_Test]
758GO
759IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKCurriculum620390]') AND parent_object_id = OBJECT_ID(N'[dbo].[Curriculum]'))
760ALTER TABLE [dbo].[Curriculum] WITH CHECK ADD CONSTRAINT [FKCurriculum620390] FOREIGN KEY([ProgramID])
761REFERENCES [dbo].[Program] ([ID])
762GO
763ALTER TABLE [dbo].[Curriculum] CHECK CONSTRAINT [FKCurriculum620390]
764GO
765IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKStudent_Pr50855]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student_Program]'))
766ALTER TABLE [dbo].[Student_Program] WITH CHECK ADD CONSTRAINT [FKStudent_Pr50855] FOREIGN KEY([StudentID])
767REFERENCES [dbo].[Student] ([ID])
768GO
769ALTER TABLE [dbo].[Student_Program] CHECK CONSTRAINT [FKStudent_Pr50855]
770GO
771IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKStudent_Pr972735]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student_Program]'))
772ALTER TABLE [dbo].[Student_Program] WITH CHECK ADD CONSTRAINT [FKStudent_Pr972735] FOREIGN KEY([ProgramID])
773REFERENCES [dbo].[Program] ([ID])
774GO
775ALTER TABLE [dbo].[Student_Program] CHECK CONSTRAINT [FKStudent_Pr972735]
776GO
777IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Teacher_Chairs]') AND parent_object_id = OBJECT_ID(N'[dbo].[Teacher]'))
778ALTER TABLE [dbo].[Teacher] WITH CHECK ADD CONSTRAINT [FK_Teacher_Chairs] FOREIGN KEY([ChairID])
779REFERENCES [dbo].[Chairs] ([ID])
780GO
781ALTER TABLE [dbo].[Teacher] CHECK CONSTRAINT [FK_Teacher_Chairs]
782GO
783IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKCourse66994]') AND parent_object_id = OBJECT_ID(N'[dbo].[Course]'))
784ALTER TABLE [dbo].[Course] WITH CHECK ADD CONSTRAINT [FKCourse66994] FOREIGN KEY([SyllabusID])
785REFERENCES [dbo].[Syllabus] ([ID])
786GO
787ALTER TABLE [dbo].[Course] CHECK CONSTRAINT [FKCourse66994]
788GO
789IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKCourse759586]') AND parent_object_id = OBJECT_ID(N'[dbo].[Course]'))
790ALTER TABLE [dbo].[Course] WITH CHECK ADD CONSTRAINT [FKCourse759586] FOREIGN KEY([CurriculumID])
791REFERENCES [dbo].[Curriculum] ([ID])
792GO
793ALTER TABLE [dbo].[Course] CHECK CONSTRAINT [FKCourse759586]
794GO
795IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKQuestion_L259070]') AND parent_object_id = OBJECT_ID(N'[dbo].[Question_Lecture]'))
796ALTER TABLE [dbo].[Question_Lecture] WITH CHECK ADD CONSTRAINT [FKQuestion_L259070] FOREIGN KEY([LectureID])
797REFERENCES [dbo].[Lecture] ([ID])
798GO
799ALTER TABLE [dbo].[Question_Lecture] CHECK CONSTRAINT [FKQuestion_L259070]
800GO
801IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKQuestion_L764430]') AND parent_object_id = OBJECT_ID(N'[dbo].[Question_Lecture]'))
802ALTER TABLE [dbo].[Question_Lecture] WITH CHECK ADD CONSTRAINT [FKQuestion_L764430] FOREIGN KEY([QuestionID])
803REFERENCES [dbo].[Question] ([ID])
804GO
805ALTER TABLE [dbo].[Question_Lecture] CHECK CONSTRAINT [FKQuestion_L764430]
806GO
807IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKAssignment690841]') AND parent_object_id = OBJECT_ID(N'[dbo].[Assignment_Lecture]'))
808ALTER TABLE [dbo].[Assignment_Lecture] WITH CHECK ADD CONSTRAINT [FKAssignment690841] FOREIGN KEY([LectureID])
809REFERENCES [dbo].[Lecture] ([ID])
810GO
811ALTER TABLE [dbo].[Assignment_Lecture] CHECK CONSTRAINT [FKAssignment690841]
812GO
813IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKAssignment721246]') AND parent_object_id = OBJECT_ID(N'[dbo].[Assignment_Lecture]'))
814ALTER TABLE [dbo].[Assignment_Lecture] WITH CHECK ADD CONSTRAINT [FKAssignment721246] FOREIGN KEY([AssignmentID])
815REFERENCES [dbo].[Assignment] ([ID])
816GO
817ALTER TABLE [dbo].[Assignment_Lecture] CHECK CONSTRAINT [FKAssignment721246]
818GO
819IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKStudent_As669142]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student_Assignment]'))
820ALTER TABLE [dbo].[Student_Assignment] WITH CHECK ADD CONSTRAINT [FKStudent_As669142] FOREIGN KEY([AssignmentID])
821REFERENCES [dbo].[Assignment] ([ID])
822GO
823ALTER TABLE [dbo].[Student_Assignment] CHECK CONSTRAINT [FKStudent_As669142]
824GO
825IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKStudent_As750184]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student_Assignment]'))
826ALTER TABLE [dbo].[Student_Assignment] WITH CHECK ADD CONSTRAINT [FKStudent_As750184] FOREIGN KEY([StudentID])
827REFERENCES [dbo].[Student] ([ID])
828GO
829ALTER TABLE [dbo].[Student_Assignment] CHECK CONSTRAINT [FKStudent_As750184]
830GO
831IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKAnswer406515]') AND parent_object_id = OBJECT_ID(N'[dbo].[Answer]'))
832ALTER TABLE [dbo].[Answer] WITH CHECK ADD CONSTRAINT [FKAnswer406515] FOREIGN KEY([QuestionID])
833REFERENCES [dbo].[Question] ([ID])
834GO
835ALTER TABLE [dbo].[Answer] CHECK CONSTRAINT [FKAnswer406515]
836GO
837IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKContract793743]') AND parent_object_id = OBJECT_ID(N'[dbo].[Contract]'))
838ALTER TABLE [dbo].[Contract] WITH CHECK ADD CONSTRAINT [FKContract793743] FOREIGN KEY([StudentID])
839REFERENCES [dbo].[Student] ([ID])
840GO
841ALTER TABLE [dbo].[Contract] CHECK CONSTRAINT [FKContract793743]
842GO
843IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKProgram550506]') AND parent_object_id = OBJECT_ID(N'[dbo].[Program]'))
844ALTER TABLE [dbo].[Program] WITH CHECK ADD CONSTRAINT [FKProgram550506] FOREIGN KEY([DepartmentID])
845REFERENCES [dbo].[Department] ([ID])
846GO
847ALTER TABLE [dbo].[Program] CHECK CONSTRAINT [FKProgram550506]
848GO
849IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Chairs_Chairs]') AND parent_object_id = OBJECT_ID(N'[dbo].[Chairs]'))
850ALTER TABLE [dbo].[Chairs] WITH CHECK ADD CONSTRAINT [FK_Chairs_Chairs] FOREIGN KEY([DepartmentID])
851REFERENCES [dbo].[Department] ([ID])
852GO
853ALTER TABLE [dbo].[Chairs] CHECK CONSTRAINT [FK_Chairs_Chairs]
854GO
855IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKQuestion682401]') AND parent_object_id = OBJECT_ID(N'[dbo].[Question]'))
856ALTER TABLE [dbo].[Question] WITH CHECK ADD CONSTRAINT [FKQuestion682401] FOREIGN KEY([TeacherID])
857REFERENCES [dbo].[Teacher] ([ID])
858GO
859ALTER TABLE [dbo].[Question] CHECK CONSTRAINT [FKQuestion682401]
860GO
861IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKTest436994]') AND parent_object_id = OBJECT_ID(N'[dbo].[Test]'))
862ALTER TABLE [dbo].[Test] WITH CHECK ADD CONSTRAINT [FKTest436994] FOREIGN KEY([SolutionID])
863REFERENCES [dbo].[Solution] ([ID])
864GO
865ALTER TABLE [dbo].[Test] CHECK CONSTRAINT [FKTest436994]
866GO
867IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Faculty_University]') AND parent_object_id = OBJECT_ID(N'[dbo].[Faculty]'))
868ALTER TABLE [dbo].[Faculty] WITH CHECK ADD CONSTRAINT [FK_Faculty_University] FOREIGN KEY([UniversityID])
869REFERENCES [dbo].[University] ([ID])
870GO
871ALTER TABLE [dbo].[Faculty] CHECK CONSTRAINT [FK_Faculty_University]