Timeline for Determine Primary and Foreign Key for two tables
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 22, 2022 at 10:21 | vote | accept | Herza Ryo | ||
| Dec 21, 2022 at 15:05 | history | edited | Niyaz | CC BY-SA 4.0 |
added 252 characters in body
|
| Dec 21, 2022 at 14:58 | comment | added | Niyaz |
Based on my understanding of your question, It is a one-time process. Afterward, you add data to the doctor_id column instead of the Doctor column. I think it takes a couple of minutes to run those queries. If your sample is more than 1M, then adding a temporary index for the Doctor column may be helpful. After the update, you can delete the index.
|
|
| Dec 21, 2022 at 13:24 | comment | added | Herza Ryo | If i update data for table patient_treatment, i must do step 2 again? is there a way to be more efficient when the data is very large? | |
| Dec 21, 2022 at 13:08 | history | edited | Niyaz | CC BY-SA 4.0 |
added 3 characters in body
|
| Dec 21, 2022 at 12:58 | history | answered | Niyaz | CC BY-SA 4.0 |