毕业生就业管理系统基于Sql 的管理系统

CREATE DATABASE [jygl] ON (NAME = N'jygl_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\jygl_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'jygl_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\jygl_Log.LDF' , SIZE = 1, FILEGROWTH = 10%) COLLATE Chinese_PRC_CI_AS GO exec sp_dboption N'jygl', N'autoclose', N'true' GO exec sp_dboption N'jygl', N'bulkcopy', N'false' GO exec sp_dboption N'jygl', N'trunc. log', N'true' GO exec sp_dboption N'jygl', N'torn page detection', N'true' GO exec sp_dboption N'jygl', N'read only', N'false' GO exec sp_dboption N'jygl', N'dbo use', N'false' GO exec sp_dboption N'jygl', N'single', N'false' GO exec sp_dboption N'jygl', N'autoshrink', N'true' GO exec sp_dboption N'jygl', N'ANSI null default', N'false' GO exec sp_dboption N'jygl', N'recursive triggers', N'false' GO exec sp_dboption N'jygl', N'ANSI nulls', N'false' GO exec sp_dboption N'jygl', N'concat null yields null', N'false' GO exec sp_dboption N'jygl', N'cursor close on commit', N'false' GO exec sp_dboption N'jygl', N'default to local cursor', N'false' GO exec sp_dboption N'jygl', N'quoted identifier', N'false' GO exec sp_dboption N'jygl', N'ANSI warnings', N'false' GO exec sp_dboption N'jygl', N'auto create statistics', N'true' GO exec sp_dboption N'jygl', N'auto update statistics', N'true' GO use [jygl] GO if not exists (select * from dbo.sysusers where name = N'LQC-FF2C8E3B9C4\Guest' and uid < 16382) EXEC sp_grantdbaccess N'LQC-FF2C8E3B9C4\Guest' GO CREATE TABLE [dbo].[单位信息] ( [id] [int] IDENTITY (1, 1) NOT NULL , [单位名称] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [单位性质] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [单位地址] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [单位联系人] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [单位联系方式] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [备注] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[学生信息] ( [学生证号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [姓名] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [照片] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [性别] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [民族] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [生日] [smalldatetime] NULL , [籍贯] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [身份证号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [家庭电话] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [居住地址] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [邮政编码] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [入校日期] [smalldatetime] NULL , [所在院系] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [职务] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [备注] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[就业记录] ( [id] [int] IDENTITY (1, 1) NOT NULL , [学生证号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [单位id] [int] NULL , [职位] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [时间] [smalldatetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[招聘信息] ( [id] [int] IDENTITY (1, 1) NOT NULL , [单位id] [int] NULL , [招聘时间] [smalldatetime] NULL , [招聘人数] [int] NULL , [招聘职位] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [招聘地点] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [备注] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[操作员信息] ( [id] [int] IDENTITY (1, 1) NOT NULL , [操作员ID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [操作员姓名] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [密码] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [权限] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [备注] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[院系班级] ( [id] [int] IDENTITY (1, 1) NOT NULL , [院系名] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [上级id]�