I'm developing my own component for Joomla. I know that in many components single records and their categories are stored in different tables of the database. But how about storing them in ONE table using parents? Each record and "category" has title, some content/description, metadata, parent field and other data in common. Parents for records are their categories and parents for categories are their parent categories (if needed). And in my table there is the column type (=record or =category) and I can just operate them in my views. This way minimizes sql-queries and number of models/views. I can understand that it's a new and maybe strange idea but is it good to simplify the things in such way and what problems may be appeared in the future?
UPDATED: And if storing the relations in such one table is a bad idea how about storing titles, content, metadata and other data in common in one table but only parent's relations (id, parent_id) in another table?