该招聘数据库共有11个表和61条招聘信息，所有的招聘信息是由中国18个地区17家酒店餐饮行业的企业提供的。每个招聘岗位中包含有职位，文化程度，招聘数量，岗位描述，薪资待遇，工作经验，岗位类型， 专业，外语，名称，工作时间等信息。在企业表中，每个企业都有提供企业名称，规模，企业类型和企业简介。该酒店餐饮行业招聘数据库中的所有岗位共有12个主分类，如前厅，房务，餐饮，销售，工程，采购等。
请注意：该数据库动态性较强，所以可以根据用户需求提供更新。
This is a jobs database with 61 records from 17 companies in hotel and catering industry. Each job is comprised of position, education, quantity, description, salary, experience, type, major, foreign language, title, time, etc. In table company, there are company, size, type & description. All these jobs have 12 primary categories.
The whole hotel & catering jobs data set has 11 tables.
Please NOTE: These data are more dynamic so it can be updated as your needs.
| Name | n3_lyz_hotel.800hr.com |
|---|---|
| Data | 768K (+ 0B) |
| Tables | 11 (+ 0) |
| Columns | 70 (+ 0) |
| Table Rows | 627 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_position_1 | 12 | position |
100%
|
| category_position_2 | 98 | position |
100%
|
| category_position_1_id |
100%
|
||
| category_position_2_x_job | 234 | category_position_2_id |
100%
|
| job_id |
100%
|
||
| company | 17 | company |
100%
|
| size |
100%
|
||
| type |
100%
|
||
| description |
100%
|
||
| company_connection | 15 | contacter |
86.67%
|
| address |
100%
|
||
| zip_code |
100%
|
||
| company_id |
100%
|
||
| website |
13.33%
|
||
| company_register | 5 | code |
100%
|
| status |
100%
|
||
| registre_property |
100%
|
||
| term |
100%
|
||
| company_id |
100%
|
||
| job | 61 | position |
100%
|
| education |
100%
|
||
| quantity |
100%
|
||
| description |
100%
|
||
| salary_from |
96.72%
|
||
| salary_to |
96.72%
|
||
| salary_unit |
96.72%
|
||
| salary_other |
3.28%
|
||
| type |
100%
|
||
| experience |
100%
|
||
| major |
100%
|
||
| foreign_language |
100%
|
||
| title |
100%
|
||
| time |
100%
|
||
| job_connection | 45 | contacter |
91.11%
|
| address |
80%
|
||
| zip_code |
80%
|
||
| job_id |
100%
|
||
| job_x_company | 61 | job_id |
100%
|
| company_id |
100%
|
||
| job_x_region | 61 | job_id |
100%
|
| region_id |
100%
|
||
| region | 18 | region |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
No media sets.
