tags:

views:

3

answers:

0
Q: 

How to merge 2 entity types in 1 gallery, ordered.

Hi all, I'd like to know what the best general approach would be for the following: I have a Showcase and a Showcase has many Image as well as Video. I would like to have those Images and Videos in one gallery, and I would like to be able to order them within that same gallery. Images and Videos (can) belong to many galleries.

I'm looking for the best approach here. What I figured out so far is the following: Use a table MediaItems that unifies and orders Images and Videos, where Showcase has many MediaItem, MediaItem habtm Video and MediaItem habtm Image. MediaItem consists of the fields id, showcase_id, image_id, video_id and order. image_id and video_id are allowed NULL.

Is this the right way to do it? I imagine I'm not the first one with this structure, is there a specific name for? So I can read in on it.

By the way: I'm working with CakePHP.

Thanks in advance!

related questions

How do you model roles / relationships with Domain Driven Design in mind?
Need help with ADO.NET Entity Framework UpdateException.
Automatically update Last Modified Date in ASP.Net MVC app
Going from 2 to many in Rails
Database Design Problem
2x one-to-many relationships in OO
How to eagerly fetch a single "default" entity from a collection in EJB3/JPA
MySQL: Finding rows that don't take part in a relationship
What is the best way to represent a many-to-many relationship between records in a single SQL table?
Entity Framework - how do I use the entity relationships in my extended classes?
Entity Framework - how do I use the entity associations?
Best relationships between one table and some other tables, each of them depending on n datasets of the first table?
How to deal with a Many-To-Many Relation in my API
How to define structure in a tag-based organization?
Same fields in most tables
Entity Relationship Diagram for MS Access
Customized naming of columns in JPA relationships
JPA - many to many relationship of a table with a compound-key with itself
Generate an E-R Diagram by reverse-engineering a database
How to combine cascading updates/deletes between SQL Server and NHibernate?
Database schema to track random settings in website for marketing
CakePHP hasAndBelogsToMany using save() vs. saveAll()
CakePHP multi-model view
Many to Many Relationship in MS Dynamics CRM 4.0 - How to?
Suitable E-R notation for introductory DB design course? Good/free diagram tools?