我使用的是Playframework 1.2.4和PostgresSQL 9.1.2。我有以下实体: Recipe和RecipeItem。食谱有一组RecipeItems。我在recipe类中注释了一组Recipe项,如下所示:
@Required
@MinSize(1)
@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
@JoinTable( name = "RecipeItemForIngredients",
joinColumns = @JoinColumn(name = "recipeId"),
inverseJoinColumns = @JoinColumn(name = "recipeItemId"),
uniqueConstraints = @UniqueConstraint(name = "uq_recipeItemPerRecipe",
columnNames = {"recipeId", "recipeItemId"}))
public Set<RecipeItem> items = Sets.newHashSet();但是,当我检查PgAdmin以查看约束是否已应用到RecipeItemForIngredients表时,我找不到它。这是PgAdmin显示的内容。
CREATE TABLE recipeitemforingredients
(
recipeid bigint NOT NULL,
recipeitemid bigint NOT NULL,
CONSTRAINT recipeitemforingredients_pkey PRIMARY KEY (recipeid, recipeitemid),
CONSTRAINT fk5ac547a883708db FOREIGN KEY (recipeid)
REFERENCES recipe (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk5ac547ad6e1da8f FOREIGN KEY (recipeitemid)
REFERENCES "recipe$recipeitem" (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT recipeitemforingredients_recipeitemid_key UNIQUE (recipeitemid)
)有人知道为什么会发生这样的事情吗?也许Playframework使用的ORM不支持这个注解。
发布于 2012-01-23 22:20:31
这个约束没有多大意义,而且不管怎样,默认情况下您有一个更强的约束:
CONSTRAINT recipeitemforingredients_recipeitemid_key UNIQUE (recipeitemid)当然,如果recipeItemId是唯一的,那么元组(recipeId, recipeItemId)也是唯一的。
此外,由于表的PK为(recipeId, recipeItemId),因此该约束已被PK约束应用。
https://stackoverflow.com/questions/8973007
复制相似问题