getjobinfo.sql

来自「网络人才招聘,系统全面很好,喜欢的朋友拿去」· SQL 代码 · 共 27 行

--51aspx.com
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