Unique values ​​for two columns in Doctrine

I have an object called Dimension. It has three attributes: ID, Width and Height. The identifier is the primary key. The size must be unique in the table, therefore there must be only one record with a given size (for example, 40x30). What restrictions do I need to set? Is it correct uniqueConstraints={@UniqueConstraint(name="dimension", columns={"width", "height"})}

?

+3


source to share


1 answer


From the documentation,

@ UnicConstraint annotations are used inside the @Table annotation at the entity-class level. This allows SchemaTool to hint at creating a unique database constraint for the specified table columns. It only matters in the context of generating a SchemaTool.

Required attributes:

  • name: index name
  • : array of columns.

Anders then YES



/**
 * @Entity
 * @Table(name="xxx",uniqueConstraints={@UniqueConstraint(name="dimension", columns={"width", "height"})})
 */
class Dimension

      

must complete the task.

+12


source







All Articles