title: Is there any tool/SW to help me build a good database?
body: <p>I am new to databases. I have a classifieds website with MySQL db and I am soon about to use SOLR to index them also. Then whenever a query is done, SOLR will return ID:s and I will match those ID:s to the MySQL database and fetch the ads to display.</p>
  
  <p>Anyways, I have trouble making the db.</p>
  
  <p>Users may choose from a drop-list what category to search. Lets say they choose CARS. Then a div is shown containing drop lists for "YEAR, FUEL, GEARBOX, PRICE". Then they may choose LOCATION also. Also if they wish, they may type in a querystring. All is optional though. </p>
  
  <p>How should I setup this?</p>
  
  <p>For example, I have this below for CARS right now, and I have to make fields/tables for Motorcycles, trucks, scooters also... But so far I have got only for the CARS.
  How would you do the structuring and designing?
  I am thinking about doing one of these for each category (TRUCKS, MC, HOUSES etc).</p>
  
  <p>SORRY, but I can't get the tabs to work here, could anybody edit this so it looks "more readable" please!</p>
  
  <pre><code>Fält            Typ         Null    Standard &lt;br&gt;
  
  id          int(7)          Nej 
  ad_id           varchar(62) Nej 
  area            varchar(40) Nej 
  area_community  varchar(50) Nej 
  price           int(9)          Nej 
  year            int(4)          Nej 
  mileage         int(6)          Nej 
  gearbox         varchar(12) Nej 
  fuel            varchar(12) Nej 
  insert_date timestamp   Nej CURRENT_TIMESTAMP
  poster_name varchar(40) Nej 
  poster_email    varchar(50) Nej 
  poster_tel  varchar(20) Nej 
  poster_password varchar(15) Nej     
  headline    varchar(40) Nej 
  description text            Nej 
  salebuy         varchar(7)  Nej 
  total_pics  int(2)          Nej 
  changeable  int(1)          Nej 
  hide_tel    int(1)          Nej 
  ad_category varchar(60) Nej 
  </code></pre>
  
  <p>Thanks and if you need more input just let me know and I will update this Q.</p>