Please refer to the structural design of a table (hope you seriously consider)
	I think this is a matter more than the actual examinations OCP (I encountered in the actual work) Conditions : An occupational classification, an industry classification A company table, a table vacancies, a look-up table Companies belonging to a maximum of three industries The largest one in three job vacancies Inquiries Inquiries can be a maximum of three industries, three professional Will companies and professional table, the table is how to design? The first method (together) Company table Id Industry1 Industry2 Industry3 Career Id Jobfamily1 Jobfamily2 Jobfamily3 Search Id Industry1 Industry2 Industry3 Jobfamily1 Jobfamily2 Jobfamily3 The second method used the methodology from the main Company Id Companyindsutry Companyid Industry Career Id Careerjobfamily Careerid Jobfamily Search Id Searchindustry Searchid Industry Searchjobfamily Searchid Jobfamily Or, do you have any other good suggestions? (I do not know what I wrote is not sufficiently clear) Progress together
	Re : Please refer to the structural design of a table (hope you seriously consider)
	That really is not very good, I do not quite understand Companies belonging to a maximum of three industries The largest one in three job vacancies Inquiries Inquiries can be a maximum of three industries, three professional Table-logic design to reflect these needs? Instead of using SQL statements? List number has been settled?
	Re : Please refer to the structural design of a table (hope you seriously consider)
	I think you had better give an example to explain : employment, industry Companies, the number of job vacancies, the search these, I really Still not very clear what you mean. For example : Companies belonging to a maximum of three industries The largest one in three job vacancies This is what it meant, how vacancies? ---------- The world is sad, toils see a visitor out booths. Spring to know other hardships, removal beaten Green.
	Re : It seemed necessary to explain to explain
	：） I do think that each of these topics interest, it is not clear. Companies belonging to a maximum of three industries : For companies in the industry Example : Siemens company, is the power industry, it may also be IT industry, but also the communications industry Why set so many? Because they hope to find more people to search through Siemens Through any of the three sectors to find Belong to a wide range of the three types of work In terms of opportunities for employment (Vacancies) Example : : Assistant general manager may be middle management, human resources or finance officer Similarly it is hoped that users will find this more convenient posts Inquiries equivalent to looking for work, and job search company, but this time I clear? Progress together
	Re : It seemed necessary to explain to explain
	I find this interesting, I still do not know what you want to achieve? The design is what you use? What query? For companies and a professional table, a table can be used as : TABLE1 (Name of the company or job title -- Category, the names of companies or professional distinction -- such as 0001 on behalf of the company, representatives of the Occupational 0002 COL1, the company's business -- or, are three kinds of COL2. COL3) -- We hope to continue the discussion. ---------- The world is sad, toils see a visitor out booths. Spring to know other hardships, removal beaten Green.
	Re : website dedicated job! ! !
	:) For example zhaopin.com, chinaHR.com, 51job.com Some find work in the above, there will be jobs in the above release information. The message of these companies is on the table inside the company. Vacancies in these companies is the opportunity to work on a table inside (we call it vacancy). Job seekers looking for work, not always got to be on the website, job seekers can set conditions Under these conditions set by the website regularly send mail to the applicant's mailboxes. These conditions are stored, tables, we told him PSA (personal search agent) For inquiries, including the general conditions of work (3), the industry (3), the type (3), as well as keyword (Oracle), advertising publication time In order to allow more people to find a company can have multiple industries, a number of types of jobs can be. Inquiries can be a condition for a number of trades, a number of types of work. . . This is my first posted a detailed explanation, I would like to know is how to design companies and jobs Table And tables, is to call the shots from the table in accordance with the design paradigm, or a redundancy on the table Inside? Progress together
	Re : Please refer to the structural design of a table (hope you seriously consider)
	I am very interested in your question, I can tell the difference between a job with the job? Please answer me as soon as possible, I would ER map database design is to send your mail inside. Manplx
	Re : website dedicated job! ! !
	This is quite fun, but you know that's really not enough A person looking for work, we must first find a certain sector of a particular company, then looking for work (a job), and to recruit a company, which is the first department to fix strokes in need, and then determine what type of personnel (career category). The only problem you type company's business and professional types. Then : 1 recruits (job) to fill in the information industry, professional types linked companies (recruitment) to fill in the information and, if the inconsistency is how counterparts. 2, as industry information and the type of job can do reference table (dictionay) use. 3, fill in the information sector should be a combination of information and information into a professional one recruitment information, and at the same time, the candidates to fill the job description is a combination of information and by the industry. If this information is the same as that of the two, and the recruitment and employment information can exist in a form that can exist in different forms. Well, we can design this : Corp (Corp_id (pk), corp_name, corp_cat1, corp_cat2, corp_cat3) Career (Career_id (pk), career_name, career_cat1, career_cat2, career3) Engage recruitment record -- (Corp_id (is fk =), career_id (is fk =), status,. . . ) Corp_cat --dict-corp industry information dictionary (Cat_id (pk), cat_name) Career_cat (Cat_id (pk), cat_name) Among them, corp_cat1, corp_cat2, corp_cat3 are corp_cat none_identifying relationship to the same token, career_cat1. . . Career_cat are to the. U_corp view : Select corp_id, corp_cat1 as corpcat from corp where corp_cat1 <> NULL union select corp_id, corp_cat2 as corpcat from corp where corp_cat2 <> NULL union select corp_id, corp_cat3 as corpcat from corp where corp_cat3 <> NULL U_career view : Select career_id, career_cat1 as corpcat from corp where career_cat1 <> NULL union select career_id, career_cat2 as corpcat from corp where career_cat2 <> NULL union select career_id, career_cat3 as corpcat from corp where career_cat3 <> NULL Thus, the inquiry is very good for recruitment information inquiries, such as the investigation of a b industry jobs need only check U_corp, u_career, the content will be able to engage inner jion. If you need to update your inquiries from the tables of things, engage in the triger on the table to do it.
	Re : Please refer to the structural design of a table (hope you seriously consider)
	Considering it 's a little hard to understand my English, I just post my script here. If you ''re interested, I' ll try to explain later. Drop table trade_table cascade constraints; Drop table title_table cascade constraints; Drop table location_table cascade constraints; Drop table employer_table cascade constraints; Drop table position_table cascade constraints; Drop table emp_trade cascade constraints; Drop table pos_title cascade constraints; Drop table query_table cascade constraints; Drop table user_table cascade constraints; Create table trade_table ( Trade_id number (9). Trade_name varchar (30). Primary key (trade_id)); Create table title_table ( Title_id number (9). Title_name varchar (30). Primary key (title_id)); Create table location_table ( Location_id number (9). Location_name varchar (30). Primary key (location_id)); Create table employer_table ( Emp_id number (9). Emp_name varchar (255). Emp_address varchar (255). Emp_phone varchar (30). Primary key (emp_id)); Create table position_table ( Position_id number (9). Emp_id number (9) references employer_table (emp_id). Publish_date date. Key_words varchar (255). Primary key (position_id)); Create table emp_trade ( Emp_id number (9) references employer_table (emp_id). Trade_id number (9) references trade_table (trade_id)); Create table pos_title ( Position_id number (9) references position_table (position_id) Title_id number (9) references title_table (title_id)); Create table user_table ( User_id number (9). User_name varchar2 (30). Password varchar2 (30). Mail_address varchar2 (30). Primary key (user_id)); Create table query_table ( User_id number (9) references user_table (user_id). Title_id number (9) references title_table (title_id) Trade_id number (9) references trade_table (trade_id) Location_id number (9) references location_table (location_id) Key_words varchar (60)); I 'm continuing optimizing the design. I try to attach the Erwin file but failed. If anybody interested please let me know the mail address Sorry, have no Chinese Input. . .
	Re : quite reasonable, I think
	In fact, there may not be the ultimate correct answer. Let me answer your question and then ask my question, and common progress. :) But if you like the 1 2 3 is not a problem, ah. 1, the candidates (job) to fill in the information industry, professional types linked companies (recruitment) to fill in the information and, if the inconsistency is how counterparts. The same course, if it can not find an inconsistency. 2, as industry information and the type of job can do reference table (dictionay) use. On, it is now doing so. 3, fill in the information sector should be a combination of information and information into a professional one recruitment information, Meanwhile, the candidates to fill the job description is a combination of information and by the industry. If this information is the same as that of the two, and the recruitment and employment information can exist in a table. May exist in different forms. One can not exist in both. The industry has broken down, the number of jobs may not, the posts are classified type of work, the company has not. Inquiries about the same table, much less a job. Whatever may sectors, as long as it is a certain kind of work on the list (for example, programmers)! My question is companies and jobs form, the design of tables instead? You say this is? According to the database or regulate this : For example, the company : Company (id, name) Companycat (companyid, cat) My personal view, according to take a paradigm, the database design troubles, but it may inquiries easy, but they have a small system? However, according to the design you are more likely to be accepted, in reality I do! Otherwise done in the following situations will arise when tables Psa (ie, personid) Psa_cat (psaid, cat) Psa_jobtype (psaid, jobtype) Psa_city (psaid, city) A table into four tables, it is not terrorism? What is your view? Progress together