qs_ad 广告表
qs_admin 管理员
qs_admin_log 管理员日志
qs_ad_category 广告分类
qs_article 文章表
qs_article_category 文章分类
qs_article_property 文章属性
qs_category其他分类管理属性(招聘信息属性分类属性)
qs_category_district 地区划分
qs_category_group 其他分类管理(招聘信息属性分类)
qs_category_jobs 职位职称划分
qs_company_down_resume
qs_company_favorites
qs_company_interview
qs_company_profile 企业会员公司信息
qs_config 网站配置表
qs_explain (footer部分)自定义栏目
qs_explain_category (footer部分)自定义栏目分类
qs_feedback反馈
qs_jobs
qs_jobs_contact
qs_link 友情链接
qs_link_category 友情分类
qs_locoyspider 火车收集器 表
qs_mailconfig 邮件配置表
qs_mail_templates 邮件模板表
qs_members 用户表
qs_members_info 用户信息表
qs_members_points 企业用户点数
qs_members_points_report 个人用户点数策略
qs_members_points_rule 企业用户点数策略
qs_members_setmeal
qs_members_type 用户类型记录表(企业和个人)
qs_navigation 菜单表
qs_navigation_category 菜单分类
qs_notice 公告
qs_notice_category 公告分类
qs_order(排序)
qs_page 静态化策略
qs_payment 支付银行
qs_personal_favorites
qs_personal_jobs_apply
qs_report
qs_resume
qs_resume_education
qs_resume_jobs
qs_resume_training
qs_resume_work
qs_setmeal 会员级别
qs_text 其他后台提示文本
表名 | 说明 |
广告 | |
后台用户 | |
后台用户登录日志 | |
广告位分类 | |
广告类型分类 | |
会员注册协议 | |
文章 | |
文章分类 | |
文章属性分类 | |
企业下载的简历 | |
企业发起的面试邀请 | |
企业简介 | |
企业职位库 | |
网站配置信息 | |
说明页 | |
说明页分类 | |
反馈信息 | |
职位 | |
地区分类 | |
职位分类 | |
职位点击次数 | |
职位联系方式 | |
企业性质 | |
学历分类 | |
工作经验分类 | |
职位性质分类 | |
企业规模 | |
查询有效天数 | |
行业划分 | |
工资划分 | |
友情链接 | |
友情链接分类 | |
邮件配置 | |
邮件发送模板 | |
网站会员 | |
会员积分 | |
积分消费报告 | |
积分消费规则 | |
会员类型 | |
导航栏 | |
导航栏分类 | |
页面 | |
在线支付插件 | |
订单 | |
个人会员职位申请 | |
个人会员职位库 | |
举报信息 | |
简历 | |
qs_resume_click | 简历点击次数 |
简历教育经历 | |
简历求职意向 | |
简历意向职位 | |
简历意向职位性质 | |
qs_resume_intention_trade | 简历意向从事行业 |
简历照片 | |
简历个人特长 | |
简历培训经历 | |
简历工作经历 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
alias | varchar(80) |
|
|
|
is_display | tinyint(4) |
| 1 |
|
category_id | smallint(6) |
|
|
|
type_id | smallint(6) |
|
|
|
title | varchar(100) |
|
|
|
show_order | int(10) | UNSIGNED | 50 |
|
addtime | int(10) | UNSIGNED |
|
|
starttime | int(10) | UNSIGNED |
|
|
deadline | int(11) |
| 0 |
|
text_content | varchar(250) |
|
|
|
text_url | varchar(250) |
|
|
|
text_color | varchar(60) |
|
|
|
img_path | varchar(250) |
|
|
|
img_url | varchar(250) |
|
|
|
img_explain | varchar(250) |
|
|
|
code_content | text |
|
|
|
flash_path | varchar(250) |
|
|
|
flash_width | int(10) | UNSIGNED |
|
|
flash_height | int(10) | UNSIGNED |
|
|
floating_type | tinyint(3) | UNSIGNED | 1 |
|
floating_width | int(10) | UNSIGNED |
|
|
floating_height | int(10) | UNSIGNED |
|
|
floating_url | varchar(250) |
|
|
|
floating_path | varchar(250) |
|
|
|
floating_left | int(11) |
|
|
|
floating_top | int(11) |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
admin_id | smallint(5) | UNSIGNED |
|
|
admin_name | varchar(40) |
|
|
|
| varchar(40) |
|
|
|
pwd | varchar(32) |
|
|
|
purview | varchar(255) |
|
|
|
add_time | int(10) |
|
|
|
last_login_time | int(10) |
|
|
|
last_login_ip | varchar(15) |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
log_id | int(10) | UNSIGNED |
|
|
admin_name | varchar(20) |
|
|
|
add_time | int(10) |
|
|
|
log_value | varchar(255) |
|
|
|
log_ip | varchar(20) |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
alias | varchar(100) |
|
|
|
type_id | int(10) | UNSIGNED |
|
|
categoryname | varchar(100) |
|
|
|
admin_set | tinyint(3) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
categoryname | varchar(30) |
|
|
|
category_order | smallint(5) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
content | text |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
type_id | tinyint(3) | UNSIGNED |
|
|
ParentID | smallint(5) | UNSIGNED |
|
|
title | varchar(100) |
|
|
|
content | mediumtext |
|
|
|
tit_color | varchar(10) |
| NULL |
|
tit_b | tinyint(3) | UNSIGNED | 0 |
|
Small_img | varchar(80) |
| NULL |
|
author | varchar(50) |
| NULL |
|
source | varchar(100) |
| NULL |
|
focos | tinyint(4) | UNSIGNED | 1 |
|
is_display | tinyint(3) | UNSIGNED | 1 |
|
is_url | varchar(200) |
| 0 |
|
seo_keywords | varchar(100) |
| NULL |
|
seo_description | varchar(200) |
| NULL |
|
click | int(10) | UNSIGNED | 1 |
|
addtime | int(10) | UNSIGNED |
|
|
article_order | smallint(6) | UNSIGNED | 0 |
|
robot | tinyint(3) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
ParentID | smallint(5) | UNSIGNED |
|
|
categoryname | varchar(80) |
|
|
|
category_order | smallint(5) | UNSIGNED | 0 |
|
title | varchar(255) |
| NULL |
|
description | varchar(255) |
| NULL |
|
keywords | varchar(255) |
| NULL |
|
admin_set | tinyint(3) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
categoryname | varchar(30) |
|
|
|
category_order | smallint(5) | UNSIGNED | 0 |
|
admin_set | tinyint(3) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
did | int(10) | UNSIGNED |
|
|
resume_id | int(10) | UNSIGNED |
|
|
resume_uid | int(10) | UNSIGNED |
|
|
company_uid | int(10) | UNSIGNED |
|
|
addtime | int(10) | UNSIGNED |
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
did | int(10) | UNSIGNED |
|
|
resume_id | int(10) | UNSIGNED |
|
|
resume_uid | int(10) | UNSIGNED |
|
|
company_id | int(10) | UNSIGNED |
|
|
company_uid | int(10) | UNSIGNED |
|
|
addtime | int(10) | UNSIGNED |
|
|
jobs_name | varchar(200) |
|
|
|
companyname | varchar(200) |
|
|
|
notes | varchar(255) |
|
|
|
personal_look | tinyint(3) | UNSIGNED | 1 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
uid | int(10) | UNSIGNED |
|
|
companyname | varchar(60) |
|
|
|
nature | smallint(5) | UNSIGNED |
|
|
trade | smallint(5) | UNSIGNED |
|
|
district | smallint(5) | UNSIGNED |
|
|
sdistrict | smallint(5) | UNSIGNED |
|
|
scale | smallint(5) | UNSIGNED |
|
|
registered | varchar(150) |
|
|
|
currency | varchar(10) |
|
|
|
address | varchar(250) |
|
|
|
contact | varchar(100) |
|
|
|
telephone | varchar(130) |
|
|
|
| varchar(100) |
|
|
|
website | varchar(100) |
|
|
|
license | varchar(120) |
|
|
|
certificate_img | varchar(80) |
|
|
|
contents | text |
|
|
|
audit | tinyint(4) | UNSIGNED | 0 |
|
map_open | tinyint(3) | UNSIGNED | 0 |
|
map_x | varchar(50) |
|
|
|
map_y | varchar(50) |
|
|
|
map_zoom | tinyint(3) | UNSIGNED |
|
|
awards_points | tinyint(3) | UNSIGNED | 1 |
|
recommend | tinyint(3) | UNSIGNED | 0 |
|
addtime | int(10) | UNSIGNED |
|
|
refreshtime | int(10) | UNSIGNED |
|
|
robot | tinyint(3) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
did | int(10) | UNSIGNED |
|
|
resume_id | int(10) | UNSIGNED |
|
|
company_uid | int(10) | UNSIGNED |
|
|
addtime | int(10) | UNSIGNED |
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
name | varchar(100) |
|
|
|
value | text |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
type_id | smallint(5) | UNSIGNED |
|
|
title | varchar(100) |
|
|
|
content | mediumtext |
|
|
|
tit_color | varchar(10) |
| NULL |
|
tit_b | tinyint(4) |
| 0 |
|
is_display | tinyint(3) | UNSIGNED | 1 |
|
is_url | varchar(200) |
| 0 |
|
seo_keywords | varchar(100) |
| NULL |
|
seo_description | varchar(200) |
| NULL |
|
click | int(11) |
| 1 |
|
addtime | int(10) |
|
|
|
show_order | smallint(6) |
| 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
categoryname | varchar(80) |
|
|
|
category_order | smallint(5) | UNSIGNED | 0 |
|
admin_set | tinyint(3) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
uid | int(10) | UNSIGNED |
|
|
replyinfo | tinyint(3) | UNSIGNED | 1 |
|
usertype | tinyint(3) | UNSIGNED |
|
|
username | varchar(80) |
|
|
|
infotype | tinyint(3) | UNSIGNED |
|
|
feedback | varchar(250) |
|
|
|
reply | varchar(250) |
|
|
|
addtime | int(10) |
|
|
|
feedbacktime | int(10) | UNSIGNED |
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| 职位id |
uid | int(10) | UNSIGNED |
| 所属会员uid |
jobs_name | varchar(30) |
|
| 职位名称 |
contents | text |
|
| 职位描述 |
emergency | tinyint(3) | UNSIGNED | 1 | 紧急招聘,默认1.普通招聘 |
nature | tinyint(3) | UNSIGNED |
| 职位性质 |
amount | smallint(5) | UNSIGNED |
| 招聘人数 |
days | smallint(5) | UNSIGNED |
| 有效天数 |
category | smallint(5) | UNSIGNED |
| 职位分类大类 |
subclass | smallint(5) | UNSIGNED |
| 职位分类小类 |
trade | smallint(5) | UNSIGNED |
| 所属行业 |
district | smallint(5) | UNSIGNED |
| 工作地区 |
sdistrict | smallint(5) | UNSIGNED |
| 工作地区二级分类 |
education | smallint(5) | UNSIGNED |
| 学历要求 |
experience | smallint(5) | UNSIGNED |
| 工作经验 |
wage | smallint(5) | UNSIGNED |
| 薪资待遇 |
addtime | int(10) | UNSIGNED |
| 添加时间 |
deadline | int(10) | UNSIGNED |
| 到期时间 |
refreshtime | int(10) | UNSIGNED |
| 刷新时间 |
audit | tinyint(3) | UNSIGNED | 1 | 审核状态 |
display | tinyint(3) | UNSIGNED | 1 | 招聘状态 |
robot | tinyint(3) | UNSIGNED | 0 | 添加类型,1为采集信息 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| 主键 |
parentid | int(10) | UNSIGNED | 0 | 父级id |
categoryname | varchar(30) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| 主键 |
ParentID | smallint(5) | UNSIGNED |
| 父级id |
categoryname | varchar(80) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| 主键 |
pid | int(10) | UNSIGNED |
| 职位id |
click | int(10) | UNSIGNED |
| 点击次数 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| 主键 |
pid | int(10) | UNSIGNED |
| 职位id |
contact | varchar(80) |
|
| 联系人 |
| varchar(20) |
| NULL | |
telephone | varchar(80) |
|
| 联系电话 |
address | varchar(80) |
|
| 联系地址 |
| varchar(80) |
|
| |
notify | tinyint(3) | UNSIGNED |
| 有人申请职位,是否邮件通知企业 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
| 主键 |
categoryname | varchar(30) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
| 主键 |
categoryname | varchar(30) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
| 主键 |
categoryname | varchar(30) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
| 主键 |
categoryname | varchar(30) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
| 主键 |
categoryname | varchar(30) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| 主键 |
days | smallint(5) | UNSIGNED |
| 天数 |
categoryname | varchar(30) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
| id |
categoryname | varchar(30) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
| id |
categoryname | varchar(30) |
|
| 分类名称 |
category_order | smallint(5) | UNSIGNED | 0 | 显示顺序 |
字段 | 类型 | 属性 | 默认 | 说明 |
link_id | int(10) | UNSIGNED |
|
|
category_id | smallint(5) | UNSIGNED |
|
|
link_name | varchar(255) |
|
|
|
link_url | varchar(255) |
|
|
|
link_logo | varchar(255) |
|
|
|
show_order | smallint(5) | UNSIGNED | 50 |
|
Notes | varchar(255) |
| NULL |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
categoryname | varchar(80) |
|
|
|
category_order | smallint(5) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
name | varchar(100) |
|
|
|
value | varchar(200) |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
name | varchar(100) |
|
|
|
value | text |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
uid | int(10) | UNSIGNED |
| 会员id |
username | varchar(100) |
|
| 用户名 |
| varchar(80) |
|
| |
password | varchar(100) |
|
| 密码 |
pwd_hash | varchar(30) |
|
| 随机字符串 |
reg_time | int(10) |
|
| 注册时间 |
reg_ip | varchar(15) |
|
| 注册ip |
last_login_time | int(10) |
|
| 最后登录时间 |
last_login_ip | varchar(15) |
|
| 最后登陆IP |
status | tinyint(3) | UNSIGNED | 1 | 帐号状态 |
robot | tinyint(3) | UNSIGNED | 0 | 添加方式,1为采集 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员UID |
points | int(10) | UNSIGNED | 0 | 会员积分 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
uid | int(10) | UNSIGNED |
|
|
i_type | tinyint(3) | UNSIGNED | 0 |
|
points | int(10) | UNSIGNED |
|
|
remain_points | int(10) | UNSIGNED |
|
|
addtime | int(10) | UNSIGNED |
|
|
notes | varchar(120) |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
title | varchar(100) |
|
|
|
name | varchar(100) |
|
|
|
operation | varchar(10) |
| - |
|
value | int(10) | UNSIGNED |
|
|
notes | varchar(150) |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
utype | tinyint(3) | UNSIGNED | 0 | 会员类型 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
alias | varchar(100) |
|
|
|
urltype | tinyint(3) | UNSIGNED | 0 |
|
display | tinyint(3) | UNSIGNED | 0 |
|
typeid | tinyint(3) | UNSIGNED |
|
|
title | varchar(100) |
|
|
|
color | varchar(30) |
|
|
|
pagealias | varchar(100) |
|
|
|
get | varchar(30) |
| 0 |
|
tag | varchar(100) |
|
|
|
url | varchar(200) |
|
|
|
target | varchar(100) |
|
|
|
navigationorder | int(10) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | smallint(5) | UNSIGNED |
|
|
alias | varchar(100) |
|
|
|
categoryname | varchar(30) |
|
|
|
admin_set | tinyint(3) | UNSIGNED | 0 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
systemclass | tinyint(3) | UNSIGNED | 0 |
|
pagetpye | tinyint(3) | UNSIGNED | 1 |
|
alias | varchar(60) |
|
|
|
pname | varchar(12) |
|
|
|
file | varchar(100) |
|
|
|
tpl | varchar(100) |
|
|
|
rewrite | varchar(100) |
|
|
|
html | varchar(100) |
|
|
|
url | tinyint(3) | UNSIGNED | 0 |
|
caching | int(10) | UNSIGNED | 0 |
|
tag | varchar(60) |
|
|
|
title | varchar(200) |
|
|
|
description | varchar(200) |
|
|
|
keywords | varchar(200) |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
listorder | int(10) | UNSIGNED | 50 |
|
typename | varchar(15) |
|
|
|
byname | varchar(50) |
|
|
|
p_introduction | varchar(100) |
|
|
|
notes | text |
| NULL |
|
partnerid | varchar(80) |
| NULL |
|
ytauthkey | varchar(100) |
| NULL |
|
fee | varchar(6) |
| 0 |
|
parameter1 | varchar(50) |
| NULL |
|
parameter2 | varchar(50) |
| NULL |
|
parameter3 | varchar(50) |
| NULL |
|
p_install | tinyint(3) | UNSIGNED | 1 |
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
uid | int(10) | UNSIGNED |
|
|
is_paid | tinyint(3) | UNSIGNED | 1 |
|
oid | varchar(80) |
|
|
|
amount | decimal(10,2) |
|
|
|
payment_name | varchar(20) |
|
|
|
points | int(10) | UNSIGNED |
|
|
addtime | int(11) | UNSIGNED |
|
|
payment_time | int(10) | UNSIGNED |
|
|
notes | varchar(150) |
| NULL |
|
字段 | 类型 | 属性 | 默认 | 说明 |
did | int(10) | UNSIGNED |
|
|
personal_uid | int(10) | UNSIGNED |
|
|
personal_fullname | varchar(30) |
|
|
|
personal_sex | tinyint(3) | UNSIGNED |
|
|
personal_age | int(10) | UNSIGNED |
|
|
jobs_id | int(10) | UNSIGNED |
|
|
jobs_name | varchar(100) |
|
|
|
company_id | int(10) | UNSIGNED |
|
|
company_uid | int(10) | UNSIGNED |
|
|
company_name | varchar(100) |
|
|
|
addtime | int(10) | UNSIGNED |
|
|
personal_look | tinyint(3) | UNSIGNED | 1 |
|
notes | varchar(200) |
|
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
did | int(10) | UNSIGNED |
|
|
personal_uid | int(10) | UNSIGNED |
|
|
jobs_id | int(10) | UNSIGNED |
|
|
jobs_name | varchar(100) |
|
|
|
company_id | int(30) | UNSIGNED |
|
|
company_name | varchar(100) |
|
|
|
addtime | int(10) | UNSIGNED |
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
|
|
uid | int(10) | UNSIGNED |
|
|
jobs_id | int(10) | UNSIGNED |
|
|
jobs_name | varchar(150) |
|
|
|
content | varchar(250) |
|
|
|
addtime | int(10) | UNSIGNED |
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
display | tinyint(3) | UNSIGNED | 1 | 显示状态 |
audit | tinyint(3) | UNSIGNED | 1 | 审核状态 |
fullname | varchar(15) |
|
| 全名 |
sex | tinyint(3) | UNSIGNED |
| 性别 |
age | tinyint(3) | UNSIGNED |
| 年龄 |
height | tinyint(3) | UNSIGNED |
| 身高 |
marriage | tinyint(3) | UNSIGNED |
| 婚姻状况 |
experience | smallint(5) | UNSIGNED |
| 工作经验 |
district | smallint(5) | UNSIGNED |
| 所在地区大类 |
sdistrict | smallint(5) | UNSIGNED |
| 所在地区 小类 |
wage | tinyint(3) | UNSIGNED |
| 期望 工资 |
householdaddress | varchar(80) |
|
| 户口所在地 |
education | smallint(5) | UNSIGNED |
| 学历 |
telephone | varchar(50) |
|
| 联系电话 |
| varchar(60) |
|
| |
email_notify | tinyint(3) | UNSIGNED | 1 | 企业邀请面试,是否邮件通知个人 |
| varchar(25) |
|
| |
address | varchar(100) |
|
| 联系地址 |
website | varchar(100) |
|
| 网址 |
recentjobs | varchar(200) |
|
| 最近工作职位 |
specialty | varchar(200) |
|
| 个人 特长 |
photoresume | tinyint(3) | UNSIGNED | 1 | 是否是照片简历 |
photo | varchar(50) |
|
| 照片 |
photo_audit | tinyint(3) | UNSIGNED |
| 照片审核状态 |
photo_display | tinyint(3) | UNSIGNED |
| 照片是否显示在简历中 |
addtime | int(10) | UNSIGNED |
| 添加 时间 |
refreshtime | int(10) | UNSIGNED |
| 刷新时间 |
deadline | int(10) | UNSIGNED |
| 到期时间 |
talent | tinyint(1) | UNSIGNED | 1 | 高级人才 |
complete | tinyint(3) | UNSIGNED | 2 | 是否完整 |
key | varchar(250) |
|
| 搜索关键字 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
click | int(10) | UNSIGNED |
| 点击次数 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
start | varchar(20) |
|
| 开始时间 |
endtime | varchar(20) |
|
| 结束时间 |
school | varchar(50) |
|
| 学校名称 |
speciality | varchar(50) |
|
| 专业 |
education | smallint(5) | UNSIGNED |
| 获得 学历 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
recentjobs | varchar(60) |
|
| 意向职位 |
wage | smallint(5) | UNSIGNED |
| 期望待遇 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
category | int(10) | UNSIGNED |
| 职位大类 |
subclass | int(10) | UNSIGNED |
| 职位小类 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
jid | int(10) | UNSIGNED |
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
jid | int(10) | UNSIGNED |
|
|
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
photo | varchar(100) |
|
| 照片 |
audit | tinyint(3) | UNSIGNED | 1 | 审核状态 |
display | tinyint(3) | UNSIGNED | 1 | 是否显示 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
specialty | varchar(255) |
|
| 特长 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
start | varchar(20) |
|
| 培训开始时间 |
endtime | varchar(20) |
|
| 结束时间 |
agency | varchar(50) |
|
| 培训结构名称 |
course | varchar(50) |
|
| 培训课程 |
description | varchar(255) |
|
| 描述 |
字段 | 类型 | 属性 | 默认 | 说明 |
id | int(10) | UNSIGNED |
| id |
uid | int(10) | UNSIGNED |
| 会员uid |
start | varchar(20) |
|
| 开始时间 |
endtime | varchar(20) |
|
| 结束时间 |
companyname | varchar(50) |
|
| 公司名称 |
companyprofile | varchar(255) |
|
| 公司简介 |
jobs | varchar(30) |
|
| 职位名称 |
achievements | varchar(255) |
|
| 个人业绩 |