699
.pdfCONSTRAINT [PK_WPr_st] PRIMARY KEY CLUSTERED
(
[Cnum] 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
ALTER TABLE [dbo].[WPr_st] WITH CHECK ADD CONSTRAINT [FK_WPr_st_prep] FOREIGN KEY([Cprep])
REFERENCES [dbo].[prep] ([Cprep]) GO
ALTER TABLE [dbo].[WPr_st] CHECK CONSTRAINT [FK_WPr_st_prep]
GO
ALTER TABLE [dbo].[WPr_st] WITH CHECK ADD CONSTRAINT [FK_WPr_st_stud] FOREIGN KEY([Cst])
REFERENCES [dbo].[stud] ([Cst]) GO
ALTER TABLE [dbo].[WPr_st] CHECK CONSTRAINT [FK_WPr_st_stud]
GO
Индекс
CREATE UNIQUE NONCLUSTERED INDEX [wp_s] ON [dbo].[WPr_st]
(
[Cprep] ASC, [Cst] ASC, [data] ASC
251
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
Название контрольной точки
CREATE TABLE [dbo].[nexam](
[Cne] [tinyint] IDENTITY(1,1) NOT NULL, [nasv] [varchar](30) NOT NULL,
CONSTRAINT [PK_nexam] PRIMARY KEY CLUSTERED
(
[Cne] 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
Контрольные точки
CREATE TABLE [dbo].[exam](
[Ce] [tinyint] IDENTITY(1,1) NOT NULL, [Cpred] [tinyint] NOT NULL,
[Cfc] [varchar](10) NOT NULL, [Cgr] [varchar](10) NOT NULL, [Course] [tinyint] NULL, [Date] [date] NULL,
[ex_ter] [varchar](50) NULL, [Cne] [tinyint] NOT NULL,
CONSTRAINT [PK_exam1] PRIMARY KEY CLUSTERED
(
[Ce] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
252
ALTER TABLE [dbo].[exam] WITH CHECK ADD CONSTRAINT [FK_exam1_fac] FOREIGN KEY([Cfc])
REFERENCES [dbo].[fac] ([Cfc]) GO
ALTER TABLE [dbo].[exam] CHECK CONSTRAINT [FK_exam1_fac]
GO
ALTER TABLE [dbo].[exam] WITH CHECK ADD CONSTRAINT [FK_exam1_Gro] FOREIGN KEY([Cgr])
REFERENCES [dbo].[Gro] ([Cgr]) GO
ALTER TABLE [dbo].[exam] CHECK CONSTRAINT [FK_exam1_Gro]
GO
ALTER TABLE [dbo].[exam] WITH CHECK ADD CONSTRAINT [FK_exam1_nexam] FOREIGN KEY([Cne])
REFERENCES [dbo].[nexam] ([Cne]) GO
ALTER TABLE [dbo].[exam] CHECK CONSTRAINT [FK_exam1_nexam]
GO
ALTER TABLE [dbo].[exam] WITH CHECK ADD CONSTRAINT [FK_exam1_pred] FOREIGN KEY([Cpred])
REFERENCES [dbo].[pred] ([Cpr]) GO
ALTER TABLE [dbo].[exam] CHECK CONSTRAINT [FK_exam1_pred]
253
GO
CREATE UNIQUE NONCLUSTERED INDEX [ex] ON [dbo].[exam]
(
[Cpred] ASC, [Cfc] ASC, [Cne] ASC, [Course] ASC, [Cgr] ASC, [Date] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
Студенты и кафедра
CREATE TABLE [dbo].[st_kaf](
[Csk] [bigint] IDENTITY(1,1) NOT NULL, [Cst] [tinyint] NOT NULL,
[Ckaf] [tinyint] NOT NULL, [dataw] [date] NULL, [wrk] [varchar](20) NULL,
CONSTRAINT [PK_st_kaf] PRIMARY KEY CLUSTERED
(
[Csk] 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
ALTER TABLE [dbo].[st_kaf] WITH CHECK ADD CONSTRAINT [FK_st_kaf_kafed] FOREIGN KEY([Ckaf])
254
REFERENCES [dbo].[kafed] ([Ckaf])
GO
ALTER TABLE [dbo].[st_kaf] CHECK CONSTRAINT [FK_st_kaf_kafed]
GO
ALTER TABLE [dbo].[st_kaf] WITH CHECK ADD CONSTRAINT [FK_st_kaf_stud] FOREIGN KEY([Cst])
REFERENCES [dbo].[stud] ([Cst]) GO
ALTER TABLE [dbo].[st_kaf] CHECK CONSTRAINT [FK_st_kaf_stud]
GO
Индекс
CREATE UNIQUE NONCLUSTERED INDEX [ska] ON [dbo].[st_kaf]
(
[Cst] ASC,
[Ckaf] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
Табель абитуриента
CREATE TABLE [dbo].[ab_exam](
[Cc] [tinyint] IDENTITY(1,1) NOT NULL, [Ce] [tinyint] NOT NULL,
[Ca] [tinyint] NOT NULL, [mark] [tinyint] NULL,
CONSTRAINT [PK_ab_exam] PRIMARY KEY CLUSTERED
(
[Cc] ASC
255
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ab_exam] WITH CHECK ADD CONSTRAINT [FK_ab_exam_abit] FOREIGN KEY([Ca])
REFERENCES [dbo].[abit] ([Cab]) GO
ALTER TABLE [dbo].[ab_exam] CHECK CONSTRAINT [FK_ab_exam_abit]
GO
ALTER TABLE [dbo].[ab_exam] WITH CHECK ADD CONSTRAINT [FK_ab_exam_exam] FOREIGN KEY([Ce])
REFERENCES [dbo].[exam] ([Ce]) GO
ALTER TABLE [dbo].[ab_exam] CHECK CONSTRAINT [FK_ab_exam_exam]
GO
CREATE UNIQUE NONCLUSTERED INDEX [exab] ON [dbo].[ab_exam]
(
[Ce] ASC,
[Ca] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
256
Оплата общежития
CREATE TABLE [dbo].[St_ob]( [Cst] [tinyint] NOT NULL, [Cob] [tinyint] NOT NULL, [opl] [money] NOT NULL, [data] [date] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[St_ob] WITH CHECK ADD CONSTRAINT [FK_St_ob_obsh] FOREIGN KEY([Cob])
REFERENCES [dbo].[obsh] ([Cob]) GO
ALTER TABLE [dbo].[St_ob] CHECK CONSTRAINT [FK_St_ob_obsh]
GO
ALTER TABLE [dbo].[St_ob] WITH CHECK ADD CONSTRAINT [FK_St_ob_stud] FOREIGN KEY([Cst])
REFERENCES [dbo].[stud] ([Cst]) GO
ALTER TABLE [dbo].[St_ob] CHECK CONSTRAINT [FK_St_ob_stud]
GO
Табель студента
CREATE TABLE [dbo].[St_exam](
[Cc] [tinyint] IDENTITY(1,1) NOT NULL, [Ce] [tinyint] NOT NULL,
[Cst] [tinyint] NOT NULL, [mark] [tinyint] NULL,
CONSTRAINT [PK_St_exam] PRIMARY KEY CLUSTERED
(
257
[Cc] 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
ALTER TABLE [dbo].[St_exam] WITH CHECK ADD CONSTRAINT [FK_St_exam_exam] FOREIGN KEY([Ce])
REFERENCES [dbo].[exam] ([Ce]) GO
ALTER TABLE [dbo].[St_exam] CHECK CONSTRAINT [FK_St_exam_exam]
GO
ALTER TABLE [dbo].[St_exam] WITH CHECK ADD CONSTRAINT [FK_St_exam_stud] FOREIGN KEY([Cst])
REFERENCES [dbo].[stud] ([Cst]) GO
ALTER TABLE [dbo].[St_exam] CHECK CONSTRAINT [FK_St_exam_stud]
GO
CREATE UNIQUE NONCLUSTERED INDEX [est] ON [dbo].[St_exam]
(
[Ce] ASC,
[Cst] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
258
GO
Учебный план
CREATE TABLE [dbo].[Uplan](
[Cup] [bigint] IDENTITY(1,1) NOT NULL, [Cpr] [tinyint] NOT NULL,
[Cst] [tinyint] NOT NULL, [mark] [int] NULL, [clock] [int] NULL, [data] [date] NOT NULL,
[disc] [varchar](10) NULL,
CONSTRAINT [PK_Uplan] PRIMARY KEY CLUSTERED
(
[Cup] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Uplan] WITH CHECK ADD CONSTRAINT [FK_Uplan_pred] FOREIGN KEY([Cpr])
REFERENCES [dbo].[pred] ([Cpr]) GO
ALTER TABLE [dbo].[Uplan] CHECK CONSTRAINT [FK_Uplan_pred]
GO
ALTER TABLE [dbo].[Uplan] WITH CHECK ADD CONSTRAINT [FK_Uplan_stud] FOREIGN KEY([Cst])
REFERENCES [dbo].[stud] ([Cst])
259
GO
ALTER TABLE [dbo].[Uplan] CHECK CONSTRAINT [FK_Uplan_stud]
GO
CREATE UNIQUE NONCLUSTERED INDEX [plan] ON [dbo].[Uplan]
(
[Cpr] ASC,
[Cst] ASC, [data] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
260