DB_51Aspx/sql2000数据库/HRManager.sql

（开头部分） 3KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

CREATE DATABASE [HRManager]
GO

USE [HRManager]
GO

/****** 对象:  Table [dbo].[City]    脚本日期: 10/21/2006 16:02:45 ******/
CREATE TABLE [dbo].[City](
	[CityID] [int] NOT NULL,
	[CityName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
 CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED 
(
	[CityID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
--51aspx.com
/****** 对象:  Table [dbo].[Job]    脚本日期: 10/21/2006 16:03:45 ******/
CREATE TABLE [dbo].[Job](
	[JobId] [int] IDENTITY(1,1) NOT NULL,
	[JobName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[JobCityId] [int] NOT NULL,
	[JobTypeId] [int] NOT NULL,
	[Responsibility] [text] COLLATE Chinese_PRC_CI_AS NULL,
	[Requirement] [text] COLLATE Chinese_PRC_CI_AS NULL,
	[IsUrgent] [int] NULL,
 CONSTRAINT [PK_Job] PRIMARY KEY CLUSTERED 
(
	[JobName] ASC,
	[JobCityId] ASC,
	[JobTypeId] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

/****** 对象:  Table [dbo].[JobType]    脚本日期: 10/21/2006 16:04:00 ******/
CREATE TABLE [dbo].[JobType](
	[TypeId] [int] NOT NULL,
	[TypeName] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
 CONSTRAINT [PK_JobType] PRIMARY KEY CLUSTERED 
(
	[TypeId] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** 对象:  Table [dbo].[Resume]    脚本日期: 10/21/2006 16:04:11 ******/
CREATE TABLE [dbo].[Resume](
	[ResumeId] [int] IDENTITY(1,1) NOT NULL,
	[JobName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[SecondJobName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[Name] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[Password] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[Gender] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[Birthday] [datetime] NULL,
	[City] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[Degree] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[School] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[Major] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[IsFreshGraduate] [int] NULL,
后面还有 42 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。