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

[rinse-dental]

A FK relationship doesn't seem to exist on either the definition or appointmenttype table.

[joes]

We use the deflink table to link objects to definitions. https://www.opendental.com/OpenDentalDo ... in#deflink

[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.

[rinse-dental]

Amazing - thanks!