I literally had this idea 30 seconds ago - why not use the MySQL comments to store a serialized array that contains additional meta data for the column - at the very least the name of the table the column is a foreign key for, stuff like that.

Has this been done? What would be the ramifications, other than condensing where the meta information is stored. My own initial reaction to the idea is it's crazy - but maybe crazy enough to actually work.


[A little further research - there's a 60 character limit]