Database Description
The following is an outline and description of the database tables created during the standard installation of SocialNetworkSoftware. Currently, the only database supported by SocialNetworkSoftware is MySQL version 4.1.2 or greater.
Table Organisation
| category1 |
|---|
| table1 |
| table2 |
| table3 |
| category2 |
|---|
| table1 |
| table2 |
| table3 |
| category3 |
|---|
| table1 |
| table2 |
| table3 |
Database Diagram
Database diagram below provides a visual overview of the SocialNetworkSoftware database and the relations between the tables created during its standard installation.
Tables Description
The following are the specific fields in each of the tables created during the standard SocialNetworkSoftware installation.
Table: admin_employer_mails
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(15) | NO | PRI | auto_increment | |
| sender_id | int(15) | NO | MUL | 0 | |
| receiver_id | int(11) | NO | MUL | 0 | |
| subject | varchar(255) | NO | |||
| message | blob | NO | |||
| attachment_file | varchar(255) | NO | |||
| sender_mark | enum(‘No’,’Yes’) | NO | No | ||
| receiver_mark | enum(‘No’,’Yes’) | NO | No | ||
| receiver_see | enum(‘No’,’Yes’) | NO | MUL | No | |
| sender_see | enum(‘Yes’,’No’) | NO | MUL | No | |
| receiver_mail_status | enum(‘active’,’inactive’,’deleted’) | NO | active | ||
| sender_mail_status | enum(‘active’,’inactive’,’deleted’) | NO | active | ||
| receiver_deleted | date | YES | |||
| sender_deleted | date | YES | |||
| inserted | datetime | NO | 0000-00-00 00:00:00 |
Table: admin_files
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| admin_files_id | int(11) | NO | PRI | auto_increment | |
| admin_files_name | varchar(64) | NO | |||
| admin_files_is_boxes | tinyint(5) | NO | 0 | ||
| admin_files_to_boxes | int(11) | NO | 0 | ||
| admin_groups_id | set(‘1′,’2’) | NO | 1 |
Table: admin_groups
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| admin_groups_id | int(11) | NO | PRI | auto_increment | |
| admin_groups_name | varchar(64) | NO |
Table: administrator
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| admin_id | int(11) | NO | PRI | auto_increment | |
| admin_groups_id | int(11) | NO | 0 | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES | |||
| admin_firstname | varchar(32) | NO | |||
| admin_lastname | varchar(32) | NO | |||
| admin_name | varchar(32) | NO | UNI | ||
| admin_password | varchar(50) | NO | |||
| admin_email_address | varchar(128) | NO | UNI | ||
| last_ip_address | varchar(255) | YES | |||
| ip_address | varchar(255) | YES | |||
| last_login_time | datetime | YES | |||
| is_admin | enum(‘No’,’Yes’) | NO | No | ||
| number_of_logon | int(11) | NO | 0 |
Table: applicant_interaction
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(15) | NO | PRI | auto_increment | |
| application_id | int(15) | NO | 0 | ||
| sender_id | int(11) | NO | 0 | ||
| email_address | varchar(128) | NO | |||
| subject | varchar(255) | NO | |||
| message | blob | NO | |||
| attachment_file | varchar(255) | NO | |||
| remark_title | varchar(255) | NO | |||
| remark_description | blob | NO | |||
| jobseeker_see | enum(‘No’,’Yes’) | NO | No | ||
| jobseeker_mark | enum(‘No’,’Yes’) | NO | No | ||
| jobseeker_mail_status | enum(‘active’,’inactive’,’deleted’) | NO | active | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 |
Table: applicant_status
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(15) | NO | PRI | auto_increment | |
| application_id | int(15) | NO | MUL | 0 | |
| process_round | int(11) | NO | MUL | 0 | |
| pre_status | smallint(3) | NO | 0 | ||
| cur_status | smallint(3) | NO | 0 | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 |
Table: application
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| application_id | varchar(32) | NO | MUL | ||
| jobseeker_apply_id | int(11) | NO | MUL | 0 | |
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| job_id | int(11) | NO | MUL | 0 | |
| jobseeker_id | int(11) | NO | MUL | 0 | |
| cover_letter | text | NO | |||
| resume_id | int(11) | NO | MUL | 0 | |
| resume_name | varchar(255) | NO | |||
| applicant_select | enum(‘No’,’Yes’) | NO | No | ||
| applicant_join_status | enum(,’joined’,’declined’) | NO | MUL | ||
| selected_date | datetime | NO | 0000-00-00 00:00:00 | ||
| source | enum(‘job_apply’,’search_resume’) | NO | job_apply |
Table: application_rating
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| rate_id | int(15) | NO | PRI | auto_increment | |
| application_id | int(15) | NO | 0 | ||
| point | smallint(3) | NO | 0 | ||
| round_id | smallint(3) | NO | 0 | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | NO | 0000-00-00 00:00:00 |
Table: application_send_template
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| application_send_template_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: application_status
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | smallint(3) | NO | PRI | auto_increment | |
| application_status | varchar(32) | NO | |||
| fr_application_status | varchar(32) | NO | |||
| priority | smallint(3) | NO | 0 |
Table: apply
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| job_id | int(11) | NO | MUL | 0 | |
| jobseeker_id | int(11) | NO | MUL | 0 | |
| cover_letter | text | NO | |||
| resume_id | int(11) | NO | 0 | ||
| resume_name | varchar(255) | NO | |||
| jobseeker_apply_status | enum(‘active’,’inactive’) | NO | active |
Table: article
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| category_id | int(11) | NO | 0 | ||
| title | varchar(255) | NO | |||
| author | varchar(255) | NO | |||
| show_date | date | NO | 0000-00-00 | ||
| description | blob | NO | |||
| short_description | text | NO | |||
| article_photo | varchar(255) | NO | |||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | NO | 0000-00-00 00:00:00 | ||
| is_show | enum(‘Yes’,’No’) | NO | Yes |
Table: article_categories
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(5) unsigned | NO | PRI | auto_increment | |
| sub_cat_id | varchar(32) | NO | |||
| category_name | varchar(255) | YES | MUL | ||
| fr_category_name | varchar(255) | NO |
Table: availability
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(5) | NO | PRI | auto_increment | |
| availability_name | varchar(255) | NO | MUL | ||
| priority | smallint(5) | NO | 0 |
Table: banner
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(5) | NO | PRI | auto_increment | |
| banner_type | enum(‘image’,’script’) | NO | image | ||
| title | varchar(150) | NO | |||
| href | varchar(255) | NO | |||
| src | varchar(255) | NO | |||
| alt | varchar(255) | YES | |||
| script | text | NO | |||
| adviews | int(10) | YES | 0 | ||
| adclicks | int(10) | YES | 0 | ||
| active | enum(‘T’,’F’) | NO | T | ||
| location | int(5) | NO | 1 | ||
| banner_date | date | NO | 0000-00-00 | ||
| b_order | int(10) | NO | 1 | ||
| company_name | varchar(50) | YES | |||
| company_contact | varchar(50) | YES | |||
| company_email | varchar(50) | YES | |||
| company_comments | varchar(100) | YES | |||
| banner_duration_from | date | YES | |||
| banner_duration_to | date | YES | |||
| banner_costing | varchar(40) | YES | |||
| duration_unlimited | enum(‘T’,’F’) | NO | T | ||
| deleted | enum(‘T’,’F’) | NO | F |
Table: banner_location
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| banner_location_id | int(5) | NO | PRI | auto_increment | |
| banner_location_name | varchar(100) | NO |
Table: career_level
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| career_level_name | varchar(64) | NO | MUL | ||
| fr_career_level_name | varchar(64) | NO | |||
| priority | int(5) | NO | 0 |
Table: company_description
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| recruiter_id | int(11) | NO | UNI | 0 | |
| description | blob | NO |
Table: configuration
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| configuration_group_id | int(11) | NO | 0 | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES | |||
| configuration_title | varchar(64) | NO | |||
| configuration_name | varchar(64) | NO | |||
| configuration_value | varchar(255) | NO | |||
| configuration_description | varchar(255) | YES | |||
| priority | int(5) | NO | 0 | ||
| use_function | varchar(255) | YES | |||
| set_function | varchar(255) | YES |
Table: configuration_group
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| configuration_group_title | varchar(64) | NO | |||
| configuration_group_description | varchar(255) | NO | |||
| priority | int(5) | NO | 0 | ||
| visible | enum(‘Yes’,’No’) | NO | Yes |
Table: continent
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | smallint(5) unsigned | NO | PRI | auto_increment | |
| continent_name | varchar(64) | NO | |||
| fr_continent_name | varchar(64) | NO | |||
| priority | smallint(5) | NO | 0 |
Table: countries
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| continent_id | int(11) | NO | 0 | ||
| country_name | varchar(64) | NO | MUL | ||
| fr_country_name | varchar(64) | NO | |||
| country_code | int(10) | NO | 0 | ||
| priority | int(5) | NO | 0 |
Table: cover_letters
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| cover_letter_id | int(11) | NO | PRI | auto_increment | |
| jobseeker_id | int(11) | NO | MUL | 0 | |
| cover_letter_name | varchar(32) | NO | |||
| cover_letter | text | NO | |||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES |
Table: currencies
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| currencies_id | int(11) | NO | PRI | auto_increment | |
| title | varchar(32) | NO | |||
| code | char(3) | NO | |||
| symbol_left | varchar(12) | YES | |||
| symbol_right | varchar(12) | YES | |||
| decimal_point | char(1) | YES | |||
| thousands_point | char(1) | YES | |||
| decimal_places | char(1) | YES | |||
| value | float(13,8) | YES | |||
| last_updated | datetime | YES |
Table: education_level
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| education_level_name | varchar(64) | NO | MUL | ||
| fr_education_level_name | varchar(64) | NO | |||
| priority | int(5) | NO | 0 |
Table: experience
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| max_experience | varchar(5) | NO | MUL | ||
| min_experience | smallint(5) | NO | 0 | ||
| experience_weight | smallint(3) | NO | 0 | ||
| priority | int(5) | NO | 0 |
Table: expired_job_alert
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| expired_job_alert_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: forum
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| category_id | int(11) | NO | MUL | 0 | |
| title | varchar(255) | NO | |||
| author | varchar(255) | NO | |||
| show_date | date | NO | 0000-00-00 | ||
| description | text | NO | |||
| forum_photo | varchar(255) | NO | |||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | NO | 0000-00-00 00:00:00 | ||
| is_show | enum(‘Yes’,’No’) | NO | Yes |
Table: forum_categories
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(5) unsigned | NO | PRI | auto_increment | |
| category_name | varchar(255) | YES | MUL | ||
| fr_category_name | varchar(255) | NO |
Table: forum_topics
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| forum_id | int(11) | NO | MUL | 0 | |
| user_id | int(9) | NO | MUL | ||
| user_type | enum(‘jobseeker’,’recruiter’) | NO | |||
| title | varchar(255) | NO | |||
| description | text | NO | |||
| hits | int(9) | NO | |||
| featured | enum(‘no’,’yes’) | NO | |||
| inserted | datetime | NO | 0000-00-00 00:00:00 |
Table: geo_zones
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| geo_zone_id | int(11) | NO | PRI | auto_increment | |
| geo_zone_name | varchar(32) | NO | |||
| geo_zone_description | varchar(255) | NO | |||
| last_modified | datetime | YES | |||
| date_added | datetime | NO | 0000-00-00 00:00:00 |
Table: gift
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| gift_id | int(10) unsigned | NO | PRI | auto_increment | |
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES | |||
| certificate_number | varchar(32) | NO | |||
| discount_type_id | tinyint(3) unsigned | NO | 0 | ||
| amount | decimal(10,2) unsigned | NO | 0.00 | ||
| expired | date | NO | 0000-00-00 |
Table: gift_used
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| recruiter_id | int(10) unsigned | NO | PRI | 0 | |
| gift_id | int(10) unsigned | NO | PRI | 0 | |
| gift_amount | decimal(10,2) | NO | 0.00 | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES |
Table: indeed_feed
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| feed_id | smallint(5) | NO | PRI | auto_increment | |
| feed_title | varchar(64) | NO | |||
| publisher_id | varchar(25) | NO | |||
| recruiter_id | int(10) | NO | |||
| feed_keyword | varchar(255) | NO | |||
| location | varchar(64) | NO | |||
| country_code | varchar(2) | NO | |||
| job_type | varchar(10) | NO | |||
| sort_by | enum(‘relevance’,’date’) | NO | |||
| channel | varchar(64) | NO | |||
| job_duration | smallint(3) | NO | |||
| max_feed | smallint(6) | NO | |||
| status | enum(‘active’,’inactive’) | NO | |||
| last_active | datetime | NO | |||
| import_jobs | int(9) | NO | |||
| updated | datetime | NO | |||
| inserted | datetime | NO |
Table: indeed_job
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| indeed_id | varchar(20) | NO | PRI | ||
| job_id | int(9) | NO | MUL | ||
| indeed_url | varchar(255) | NO |
Table: invite_friend_tmpl
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| template_name | varchar(64) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: ipaddress_block
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| ip_address1 | varchar(15) | NO | |||
| ip_address2 | varchar(15) | YES | |||
| priority | int(11) | NO | 0 |
Table: job_alert
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| job_alert_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: job_category
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(5) | NO | PRI | auto_increment | |
| sub_cat_id | int(11) | YES | |||
| category_name | varchar(255) | NO | MUL | ||
| fr_category_name | varchar(255) | NO | |||
| priority | smallint(5) | NO | 0 |
Table: job_point_history
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| job_id | int(11) | NO | 0 | ||
| re_advertised_from | datetime | NO | 0000-00-00 00:00:00 | ||
| re_advertised_to | datetime | NO | 0000-00-00 00:00:00 |
Table: job_post_invoice_tmpl
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| template_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: job_posted
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(5) | NO | PRI | auto_increment | |
| type_name | varchar(255) | NO | MUL | ||
| fr_type_name | varchar(255) | NO | |||
| value | smallint(3) | NO | 0 | ||
| priority | smallint(5) | NO | 0 |
Table: job_screener
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| job_id | int(11) | NO | 0 | ||
| recruiter_id | int(11) | NO | 0 | ||
| q1 | varchar(255) | YES | |||
| q2 | varchar(255) | YES |
Table: job_statistics
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| job_id | int(11) | NO | PRI | 0 | |
| applications | int(11) | NO | 0 | ||
| viewed | int(11) | NO | 0 | ||
| clicked | int(11) | NO | 0 |
Table: job_title
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| job_title_name | varchar(64) | NO | |||
| priority | int(11) | NO | 0 |
Table: job_type
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(5) | NO | PRI | auto_increment | |
| type_name | varchar(255) | NO | MUL | ||
| fr_type_name | varchar(255) | NO | |||
| priority | smallint(5) | NO | 0 |
Table: jobs
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| job_id | int(11) | NO | PRI | auto_increment | |
| display_id | varchar(32) | NO | |||
| recruiter_id | int(11) | NO | MUL | 0 | |
| recruiter_user_id | int(11) | YES | |||
| job_source | enum(‘jobsite’,’indeed’) | NO | MUL | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES | |||
| deleted | datetime | YES | |||
| re_adv | datetime | YES | MUL | ||
| expired | datetime | YES | |||
| job_title | varchar(255) | NO | |||
| job_reference | varchar(64) | NO | MUL | ||
| job_country_id | varchar(5) | NO | |||
| job_state_id | varchar(5) | YES | |||
| job_state | varchar(64) | YES | |||
| job_location | varchar(64) | NO | |||
| currency | smallint(5) | NO | 0 | ||
| job_salary | varchar(64) | YES | |||
| job_allowance | varchar(64) | YES | |||
| job_industry_sector | text | NO | |||
| job_short_description | text | NO | |||
| job_description | blob | NO | |||
| job_type | varchar(5) | NO | |||
| job_relocate | enum(‘Yes’,’No’) | NO | Yes | ||
| min_experience | varchar(5) | NO | |||
| max_experience | varchar(5) | NO | |||
| job_vacancy_period | varchar(15) | NO | |||
| job_status | enum(‘Yes’,’No’) | NO | Yes | ||
| job_featured | enum(‘Yes’,’No’) | NO | No | ||
| post_url | enum(‘Yes’,’No’) | NO | No | ||
| url | varchar(255) | NO |
Table: jobs_job_category
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| job_id | int(11) | NO | PRI | 0 | |
| job_category_id | int(11) | NO | PRI | 0 |
Table: jobseeker
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| jobseeker_id | int(11) | NO | PRI | 0 | |
| jobseeker_privacy | enum(‘1′,’2′,’3’) | NO | 3 | ||
| jobseeker_cv_searchable | enum(‘Yes’,’No’) | NO | Yes | ||
| jobseeker_url | varchar(64) | NO | |||
| jobseeker_first_name | varchar(32) | NO | |||
| jobseeker_middle_name | varchar(32) | NO | |||
| jobseeker_last_name | varchar(32) | NO | |||
| jobseeker_salutation | smallint(5) | NO | 0 | ||
| jobseeker_address1 | varchar(128) | NO | |||
| jobseeker_address2 | varchar(128) | NO | |||
| jobseeker_country_id | int(3) | NO | 0 | ||
| jobseeker_state | varchar(32) | NO | |||
| jobseeker_state_id | int(11) | NO | 0 | ||
| jobseeker_city | varchar(64) | NO | |||
| jobseeker_zip | varchar(10) | NO | |||
| jobseeker_phone | varchar(24) | NO | |||
| jobseeker_mobile | varchar(24) | NO | |||
| jobseeker_work_phone | varchar(24) | NO | |||
| jobseeker_featured | enum(‘Yes’,’No’) | NO | No | ||
| jobseeker_newsletter | enum(‘Yes’,’No’) | NO | Yes |
Table: jobseeker_account_alert
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| jobseeker_account_alert_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: jobseeker_account_history
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| jobseeker_id | int(11) | NO | MUL | 0 | |
| order_id | int(11) | NO | 0 | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES | |||
| plan_type_name | varchar(32) | NO | |||
| start_date | date | NO | MUL | 0000-00-00 | |
| end_date | date | NO | 0000-00-00 |
Table: jobseeker_language
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| languages_id | int(11) | NO | PRI | auto_increment | |
| name | varchar(32) | NO | MUL | ||
| fr_name | varchar(32) | NO | |||
| priority | int(3) | YES |
Table: jobseeker_login
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| jobseeker_id | int(11) | NO | PRI | auto_increment | |
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | NO | 0000-00-00 00:00:00 | ||
| jobseeker_email_address | varchar(128) | NO | UNI | ||
| jobseeker_password | varchar(50) | NO | |||
| jobseeker_status | enum(‘No’,’Yes’) | NO | Yes | ||
| last_ip_address | varchar(15) | NO | |||
| ip_address | varchar(15) | NO | |||
| last_login_time | datetime | NO | 0000-00-00 00:00:00 | ||
| number_of_logon | int(11) | NO | 0 |
Table: jobseeker_order_status_update_tmpl
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| order_template_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: jobseeker_order_template
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| order_template_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: jobseeker_orders
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| orders_id | int(11) | NO | PRI | auto_increment | |
| jobseeker_id | int(11) | NO | 0 | ||
| product_id | int(5) | NO | 0 | ||
| jobseeker_name | varchar(128) | NO | |||
| jobseeker_email_address | varchar(128) | NO | 0 | ||
| jobseeker_street_address | varchar(255) | NO | |||
| jobseeker_zip | varchar(10) | NO | |||
| jobseeker_city | varchar(64) | NO | |||
| jobseeker_state | varchar(32) | YES | |||
| jobseeker_country | varchar(64) | NO | |||
| jobseeker_telephone | varchar(20) | NO | |||
| billing_name | varchar(64) | NO | |||
| billing_company | tinyint(32) unsigned | YES | |||
| billing_street_address | varchar(255) | NO | |||
| billing_city | varchar(64) | NO | |||
| billing_state | varchar(32) | YES | |||
| billing_country | varchar(64) | NO | |||
| billing_zip | varchar(20) | NO | |||
| billing_telephone | varchar(20) | NO | |||
| payment_method | varchar(32) | NO | |||
| cc_type | varchar(20) | YES | |||
| cc_owner | varchar(64) | YES | |||
| cc_number | varchar(32) | YES | |||
| cc_expires | varchar(4) | YES | |||
| last_modified | datetime | YES | |||
| date_purchased | datetime | YES | |||
| orders_status | int(5) | NO | 0 | ||
| orders_date_finished | datetime | YES | |||
| currency | char(3) | YES | |||
| currency_value | decimal(14,6) | YES | |||
| comments | text | NO | |||
| admin_comment | text | NO |
Table: jobseeker_orders_history
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| order_id | int(11) | NO | PRI | 0 | |
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| plan_type_name | varchar(64) | NO | |||
| time_period | int(3) | NO | 0 | ||
| time_period1 | varchar(5) | NO | |||
| fee | float(10,2) | NO | 0.00 | ||
| currency | varchar(4) | NO | GBP | ||
| total_price | float(12,2) | NO | 0.00 |
Table: jobseeker_orders_total
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| orders_total_id | int(10) unsigned | NO | PRI | auto_increment | |
| orders_id | int(11) | NO | MUL | 0 | |
| title | varchar(255) | NO | |||
| text | varchar(255) | NO | |||
| value | decimal(15,4) | NO | 0.0000 | ||
| class | varchar(32) | NO | |||
| sort_order | int(11) | NO | 0 |
Table: jobseeker_plan_type
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| plan_type_name | varchar(64) | NO | MUL | ||
| fr_plan_type_name | varchar(64) | NO | |||
| priority | int(5) | NO | 0 | ||
| time_period | smallint(3) | NO | 0 | ||
| time_period1 | varchar(5) | NO | |||
| fee | float(10,2) | NO | 0.00 | ||
| currency | varchar(4) | NO | GBP | ||
| cv | int(5) | NO | 0 |
Table: jobseeker_rating
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| rating_id | int(11) | NO | PRI | auto_increment | |
| resume_id | int(11) | NO | MUL | 0 | |
| recruiter_id | int(11) | NO | MUL | 0 | |
| point | tinyint(1) | NO | 0 | ||
| admin_rating | smallint(5) | NO | 0 | ||
| admin_rate | enum(‘N’,’Y’) | NO | MUL | N | |
| private_notes | varchar(255) | YES |
Table: jobseeker_registration
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| jobseeker_registration_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: jobseeker_resume1
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| resume_id | int(11) | NO | PRI | auto_increment | |
| jobseeker_id | int(11) | NO | MUL | 0 | |
| resume_title | varchar(64) | NO | |||
| objective | text | NO | |||
| job_type_id | text | NO | |||
| currency | smallint(5) | NO | 0 | ||
| expected_salary | varchar(96) | NO | |||
| expected_salary_per | varchar(96) | NO | |||
| target_job_titles | varchar(96) | NO | |||
| job_category | text | NO | |||
| relocate | enum(‘Yes’,’No’) | NO | Yes | ||
| work_experince | smallint(4) | NO | 0 | ||
| experience_year | smallint(2) | NO | 0 | ||
| experience_month | smallint(2) | NO | 0 | ||
| availability_date | date | YES | |||
| jobseeker_resume | varchar(128) | NO | |||
| jobseeker_photo | varchar(128) | NO | |||
| jobseeker_video | varchar(255) | NO | |||
| jobseeker_resume_text | text | NO | |||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES | 0000-00-00 00:00:00 | ||
| search_status | enum(‘Yes’,’No’) | NO | Yes |
Table: jobseeker_resume2
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| r2_id | int(11) | NO | PRI | auto_increment | |
| resume_id | int(11) | NO | MUL | 0 | |
| company | varchar(96) | NO | |||
| city | varchar(96) | NO | |||
| state | varchar(96) | NO | |||
| state_id | smallint(5) | NO | 0 | ||
| country | smallint(5) | NO | 0 | ||
| job_title | varchar(96) | NO | |||
| currency | smallint(5) | NO | 0 | ||
| salary | varchar(64) | NO | |||
| salary_per | varchar(5) | NO | |||
| company_industry | smallint(5) | NO | 0 | ||
| start_month | int(2) | NO | 0 | ||
| start_year | int(4) | NO | 0 | ||
| end_month | int(2) | NO | 0 | ||
| end_year | int(4) | NO | 0 | ||
| still_work | enum(‘Yes’,’No’) | NO | No | ||
| description | text | NO | MUL |
Table: jobseeker_resume3
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| r3_id | int(11) | NO | PRI | auto_increment | |
| resume_id | int(11) | NO | MUL | 0 | |
| degree | varchar(96) | NO | |||
| specialization | varchar(128) | NO | |||
| school | varchar(96) | NO | |||
| city | varchar(96) | NO | |||
| state | varchar(96) | NO | |||
| state_id | smallint(5) | NO | 0 | ||
| country | smallint(5) | NO | 0 | ||
| start_month | smallint(2) | NO | 0 | ||
| start_year | smallint(4) | NO | 0 | ||
| end_month | smallint(2) | NO | 0 | ||
| end_year | smallint(4) | NO | 0 | ||
| related_info | text | NO | MUL |
Table: jobseeker_resume4
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| r4_id | int(11) | NO | PRI | auto_increment | |
| resume_id | int(11) | NO | MUL | 0 | |
| skill | varchar(96) | NO | |||
| skill_level | varchar(128) | NO | |||
| last_used | smallint(5) | NO | 0 | ||
| years_of_exp | varchar(96) | YES |
Table: jobseeker_resume5
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| r5_id | int(11) | NO | PRI | auto_increment | |
| resume_id | int(11) | NO | MUL | 0 | |
| language | smallint(5) | NO | 0 | ||
| proficiency | smallint(5) | NO | 0 |
Table: jobseeker_resume6
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| r6_id | int(11) | NO | PRI | auto_increment | |
| resume_id | int(11) | NO | MUL | 0 | |
| name | varchar(128) | NO | |||
| company_name | varchar(128) | NO | |||
| country | int(10) | NO | 0 | ||
| position_title | varchar(128) | NO | |||
| contact_no | varchar(20) | NO | |||
| email_address | varchar(50) | NO | |||
| relationship | varchar(50) | NO | |||
| inserted | date | NO | 0000-00-00 | ||
| updated | date | NO | 0000-00-00 |
Table: language_proficiency
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | smallint(5) | NO | PRI | auto_increment | |
| language_proficiency | varchar(64) | NO | |||
| fr_language_proficiency | varchar(64) | NO | |||
| priority | smallint(5) | NO | 0 |
Table: languages
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| languages_id | int(11) | NO | PRI | auto_increment | |
| name | varchar(32) | NO | MUL | ||
| code | char(2) | NO | |||
| image | varchar(64) | YES | |||
| directory | varchar(32) | YES | |||
| sort_order | int(3) | YES |
Table: newsletters
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| title | varchar(255) | NO | |||
| content | text | NO | |||
| attachment_file | varchar(255) | YES | |||
| module | varchar(255) | NO | |||
| date_added | datetime | NO | 0000-00-00 00:00:00 | ||
| date_sent | datetime | YES | |||
| status | int(1) | YES | |||
| locked | int(1) | YES | 0 |
Table: newsletters_history
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| title | varchar(255) | NO | |||
| content | text | NO | |||
| attachment_file | varchar(255) | YES | |||
| send_to | enum(‘jobseeker’,’recruiter’) | NO | jobseeker | ||
| date_send | datetime | YES |
Table: order_status_update_tmpl
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| order_template_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: orders
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| orders_id | int(11) | NO | PRI | auto_increment | |
| recruiter_id | int(11) | NO | MUL | 0 | |
| product_id | int(5) | NO | 0 | ||
| recruiter_name | varchar(128) | NO | |||
| recruiter_email_address | varchar(128) | NO | |||
| recruiter_company | varchar(64) | YES | |||
| recruiter_street_address | varchar(255) | NO | |||
| recruiter_zip | varchar(10) | NO | |||
| recruiter_city | varchar(64) | NO | |||
| recruiter_state | varchar(32) | YES | |||
| recruiter_country | varchar(64) | NO | |||
| recruiter_telephone | varchar(20) | NO | |||
| billing_name | varchar(64) | NO | |||
| billing_company | varchar(32) | YES | |||
| billing_street_address | varchar(255) | NO | |||
| billing_city | varchar(64) | NO | |||
| billing_state | varchar(32) | YES | |||
| billing_country | varchar(64) | NO | |||
| billing_zip | varchar(20) | NO | |||
| billing_telephone | varchar(20) | NO | |||
| payment_method | varchar(32) | NO | |||
| cc_type | varchar(20) | YES | |||
| cc_owner | varchar(64) | YES | |||
| cc_number | varchar(32) | YES | |||
| cc_expires | varchar(4) | YES | |||
| last_modified | datetime | YES | |||
| date_purchased | datetime | YES | |||
| orders_status | int(5) | NO | 0 | ||
| orders_date_finished | datetime | YES | |||
| currency | char(3) | YES | |||
| currency_value | decimal(14,6) | YES | |||
| comments | text | NO | |||
| admin_comment | text | NO |
Table: orders_history
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| order_id | int(11) | NO | PRI | 0 | |
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| plan_type_name | varchar(64) | NO | |||
| time_period | int(3) | NO | 0 | ||
| time_period1 | varchar(5) | NO | |||
| fee | float(10,2) | NO | 0.00 | ||
| currency | varchar(4) | NO | GBP | ||
| job | int(5) | NO | 0 | ||
| cv | int(5) | NO | 0 | ||
| sms | int(5) | NO | 0 | ||
| total_price | float(12,2) | NO | 0.00 |
Table: orders_status
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| orders_status_id | int(11) | NO | PRI | 0 | |
| language_id | int(11) | NO | PRI | 1 | |
| orders_status_name | varchar(32) | NO | MUL |
Table: orders_total
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| orders_total_id | int(10) unsigned | NO | PRI | auto_increment | |
| orders_id | int(11) | NO | MUL | 0 | |
| title | varchar(255) | NO | |||
| text | varchar(255) | NO | |||
| value | decimal(15,4) | NO | 0.0000 | ||
| class | varchar(32) | NO | |||
| sort_order | int(11) | NO | 0 |
Table: page_rank
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| date | date | NO | PRI | ||
| google_rank | smallint(2) | NO | |||
| alexa_rank | int(9) | NO |
Table: plan_type
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| plan_type_name | varchar(64) | NO | MUL | ||
| fr_plan_type_name | varchar(64) | NO | |||
| priority | int(5) | NO | 0 | ||
| time_period | smallint(3) | NO | 0 | ||
| time_period1 | varchar(5) | NO | |||
| fee | float(10,2) | NO | 0.00 | ||
| currency | varchar(4) | NO | GBP | ||
| job | int(5) | NO | 0 | ||
| cv | int(5) | NO | 0 | ||
| sms | int(5) | NO | 0 |
Table: recruiter
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| recruiter_id | int(11) | NO | PRI | 0 | |
| recruiter_first_name | varchar(32) | NO | |||
| recruiter_last_name | varchar(32) | NO | |||
| recruiter_position | varchar(128) | NO | |||
| recruiter_company_name | varchar(128) | NO | |||
| recruiter_address1 | varchar(128) | NO | |||
| recruiter_address2 | varchar(128) | YES | |||
| recruiter_city | varchar(32) | NO | |||
| recruiter_country_id | int(3) | NO | 0 | ||
| recruiter_state | varchar(32) | YES | |||
| recruiter_state_id | int(11) | NO | 0 | ||
| recruiter_zip | varchar(20) | NO | |||
| recruiter_telephone | varchar(20) | NO | |||
| fax | varchar(20) | NO | |||
| recruiter_logo | varchar(255) | YES | |||
| recruiter_url | varchar(255) | NO | |||
| recruiter_newsletter | enum(‘Yes’,’No’) | NO | Yes | ||
| recruiter_featured | enum(‘Yes’,’No’) | NO | No |
Table: recruiter_account_alert
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| recruiter_account_alert_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: recruiter_account_history
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| recruiter_id | int(11) | NO | 0 | ||
| order_id | int(11) | NO | 0 | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES | |||
| plan_type_name | varchar(32) | NO | |||
| plan_for | enum(‘job_post’,’resume_search’) | NO | job_post | ||
| start_date | date | NO | 0000-00-00 | ||
| end_date | date | NO | 0000-00-00 | ||
| recruiter_job_status | enum(‘Yes’,’No’) | NO | No | ||
| recruiter_job | int(5) | NO | 0 | ||
| recruiter_cv_status | enum(‘Yes’,’No’) | NO | No | ||
| recruiter_cv | int(5) | NO | 0 | ||
| recruiter_sms_status | enum(‘No’,’Yes’) | NO | No | ||
| recruiter_sms | int(10) | NO | 0 | ||
| job_enjoyed | int(5) | NO | 0 | ||
| cv_enjoyed | int(5) | NO | 0 | ||
| sms_enjoyed | int(5) | NO | 0 |
Table: recruiter_login
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| recruiter_id | int(11) | NO | PRI | auto_increment | |
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES | |||
| recruiter_email_address | varchar(128) | NO | UNI | ||
| recruiter_password | varchar(50) | NO | |||
| recruiter_status | enum(‘No’,’Yes’) | NO | Yes | ||
| last_ip_address | varchar(15) | YES | |||
| ip_address | varchar(15) | YES | |||
| last_login_time | datetime | NO | 0000-00-00 00:00:00 | ||
| number_of_logon | int(11) | NO | 0 |
Table: recruiter_order_template
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| order_template_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: recruiter_registration
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| recruiter_registration_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: recruiter_users
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| recruiter_id | int(11) | NO | MUL | 0 | |
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES | |||
| name | varchar(64) | NO | |||
| email_address | varchar(64) | NO | |||
| password | varchar(50) | NO | |||
| last_ip_address | varchar(15) | YES | |||
| ip_address | varchar(15) | YES | |||
| last_login_time | datetime | NO | 0000-00-00 00:00:00 | ||
| number_of_logon | int(11) | NO | 0 | ||
| status | enum(‘Yes’,’No’) | NO | Yes |
Table: resume_alert
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | tinyint(3) | NO | PRI | auto_increment | |
| resume_alert_name | varchar(32) | NO | |||
| description | blob | NO | |||
| fr_description | blob | NO | |||
| priority | tinyint(3) | NO | 0 | ||
| alert_default | enum(‘No’,’Yes’) | NO | No |
Table: resume_job_category
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| resume_id | int(11) | NO | PRI | 0 | |
| job_category_id | int(11) | NO | PRI | 0 |
Table: resume_statistics
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| resume_id | int(11) | NO | 0 | ||
| recruiter_id | int(11) | NO | 0 | ||
| viewed | int(11) | NO | 0 |
Table: resume_weight
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| weight_id | int(10) | NO | PRI | auto_increment | |
| job_id | int(10) | NO | MUL | 0 | |
| location | smallint(3) | NO | 0 | ||
| industry | smallint(3) | NO | 0 | ||
| job_type | smallint(3) | NO | 0 | ||
| experience | smallint(3) | NO | 0 |
Table: salutation
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | smallint(5) | NO | PRI | auto_increment | |
| salutation_name | varchar(255) | NO | |||
| priority | smallint(5) | NO | 0 |
Table: save_job
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| jobseeker_id | int(11) | NO | 0 | ||
| job_id | int(11) | NO | 0 |
Table: save_resume
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| recruiter_id | int(11) | NO | 0 | ||
| resume_id | int(11) | NO | 0 | ||
| inserted | datetime | NO | 0000-00-00 00:00:00 |
Table: search_job_result
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| jobseeker_id | int(11) | NO | MUL | 0 | |
| title_name | varchar(64) | NO | |||
| keyword | varchar(64) | NO | |||
| location | varchar(64) | NO | |||
| word1 | enum(‘Yes’,’No’) | NO | Yes | ||
| country | varchar(5) | NO | |||
| state | varchar(64) | NO | |||
| industry_sector | varchar(255) | NO | |||
| experience | varchar(32) | NO | |||
| zip_code | varchar(5) | NO | |||
| radius | smallint(5) | NO | |||
| company | varchar(120) | NO | |||
| job_alert | enum(‘daily’,’weekly’,’monthly’) | NO | |||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES |
Table: search_resume_result
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| recruiter_id | int(11) | NO | 0 | ||
| title_name | varchar(64) | NO | |||
| keyword | varchar(64) | NO | |||
| word1 | enum(‘Yes’,’No’) | NO | Yes | ||
| resume_type | varchar(24) | NO | |||
| minimum_rating | varchar(32) | YES | |||
| maximum_rating | varchar(32) | YES | |||
| first_name | varchar(32) | NO | |||
| last_name | varchar(32) | NO | |||
| email_address | varchar(32) | NO | |||
| country | varchar(5) | NO | |||
| state | varchar(64) | NO | |||
| city | varchar(32) | NO | |||
| zip | varchar(15) | NO | |||
| industry_sector | varchar(255) | NO | |||
| education_level | varchar(20) | NO | |||
| job_type | varchar(20) | NO | |||
| shift_type | varchar(20) | NO | |||
| experience | varchar(20) | NO | |||
| inserted | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | YES |
Table: selection_round
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | smallint(3) | NO | PRI | auto_increment | |
| round_name | varchar(32) | NO | |||
| fr_round_name | varchar(64) | NO | |||
| value | smallint(3) | NO | 0 |
Table: site_map
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | smallint(6) | NO | PRI | auto_increment | |
| configuration_name | varchar(128) | NO | |||
| title | varchar(128) | NO | |||
| page_url | varchar(128) | NO | |||
| priority | smallint(3) | NO | |||
| status | enum(‘active’,’inactive’) | NO |
Table: skill_last_used
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | smallint(5) | NO | PRI | auto_increment | |
| skill_last_used | varchar(64) | NO | |||
| fr_skill_last_used | varchar(64) | NO | |||
| priority | smallint(5) | NO | 0 |
Table: skill_level
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | smallint(5) | NO | PRI | auto_increment | |
| skill_name | varchar(64) | NO | |||
| fr_skill_name | varchar(64) | NO | |||
| priority | smallint(6) | NO | 0 |
Table: tag_statistics
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| date | date | NO | MUL | 0000-00-00 | |
| ip_address | varchar(15) | NO | MUL | ||
| tag | varchar(64) | NO |
Table: tags
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | auto_increment | |
| tag | varchar(64) | NO | |||
| point | smallint(5) | NO | 0 | ||
| status | enum(‘active’,’inactive’) | NO | inactive |
Table: tax_class
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| tax_class_id | int(11) | NO | PRI | auto_increment | |
| tax_class_title | varchar(32) | NO | |||
| tax_class_description | varchar(255) | NO | |||
| last_modified | datetime | YES | |||
| date_added | datetime | NO | 0000-00-00 00:00:00 |
Table: title_keywordmetatype
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| file_name | varchar(255) | NO | |||
| title | varchar(255) | NO | |||
| fr_title | varchar(255) | NO | |||
| meta_keyword | text | NO | |||
| fr_meta_keyword | text | NO |
Table: topic_reply
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| topic_id | int(11) | NO | MUL | 0 | |
| user_id | int(9) | NO | MUL | ||
| user_type | enum(‘jobseeker’,’recruiter’) | NO | |||
| description | text | NO | |||
| inserted | datetime | NO | 0000-00-00 00:00:00 |
Table: user_category
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| id | int(5) | NO | PRI | auto_increment | |
| user_category_name | varchar(255) | NO | MUL | ||
| priority | smallint(5) | NO | 0 |
Table: whos_online
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| user_id | int(11) | YES | |||
| user | varchar(13) | NO | |||
| session_id | varchar(32) | NO | |||
| ip_address | varchar(15) | NO | |||
| time_entry | varchar(14) | NO | |||
| time_last_click | varchar(14) | NO | |||
| last_page_url | varchar(255) | NO |
Table: zip_code
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| zip_code | varchar(10) | NO | PRI | ||
| latitude | float(10,6) | NO | |||
| longitude | float(10,6) | NO | |||
| city | varchar(64) | NO | |||
| state2 | varchar(64) | NO | |||
| state | smallint(5) | NO |
Table: zip_code_search
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| zip_code | varchar(10) | NO | MUL | ||
| radius | smallint(2) | NO | |||
| state | text | NO | |||
| inserted | date | NO |
Table: zones
Description here
| Field | Type | Null | Key | Default | Auto Increment |
|---|---|---|---|---|---|
| zone_id | int(11) | NO | PRI | auto_increment | |
| zone_country_id | int(11) | NO | MUL | 0 | |
| zone_code | varchar(32) | NO | |||
| zone_name | varchar(64) | NO | |||
| fr_zone_name | varchar(64) | NO |