The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
This is how I would go about it as well. But with 2 tables. The links and relationship definitions table can be merged into a single "Relationship" table with a field for relationship type holding the types of relationships you want your base to su...