基于web的航班查詢訂票系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)說明書(編輯修改稿)
2025-07-24 19:34 本頁面
【文章內(nèi)容簡介】 0) NOT NULL, [explanFashionID] [int] NULL, [termID] [nchar](10) NULL, CONSTRAINT [PK__especialCourse__02925FBF] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOALTER TABLE [dbo].[especialCourse] WITH CHECK ADD CONSTRAINT [FK_especialCourse_DepartCourse] FOREIGN KEY([departCourseID])REFERENCES [dbo].[DepartCourse] ([id])ON UPDATE CASCADEON DELETE CASCADEGOALTER TABLE [dbo].[especialCourse] CHECK CONSTRAINT [FK_especialCourse_DepartCourse]用戶信息 Class：CREATE TABLE [dbo].[ExpertAppraise]( [id] [int] IDENTITY(1000,1) NOT FOR REPLICATION NOT NULL, [teacherID] [int] NULL, [termID] [int] NULL, [mark] [int] NULL CONSTRAINT [DF__ExpertAppr__mark__32E0915F] DEFAULT ((0)), [departID] [int] NULL, [appraiseTeacherID] [int] NULL, CONSTRAINT [PK_ExpertAppraise] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOALTER TABLE [dbo].[ExpertAppraise] WITH CHECK ADD CONSTRAINT [FK__ExpertApp__teach__30F848ED] FOREIGN KEY([teacherID])REFERENCES [dbo].[Teacher] ([id])ON UPDATE CASCADEON DELETE CASCADEGOALTER TABLE [dbo].[ExpertAppraise] CHECK CONSTRAINT [FK__ExpertApp__teach__30F848ED]GOALTER TABLE [dbo].[ExpertAppraise] WITH CHECK ADD CONSTRAINT [FK__ExpertApp__termI__31EC6D26] FOREIGN KEY([termID])REFERENCES [dbo].[Term] ([id])GOALTER TABLE [dbo].[ExpertAppraise] CHECK CONSTRAINT [FK__ExpertApp__termI__31EC6D26]用戶信息 Class：CREATE TABLE [dbo].[ExpertAppraised]( [teacherID] [int] NOT NULL, [termID] [int] NOT NULL, [appraiseTeacherID] [int] NOT NULL, [departID] [int] NULL, CONSTRAINT [PK_ExpertAppraised] PRIMARY KEY CLUSTERED ( [teacherID] ASC, [termID] ASC, [appraiseTeacherID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOALTER TABLE [dbo].[ExpertAppraised] WITH CHECK ADD CONSTRAINT [FK__ExpertApp__appra__38996AB5] FOREIGN KEY([appraiseTeacherID])REFERENCES [dbo].[Teacher] ([id])GOALTER TABLE [dbo].[ExpertAppraised] CHECK CONSTRAINT [FK__ExpertApp__appra__38996AB5]GOALTER TABLE [dbo].[ExpertAppraised] WITH CHECK ADD CONSTRAINT [FK__ExpertApp__teach__36B12243] FOREIGN KEY([teacherID])REFERENCES [dbo].[Teacher] ([id])GOALTER TABLE [dbo].[ExpertAppraised] CHECK CONSTRAINT [FK__ExpertApp__teach__36B12243]GOALTER TABLE [dbo].[ExpertAppraised] WITH CHECK ADD CONSTRAINT [FK__ExpertApp__termI__37A5467C] FOREIGN KEY([termID])REFERENCES [dbo].[Term] ([id])GOALTER TABLE [dbo].[ExpertAppraised] CHECK CONSTRAINT [FK__ExpertApp__termI__37A5467C]用戶信息 Class：CREATE TABLE [dbo].[explanFashion]( [id] [int] IDENTITY(1,1) NOT NULL, [symbol] [int] NOT NULL, [fashion] [nvarchar](50) NOT NULL,PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],UNIQUE NONCLUSTERED ( [fashion] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],UNIQUE NONCLUSTERED ( [symbol] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]用戶信息 Class：CREATE TABLE [dbo].[KeySet]( [dept] [nvarchar](100) NULL, [child] [nvarchar](100) NULL, [value] [nvarchar](100) NULL) ON [PRIMARY]用戶信息 Class：CREATE TABLE [dbo].[password]( [username] [varchar](20) NOT N
電大資料相關(guān)推薦
鄂ICP備17016276號-1