Another question related to many-to-many relations. I might need to convert an already existing implicit many-to-many relation, to an explicit m-n relation instead (to add extra fields in the relation table). In that context, I’d be interested to know if there is a recommended approach to smoothly achieve this with minimum disruption?
r
Ryan
06/18/2021, 6:57 AM
@Sylvain (seel-vahn) 👋
That would have to be done in multiple steps, so something like this:
1. Create the explicit table
2. Migrate existing data from the implicit table
3. Delete the implicit table and connect to the explicit one
I don’t see any easier way of doing this at the moment 🙂
s
Sylvain (seel-vahn)
06/18/2021, 7:01 AM
How about re-using the same naming convention as the implicit relation (aka. A / B _RelationName)? Would that cause any issue?
r
Ryan
06/18/2021, 7:04 AM
That wouldn’t work as you wouldn’t be able to fetch extra columns from the explicit relation.
Ryan
06/18/2021, 7:04 AM
Explicit relation tables with the implicit conventions are hidden from