?? sql.sql
字號(hào):
CREATE TABLE `uchome_job_collect` (
`cid` int(10) unsigned NOT NULL auto_increment COMMENT '序列',
`cuid` int(10) unsigned NOT NULL COMMENT 'UID',
`collect` int(10) unsigned NOT NULL COMMENT '收藏',
`apply` int(10) unsigned NOT NULL COMMENT '應(yīng)聘',
`corpid` int(10) unsigned NOT NULL COMMENT '公司',
`jobid` int(10) unsigned NOT NULL COMMENT '工作',
`applyinfo` mediumtext NOT NULL COMMENT '狀態(tài)',
`dateline` int(10) unsigned NOT NULL COMMENT '時(shí)間',
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `uchome_job_company` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT '公司序列',
`uid` int(10) unsigned NOT NULL COMMENT 'UID',
`corptitle` varchar(200) NOT NULL COMMENT '公司名稱',
`industry` varchar(50) NOT NULL COMMENT '行業(yè)',
`subindustry` varchar(50) NOT NULL COMMENT '行業(yè)',
`corpprovince` varchar(50) NOT NULL COMMENT '公司地點(diǎn)省',
`corpcity` varchar(50) NOT NULL COMMENT '公司地點(diǎn)市',
`corptype` int(2) unsigned NOT NULL COMMENT '公司類型',
`corpsize` int(2) unsigned NOT NULL COMMENT '公司規(guī)模',
`corpcontact` varchar(20) NOT NULL COMMENT '聯(lián)系人',
`corpemail` varchar(50) NOT NULL COMMENT '郵件',
`corpphone` int(20) unsigned NOT NULL COMMENT '電話',
`corpfax` int(20) unsigned NOT NULL COMMENT '傳真',
`corpaddress` varchar(200) NOT NULL COMMENT '地址',
`corpzipcode` varchar(10) NOT NULL COMMENT '郵編',
`corpregarea` int(2) unsigned NOT NULL COMMENT '注冊(cè)所在地',
`corpregyear` int(4) unsigned NOT NULL COMMENT '注冊(cè)時(shí)間年',
`corpregmonth` int(2) unsigned NOT NULL COMMENT '注冊(cè)時(shí)間月',
`corpreguser` varchar(20) NOT NULL COMMENT '注冊(cè)人',
`corpdescription` text NOT NULL COMMENT '公司簡(jiǎn)介',
`corpintro` text NOT NULL COMMENT '詳細(xì)介紹',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `uchome_job_newjobs` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT '工作序列',
`uid` int(10) unsigned NOT NULL,
`title` varchar(200) character set gb2312 NOT NULL COMMENT '招聘名稱',
`department` varchar(150) NOT NULL COMMENT '招聘部門(mén)',
`number` varchar(100) NOT NULL COMMENT '招聘編號(hào)',
`corpid` int(10) unsigned NOT NULL COMMENT '公司名稱id',
`corptitle` varchar(200) NOT NULL COMMENT '公司名稱',
`jobtype` int(2) unsigned NOT NULL COMMENT '工作類型',
`days` int(10) unsigned NOT NULL COMMENT '有效期',
`pcount` int(10) unsigned NOT NULL COMMENT '招聘人數(shù)',
`displayorder` int(10) unsigned NOT NULL COMMENT '職位排序',
`jobprovince` varchar(50) NOT NULL COMMENT '工作地點(diǎn)省',
`jobcity` varchar(50) NOT NULL COMMENT '工作地點(diǎn)市',
`industry` varchar(50) NOT NULL COMMENT '工作行業(yè)',
`subindustry` varchar(50) NOT NULL COMMENT '工作行業(yè)',
`position` varchar(50) NOT NULL COMMENT '職位職能',
`subposition` varchar(50) NOT NULL COMMENT '職位職能',
`emolumenttype` int(2) unsigned NOT NULL COMMENT '薪資范圍幣種',
`emolument` int(2) unsigned NOT NULL COMMENT '薪資范圍數(shù)量',
`subsidy` varchar(200) NOT NULL COMMENT '其他待遇',
`jobintro` mediumtext NOT NULL COMMENT '職位介紹',
`seniority` int(2) unsigned NOT NULL COMMENT '工作經(jīng)驗(yàn)',
`entrytype` int(2) unsigned NOT NULL COMMENT '到崗時(shí)間',
`edudegree` int(2) unsigned NOT NULL COMMENT '學(xué)歷要求',
`language` int(2) unsigned NOT NULL COMMENT '語(yǔ)言要求',
`languagelevel` int(2) unsigned NOT NULL COMMENT '語(yǔ)言要求',
`jobcontact` varchar(20) NOT NULL COMMENT '聯(lián)系人',
`jobemail` varchar(50) NOT NULL COMMENT '聯(lián)系郵件',
`jobphone` int(15) unsigned NOT NULL COMMENT '聯(lián)系電話',
`jobaddress` varchar(100) NOT NULL COMMENT '地址',
`jobzipcode` int(15) unsigned NOT NULL COMMENT '郵政編碼',
`jobstatus` mediumtext NOT NULL COMMENT '發(fā)布類型',
`resumefilter` varchar(100) NOT NULL COMMENT '應(yīng)聘條件',
`dateline` int(10) unsigned NOT NULL,
`num` int(20) unsigned NOT NULL COMMENT '收藏?cái)?shù)',
`view` int(20) unsigned NOT NULL COMMENT '瀏覽數(shù)',
`verify` int(2) unsigned NOT NULL COMMENT '審核',
`draft` int(2) unsigned NOT NULL COMMENT '草稿',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `uchome_job_resumes` (
`resumetitle` varchar(30) NOT NULL COMMENT '簡(jiǎn)歷名稱',
`hasexperience` int(1) unsigned NOT NULL COMMENT '工作經(jīng)驗(yàn)',
`workstatus` int(1) unsigned NOT NULL COMMENT '求職狀態(tài)',
`resumestatus` int(1) unsigned NOT NULL COMMENT '簡(jiǎn)歷狀態(tài)',
`name` varchar(10) NOT NULL COMMENT '姓名',
`email` varchar(50) NOT NULL COMMENT 'Email',
`sex` int(1) unsigned NOT NULL COMMENT '性別',
`marry` int(1) unsigned NOT NULL COMMENT '婚戀狀態(tài)',
`birthyear` int(4) unsigned NOT NULL COMMENT '生日-年',
`birthmonth` int(2) unsigned NOT NULL COMMENT '生日-月',
`birthday` int(2) unsigned NOT NULL COMMENT '生日-日',
`blood` int(1) unsigned NOT NULL COMMENT '血型',
`birthprovince` varchar(20) NOT NULL COMMENT '出生地-省',
`birthcity` varchar(20) NOT NULL COMMENT '出生地-市',
`resideprovince` varchar(20) NOT NULL COMMENT '居住地-省',
`residecity` varchar(20) NOT NULL COMMENT '居住地-市',
`area` int(2) unsigned NOT NULL COMMENT '國(guó)家或地區(qū)',
`nationality` int(2) unsigned NOT NULL COMMENT '民族',
`politicsstatus` int(2) unsigned NOT NULL COMMENT '政治面貌',
`censusprovince` varchar(20) NOT NULL COMMENT '戶口所在地-省',
`censuscity` varchar(20) NOT NULL COMMENT '戶口所在地-市',
`idcardtype` int(2) unsigned NOT NULL COMMENT '證件類型',
`idcard` int(20) unsigned NOT NULL COMMENT '證件序號(hào)',
`edudegree` int(2) unsigned NOT NULL COMMENT '教育程度',
`school` varchar(255) NOT NULL COMMENT '畢業(yè)院校',
`emolumenttype` int(2) unsigned NOT NULL COMMENT '目前年薪-幣種',
`emolument` int(2) unsigned NOT NULL COMMENT '目前年薪-數(shù)量',
`seniority` int(2) unsigned NOT NULL COMMENT '工作年限',
`contacttype` int(2) unsigned NOT NULL COMMENT '聯(lián)系方式',
`mophone` varchar(15) NOT NULL COMMENT '手機(jī)',
`homephone` varchar(15) NOT NULL COMMENT '家庭電話',
`officephone` varchar(20) NOT NULL COMMENT '公司電話',
`address` varchar(200) NOT NULL COMMENT '地址',
`postcode` int(6) unsigned NOT NULL COMMENT '郵編',
`blogurl` varchar(100) NOT NULL COMMENT '博客地址',
`homepageurl` varchar(100) NOT NULL COMMENT '個(gè)人主頁(yè)',
`description` mediumtext NOT NULL COMMENT '自我評(píng)價(jià)',
`hopejobtype` int(2) unsigned NOT NULL COMMENT '工作類型',
`hasoverseas` int(2) unsigned NOT NULL COMMENT '海外工作經(jīng)驗(yàn)',
`hopesubposition` varchar(255) NOT NULL COMMENT '意向工作職能',
`hopeposition` varchar(255) NOT NULL,
`hopesubindustry` varchar(255) NOT NULL COMMENT '意向工作行業(yè)',
`hopeindustry` varchar(255) NOT NULL,
`specialty` varchar(100) NOT NULL COMMENT '專業(yè)特長(zhǎng)',
`hopeprovince1` varchar(20) NOT NULL COMMENT '首選工作地點(diǎn)-省',
`hopecity1` varchar(20) NOT NULL COMMENT '首選工作地點(diǎn)-市',
`hopeprovince2` varchar(20) NOT NULL COMMENT '二選工作地點(diǎn)-省',
`hopecity2` varchar(20) NOT NULL COMMENT '二選工作地點(diǎn)-市',
`hopeprovince3` varchar(20) NOT NULL COMMENT '三選工作地點(diǎn)-省',
`hopecity3` varchar(20) NOT NULL COMMENT '三選工作地點(diǎn)-市',
`language1` int(2) unsigned NOT NULL COMMENT '第一語(yǔ)言-語(yǔ)種',
`language1level` int(2) unsigned NOT NULL COMMENT '第一語(yǔ)言-等級(jí)',
`language2` int(2) unsigned NOT NULL COMMENT '第二語(yǔ)言-語(yǔ)種',
`language2level` int(2) unsigned NOT NULL COMMENT '第二語(yǔ)言-等級(jí)',
`language3` int(2) unsigned NOT NULL COMMENT '第三語(yǔ)言-語(yǔ)種',
`language3level` int(2) unsigned NOT NULL COMMENT '第三語(yǔ)言-等級(jí)',
`hopeemolumenttype` int(2) unsigned NOT NULL COMMENT '期望薪資-幣種',
`hopeemolument` int(2) unsigned NOT NULL COMMENT '期望薪資-數(shù)量',
`entrytype` int(2) unsigned NOT NULL COMMENT '到崗時(shí)間',
`customresume` mediumtext NOT NULL COMMENT '自定義簡(jiǎn)歷',
`industry` varchar(50) NOT NULL COMMENT '當(dāng)前工作行業(yè)-主類',
`subindustry` varchar(50) NOT NULL COMMENT '當(dāng)前工作行業(yè)-輔類',
`position` varchar(50) NOT NULL COMMENT '當(dāng)前工作職能-主類',
`subposition` varchar(50) NOT NULL COMMENT '當(dāng)前工作職能-輔類',
`id` int(20) unsigned NOT NULL auto_increment COMMENT '簡(jiǎn)歷序列',
`uid` mediumint(10) unsigned NOT NULL COMMENT 'UID',
`username` varchar(50) NOT NULL COMMENT '用戶名',
`dateline` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `uchome_job_study` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT '序列',
`uid` int(10) unsigned NOT NULL COMMENT 'UID',
`beginyear` int(4) unsigned NOT NULL COMMENT '開(kāi)始時(shí)間年',
`beginmonth` int(2) unsigned NOT NULL COMMENT '開(kāi)始時(shí)間月',
`finishyear` int(4) unsigned NOT NULL COMMENT '結(jié)束時(shí)間年',
`finishmonth` int(2) unsigned NOT NULL COMMENT '結(jié)束時(shí)間月',
`school` varchar(60) NOT NULL COMMENT '學(xué)校',
`major` varchar(40) NOT NULL COMMENT '專業(yè)',
`submajor` varchar(40) NOT NULL COMMENT '專業(yè)',
`edudegree` int(2) unsigned NOT NULL COMMENT '學(xué)歷',
`description` text NOT NULL COMMENT '學(xué)業(yè)描述',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `uchome_job_visitor` (
`vid` mediumint(8) unsigned NOT NULL default '0',
`vuid` mediumint(8) unsigned NOT NULL default '0',
`vusername` char(15) NOT NULL,
`type` varchar(50) NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`vid`,`vuid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `uchome_job_work` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT '序列',
`uid` int(10) unsigned NOT NULL COMMENT 'UID',
`beginyear` int(4) unsigned NOT NULL COMMENT '開(kāi)始時(shí)間年',
`beginmonth` int(2) unsigned NOT NULL COMMENT '開(kāi)始時(shí)間月',
`finishyear` int(4) unsigned NOT NULL COMMENT '截止時(shí)間年',
`finishmonth` int(2) unsigned NOT NULL COMMENT '截止時(shí)間月',
`company` varchar(40) NOT NULL COMMENT '公司',
`companysite` varchar(40) NOT NULL COMMENT '公司網(wǎng)址',
`industry` varchar(50) NOT NULL COMMENT '行業(yè)',
`subindustry` varchar(50) NOT NULL COMMENT '行業(yè)',
`companytype` int(2) unsigned NOT NULL COMMENT '公司類型',
`department` varchar(40) NOT NULL COMMENT '部門(mén)',
`position` varchar(50) NOT NULL COMMENT '職位',
`subposition` varchar(50) NOT NULL COMMENT '職位',
`description` text NOT NULL COMMENT '工作描述',
`reportto` varchar(20) NOT NULL COMMENT '匯報(bào)對(duì)象',
`underlingnumber` varchar(20) NOT NULL COMMENT '下屬人數(shù)',
`witness` varchar(20) NOT NULL COMMENT '證明人',
`leavingreason` varchar(60) NOT NULL COMMENT '離職原因',
`achievement` text NOT NULL COMMENT '主要業(yè)績(jī)',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -