child tables inside parent table
I need to add function of viewing the history of each record in my db (date, comment, mb smth else that will be managed manually and automatically (e.g. date)).
Now I see only one way to do this: to create separate table for each record. However I'm not sure if it is a good idea and moreover I do not know if it is possible to script this (creating table for each record).
Also I though about creating many additional fields directly to the records in my db and then write history records there, however it is not a good idea either: history records will be limited to number of additional fields and it will be necessary to create tons of additional fields.
Any suggestions how can I realise this?