數據庫高校教務管理系統(tǒng)-在線瀏覽
2025-05-25 23:10本頁面
【正文】 ATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（8）建立學籍代碼表格：CREATE TABLE [dbo].[學籍代碼表]( [學籍編號] [varchar](2) NOT NULL, [學籍名稱] [varchar](8) NULL, CONSTRAINT [PK_學籍代碼表] PRIMARY KEY CLUSTERED ( [學籍編號] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（8）建立學生信息表格：CREATE TABLE [dbo].[學生信息]( [學號] [varchar](14) NOT NULL, [姓名] [varchar](8) NULL, [班級編號] [varchar](14) NULL, [性別] [varchar](2) NULL, [年級] [int] NULL, [政治面貌編號] [varchar](2) NULL, [民族編號] [varchar](2) NOT NULL, [籍貫編號] [varchar](2) NOT NULL, [身份證號] [varchar](15) NULL, [學籍編號] [varchar](2) NOT NULL, CONSTRAINT [PK_學生信息] PRIMARY KEY CLUSTERED ( [學號] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（9）建立政治面貌代碼表格：CREATE TABLE [dbo].[政治面貌代碼表]( [政治面貌編號] [varchar](2) NOT NULL, [政治面貌] [varchar](14) NULL, CONSTRAINT [PK_政治面貌代碼表] PRIMARY KEY CLUSTERED ( [政治面貌編號] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（10）創(chuàng)建主鍵及外鍵等表的約束ALTER TABLE [dbo].[學生信息] WITH NOCHECK ADD CONSTRAINT [PK_學生信息] PRIMARY KEY CLUSTERED ( [學號] ) ON [PRIMARY] GOALTER TABLE [dbo].[學籍代碼表] WITH NOCHECK ADD CONSTRAINT [PK_學籍代碼表] PRIMARY KEY CLUSTERED ( [學籍編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[成績表] WITH NOCHECK ADD CONSTRAINT [PK_成績表] PRIMARY KEY CLUSTERED ( [編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[政治面貌代碼表] WITH NOCHECK ADD CONSTRAINT [PK_政治面貌代碼表] PRIMARY KEY CLUSTERED ( [政治面貌編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[民族代碼表] WITH NOCHECK ADD CONSTRAINT [PK_民族代碼表] PRIMARY KEY CLUSTERED ( [民族編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[班級信息] WITH NOCHECK ADD CONSTRAINT [PK_班級信息] PRIMARY KEY CLUSTERED ( [班級編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[籍貫代碼表] WITH NOCHECK ADD CONSTRAINT [PK_籍貫代碼表] PRIMARY KEY CLUSTERED ( [籍貫編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[課程信息] WITH NOCHECK ADD CONSTRAINT [PK_課程信息] PRIMARY KEY CLUSTERED ( [課程編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[課程表] WITH NOCHECK ADD CONSTRAINT [PK_課程表] PRIMARY KEY CLUSTERED ( [編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[選課表] WITH NOCHECK ADD CONSTRAINT [PK_選課表] PRIMARY KEY CLUSTERED ( [編號] ) ON [PRIMARY] GOALTER TABLE [dbo].[成績表] ADD CONSTRAINT [DF_成績表_成績] DEFAULT (0) FOR [成績
公司管理相關推薦
鄂ICP備17016276號-1