Hello,
I have big problem with mapping specific association...maybe I describe my problem:
I have two tables:
1) Table: TASKS (idT,taskName,taskDescription)
PRIMARY KEY: idT
2) TABLE JOBS (idJ,jobName);
I can't use standard many-to-many mapping, because I need more information at intersection table....so I need third table that contains:
3) TABLE TASKJOBS(idT,idJ,orderT);
PRIMARY KEY: (idT,order)
I need this, because I need to store in database information about job's order in concrete Task....for example: TASK_1 has on first position job_1, on second job_2....on tenth job_10
...and I need to know where is conrete job used...I mean I have 5 tasks with job_1...so job_1 is used 5 times...
Maybe someone can resolve my problem....
Best regards
Krzychu
|