I'm looking to add a new first class object to Magento - in this case a Video class.
I'd like the video class to have many-to-many relationships with products and categories. These relationships would identify which pages that video shows up on, and should be accessible from both sides of the relationship.
It's pretty clear how to add a new table and object class to Magento, but not clear how to create many-to-many relationships with existing classes. Any advice on this one?