###Tenders
name:string description:text category:string website:string department_id:integer
##Images for Tender image:string banner:string
######Private Sector
name:string descriptin:text category:string website:string facebook_page:string image:string #private sector image/logo banner:string #private sector banner
#foreign_key district_id:integer
######Ads
district has_many ads mandal has_many ads consituency has_many ads office has_many ads
#foriegn_keys district_id :integer mandal_id:integer constitution_id:integer
attr_accessible :constitution_id
#normal DB fields
name:string descriptin:text category:string website:string image:string #private sector image/logo banner:string #private sector banner
Geographical ######## District
1.district has_many mandals 2.ditrict has_many constitutions
Mandal
1.has_many villages
2.belongs_to constitution
3.belongs_to district
--> constitution_id:integer
district_id:integer
village
1.belongs_to mandal
Political View ########
Constitution #######
1.has_many --> mandals 2.belongs_to district -->district_id:integer
Oraganizations/Offices/Administration ########
department
People #########
mla mp minister