【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-getJobInfo.sql,希望本篇文章对您学习有所帮助。
USE hr
GO
CREATE TABLE getJobInfo
(
getJobInfoID Int IDENTITY PRIMARY KEY,
personID Int NOT NULL,
name Varchar(10) ,
sex Varchar(5),
email Varchar(50),
phone Varchar(20),
address Varchar(50),
addrNum Varchar(10),
education Varchar(50),
Strong Text,
experience Text,
introduction Text,
type varchar(50),
workPosition varchar(50),
workCity Varchar(50),
wage Varchar(50),
other Text,
publicTime Datatime,
lookTimes Int
)
GO