數(shù)據(jù)庫(kù)高校教務(wù)管理系統(tǒng)-wenkub
2023-04-22 23:10:32 本頁面
【正文】 (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（7）建立選課表格：CREATE TABLE [dbo].[選課表]( [編號(hào)] [int] IDENTITY(1,1) NOT NULL, [學(xué)號(hào)] [varchar](14) NOT NULL, [課序號(hào)] [varchar](14) NOT NULL, CONSTRAINT [PK_選課表] PRIMARY KEY CLUSTERED ( [編號(hào)] 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）建立學(xué)籍代碼表格：CREATE TABLE [dbo].[學(xué)籍代碼表]( [學(xué)籍編號(hào)] [varchar](2) NOT NULL, [學(xué)籍名稱] [varchar](8) NULL, CONSTRAINT [PK_學(xué)籍代碼表] PRIMARY KEY CLUSTERED ( [學(xué)籍編號(hào)] 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）建立學(xué)生信息表格：CREATE TABLE [dbo].[學(xué)生信息]( [學(xué)號(hào)] [varchar](14) NOT NULL, [姓名] [varchar](8) NULL, [班級(jí)編號(hào)] [varchar](14) NULL, [性別] [varchar](2) NULL, [年級(jí)] [int] NULL, [政治面貌編號(hào)] [varchar](2) NULL, [民族編號(hào)] [varchar](2) NOT NULL, [籍貫編號(hào)] [varchar](2) NOT NULL, [身份證號(hào)] [varchar](15) NULL, [學(xué)籍編號(hào)] [varchar](2) NOT NULL, CONSTRAINT [PK_學(xué)生信息] PRIMARY KEY CLUSTERED ( [學(xué)號(hào)] 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].[政治面貌代碼表]( [政治面貌編號(hào)] [varchar](2) NOT NULL, [政治面貌] [varchar](14) NULL, CONSTRAINT [PK_政治面貌代碼表] PRIMARY KEY CLUSTERED ( [政治面貌編號(hào)] 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].[學(xué)生信息] WITH NOCHECK ADD CONSTRAINT [PK_學(xué)生信息] PRIMARY KEY CLUSTERED ( [學(xué)號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[學(xué)籍代碼表] WITH NOCHECK ADD CONSTRAINT [PK_學(xué)籍代碼表] PRIMARY KEY CLUSTERED ( [學(xué)籍編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[成績(jī)表] WITH NOCHECK ADD CONSTRAINT [PK_成績(jī)表] PRIMARY KEY CLUSTERED ( [編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[政治面貌代碼表] WITH NOCHECK ADD CONSTRAINT [PK_政治面貌代碼表] PRIMARY KEY CLUSTERED ( [政治面貌編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[民族代碼表] WITH NOCHECK ADD CONSTRAINT [PK_民族代碼表] PRIMARY KEY CLUSTERED ( [民族編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[班級(jí)信息] WITH NOCHECK ADD CONSTRAINT [PK_班級(jí)信息] PRIMARY KEY CLUSTERED ( [班級(jí)編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[籍貫代碼表] WITH NOCHECK ADD CONSTRAINT [PK_籍貫代碼表] PRIMARY KEY CLUSTERED ( [籍貫編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[課程信息] WITH NOCHECK ADD CONSTRAINT [PK_課程信息] PRIMARY KEY
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1