Case: relation without properties
Types: Recipe and Product.
Relation: there is a product in many recipes and one recipe contains many products (many-to-many)
Solution: two tables
Case: relation with property
Types: Recipe, Product and ProductRecipe
Relation: there is a product in the recipe with a certain gram and vice-versa
Solution: three tables
In result of second solution i have this table:
Table of ProductRecipes
And it’s not convenient cause i can’t click to Product or Recipe cell and open it’s entity, this table allows me only change it, also i must have one ephemeral type, that not represent real entity.
How to properly solve “relation with property” problem?
Maybe guys you were considering about lightweight relation types with ability to storing information there instead of creating new type?
How Airtable solving this problem: Link