English 中文(简体)
2. 结晶体与HABTM的关系
原标题:Polymorphic vs HABTM relationships for a tagging system

我目前正在建立一个铁路应用数据库。 该图形涉及三个模型:照片、物体和塔格。 照片和物体都需要“贴切”。

  • Tags are unique
  • Tags can belong to a Photo, or an Object, or both

铁路提供一种多形态的结合,其结果是标的归属与照片和物体的关系;但不允许塔格属于

One might solve this by having two independent HABTM relationships for tags to photos and tags to objects .

我很想知道,实现这一点是否有更有效的方法? 或者,或许我是从错误的方向来处理这个问题?

最佳回答

塔格斯是说什么东西的一种方式。

只使用一套标签就每一件事说几件事可能不明智。 我可以想象,像“1024x768”和“瞬间-冲锋枪”的标签,如果你试图就照片发表一些看法,是有用的,但如果你试图就物体发表一些看法,则不会真正有用。

我要说的是,我使用像“蓝色”这样的标签来指照片和物体。{photo_id,“blue”} 是否与{object_id,“blue”}相同? 我不认为这样做。

在我看来,最有效的解决办法似乎是使用一组标签来谈论照片,而另一套标签则对物体说一些。 这还可能更有利于用户。

问题回答

暂无回答




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...