opportunities_cstm and opportunities relationship

[skysolutions]

What is the relationship and the cardinality between those 2 tables (oportunities_cstm <--> opportunities) ?

I saw that oportunities_cstm contains the custom fields.

Thanks.

[fsamuels]

oportunities_cstm.id_c == opportunities.id

There is only 1 opportunities_cstm per opportunities but only if there is custom data that has been stored. So the cardinality of oportunities_cstm.id_c <= opportunities.id

That help?

[skysolutions]

thanks!

if I understand correct: each opportunities has 0 or 1 opportunities_cstm and each opportunities_cstm has ONLY 1 opportunities ?

because when I check a report (which have fields from both tables) it brings NULL and blank values in the opportunities_cstm.offering_c field.

[fsamuels]

Yep, that is correct.