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

-

[星期] [nchar](20) NULL

) ON [PRIMARY]

ALTER TABLE [dbo].[courselist2] WITH CHECK ADD CONSTRAINT

[FK_courselist2_course] FOREIGN KEY([第一节])

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

ALTER TABLE [dbo].[courselist2] CHECK CONSTRAINT [FK_courselist2_course] ALTER TABLE [dbo].[courselist2] WITH CHECK ADD CONSTRAINT

[FK_courselist2_course1] FOREIGN KEY([第二节])

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

ALTER TABLE [dbo].[courselist2] CHECK CONSTRAINT [FK_courselist2_course1] ALTER TABLE [dbo].[courselist2] WITH CHECK ADD CONSTRAINT

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

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

ALTER TABLE [dbo].[courselist2] CHECK CONSTRAINT [FK_courselist2_course2] ALTER TABLE [dbo].[courselist2] WITH CHECK ADD CONSTRAINT

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

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

ALTER TABLE [dbo].[courselist2] CHECK CONSTRAINT [FK_courselist2_course3] ALTER TABLE [dbo].[courselist2] WITH CHECK ADD CONSTRAINT

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

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

ALTER TABLE [dbo].[courselist2] CHECK CONSTRAINT [FK_courselist2_course4] ALTER TABLE [dbo].[courselist2] WITH CHECK ADD CONSTRAINT

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

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

ALTER TABLE [dbo].[courselist2] CHECK CONSTRAINT [FK_courselist2_course5] ALTER TABLE [dbo].[courselist2] WITH CHECK ADD CONSTRAINT

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

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

ALTER TABLE [dbo].[courselist2] CHECK CONSTRAINT [FK_courselist2_course6] ALTER TABLE [dbo].[courselist2] WITH CHECK ADD CONSTRAINT

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

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

ALTER TABLE [dbo].[courselist2] CHECK CONSTRAINT [FK_courselist2_course7] 7）用户user表

- .

- 总结资料-