I don’t know how the collection for a meteor app should be. In MySQL I would have 3 tables:
- table_1: id, column_a, column_b
- table_2: id, table_1_id, column_c, column_d
- table_3: id, column_e, column_f
table_2 and table_3 could have the same indentical rows. Some information can pe in both tables, in table_2 and not in table_3, in table_3 and not in table_2.
I know that in meteor/mongodb when you design database schema, you need to know how you will access/display the information. I want to display something like this:
- show all rows from table2 where table_2.table_1_id=table_1.id; and I
also want to check if table_2.column_c=table_3.column_e, if it’s true
than I want to display that row from table_3.
I hope did you understand, also if you have some suggestions about subscriptions/publications whould be much aprecieted.
P.S. I am sorry for the title of this topic, but I couldn’t find a more specific title.