排课系统数据库报告(20)
时间：2025-01-19
-
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,
- .
- 总结资料-
上一篇：土地使用税汇总
