Solr Indexing Design Requirement -

i having 5 tables in database namely state,district,city,locality , pincode(hierarchy mention).
each table having foreign keys corresponding parents in hierarchy.but of pincodes maynot have locality id.i trying indexing data solr. far indexing such below

    <doc>     <str name="state">punjab</str>     <arr name="district">        <str>test</str>        <str>test1</str>     </arr>     <arr name="city">       <str>abc</str>       <str>dfsdf</str>      </arr>     <arr name="locality">       <str>fggf</str>       <str>gddd</str>      </arr>      <arr name="pincode">       <str>123</str>       <str>345</str>      </arr> </doc> 

but hope not correct way fetching data there no relation between district , city,city , locality etc..
me on this

you looking @ problem backwards. need work results. want find?

imagine have everythin working correctly. given that, individual record in search result (pincode-level entries?). then, de-normalize down level , include information required find record.

see the presentation gilt regarding how refactored initial architecture reflect needs better. ignore technical details now, follow logic arguments.

then, have (separate) technical question on how implement it.