Hi,

You should use more tables, and relate them using the ids.Don't forget the many-to-many relations...

Also something useful is to use an Object Relational Mapper, like DBIx::Class

Update: You can also use GraphViz for displaying the data

Regards,