數(shù)據(jù)庫高校教務(wù)管理系統(tǒng)-文庫吧在線文庫
【正文】 ]( [民族編號] [varchar](2) NOT NULL, [民族] [varchar](18) 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]（7）建立選課表格：CREATE TABLE [dbo].[選課表]( [編號] [int] IDENTITY(1,1) NOT NULL, [學(xué)號] [varchar](14) NOT NULL, [課序號] [varchar](14) 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]（8）建立學(xué)籍代碼表格：CREATE TABLE [dbo].[學(xué)籍代碼表]( [學(xué)籍編號] [varchar](2) NOT NULL, [學(xué)籍名稱] [varchar](8) NULL, CONSTRAINT [PK_學(xué)籍代碼表] PRIMARY KEY CLUSTERED ( [學(xué)籍編號] 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é)號] [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, [學(xué)籍編號] [varchar](2) NOT NULL, CONSTRAINT [PK_學(xué)生信息] PRIMARY KEY CLUSTERED ( [學(xué)號] 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].[學(xué)生信息] WITH NOCHECK ADD CONSTRAINT [PK_學(xué)生信息] PRIMARY KEY CLUSTERED ( [學(xué)號] ) ON [PRIMARY] GOALTER TABLE [dbo].[學(xué)籍代碼表] WITH NOCHECK ADD CONSTRAINT [PK_學(xué)籍代碼表] PRIMARY KEY CLUSTERED ( [學(xué)籍編號] ) 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
公司管理相關(guān)推薦
鄂ICP備17016276號-1