排课系统数据库报告(20)

-

ALTER TABLE [dbo].[courselist1] CHECK CONSTRAINT [FK_courselist1_course1] ALTER TABLE [dbo].[courselist1] WITH CHECK ADD CONSTRAINT

[FK_courselist1_course2] FOREIGN KEY([第三节])

REFERENCES [dbo].[course] ([coursename])

ALTER TABLE [dbo].[courselist1] CHECK CONSTRAINT [FK_courselist1_course2] ALTER TABLE [dbo].[courselist1] WITH CHECK ADD CONSTRAINT

[FK_courselist1_course3] FOREIGN KEY([第四节])

REFERENCES [dbo].[course] ([coursename])

ALTER TABLE [dbo].[courselist1] CHECK CONSTRAINT [FK_courselist1_course3] ALTER TABLE [dbo].[courselist1] WITH CHECK ADD CONSTRAINT

[FK_courselist1_course4] FOREIGN KEY([第五节])

REFERENCES [dbo].[course] ([coursename])

ALTER TABLE [dbo].[courselist1] CHECK CONSTRAINT [FK_courselist1_course4] ALTER TABLE [dbo].[courselist1] WITH CHECK ADD CONSTRAINT

[FK_courselist1_course5] FOREIGN KEY([第六节])

REFERENCES [dbo].[course] ([coursename])

ALTER TABLE [dbo].[courselist1] CHECK CONSTRAINT [FK_courselist1_course5] ALTER TABLE [dbo].[courselist1] WITH CHECK ADD CONSTRAINT

[FK_courselist1_course6] FOREIGN KEY([第七节])

REFERENCES [dbo].[course] ([coursename])

ALTER TABLE [dbo].[courselist1] CHECK CONSTRAINT [FK_courselist1_course6] ALTER TABLE [dbo].[courselist1] WITH CHECK ADD CONSTRAINT

[FK_courselist1_course7] FOREIGN KEY([第八节])

REFERENCES [dbo].[course] ([coursename])

ALTER TABLE [dbo].[courselist1] CHECK CONSTRAINT [FK_courselist1_course7] 6）courselist2表

CREATE TABLE [dbo].[courselist2](

[第一节] [nchar](20) NULL,

[第二节] [nchar](20) NULL,

[第三节] [nchar](20) NULL,

[第四节] [nchar](20) NULL,

[第五节] [nchar](20) NULL,

[第六节] [nchar](20) NULL,

[第七节] [nchar](20) NULL,

[第八节] [nchar](20) NULL,

- .

- 总结资料-