From Online Job board software - Job Site Software and Online Recruitment Software Solutions
Jump to: navigation, search

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.

Contents

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
idint(15)NOPRI auto_increment
sender_idint(15)NOMUL0
receiver_idint(11)NOMUL0
subjectvarchar(255)NO
messageblobNO
attachment_filevarchar(255)NO
sender_markenum('No','Yes')NO No
receiver_markenum('No','Yes')NO No
receiver_seeenum('No','Yes')NOMULNo
sender_seeenum('Yes','No')NOMULNo
receiver_mail_statusenum('active','inactive','deleted')NO active
sender_mail_statusenum('active','inactive','deleted')NO active
receiver_deleteddateYES
sender_deleteddateYES
inserteddatetimeNO 0000-00-00 00:00:00

Table: admin_files

Description here

Field Type Null Key Default Auto Increment
admin_files_idint(11)NOPRI auto_increment
admin_files_namevarchar(64)NO
admin_files_is_boxestinyint(5)NO 0
admin_files_to_boxesint(11)NO 0
admin_groups_idset('1','2')NO 1

Table: admin_groups

Description here

Field Type Null Key Default Auto Increment
admin_groups_idint(11)NOPRI auto_increment
admin_groups_namevarchar(64)NO

Table: administrator

Description here

Field Type Null Key Default Auto Increment
admin_idint(11)NOPRI auto_increment
admin_groups_idint(11)NO 0
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES
admin_firstnamevarchar(32)NO
admin_lastnamevarchar(32)NO
admin_namevarchar(32)NOUNI
admin_passwordvarchar(50)NO
admin_email_addressvarchar(128)NOUNI
last_ip_addressvarchar(255)YES
ip_addressvarchar(255)YES
last_login_timedatetimeYES
is_adminenum('No','Yes')NO No
number_of_logonint(11)NO 0

Table: applicant_interaction

Description here

Field Type Null Key Default Auto Increment
idint(15)NOPRI auto_increment
application_idint(15)NO 0
sender_idint(11)NO 0
email_addressvarchar(128)NO
subjectvarchar(255)NO
messageblobNO
attachment_filevarchar(255)NO
remark_titlevarchar(255)NO
remark_descriptionblobNO
jobseeker_seeenum('No','Yes')NO No
jobseeker_markenum('No','Yes')NO No
jobseeker_mail_statusenum('active','inactive','deleted')NO active
inserteddatetimeNO 0000-00-00 00:00:00

Table: applicant_status

Description here

Field Type Null Key Default Auto Increment
idint(15)NOPRI auto_increment
application_idint(15)NOMUL0
process_roundint(11)NOMUL0
pre_statussmallint(3)NO 0
cur_statussmallint(3)NO 0
inserteddatetimeNO 0000-00-00 00:00:00

Table: application

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
application_idvarchar(32)NOMUL
jobseeker_apply_idint(11)NOMUL0
inserteddatetimeNO 0000-00-00 00:00:00
job_idint(11)NOMUL0
jobseeker_idint(11)NOMUL0
cover_lettertextNO
resume_idint(11)NOMUL0
resume_namevarchar(255)NO
applicant_selectenum('No','Yes')NO No
applicant_join_statusenum(,'joined','declined')NOMUL
selected_datedatetimeNO 0000-00-00 00:00:00
sourceenum('job_apply','search_resume')NO job_apply

Table: application_rating

Description here

Field Type Null Key Default Auto Increment
rate_idint(15)NOPRI auto_increment
application_idint(15)NO 0
pointsmallint(3)NO 0
round_idsmallint(3)NO 0
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeNO 0000-00-00 00:00:00

Table: application_send_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
application_send_template_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: application_status

Description here

Field Type Null Key Default Auto Increment
idsmallint(3)NOPRI auto_increment
application_statusvarchar(32)NO
fr_application_statusvarchar(32)NO
prioritysmallint(3)NO 0

Table: apply

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
inserteddatetimeNO 0000-00-00 00:00:00
job_idint(11)NOMUL0
jobseeker_idint(11)NOMUL0
cover_lettertextNO
resume_idint(11)NO 0
resume_namevarchar(255)NO
jobseeker_apply_statusenum('active','inactive')NO active

Table: article

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
category_idint(11)NO 0
titlevarchar(255)NO
authorvarchar(255)NO
show_datedateNO 0000-00-00
descriptionblobNO
short_descriptiontextNO
article_photovarchar(255)NO
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeNO 0000-00-00 00:00:00
is_showenum('Yes','No')NO Yes

Table: article_categories

Description here

Field Type Null Key Default Auto Increment
idint(5) unsignedNOPRI auto_increment
sub_cat_idvarchar(32)NO
category_namevarchar(255)YESMUL
fr_category_namevarchar(255)NO

Table: availability

Description here

Field Type Null Key Default Auto Increment
idint(5)NOPRI auto_increment
availability_namevarchar(255)NOMUL
prioritysmallint(5)NO 0

Table: banner

Description here

Field Type Null Key Default Auto Increment
idint(5)NOPRI auto_increment
banner_typeenum('image','script')NO image
titlevarchar(150)NO
hrefvarchar(255)NO
srcvarchar(255)NO
altvarchar(255)YES
scripttextNO
adviewsint(10)YES 0
adclicksint(10)YES 0
activeenum('T','F')NO T
locationint(5)NO 1
banner_datedateNO 0000-00-00
b_orderint(10)NO 1
company_namevarchar(50)YES
company_contactvarchar(50)YES
company_emailvarchar(50)YES
company_commentsvarchar(100)YES
banner_duration_fromdateYES
banner_duration_todateYES
banner_costingvarchar(40)YES
duration_unlimitedenum('T','F')NO T
deletedenum('T','F')NO F

Table: banner_location

Description here

Field Type Null Key Default Auto Increment
banner_location_idint(5)NOPRI auto_increment
banner_location_namevarchar(100)NO

Table: career_level

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
career_level_namevarchar(64)NOMUL
fr_career_level_namevarchar(64)NO
priorityint(5)NO 0

Table: company_description

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
recruiter_idint(11)NOUNI0
descriptionblobNO

Table: configuration

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
configuration_group_idint(11)NO 0
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES
configuration_titlevarchar(64)NO
configuration_namevarchar(64)NO
configuration_valuevarchar(255)NO
configuration_descriptionvarchar(255)YES
priorityint(5)NO 0
use_functionvarchar(255)YES
set_functionvarchar(255)YES

Table: configuration_group

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
configuration_group_titlevarchar(64)NO
configuration_group_descriptionvarchar(255)NO
priorityint(5)NO 0
visibleenum('Yes','No')NO Yes

Table: continent

Description here

Field Type Null Key Default Auto Increment
idsmallint(5) unsignedNOPRI auto_increment
continent_namevarchar(64)NO
fr_continent_namevarchar(64)NO
prioritysmallint(5)NO 0

Table: countries

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
continent_idint(11)NO 0
country_namevarchar(64)NOMUL
fr_country_namevarchar(64)NO
country_codeint(10)NO 0
priorityint(5)NO 0

Table: cover_letters

Description here

Field Type Null Key Default Auto Increment
cover_letter_idint(11)NOPRI auto_increment
jobseeker_idint(11)NOMUL0
cover_letter_namevarchar(32)NO
cover_lettertextNO
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES

Table: currencies

Description here

Field Type Null Key Default Auto Increment
currencies_idint(11)NOPRI auto_increment
titlevarchar(32)NO
codechar(3)NO
symbol_leftvarchar(12)YES
symbol_rightvarchar(12)YES
decimal_pointchar(1)YES
thousands_pointchar(1)YES
decimal_placeschar(1)YES
valuefloat(13,8)YES
last_updateddatetimeYES

Table: education_level

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
education_level_namevarchar(64)NOMUL
fr_education_level_namevarchar(64)NO
priorityint(5)NO 0

Table: experience

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
max_experiencevarchar(5)NOMUL
min_experiencesmallint(5)NO 0
experience_weightsmallint(3)NO 0
priorityint(5)NO 0

Table: expired_job_alert

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
expired_job_alert_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: forum

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
category_idint(11)NOMUL0
titlevarchar(255)NO
authorvarchar(255)NO
show_datedateNO 0000-00-00
descriptiontextNO
forum_photovarchar(255)NO
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeNO 0000-00-00 00:00:00
is_showenum('Yes','No')NO Yes

Table: forum_categories

Description here

Field Type Null Key Default Auto Increment
idint(5) unsignedNOPRI auto_increment
category_namevarchar(255)YESMUL
fr_category_namevarchar(255)NO

Table: forum_topics

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
forum_idint(11)NOMUL0
user_idint(9)NOMUL
user_typeenum('jobseeker','recruiter')NO
titlevarchar(255)NO
descriptiontextNO
hitsint(9)NO
featuredenum('no','yes')NO
inserteddatetimeNO 0000-00-00 00:00:00

Table: geo_zones

Description here

Field Type Null Key Default Auto Increment
geo_zone_idint(11)NOPRI auto_increment
geo_zone_namevarchar(32)NO
geo_zone_descriptionvarchar(255)NO
last_modifieddatetimeYES
date_addeddatetimeNO 0000-00-00 00:00:00

Table: gift

Description here

Field Type Null Key Default Auto Increment
gift_idint(10) unsignedNOPRI auto_increment
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES
certificate_numbervarchar(32)NO
discount_type_idtinyint(3) unsignedNO 0
amountdecimal(10,2) unsignedNO 0.00
expireddateNO 0000-00-00

Table: gift_used

Description here

Field Type Null Key Default Auto Increment
recruiter_idint(10) unsignedNOPRI0
gift_idint(10) unsignedNOPRI0
gift_amountdecimal(10,2)NO 0.00
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES

Table: indeed_feed

Description here

Field Type Null Key Default Auto Increment
feed_idsmallint(5)NOPRI auto_increment
feed_titlevarchar(64)NO
publisher_idvarchar(25)NO
recruiter_idint(10)NO
feed_keywordvarchar(255)NO
locationvarchar(64)NO
country_codevarchar(2)NO
job_typevarchar(10)NO
sort_byenum('relevance','date')NO
channelvarchar(64)NO
job_durationsmallint(3)NO
max_feedsmallint(6)NO
statusenum('active','inactive')NO
last_activedatetimeNO
import_jobsint(9)NO
updateddatetimeNO
inserteddatetimeNO

Table: indeed_job

Description here

Field Type Null Key Default Auto Increment
indeed_idvarchar(20)NOPRI
job_idint(9)NOMUL
indeed_urlvarchar(255)NO

Table: invite_friend_tmpl

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
template_namevarchar(64)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: ipaddress_block

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
ip_address1varchar(15)NO
ip_address2varchar(15)YES
priorityint(11)NO 0

Table: job_alert

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
job_alert_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: job_category

Description here

Field Type Null Key Default Auto Increment
idint(5)NOPRI auto_increment
sub_cat_idint(11)YES
category_namevarchar(255)NOMUL
fr_category_namevarchar(255)NO
prioritysmallint(5)NO 0

Table: job_point_history

Description here

Field Type Null Key Default Auto Increment
job_idint(11)NO 0
re_advertised_fromdatetimeNO 0000-00-00 00:00:00
re_advertised_todatetimeNO 0000-00-00 00:00:00

Table: job_post_invoice_tmpl

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
template_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: job_posted

Description here

Field Type Null Key Default Auto Increment
idint(5)NOPRI auto_increment
type_namevarchar(255)NOMUL
fr_type_namevarchar(255)NO
valuesmallint(3)NO 0
prioritysmallint(5)NO 0

Table: job_screener

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
job_idint(11)NO 0
recruiter_idint(11)NO 0
q1varchar(255)YES
q2varchar(255)YES

Table: job_statistics

Description here

Field Type Null Key Default Auto Increment
job_idint(11)NOPRI0
applicationsint(11)NO 0
viewedint(11)NO 0
clickedint(11)NO 0

Table: job_title

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
job_title_namevarchar(64)NO
priorityint(11)NO 0

Table: job_type

Description here

Field Type Null Key Default Auto Increment
idint(5)NOPRI auto_increment
type_namevarchar(255)NOMUL
fr_type_namevarchar(255)NO
prioritysmallint(5)NO 0

Table: jobs

Description here

Field Type Null Key Default Auto Increment
job_idint(11)NOPRI auto_increment
display_idvarchar(32)NO
recruiter_idint(11)NOMUL0
recruiter_user_idint(11)YES
job_sourceenum('jobsite','indeed')NOMUL
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES
deleteddatetimeYES
re_advdatetimeYESMUL
expireddatetimeYES
job_titlevarchar(255)NO
job_referencevarchar(64)NOMUL
job_country_idvarchar(5)NO
job_state_idvarchar(5)YES
job_statevarchar(64)YES
job_locationvarchar(64)NO
currencysmallint(5)NO 0
job_salaryvarchar(64)YES
job_allowancevarchar(64)YES
job_industry_sectortextNO
job_short_descriptiontextNO
job_descriptionblobNO
job_typevarchar(5)NO
job_relocateenum('Yes','No')NO Yes
min_experiencevarchar(5)NO
max_experiencevarchar(5)NO
job_vacancy_periodvarchar(15)NO
job_statusenum('Yes','No')NO Yes
job_featuredenum('Yes','No')NO No
post_urlenum('Yes','No')NO No
urlvarchar(255)NO

Table: jobs_job_category

Description here

Field Type Null Key Default Auto Increment
job_idint(11)NOPRI0
job_category_idint(11)NOPRI0

Table: jobseeker

Description here

Field Type Null Key Default Auto Increment
jobseeker_idint(11)NOPRI0
jobseeker_privacyenum('1','2','3')NO 3
jobseeker_cv_searchableenum('Yes','No')NO Yes
jobseeker_urlvarchar(64)NO
jobseeker_first_namevarchar(32)NO
jobseeker_middle_namevarchar(32)NO
jobseeker_last_namevarchar(32)NO
jobseeker_salutationsmallint(5)NO 0
jobseeker_address1varchar(128)NO
jobseeker_address2varchar(128)NO
jobseeker_country_idint(3)NO 0
jobseeker_statevarchar(32)NO
jobseeker_state_idint(11)NO 0
jobseeker_cityvarchar(64)NO
jobseeker_zipvarchar(10)NO
jobseeker_phonevarchar(24)NO
jobseeker_mobilevarchar(24)NO
jobseeker_work_phonevarchar(24)NO
jobseeker_featuredenum('Yes','No')NO No
jobseeker_newsletterenum('Yes','No')NO Yes

Table: jobseeker_account_alert

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
jobseeker_account_alert_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: jobseeker_account_history

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
jobseeker_idint(11)NOMUL0
order_idint(11)NO 0
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES
plan_type_namevarchar(32)NO
start_datedateNOMUL0000-00-00
end_datedateNO 0000-00-00

Table: jobseeker_language

Description here

Field Type Null Key Default Auto Increment
languages_idint(11)NOPRI auto_increment
namevarchar(32)NOMUL
fr_namevarchar(32)NO
priorityint(3)YES

Table: jobseeker_login

Description here

Field Type Null Key Default Auto Increment
jobseeker_idint(11)NOPRI auto_increment
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeNO 0000-00-00 00:00:00
jobseeker_email_addressvarchar(128)NOUNI
jobseeker_passwordvarchar(50)NO
jobseeker_statusenum('No','Yes')NO Yes
last_ip_addressvarchar(15)NO
ip_addressvarchar(15)NO
last_login_timedatetimeNO 0000-00-00 00:00:00
number_of_logonint(11)NO 0

Table: jobseeker_order_status_update_tmpl

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
order_template_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: jobseeker_order_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
order_template_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: jobseeker_orders

Description here

Field Type Null Key Default Auto Increment
orders_idint(11)NOPRI auto_increment
jobseeker_idint(11)NO 0
product_idint(5)NO 0
jobseeker_namevarchar(128)NO
jobseeker_email_addressvarchar(128)NO 0
jobseeker_street_addressvarchar(255)NO
jobseeker_zipvarchar(10)NO
jobseeker_cityvarchar(64)NO
jobseeker_statevarchar(32)YES
jobseeker_countryvarchar(64)NO
jobseeker_telephonevarchar(20)NO
billing_namevarchar(64)NO
billing_companytinyint(32) unsignedYES
billing_street_addressvarchar(255)NO
billing_cityvarchar(64)NO
billing_statevarchar(32)YES
billing_countryvarchar(64)NO
billing_zipvarchar(20)NO
billing_telephonevarchar(20)NO
payment_methodvarchar(32)NO
cc_typevarchar(20)YES
cc_ownervarchar(64)YES
cc_numbervarchar(32)YES
cc_expiresvarchar(4)YES
last_modifieddatetimeYES
date_purchaseddatetimeYES
orders_statusint(5)NO 0
orders_date_finisheddatetimeYES
currencychar(3)YES
currency_valuedecimal(14,6)YES
commentstextNO
admin_commenttextNO

Table: jobseeker_orders_history

Description here

Field Type Null Key Default Auto Increment
order_idint(11)NOPRI0
inserteddatetimeNO 0000-00-00 00:00:00
plan_type_namevarchar(64)NO
time_periodint(3)NO 0
time_period1varchar(5)NO
feefloat(10,2)NO 0.00
currencyvarchar(4)NO GBP
total_pricefloat(12,2)NO 0.00

Table: jobseeker_orders_total

Description here

Field Type Null Key Default Auto Increment
orders_total_idint(10) unsignedNOPRI auto_increment
orders_idint(11)NOMUL0
titlevarchar(255)NO
textvarchar(255)NO
valuedecimal(15,4)NO 0.0000
classvarchar(32)NO
sort_orderint(11)NO 0

Table: jobseeker_plan_type

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
plan_type_namevarchar(64)NOMUL
fr_plan_type_namevarchar(64)NO
priorityint(5)NO 0
time_periodsmallint(3)NO 0
time_period1varchar(5)NO
feefloat(10,2)NO 0.00
currencyvarchar(4)NO GBP
cvint(5)NO 0

Table: jobseeker_rating

Description here

Field Type Null Key Default Auto Increment
rating_idint(11)NOPRI auto_increment
resume_idint(11)NOMUL0
recruiter_idint(11)NOMUL0
pointtinyint(1)NO 0
admin_ratingsmallint(5)NO 0
admin_rateenum('N','Y')NOMULN
private_notesvarchar(255)YES

Table: jobseeker_registration

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
jobseeker_registration_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: jobseeker_resume1

Description here

Field Type Null Key Default Auto Increment
resume_idint(11)NOPRI auto_increment
jobseeker_idint(11)NOMUL0
resume_titlevarchar(64)NO
objectivetextNO
job_type_idtextNO
currencysmallint(5)NO 0
expected_salaryvarchar(96)NO
expected_salary_pervarchar(96)NO
target_job_titlesvarchar(96)NO
job_categorytextNO
relocateenum('Yes','No')NO Yes
work_experincesmallint(4)NO 0
experience_yearsmallint(2)NO 0
experience_monthsmallint(2)NO 0
availability_datedateYES
jobseeker_resumevarchar(128)NO
jobseeker_photovarchar(128)NO
jobseeker_videovarchar(255)NO
jobseeker_resume_texttextNO
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES 0000-00-00 00:00:00
search_statusenum('Yes','No')NO Yes

Table: jobseeker_resume2

Description here

Field Type Null Key Default Auto Increment
r2_idint(11)NOPRI auto_increment
resume_idint(11)NOMUL0
companyvarchar(96)NO
cityvarchar(96)NO
statevarchar(96)NO
state_idsmallint(5)NO 0
countrysmallint(5)NO 0
job_titlevarchar(96)NO
currencysmallint(5)NO 0
salaryvarchar(64)NO
salary_pervarchar(5)NO
company_industrysmallint(5)NO 0
start_monthint(2)NO 0
start_yearint(4)NO 0
end_monthint(2)NO 0
end_yearint(4)NO 0
still_workenum('Yes','No')NO No
descriptiontextNOMUL

Table: jobseeker_resume3

Description here

Field Type Null Key Default Auto Increment
r3_idint(11)NOPRI auto_increment
resume_idint(11)NOMUL0
degreevarchar(96)NO
specializationvarchar(128)NO
schoolvarchar(96)NO
cityvarchar(96)NO
statevarchar(96)NO
state_idsmallint(5)NO 0
countrysmallint(5)NO 0
start_monthsmallint(2)NO 0
start_yearsmallint(4)NO 0
end_monthsmallint(2)NO 0
end_yearsmallint(4)NO 0
related_infotextNOMUL

Table: jobseeker_resume4

Description here

Field Type Null Key Default Auto Increment
r4_idint(11)NOPRI auto_increment
resume_idint(11)NOMUL0
skillvarchar(96)NO
skill_levelvarchar(128)NO
last_usedsmallint(5)NO 0
years_of_expvarchar(96)YES

Table: jobseeker_resume5

Description here

Field Type Null Key Default Auto Increment
r5_idint(11)NOPRI auto_increment
resume_idint(11)NOMUL0
languagesmallint(5)NO 0
proficiencysmallint(5)NO 0

Table: jobseeker_resume6

Description here

Field Type Null Key Default Auto Increment
r6_idint(11)NOPRI auto_increment
resume_idint(11)NOMUL0
namevarchar(128)NO
company_namevarchar(128)NO
countryint(10)NO 0
position_titlevarchar(128)NO
contact_novarchar(20)NO
email_addressvarchar(50)NO
relationshipvarchar(50)NO
inserteddateNO 0000-00-00
updateddateNO 0000-00-00

Table: language_proficiency

Description here

Field Type Null Key Default Auto Increment
idsmallint(5)NOPRI auto_increment
language_proficiencyvarchar(64)NO
fr_language_proficiencyvarchar(64)NO
prioritysmallint(5)NO 0

Table: languages

Description here

Field Type Null Key Default Auto Increment
languages_idint(11)NOPRI auto_increment
namevarchar(32)NOMUL
codechar(2)NO
imagevarchar(64)YES
directoryvarchar(32)YES
sort_orderint(3)YES

Table: newsletters

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
titlevarchar(255)NO
contenttextNO
attachment_filevarchar(255)YES
modulevarchar(255)NO
date_addeddatetimeNO 0000-00-00 00:00:00
date_sentdatetimeYES
statusint(1)YES
lockedint(1)YES 0

Table: newsletters_history

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
titlevarchar(255)NO
contenttextNO
attachment_filevarchar(255)YES
send_toenum('jobseeker','recruiter')NO jobseeker
date_senddatetimeYES

Table: order_status_update_tmpl

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
order_template_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: orders

Description here

Field Type Null Key Default Auto Increment
orders_idint(11)NOPRI auto_increment
recruiter_idint(11)NOMUL0
product_idint(5)NO 0
recruiter_namevarchar(128)NO
recruiter_email_addressvarchar(128)NO
recruiter_companyvarchar(64)YES
recruiter_street_addressvarchar(255)NO
recruiter_zipvarchar(10)NO
recruiter_cityvarchar(64)NO
recruiter_statevarchar(32)YES
recruiter_countryvarchar(64)NO
recruiter_telephonevarchar(20)NO
billing_namevarchar(64)NO
billing_companyvarchar(32)YES
billing_street_addressvarchar(255)NO
billing_cityvarchar(64)NO
billing_statevarchar(32)YES
billing_countryvarchar(64)NO
billing_zipvarchar(20)NO
billing_telephonevarchar(20)NO
payment_methodvarchar(32)NO
cc_typevarchar(20)YES
cc_ownervarchar(64)YES
cc_numbervarchar(32)YES
cc_expiresvarchar(4)YES
last_modifieddatetimeYES
date_purchaseddatetimeYES
orders_statusint(5)NO 0
orders_date_finisheddatetimeYES
currencychar(3)YES
currency_valuedecimal(14,6)YES
commentstextNO
admin_commenttextNO

Table: orders_history

Description here

Field Type Null Key Default Auto Increment
order_idint(11)NOPRI0
inserteddatetimeNO 0000-00-00 00:00:00
plan_type_namevarchar(64)NO
time_periodint(3)NO 0
time_period1varchar(5)NO
feefloat(10,2)NO 0.00
currencyvarchar(4)NO GBP
jobint(5)NO 0
cvint(5)NO 0
smsint(5)NO 0
total_pricefloat(12,2)NO 0.00

Table: orders_status

Description here

Field Type Null Key Default Auto Increment
orders_status_idint(11)NOPRI0
language_idint(11)NOPRI1
orders_status_namevarchar(32)NOMUL

Table: orders_total

Description here

Field Type Null Key Default Auto Increment
orders_total_idint(10) unsignedNOPRI auto_increment
orders_idint(11)NOMUL0
titlevarchar(255)NO
textvarchar(255)NO
valuedecimal(15,4)NO 0.0000
classvarchar(32)NO
sort_orderint(11)NO 0

Table: page_rank

Description here

Field Type Null Key Default Auto Increment
datedateNOPRI
google_ranksmallint(2)NO
alexa_rankint(9)NO

Table: plan_type

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
plan_type_namevarchar(64)NOMUL
fr_plan_type_namevarchar(64)NO
priorityint(5)NO 0
time_periodsmallint(3)NO 0
time_period1varchar(5)NO
feefloat(10,2)NO 0.00
currencyvarchar(4)NO GBP
jobint(5)NO 0
cvint(5)NO 0
smsint(5)NO 0

Table: recruiter

Description here

Field Type Null Key Default Auto Increment
recruiter_idint(11)NOPRI0
recruiter_first_namevarchar(32)NO
recruiter_last_namevarchar(32)NO
recruiter_positionvarchar(128)NO
recruiter_company_namevarchar(128)NO
recruiter_address1varchar(128)NO
recruiter_address2varchar(128)YES
recruiter_cityvarchar(32)NO
recruiter_country_idint(3)NO 0
recruiter_statevarchar(32)YES
recruiter_state_idint(11)NO 0
recruiter_zipvarchar(20)NO
recruiter_telephonevarchar(20)NO
faxvarchar(20)NO
recruiter_logovarchar(255)YES
recruiter_urlvarchar(255)NO
recruiter_newsletterenum('Yes','No')NO Yes
recruiter_featuredenum('Yes','No')NO No

Table: recruiter_account_alert

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
recruiter_account_alert_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: recruiter_account_history

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
recruiter_idint(11)NO 0
order_idint(11)NO 0
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES
plan_type_namevarchar(32)NO
plan_forenum('job_post','resume_search')NO job_post
start_datedateNO 0000-00-00
end_datedateNO 0000-00-00
recruiter_job_statusenum('Yes','No')NO No
recruiter_jobint(5)NO 0
recruiter_cv_statusenum('Yes','No')NO No
recruiter_cvint(5)NO 0
recruiter_sms_statusenum('No','Yes')NO No
recruiter_smsint(10)NO 0
job_enjoyedint(5)NO 0
cv_enjoyedint(5)NO 0
sms_enjoyedint(5)NO 0

Table: recruiter_login

Description here

Field Type Null Key Default Auto Increment
recruiter_idint(11)NOPRI auto_increment
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES
recruiter_email_addressvarchar(128)NOUNI
recruiter_passwordvarchar(50)NO
recruiter_statusenum('No','Yes')NO Yes
last_ip_addressvarchar(15)YES
ip_addressvarchar(15)YES
last_login_timedatetimeNO 0000-00-00 00:00:00
number_of_logonint(11)NO 0

Table: recruiter_order_template

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
order_template_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: recruiter_registration

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
recruiter_registration_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: recruiter_users

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
recruiter_idint(11)NOMUL0
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES
namevarchar(64)NO
email_addressvarchar(64)NO
passwordvarchar(50)NO
last_ip_addressvarchar(15)YES
ip_addressvarchar(15)YES
last_login_timedatetimeNO 0000-00-00 00:00:00
number_of_logonint(11)NO 0
statusenum('Yes','No')NO Yes

Table: resume_alert

Description here

Field Type Null Key Default Auto Increment
idtinyint(3)NOPRI auto_increment
resume_alert_namevarchar(32)NO
descriptionblobNO
fr_descriptionblobNO
prioritytinyint(3)NO 0
alert_defaultenum('No','Yes')NO No

Table: resume_job_category

Description here

Field Type Null Key Default Auto Increment
resume_idint(11)NOPRI0
job_category_idint(11)NOPRI0

Table: resume_statistics

Description here

Field Type Null Key Default Auto Increment
resume_idint(11)NO 0
recruiter_idint(11)NO 0
viewedint(11)NO 0

Table: resume_weight

Description here

Field Type Null Key Default Auto Increment
weight_idint(10)NOPRI auto_increment
job_idint(10)NOMUL0
locationsmallint(3)NO 0
industrysmallint(3)NO 0
job_typesmallint(3)NO 0
experiencesmallint(3)NO 0

Table: salutation

Description here

Field Type Null Key Default Auto Increment
idsmallint(5)NOPRI auto_increment
salutation_namevarchar(255)NO
prioritysmallint(5)NO 0

Table: save_job

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
jobseeker_idint(11)NO 0
job_idint(11)NO 0

Table: save_resume

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
recruiter_idint(11)NO 0
resume_idint(11)NO 0
inserteddatetimeNO 0000-00-00 00:00:00

Table: search_job_result

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
jobseeker_idint(11)NOMUL0
title_namevarchar(64)NO
keywordvarchar(64)NO
locationvarchar(64)NO
word1enum('Yes','No')NO Yes
countryvarchar(5)NO
statevarchar(64)NO
industry_sectorvarchar(255)NO
experiencevarchar(32)NO
zip_codevarchar(5)NO
radiussmallint(5)NO
companyvarchar(120)NO
job_alertenum('daily','weekly','monthly')NO
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES

Table: search_resume_result

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
recruiter_idint(11)NO 0
title_namevarchar(64)NO
keywordvarchar(64)NO
word1enum('Yes','No')NO Yes
resume_typevarchar(24)NO
minimum_ratingvarchar(32)YES
maximum_ratingvarchar(32)YES
first_namevarchar(32)NO
last_namevarchar(32)NO
email_addressvarchar(32)NO
countryvarchar(5)NO
statevarchar(64)NO
cityvarchar(32)NO
zipvarchar(15)NO
industry_sectorvarchar(255)NO
education_levelvarchar(20)NO
job_typevarchar(20)NO
shift_typevarchar(20)NO
experiencevarchar(20)NO
inserteddatetimeNO 0000-00-00 00:00:00
updateddatetimeYES

Table: selection_round

Description here

Field Type Null Key Default Auto Increment
idsmallint(3)NOPRI auto_increment
round_namevarchar(32)NO
fr_round_namevarchar(64)NO
valuesmallint(3)NO 0

Table: site_map

Description here

Field Type Null Key Default Auto Increment
idsmallint(6)NOPRI auto_increment
configuration_namevarchar(128)NO
titlevarchar(128)NO
page_urlvarchar(128)NO
prioritysmallint(3)NO
statusenum('active','inactive')NO

Table: skill_last_used

Description here

Field Type Null Key Default Auto Increment
idsmallint(5)NOPRI auto_increment
skill_last_usedvarchar(64)NO
fr_skill_last_usedvarchar(64)NO
prioritysmallint(5)NO 0

Table: skill_level

Description here

Field Type Null Key Default Auto Increment
idsmallint(5)NOPRI auto_increment
skill_namevarchar(64)NO
fr_skill_namevarchar(64)NO
prioritysmallint(6)NO 0

Table: tag_statistics

Description here

Field Type Null Key Default Auto Increment
datedateNOMUL0000-00-00
ip_addressvarchar(15)NOMUL
tagvarchar(64)NO

Table: tags

Description here

Field Type Null Key Default Auto Increment
idint(10)NOPRI auto_increment
tagvarchar(64)NO
pointsmallint(5)NO 0
statusenum('active','inactive')NO inactive

Table: tax_class

Description here

Field Type Null Key Default Auto Increment
tax_class_idint(11)NOPRI auto_increment
tax_class_titlevarchar(32)NO
tax_class_descriptionvarchar(255)NO
last_modifieddatetimeYES
date_addeddatetimeNO 0000-00-00 00:00:00

Table: title_keywordmetatype

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
file_namevarchar(255)NO
titlevarchar(255)NO
fr_titlevarchar(255)NO
meta_keywordtextNO
fr_meta_keywordtextNO

Table: topic_reply

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
topic_idint(11)NOMUL0
user_idint(9)NOMUL
user_typeenum('jobseeker','recruiter')NO
descriptiontextNO
inserteddatetimeNO 0000-00-00 00:00:00

Table: user_category

Description here

Field Type Null Key Default Auto Increment
idint(5)NOPRI auto_increment
user_category_namevarchar(255)NOMUL
prioritysmallint(5)NO 0

Table: user_contact

Description here

Field Type Null Key Default Auto Increment
idint(11)NOPRI auto_increment
user_idint(11)NOMUL0
user_typeenum('jobseeker','recruiter')NO jobseeker
user_first_namevarchar(32)NO
user_middle_namevarchar(32)NO
user_last_namevarchar(32)NO
user_email_addressvarchar(64)NO
user_address1varchar(128)NO
user_address2varchar(128)NO
user_country_idint(3)NO 0
user_statevarchar(32)NO
user_state_idint(11)NO 0
user_cityvarchar(64)NO
user_zipvarchar(10)NO
user_phonevarchar(24)NO
user_mobilevarchar(24)NO

Table: whos_online

Description here

Field Type Null Key Default Auto Increment
user_idint(11)YES
uservarchar(13)NO
session_idvarchar(32)NO
ip_addressvarchar(15)NO
time_entryvarchar(14)NO
time_last_clickvarchar(14)NO
last_page_urlvarchar(255)NO

Table: zip_code

Description here

Field Type Null Key Default Auto Increment
zip_codevarchar(10)NOPRI
latitudefloat(10,6)NO
longitudefloat(10,6)NO
cityvarchar(64)NO
state2varchar(64)NO
statesmallint(5)NO

Table: zip_code_search

Description here

Field Type Null Key Default Auto Increment
zip_codevarchar(10)NOMUL
radiussmallint(2)NO
statetextNO
inserteddateNO

Table: zones

Description here

Field Type Null Key Default Auto Increment
zone_idint(11)NOPRI auto_increment
zone_country_idint(11)NOMUL0
zone_codevarchar(32)NO
zone_namevarchar(64)NO
fr_zone_namevarchar(64)NO
Main Page
About Jobsite Software
Help files
Developer Documentation
Personal tools