Hello I'm having a hard time structuring my data in a database.
I have a table for exam procedures with id, exam name and value. But the problem is that a "procedure" can contain other procedures, and in that case the unit value of each procedure changes.
Example - Single Procedures -Radiography 10.00 -Photography 5.00 -Slide 15.00 -Model 50.00
Sample Procedures Group -Documentation A --Radiography 8.00 --Photos --Model 40.00
-Documentation B --Radiography 8.00 --Photographs 2.50 --Model 40.00
However, these documentation procedures need to reference the id of the single procedures.
Thank you