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: 73
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.

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

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

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

rinse-dental
Posts: 73
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!

Post Reply