See interspersed. --- [EMAIL PROTECTED] wrote: > Let's do this verbally and maybe the database > structure will become > intuitively apparent.... > > You are hosting a website that supports job seekers > (maybe more but let's > concentrate on just this side of it)
Yep, there is the employer side. Hopefully I can easily translate my knowledge base over. > > Each seeker (a User) can have a profile in the > system Each user (job seeker) can have 5 profiles. > Each profile describes who the User is (name), where > they are (address, > email address) and how to contact them (main phone, > cell phone) Yes and no. Profiles maybe created to target different types of jobs. i.e. I'm a salesman, I've worked in the software industry (don't laugh), but also in the Human Resources industry. Profile 1 reflects that I'm interested in software, Profile 2 reflects that I want to go back to HR. Another exmaple, I want full time work as a salesman, but until the right spot comes along I'll take part time work as a consultant. Profile 1 reflect that I'm interested in full time sales work. Profile 2 that I want part time consulting. Some of the fields are optional. Last example - I was a research scientist at NASA, but out of work, still interested in science, but will take anything. Profile 1 reflects Multiple Doctorates, Profile 2 shows High School Diploma , highest level. Now no one is forced to enter 5, it's an option. > Associated with each user is a list of up to 10 > industries they have > belonged to. Now here is where each profile has another level to it. I'm a C## developer, and I've worked in the Airlines, Hospitality and Financial Industry. Maybe Fiancial pays best, but I'm willing to explore other industries, or due to an employers orientation, best to choose as many possible industries that may result in a match. So there are mulitple options on certain criteria within each profile. Industry, Location and Pay type (tax term, i.e. contract, full time, contract too full time) They may not have been associated with the industries before or live in a particular location but they are throwing their gloves into those areas to increase their chance of employment. > Associated with each user is up to 5 resumes. Each profile has 1 resume. 5 Profiles = 5 resumes, but each resume should be tied into the particular profile it's part of. > Each user can be looking for employment in any of 5 > locations Well 2, 5 , haven't made my mind up, but it will be multiple > Each user can be looking for employment in any of 5 > industries See above and way above. Yes, multiple industries. > Each user can look for employment under up to 5 > different job titles. Slight different here. There is a "current" or most recent , a desired one, maybe the same as current. Also an alternate. > > Please take the time to correct me and fill in any > gaps. Please DO NOT attempt to make any data > definitions at this stage. > I need to understand > what data you are going to maintain verbally before > I can help you > translate it into storage requirements. Up to you, only a suggestion if you haven't seen a job board or looked at one closer. Dice.com , Monster, CareerBuilders, all have pretty much the same standard. Essentially , the more a user fills in on their profile, the more they answer, better the chances of finding opportunities. At the same time, the more field information avaiable about users/job seekers, the more refined a search can be before resumes are text searched or pulled up. Hopefully now my original question about tying all the responses / data from one profile together is important. Let me know if this is clearer. Thank you. Stuart - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
