givejobinfo.sql

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

USE  hr
GO
CREATE TABLE giveJobInfo
(
giveJobInfoID    Int IDENTITY PRIMARY KEY,
    companyID      Int  NOT NULL,
    companyName   Varchar(50),
    vocation         Varchar(50),
    email           Varchar(50),
    phone           Varchar(50),
    address          Varchar(50),
    addrNum         Varchar(50),
    workPosition       Varchar(50),
    giveNum        Varchar(50),
    workCity        Varchar(50),
    describe        Text,
    request         Text,
    publicTime      DateTime,
    lookTimes       Int
)
GO