Where is the DB relationship between definitions/websched and appointmenttype?

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
rinse-dental
Posts: 110
Joined: Wed Apr 06, 2022 12:04 pm

Where is the DB relationship between definitions/websched and appointmenttype?

Post by rinse-dental » Sat May 07, 2022 12:35 pm

A FK relationship doesn't seem to exist on either the definition or appointmenttype table.
Top
joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: Where is the DB relationship between definitions/websched and appointmenttype?

Post by joes » Tue May 10, 2022 3:42 pm

We use the deflink table to link objects to definitions. https://www.opendental.com/OpenDentalDo ... in#deflink
Joe Sullivan
Open Dental Software
http://www.opendental.com
Top
User avatar
jordansparks
Site Admin
Posts: 5758
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:
Contact jordansparks

Re: Where is the DB relationship between definitions/websched and appointmenttype?

Post by jordansparks » Sat May 14, 2022 7:48 am

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.
Jordan Sparks, DMD
http://www.opendental.com
Top
rinse-dental
Posts: 110
Joined: Wed Apr 06, 2022 12:04 pm

Re: Where is the DB relationship between definitions/websched and appointmenttype?

Post by rinse-dental » Sat May 14, 2022 10:02 am

Amazing - thanks!
Top
Post Reply

Return to “Advanced Topics”