Category: Documentation

Job Board Software Documentation

  • Class Reference

    AI Tutorials
    View Demo

    Class Reference

    Class : block_ip_address

    Blocks an ip address range from database

     
    Variables
    none
    Functions
    constructor : block_ip_address
    void block_ip_address( void )
    Read ip addresses from ipadress_block table and print error message if the user is blocked
    lock
    bool lock( $ip , $ip1 , $ip2)
    Check whether user ip address should be blocked or not

    Class : configuration

    Load configuration from database into constant variables

     
    Variables
    none
    Functions
    constructor : configuration
    void configuration( void )
    Read configuration table and define them as php constants

    Class : left_box

    Form left vertical menu or sidebar in admin panel

     
    Extends
    tableBlockLeft
    Variables
    heading
    Associative array storing info about menu items

     $heading  [$index]   ['link']
                      ['text']
    contents
    Associative array storing info about sub-menu items which opens when a particular menu is active

     $contents [$index]   ['link']
                      ['text']
    Functions
    constructor : left_box

    Reset menu and sub-menu 

    void left_box( void )
    menuBox

    Returns left aligned vertical menu and sub-menu markups as single string 

    string menuBox( $heading , $contents)

    Class : messageStack

    Create custom notifications

     
    Extends
    tableBlock
    Variables
    size
    Number of errors
    errors
    Associative array storing error content and html attributes

     $contents [$index]   ['params']
                      ['text']
    Functions
    constructor : messageStack
    void messageStack( void )
    Move notifications from session vars to class vars
    add
    void add( $message, $type = 'error' )
    Determine type of notification and copy them to local variable with HTML styling
    add_session
    void add_session( $message, $type = 'error' )
    Create session variable for notification
    reset
    void reset( void )
    Reset class variables
    output
    string output( void )
    Form html table markup for notification
    size
    int size( string $class )
    Find number of messages having a particular type/class eg error type/class

    Class : right_box

    Form left vertical menu or sidebar in admin panel

     
    Extends
    tableBlockRight
    Variables
    heading
    Markup of infobox heading
    contents
    Markup of infobox body, which is a form inside table
    Functions
    constructor : right_box
    void right_box( void )
    Reset heading and body variables
    infoBox
    string menuBox( $heading , $contents )
    Return heading and body HTML markups as one single string

    Function : block_ip_address

    Form generic table in html

     
    Variables
    table_border
    Border in pixels
    table_width
    Width param of table
    table_cellspacing
    Cell spacing attribute of table
    table_cellpadding
    Cell padding attribute of table
    table_parameters
    Additional atributes of table
    table_row_parameters
    Attributes for row of table ie tr
    table_data_parameters
    Attributes of table data ie td
    Functions
    constructor : tableBlock
    void tableBlock( array contents )
    Form generic table HTML markup

    Class : tableBlockLeft

    Form left aligned table in html

     
    Variables
    table_border
    Border in pixels
    table_width
    Width param of table
    table_cellspacing
    Cell spacing attribute of table
    table_cellpadding
    Cell padding attribute of table
    table_parameters
    Additional atributes of table
    table_row_parameters
    Attributes for row of table ie tr
    table_data_parameters
    Attributes of table data ie td
    Functions
    constructor : tableBlockLeft
    void tableBlockLeft( array contents )
    Form left aligned table HTML markup

    Class : tableBlockRight

    Form right aligned table in html

     
    Variables
    table_border
    Border in pixels
    table_width
    Width param of table
    table_cellspacing
    Cell spacing attribute of table
    table_cellpadding
    Cell padding attribute of table
    table_parameters
    Additional atributes of table
    table_row_parameters
    Attributes for row of table ie tr
    table_data_parameters
    Attributes of table data ie td
    Functions
    constructor : tableBlockRight
    void tableBlockRight( array contents )
    Form right aligned table HTML markup

  • Function Reference

    AI Tutorials
    View Demo

    Function Reference

    Function : add

     
    Description 
    void add( $message, $type = 'error' )

    Member function of class messageStack
    Create session variable for notification

    Parameters

    message string

    Notification message to be displayed

    type string

    Type of notification, Default is ‘error’
    Flowchart

    Source Code

    Function : add_session

     
    Description 
    void add_session( $message, $type = 'error' )

    Member function of class messageStack
    Create session variable for notification

    Parameters

    message string

    Notification message to be displayed

    type string

    Type of notification, Default is ‘error’
    Flowchart

    Source Code

    Function : block_ip_address

     
    Description 
    void block_ip_address( void )

    Constructor of class block_ip_address
    Read ip addresses from ipadress_block table and print error message if the user is blocked

    Flowchart

    Source Code

    Function : configuration

     
    Description 
    void configuration( void )

    Constructor of class configuration
    Read configuration table and define them as php constants

    Flowchart

    Source Code

    Function : infoBox

     
    Description 
    string infoBox( string $heading , string $contents )

    Member function of class right_box
    Return right aligned heading and body HTML markups as single string

    Parameters

    heading string

    HTML markup of infobox heading

    contents string

    HTML markup of infobox body which is a form inside a table
    Return

    string contaning html markup of right side info box and its body

    Flowchart

    Source Code

    Function : left_box

     
    Description 
    void left_box( void )

    Constructor of class left_box

    Reset menu and sub-menu

    Flowchart

    Source Code

    Function : lock

     
    Description 
    bool lock( string $ip , string $ip1 , string $ip2)

    Member function of class block_ip_address
    Check whether user ip address should be blocked or not

    Parameters

    ip string

    User IP address to be checked

    ip1 string

    Lower bound of IP address range to be blocked

    ip2 string

    Upper bound of IP address range to be blocked
    Return

    true when user should be blocked and false when user should be allowed

    Flowchart

    Source Code

    Function : menuBox

     
    Description 
    string menuBox( array $heading , array $contents)

    Member function of class left_box
    Returns left aligned vertical menu and sub-menu markups as single string

    Parameters

    heading array

    Associative array storing info about menu items

     $heading  [$index]   ['link']
                      ['text']

    contents array

    Associative array storing info about sub-menu items which opens when a particular menu is active

     $contents [$index]   ['link']
                      ['text']
    Return

    string contaning html markup of left side menu and its sub-menu

    Flowchart

    Source Code

    Function : messageStack

     
    Description 
    void messageStack( void )

    Constructor of class messageStack
    Move notifications from session vars to class vars

    Flowchart

    Source Code

    Function : output

     
    Description 
    string output( void )

    Constructor of class messageStack
    Form html table markup for notification

    Return

    string Return html table markup for notification

    Flowchart

    Source Code

    Function : reset

     
    Description 
    void reset( void )

    Member function of class messageStack
    Reset class variables

    Flowchart

    Source Code

    Function : right_box

     
    Description 
    void right_box( void )

    Constructor of class right_box
    Reset menu and sub-menu

    Flowchart

    Source Code

    Function : size

     
    Description 
    int size( string $class )

    Member function of class messageStack
    Find number of notifications having a particular type/class eg error type/class

    Parameters

    class string

    The class style name for the notification which is same as the type of the notification
    Return

    int number of matched notifications

    Flowchart

    Source Code

    Function : tableBlock

     
    Description 
    string tableBlock( array $contents )

    Constructor of class tableBlock
    Form generic table HTML markup

    Parameters

    contents array

    Store table data values and column parameters 

     $contents['form']
	  [$row_index]	['params']
	     		['text']
			[$column_index]	['params']
					['text']
					['align']
					['form']
    Return

    string containing HTML markup of desired generic table

    Flowchart

    Source Code

    Function : tableBlockLeft

     
    Description 
    string tableBlockLeft( array $contents )

    Constructor of class tableBlockLeft
    Form left aligned table HTML markup

    Parameters

    contents array

    Store table data values and column parameters 

     $contents['form']
	  [$row_index]	['params']
	     		['text']
			[$column_index]	['params']
					['text']
					['align']
					['form']
    Return

    string containing HTML markup of desired left aligned table

    Flowchart

    Source Code

    Function : tableBlockRight

     
    Description 
    string tableBlockRight( array $contents )

    Constructor of class tableBlockRight
    Form left aligned table HTML markup

    Parameters

    contents array

    Store table data values and column parameters 

     $contents['form']
	  [$row_index]	['params']
	     		['text']
			[$column_index]	['params']
					['text']
					['align']
					['form']
    Return

    string containing HTML markup of desired right aligned table

    Flowchart

    Source Code

  • Database Description

    AI Tutorials
    View Demo

    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

  • Ejobsite API

    AI Tutorials
    View Demo


    Wiki · API reference

    ejobsitesoftware.com API reference

    Integrate your job board with external systems and mobile apps using the ejobsitesoftware.com REST API. Authenticate users, search and apply for jobs, post jobs, and read resumes and application history — all through simple HTTP endpoints. Below is the full endpoint reference with parameters and examples.

    Try the demoDeveloper wiki
    RESTHTTP POSTAccess-key auth12 endpoints

    What is the ejobsitesoftware.com API?

    The ejobsitesoftware.com API is a set of REST endpoints that let external applications and mobile apps talk to an ejobsitesoftware.com job board — logging users in, registering job seekers, searching jobs, applying to jobs, posting jobs, and reading resumes and application history. Requests are made as HTTP POST calls, and most actions are protected by an access key you obtain when a user logs in.

    Base URL (demo)https://www.ejobsitesoftware.com/jobboard_demo/app/

    On your own installation, replace the demo host with your domain — for example https://your-jobboard.com/app/. The endpoint paths stay the same.

    API providers and integrations configured in the ejobsitesoftware.com admin panel

    Authentication

    How access keys work

    Most endpoints require an access key. The flow is simple.

    Log in

    POST to jobseeker_login or recruiter_login with email and password.

    Get an access key

    On success, the response returns an access_key for the session.

    Call & log out

    Send access_key with each request, then logout to end the session.

    curl — job seeker login
    curl -X POST "https://www.ejobsitesoftware.com/jobboard_demo/app/jobseeker_login/" \
  -d "act=check" \
  -d "email_address=you@example.com" \
  -d "password=your_password"
# success returns an access_key to use on later calls

    Quick reference

    All endpoints at a glance

    Every endpoint uses the POST method. Full parameters are listed in the sections below.

    ejobsitesoftware.com API endpoints (base path /app/)
    Method Endpoint Purpose Auth
    POST /jobseeker_login/ Log a job seeker in —
    POST /recruiter_login/ Log a recruiter in —
    POST /logout/ End the session access_key
    POST /jobseeker_info/ Get logged-in job seeker info access_key
    POST /jobseeker_reg/ Register or update a job seeker partial
    POST /jobseeker_resumes/ List a job seeker’s resumes access_key
    POST /search/ Search jobs —
    POST /apply_job/ Apply to a job access_key
    POST /applyed_jobs/ List applied jobs access_key
    POST /job_countries/ List job countries —
    POST /recruiter_info/ Get logged-in recruiter info access_key
    POST /add_job/ Post a job access_key

    Reference

    Endpoints in detail

    Parameters marked required must be sent; optional ones may be omitted.

    Authentication

    POST/app/jobseeker_login/

    Authenticate a job seeker and receive an access key.

    • actrequired — set to check.
    • email_addressrequired — the job seeker’s email.
    • passwordrequired — the account password.
    POST/app/recruiter_login/

    Authenticate a recruiter and receive an access key.

    • actrequired — set to check.
    • email_addressrequired — the recruiter’s email.
    • passwordrequired — the account password.
    POST/app/logout/

    End the current session.

    • access_keyrequired — the session access key.

    Job seeker

    POST/app/jobseeker_info/

    Return the logged-in job seeker’s profile information.

    • access_keyrequired — the session access key.
    POST/app/jobseeker_reg/

    Register a new job seeker or update an existing profile.

    • actrequired — register for a new account or update to edit.
    • email_addressrequired — the job seeker’s email.
    • passwordrequired — required for a new registration.
    • access_keyupdate — required when updating an existing profile.
    • first_namerequired — the job seeker’s first name.
    • last_nameoptional — the job seeker’s last name.
    • address1required — address line.
    • countryrequired — numeric country id.
    • stateoptional — state or region.
    • cityrequired — city.
    • mobileoptional — mobile number.
    POST/app/jobseeker_resumes/

    List the resumes belonging to the logged-in job seeker.

    • access_keyrequired — the session access key.

    Returns: an array of resume_id and resume_title on success.

    POST/app/apply_job/

    Apply to a job with a selected resume.

    • access_keyrequired — the session access key.
    • job_idrequired — the job to apply to.
    • resume_idrequired — the resume to submit.
    POST/app/applyed_jobs/

    List the jobs the job seeker has applied to.

    • access_keyrequired — the session access key.

    Returns:jobID, apply_id, job_title, and apply_date on success.

    Recruiter

    POST/app/recruiter_info/

    Return the logged-in recruiter’s profile information.

    • access_keyrequired — the session access key.
    POST/app/add_job/

    Post a new job to the board (recruiter access key required).

    • access_keyrequired — the recruiter session access key.
    • job_titlerequired — the job title.
    • job_countryrequired — numeric country id (existing on site) or free text.
    • job_short_descriptionrequired — a short summary.
    • job_descriptionrequired — the full job description.
    • referenceoptional — free-text reference.
    • stateoptional — free-text state.
    • locationoptional — free-text location.
    • salaryoptional — free-text salary.
    • job_industryoptional — numeric industry id (existing on site).
    • job_experienceoptional — experience in months (numeric).
    • job_typeoptional — existing job type on site.
    • skillsoptional — job tags/skills.
    • job_durationoptional — number of days to show the job (numeric).

    Search & data

    POST/app/job_countries/

    List the countries available for jobs.

    • actrequired — set to list.

    Returns:id and name for each country on success.

    Example

    Posting a job

    A recruiter posts a job with the required fields after logging in.

    curl — add a job
    curl -X POST "https://www.ejobsitesoftware.com/jobboard_demo/app/add_job/" \
  -d "access_key=RECRUITER_ACCESS_KEY" \
  -d "job_title=Senior PHP Developer" \
  -d "job_country=US" \
  -d "job_short_description=Build and maintain our job board" \
  -d "job_description=Full description of the role..." \
  -d "salary=Competitive" \
  -d "skills=PHP,MySQL,REST" \
  -d "job_duration=30"

    Tip: numeric-id fields like job_country, job_industry, and job_category accept ids that already exist on your site. Some fields (like job_country) also accept free text. Check the database description for valid ids.

    Answers

    Frequently asked questions

    What is the ejobsitesoftware.com API?
    A set of REST endpoints that let external applications and mobile apps integrate with an ejobsitesoftware.com job board — logging users in, registering job seekers, searching jobs, applying to jobs, posting jobs, and reading resumes and application history.
    What is the API base URL?
    Endpoints live under the /app/ path of your job board. The demo uses https://www.ejobsitesoftware.com/jobboard_demo/app/. On your own install, replace the demo host with your domain, e.g. https://your-jobboard.com/app/.
    How does authentication work?
    Call the login endpoint (jobseeker_login or recruiter_login) with email and password. On success you receive an access_key. Pass that key with later requests, and call logout to end the session.
    What format are the API requests?
    HTTP POST calls with parameters. Several endpoints also take an act parameter to select an action, such as act=check for login or act=search for search.
    How do I post a job through the API?
    Use add_job with a valid recruiter access_key. Required fields are job_title, job_country, job_short_description, and job_description, with optional fields like salary, location, industry, experience, skills, and duration.
    How do I search for jobs?
    Call search with act=search and optional filters such as keyword, country, state, location, and job_category. Use start_index to page through results; it defaults to 0.
    Can job seekers apply through the API?
    Yes. After logging in, list resumes with jobseeker_resumes, then call apply_job with the access_key, job_id, and resume_id. applyed_jobs returns the application history.
    Where are the rest of the developer docs?
    The wiki links the full developer documentation — theme development, the database description, the function reference, and the class reference — which support custom development and integrations.

    Keep exploring

    Resources & related pages

    DocsDeveloper wikiAll documentation in one place.ReferenceDatabase descriptionData structure and ids.ReferenceFunction referenceFunctions and usage.ReferenceClass referenceClasses in the codebase.FeaturesAPI featuresWhat the API enables.DemoLive demoSee the board the API drives.

    Build on the ejobsitesoftware.com API

    Authenticate, search, apply, and post jobs from any app — with full source code and documented endpoints. Try the demo, or explore the wider developer wiki.

    Try the demoContact us
    Self-hosted · Full source code · One-time from $600 · info@ejobsitesoftware.com · +91 98103 36906

  • Wiki

    AI Tutorials
    View Demo



    Developer Wiki & Documentation: API, Themes & Reference | ejobsitesoftware.com
















    Support · Developer wiki

    Developer wiki & documentation

    Everything you need to build on, extend, and customize ejobsitesoftware.com job board software — in one place. Dive into the API reference, learn theme development, and explore the database, function, and class references, backed by step-by-step tutorials.

    Open the API docs
    Try the demo
    API reference
    Theme development
    Full source code
    Tutorials

    ejobsitesoftware.com job board admin dashboard the documentation covers

    About ejobsitesoftware.com software

    ejobsitesoftware.com is a web-based application that lets you quickly deploy a fully functional, advanced job board or job site. It can power niche job sites for specific countries, regional job sites, or a general job site — and because it ships self-hosted with full source code, every deployment can be customized to the client’s requirements. This wiki is where developers find the references and guides to do exactly that.

    Documentation

    Start building

    Guides for customizing the look and behaviour of your job board.

    Developer guides

    ejobsitesoftware.com API

    Endpoints for job posting, imports, users, search, and applications.

    Open →

    Theme development

    Build and customize job board themes, layouts, and templates.

    Open →

    Tutorials

    Step-by-step guides to get started with the software.

    Open →

    API reference

    Database description

    The data structure and tables behind the platform.

    Open →

    Function reference

    Available functions and how to use them in your code.

    Open →

    Class reference

    Documentation of the classes in the codebase.

    Open →

    API

    Integrate your job board with anything

    The ejobsitesoftware.com API lets you post and import jobs, manage users, search listings and resumes, and submit applications from external systems and mobile apps. Pair it with the database, function, and class references for deeper custom development.

    See API features →

    API providers configuration in the ejobsitesoftware.com admin

    At a glance

    Documentation overview

    ejobsitesoftware.com developer documentation sections
    Section What it covers For
    ejobsitesoftware.com API Endpoints for jobs, imports, users, search, and applications. Integrators
    Theme development Building and customizing themes and layouts. Front-end devs
    Database description Data structure and tables. Back-end devs
    Function reference Functions and usage. Developers
    Class reference Classes in the codebase. Developers
    Tutorial Getting-started walkthroughs. Everyone

    Answers

    Frequently asked questions

    What is the ejobsitesoftware.com wiki?
    The developer documentation hub for the job board software. It gathers the API reference, theme development guide, database description, function reference, class reference, and tutorials in one place so developers can build on and customize the platform.
    What is ejobsitesoftware.com software?
    A web-based application that lets you quickly deploy a fully functional, advanced job board or job site — for a specific country, a region, or a general audience — customized to each client’s requirements.
    Where is the API documentation?
    The ejobsitesoftware.com API section documents endpoints for job posting, imports, user management, search, and application submission, supported by the database, function, and class references for deeper integration.
    How do I develop or customize a theme?
    The theme development guide explains how to build and customize the look of your job board — layouts, templates, and styling — so you can match your brand.
    What are the database, function, and class references?
    The database description documents the data structure, the function reference lists available functions and their usage, and the class reference documents the classes in the codebase — together supporting custom development.
    Is there a tutorial to get started?
    Yes. The tutorial section walks you through getting started, and you can try the live demo to explore features hands-on before diving into the code.
    Do I get the full source code?
    Yes. ejobsitesoftware.com is self-hosted and ships with full source code, so developers can read the references, customize the platform, and integrate it with other systems.
    Where can I try a demo?
    Explore the software in the live demo linked throughout the site — it lets you see the job seeker, employer, and admin areas before you build.

    Keep exploring

    Resources & related pages

    Features
    API features
    What the REST API can do.


    Support
    Tutorial
    Get started step by step.


    Design
    Themes
    Ready-made theme designs.


    Support
    FAQs
    Common product questions.


    Product
    Job board software
    The platform overview.


    Demo
    Live demo
    Explore before you build.

    Build on a platform you fully own

    Self-hosted, full source code, and documented end to end. Open the API docs to start integrating, or try the live demo to see what you’re building on.

    Open the API docs
    Contact us
    Self-hosted · Full source code · One-time from $600 · info@ejobsitesoftware.com · +91 98103 36906


  • Theme Development

    AI Tutorials
    View Demo


    Wiki · Theme development

    Theme development guide

    Build a custom job board theme with complete control over layout, presentation, and design. This developer guide walks through the theme structure of ejobsitesoftware.com software — how the homepage renders, which files a theme needs, and how the header, footer, and helper files fit together — with real code examples.

    Try the demoDeveloper wiki
    PHPHTML / CSSJavaScriptAdvanced

    This is a technical document. Developing a custom theme requires a good knowledge of advanced PHP, HTML, CSS, and JavaScript, and isn’t meant for non-technical users. If you’d rather not code, browse the ready-made theme gallery or read what themes are and how to change them.

    What are ejobsitesoftware.com themes?

    Themes are a collection of PHP scripts, HTML/CSS files, and images that live under the themes folder at the site root, in a folder named after the theme. For example, a theme called Demo lives at ROOT/themes/demo. The theme files are interlinked and hooked together to form the actual website.

    Why develop themes

    Reasons to build your own

    Total control

    Own the layout, presentation, and every design element.

    Tweak existing themes

    Adjust a gallery theme to your own and your domain’s taste.

    Unique requirements

    Build for needs too specific to find in the theme gallery.

    Migrate a site

    Move from a non-platform site to an ejobsitesoftware.com-powered one.

    Out-of-box ideas

    Implement creative concepts on top of the software.

    Reusable structure

    Create a robust, extensible base you can build on.

    Theme structure

    How the homepage renders

    A minimal theme needs just two files — and the homepage is rendered at two levels.

    The two essential files are text.htm, which is responsible for the basic layout of the homepage — where the banner, menu, footer, and other elements are placed — and home.php, which paints what resides inside those elements, like the login form, job search, welcome text, and latest jobs section.

    text.htm — the structure

    This file controls the homepage structure. It looks like an HTML file with placeholders enclosed in curly braces (for example {PLACEHOLDER}). The basic website structure is clear from it.

    text.htm theme structure showing homepage placeholders and layout

    The text.htm layout, with placeholders marking where each homepage element goes.

    home.php — the content

    This file controls what’s inside each placeholder. It substitutes whatever HTML needs to go in place of the placeholders in text.htm, using the assign_vars method of the $template object of the Template class. To assign HTML to {PLACEHOLDER}, generate the HTML into a variable (say $placeholder_html) and assign it:

    home.php — assign HTML to a placeholder
    $template->assign_vars(array(
    'PLACEHOLDER' => $placeholder_html
));

    Recommended files

    Header, footer & stylesheet

    For a full-featured theme — not just a static homepage — add a few more files for a robust, extensible structure.

    Every website has two elements global to all pages: the header and the footer. They must appear on every page. A file called body.php (not itself a theme file) assigns values to the {HEADER_HTML} and {FOOTER_HTML} placeholders — just like home.php — and is included on every page automatically.

    body.php — assigns the global header & footer
    <?php
$template->assign_vars(array(
  'HEADER_HTML' => HEADER_HTML,   // defined in header.php
  'FOOTER_HTML' => FOOTER_HTML    // defined in footer.php
));
?>

    header.php

    The header is a global element covering everything up to the opening <body> tag (the DOCTYPE, opening HTML tag, and HEAD section), the banner HTML (which includes the site logo), and the menu bar HTML. A minimal header.php defines the data for {HEADER_HTML}.

    header.php — minimal
    <?php
define('HEADER_HTML', '<!DOCTYPE html>
<html lang="en">
  <head>
    <!-- meta tags -->
    <!-- CSS calling -->
  </head>
  <body>
    <nav class="navbar navbar-expand-lg navbar-dark bg-dark fixed-top">
      <div class="container">
        <div id="banner"><!-- BANNER DATA --></div>
        <ul id="menu">
          <li><!-- MENU ITEM 1 --></li>
          <li><!-- MENU ITEM 2 --></li>
          <li><!-- MENU ITEM 3 --></li>
        </ul>
      </div>
    </nav>');
?>

    footer.php

    The footer is also global and may include a copyright link, social media sharing, RSS feeds, links to the disclaimer and privacy policy, and sometimes a small sitemap. A minimal footer.php defines the data for {FOOTER_HTML}.

    footer.php — minimal
    <?php
define('FOOTER_HTML', '<div class="container-fluid border-top border-bottom py-3 footer">
    &copy; ' . date('Y') . ' by <a href="https://www.mywebsite.com">My Website</a>
    <!-- Social Media Links -->
    <!-- Other Links -->
    <!-- RSS publishing link -->
  </div>');
?>

    stylesheet.css

    It’s recommended to separate theme-specific design features into a CSS file. You can create and maintain more than one stylesheet inside a folder.

    Helper files

    Miscellaneous theme files

    These are optional — their absence causes no problems — but they add useful features without altering theme functionality.

    index.php

    Not part of theme development itself, this is a small security feature. It redirects anyone trying to reach the theme folder one directory back — so a user browsing to {ROOT}/themes/defaulttheme bounces back to {ROOT}/themes, whose own index.php sends them back again to the homepage. Directory listing is already prevented by directory permissions; this is just a friendlier way to say access isn’t allowed.

    index.php — folder guard
    <?php header('../'); ?>

    screenshot.gif

    A screenshot of the theme’s homepage, shown as a thumbnail in the admin panel’s theme-choosing screen so a theme can be visually recognized. If absent, no thumbnail is shown.

    info.txt

    Holds information about the theme — its name, description, and version — displayed in the admin panel’s theme selection screen, in this format:

    info.txt
    Theme Name: Default theme
Description: This is the default theme for ejobsitesoftware.com Software.
Version: 1.0

    If absent, the theme folder name is displayed as the theme name and the rest of the information is not shown.

    Theme-specific images

    Store theme-related images inside a folder named images within the theme directory. Only theme-dependent images (bullets, backgrounds, buttons, icons) belong there. Images that are part of the website itself — like the logo and product images — should go in {ROOT}/images so they can be shared across all themes.

    Reference

    Theme files at a glance

    Files that make up an ejobsitesoftware.com theme (in ROOT/themes/<theme>)
    File Role Purpose
    text.htm Required Homepage structural layout with placeholders.
    home.php Required Fills homepage placeholders with HTML via assign_vars.
    header.php Recommended Defines the global header (DOCTYPE, banner, menu).
    footer.php Recommended Defines the global footer (copyright, social, links).
    stylesheet.css Recommended Theme-specific styles; multiple allowed.
    index.php Optional Security redirect out of the theme folder.
    screenshot.gif Optional Thumbnail in the admin theme picker.
    info.txt Optional Theme name, description, and version for admin.
    images/ Optional Theme-dependent images (bullets, icons, backgrounds).

    Answers

    Frequently asked questions

    What are ejobsitesoftware.com themes?
    A collection of PHP scripts, HTML/CSS files, and images under the themes folder at the site root, in a folder named after the theme (e.g. ROOT/themes/demo). The files are interlinked to form the actual website.
    Do I need coding skills to develop a theme?
    Yes. It requires a good knowledge of advanced PHP, HTML, CSS, and JavaScript. Non-technical users can pick from the ready-made theme gallery or request a custom theme instead.
    What files does a minimal theme need?
    Two: text.htm, which defines the homepage layout with placeholders, and home.php, which fills those placeholders with HTML for elements like the login form, job search, welcome text, and latest jobs.
    What is text.htm?
    It controls the homepage structure — an HTML-like file with placeholders in curly braces such as {PLACEHOLDER} that determine where the banner, menu, and footer are placed.
    What is home.php?
    It controls what goes inside the placeholders, substituting HTML for them using the assign_vars method of the $template object.
    How are the header and footer handled?
    header.php defines HEADER_HTML (everything up to the opening body tag, plus banner and menu) and footer.php defines FOOTER_HTML. A body.php file automatically assigns these to the {HEADER_HTML} and {FOOTER_HTML} placeholders on every page.
    What do screenshot.gif and info.txt do?
    screenshot.gif is the theme thumbnail shown in the admin theme picker; info.txt holds the theme name, description, and version shown there. If absent, the folder name is used and no thumbnail appears.
    Where should theme images be stored?
    Theme-dependent images (bullets, backgrounds, buttons, icons) go in an images folder inside the theme directory. Website images like the logo and product images go in {ROOT}/images to be shared across all themes.

    Keep exploring

    Resources & related pages

    DocsDeveloper wikiAll documentation in one place.ReferenceAPI referenceREST endpoints for your board.ReferenceDatabase descriptionData structure and ids.DesignThemesReady-made theme gallery.DesignCustom homepageA bespoke branded homepage.DemoLive demoSee a theme in action.

    Build a theme, own every pixel

    Self-hosted with full source code, ejobsitesoftware.com lets you craft custom themes end to end. Explore the developer wiki, or start from a ready-made theme in the gallery.

    Open the wikiBrowse themes
    Self-hosted · Full source code · One-time from $600 · info@ejobsitesoftware.com · +91 98103 36906