Home arrow MySQL arrow Page 6 - The Perfect Job (part 1)

Lucky Thirteen - MySQL

Recruitment - the art of matching qualified applications to openpositions within an organization - is one of the most challenging tasks forany Human Resources department. However, powerful open-source tools likePHP and mySQL have made the process simpler, more efficient and moreeconomical than at any time in the past. This case study demonstrates how,by building a complete job listing and resume management system fromscratch.

TABLE OF CONTENTS:
  1. The Perfect Job (part 1)
  2. An Ideal World
  3. Entry Point
  4. Going To The Database
  5. The Five Rs
  6. Lucky Thirteen
  7. Building The Foundation
  8. The Devil Is In The Details
  9. Applying Yourself
  10. Testing Times
  11. Filing It All Away
By: icarus, (c) Melonfire
Rating: starstarstarstarstar / 4
June 28, 2001

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement
Finally, I have some ancillary tables which store country lists, industry lists, subject lists and the like. Again, these have been placed in separate tables and linked via foreign keys to simplify customizing the application for diverse needs. Here they are:

# # Table structure for table 'country' # DROP TABLE IF EXISTS country; CREATE TABLE country ( id tinyint(4) unsigned NOT NULL auto_increment, country varchar(255) NOT NULL, PRIMARY KEY (id) ); # # id - unique record identifier # country - country name # # # Dumping data for table 'country' # INSERT INTO country (id, country) VALUES ( '', 'Afghanistan'); INSERT INTO country (id, country) VALUES ( '', 'Albania'); # # Table structure for table 'degree' # DROP TABLE IF EXISTS degree; CREATE TABLE degree ( id tinyint(3) unsigned NOT NULL auto_increment, degree varchar(255) NOT NULL, PRIMARY KEY (id) ); # # id - unique record identifier # degree - degree type # # # Dumping data for table 'degree' # INSERT INTO degree (id, degree) VALUES ( '1', 'High School degree'); INSERT INTO degree (id, degree) VALUES ( '2', 'Undergraduate degree'); INSERT INTO degree (id, degree) VALUES ( '3', 'Bachelor\'s degree'); # # Table structure for table 'industry' # DROP TABLE IF EXISTS industry; CREATE TABLE industry ( id tinyint(4) unsigned NOT NULL auto_increment, industry varchar(255) NOT NULL, PRIMARY KEY (id) ); # # id - unique record identifier # industry - industry type # # # Dumping data for table 'industry' # INSERT INTO industry (id, industry) VALUES ( '1', 'Advertising'); INSERT INTO industry (id, industry) VALUES ( '2', 'Agriculture and Forestry'); # # Table structure for table 'subject' # DROP TABLE IF EXISTS subject; CREATE TABLE subject ( id tinyint(3) unsigned NOT NULL auto_increment, subject varchar(255) NOT NULL, PRIMARY KEY (id) ); # # id - unique record identifier # subject - subject name # # # Dumping data for table 'subject' # INSERT INTO subject (id, subject) VALUES ( '', 'Accounting'); INSERT INTO subject (id, subject) VALUES ( '', 'Actuarial Science');
The "jobs.sql" file in the source code archive contains a longer list of items for these ancillary tables.

How many tables is that? Well, Joe, it's lucky number thirteen! Whoopee!

This article copyright Melonfire 2001. All rights reserved.

 
 
>>> More MySQL Articles          >>> More By icarus, (c) Melonfire
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: