I need help to decide what way follow in order to modeling this data in mongodb -
I need help to decide what way follow in order to modeling this data in mongodb -
i have 3 entities, , inheritance following:
countries | - provinces | - cities
in denormalized (or embedded) construction following:
one illustration document countries
collection
{ name : "argentina", provinces : [ { name : "santa fe", cities : [ { name : "rosario", zipcode : 2000 }, { name : "other", zipcode : 3142 }, ... ] }, ... ] }
what going take city zipcode
field (which going unique) , assign person
document in order identify city. pain query cities structure, when want filter cities in search box.
the other thought (based on going work cities in mostly) separate entities collections , link every city
document province 1 using province_id
field (just saying).
what want not duplicate information. in case?
cheers!
mongodb
Comments
Post a Comment