title: Django database model: fields depending on the type of the object
body: <p>I have some objects which will be used in the same manor. This object is categorised in predefined types of this object. Each type has properties belonging to this type of the object.
  To get this in a model, I had this tables for the model in mind:</p>
  
  <ul>
  <li>One table with the types of the object</li>
  <li>One table with the predefined properties belonging to the type (with a description/help text of the field, is the property requierd, the type of the field and so on)</li>
  <li>One table with the objects with a relation to the table with its
  properties (the next one in this list)</li>
  <li>One table with the properties of the objects and it values (refering to the
  predefined properties for its definition)</li>
  </ul>
  
  <p>it does work, but needs some programming to keep things together.</p>
  
  <p>another issue with this solution is the fieldtype of the property, this can be different. So or I'll use 1 field type (charField) and try to parse it, or I'll have a table with different value fields with the most used field types (value_integer = models.IntegerField). In this case you get a lot of emtpy fields just to have 1 of the fields filled in per property. Actually I Am looking for some kind of dictionary...</p>
  
  <p>Not sure whether this is the right way to go....any suggestions?</p>