خرید بک لینک

Vote count: 0

This might sound silly but i am confused as to how to link the two tables together and my question is specific to mysql and database table design. I have 2 tables . The first table is pr_resignation_requests and the second table is pr_exit_checklists. Now foreach row in pr_resignation_requests i have to link each row in pr_exit_checklists. Scenario : when a person resigns from a company there will be a exit checklist which the company admin adds from the backend into pr_exit_checklist table. Now for each resignation request from any employee there will be one checklist with many items in it and mails and notifications have to go to each person responsible for the job i.e for each item. Now i want to link these tables somehow. I have attached an image for better understanding. One is my pr_resignation_requests table, for which each row in pr_resignation_requests to be linked to many rows of pr_exit_checklists. What i mean is any number of checklists can be added and any number of resignations. How to link these together and display them as a single checklist for each resignation request. How to solve this kind of a problem? This is pr_resignation_request table enter image description here

And foreach item in the above table (Now there is only on item) . Link the below table which has multiple items.

enter image description here

The view should look like the below Screenshot explaining the process.

For the manager: Please look at exit checklist

enter image description here

enter image description here

Exit checklist screenshot: enter image description here

asked 27 secs ago

برچسب: how to link two tables together in mysql,how to link tables together mysql,how to join two tables together in mysql,how to link tables in mysql,how to link tables in mysql database,how to link tables in mysql workbench,how to join tables in mysql,how to join tables in mysql php,how to join tables in mysql database,how to join tables in mysql query, نویسنده: استخدام کار تاريخ: دوشنبه 18 مرداد 1395 ساعت: 1:13

صفحه بندی