ss1289
10-14-2009, 10:44 AM
I'll explain my question with this example.
Say I have a "employee" table and a "city" table and a "employeeToCity" to associate a employee to a city. The association means that an employee is responsible for, lets say, IT jobs in that city. These 3 tables already exists and code depends on the way it's built to this point.
Now I want to add another association between an employee and city that associates an employee to city where the employee is responsible for, lets say, Accounting jobs in that city. Accounting and IT jobs are two different things.
How do I add/modify the "employeeToCity" to show that an employee is either associated to a IT, Accounting, or both jobs? Do I need to add a new table called "jobType" and add a "jobTypeId" to "employeeToCity"?
Say I have a "employee" table and a "city" table and a "employeeToCity" to associate a employee to a city. The association means that an employee is responsible for, lets say, IT jobs in that city. These 3 tables already exists and code depends on the way it's built to this point.
Now I want to add another association between an employee and city that associates an employee to city where the employee is responsible for, lets say, Accounting jobs in that city. Accounting and IT jobs are two different things.
How do I add/modify the "employeeToCity" to show that an employee is either associated to a IT, Accounting, or both jobs? Do I need to add a new table called "jobType" and add a "jobTypeId" to "employeeToCity"?