Design database for a real estate php app, tables have too many columns
<p>I'm designing mysql database for a php app, which has two sections: adding advertisement for properties like house shops.. , and searching for them.</p>

<p>I have tables for <code>users, addresses, ads...</code></p>

<p>The problem is <code>properties</code> table. I don't know if I should split that up into multiple table or should I have one big table? Columns are too many. I have up to 100 fields, like:</p>

<p>Property type: <code>house, shop, fields...</code> Each property type has some fields like bedrooms number for house, and other fields like air conditioning system, facilities, equipments..
What should I do? Should I divide this table into smaller tables? </p>