I'm using appointment scheduling, and I need to relate appointment_types to providers. What I want to achieve is a way I can directly get appointment types(or medical specialties) which a provider can do.
In this moment, for what I understand from the database model, we just associate both them through an appointment block, and that's not enough for me.
I was thinking about use Provider attribute type, as a way to do it, using a CustomDatatype (ex: AppointmentTypeCustomDatatype), receiving a list of AppointmentType, on this attribute.
What do you think? Is this a good approach? Or do you think it's preferrable to add a new relation table to the database model?