Page 1 of 1
Where is the DB relationship between definitions/websched and appointmenttype?
Posted: Sat May 07, 2022 12:35 pm
by rinse-dental
A FK relationship doesn't seem to exist on either the definition or appointmenttype table.
Re: Where is the DB relationship between definitions/websched and appointmenttype?
Posted: Tue May 10, 2022 3:42 pm
by joes
We use the deflink table to link objects to definitions.
https://www.opendental.com/OpenDentalDo ... in#deflink
Re: Where is the DB relationship between definitions/websched and appointmenttype?
Posted: Sat May 14, 2022 7:48 am
by jordansparks
I just added this to our schema under definition.DefCat enum:
Each appointment can be assigned one appointment.AppointmentTypeNum. Multiple AppointmentTypes are linked to this definition through the DefLink table, where deflink.DefNum=definition.DefNum, deflink.LinkType=2, and deflink.FKey=appointmenttype.AppointmentTypeNum.
Re: Where is the DB relationship between definitions/websched and appointmenttype?
Posted: Sat May 14, 2022 10:02 am
by rinse-dental
Amazing - thanks!