You are browsing a version that is no longer maintained.

Annotations Reference

To be able to use annotations, you will have to install an extra package called doctrine/annotations.

You've probably used docblock annotations in some form already, most likely to provide documentation metadata for a tool like PHPDocumentor (@author, @link, ...). Docblock annotations are a tool to embed metadata inside the documentation section which can then be processed by some tool. Doctrine ORM generalizes the concept of docblock annotations so that they can be used for any kind of metadata and so that it is easy to define new docblock annotations. In order to allow more involved annotation values and to reduce the chances of clashes with other docblock annotations, the Doctrine ORM docblock annotations feature an alternative syntax that is heavily inspired by the Annotation syntax introduced in Java 5.

The implementation of these enhanced docblock annotations is located in the doctrine/annotations package, but in the Doctrine\Common\Annotations namespace for backwards compatibility reasons. Note that doctrine/annotations is not required by Doctrine ORM, and you will need to require that package if you want to use annotations. Doctrine ORM docblock annotations support namespaces and nested annotations among other things. The Doctrine ORM defines its own set of docblock annotations for supplying object-relational mapping metadata.

If you're not comfortable with the concept of docblock annotations, don't worry, as mentioned earlier Doctrine ORM provides XML and YAML alternatives and you could easily implement your own favourite mechanism for defining ORM metadata.

In this chapter a reference of every Doctrine ORM Annotation is given with short explanations on their context and usage.

Reference

@Column

Marks an annotated instance variable as persistent. It has to be inside the instance variables PHP DocBlock comment. Any value hold inside this variable will be saved to and loaded from the database as part of the lifecycle of the instance variables entity-class.

Required attributes:

  • type: Name of the Doctrine Type which is converted between PHP and Database representation. Default to string or Type from PHP property type

Optional attributes:

  • name: By default the property name is used for the database column name also, however the 'name' attribute allows you to determine the column name.
  • length: Used by the "string" type to determine its maximum length in the database. Doctrine does not validate the length of a string value for you.
  • precision: The precision for a decimal (exact numeric) column (applies only for decimal column), which is the maximum number of digits that are stored for the values.
  • scale: The scale for a decimal (exact numeric) column (applies only for decimal column), which represents the number of digits to the right of the decimal point and must not be greater than precision.
  • unique: Boolean value to determine if the value of the column should be unique across all rows of the underlying entities table.
  • nullable: Determines if NULL values allowed for this column. If not specified, default value is false.
  • insertable: Boolean value to determine if the column should be included when inserting a new row into the underlying entities table.
    If not specified, default value is true.
  • updatable: Boolean value to determine if the column should be included when updating the row of the underlying entities table. If not specified, default value is true.
  • generated: An enum with the possible values ALWAYS, INSERT, NEVER. Is used after an INSERT or UPDATE statement to determine if the database generated this value and it needs to be fetched using a SELECT statement.
  • options: Array of additional options:

    • default: The default value to set for the column if no value is supplied.
    • unsigned: Boolean value to determine if the column should be capable of representing only non-negative integers (applies only for integer column and might not be supported by all vendors).
    • fixed: Boolean value to determine if the specified length of a string column should be fixed or varying (applies only for string/binary column and might not be supported by all vendors).
    • comment: The comment of the column in the schema (might not be supported by all vendors).
    • collation: The collation of the column (only supported by Drizzle, Mysql, PostgreSQL>=9.1, Sqlite and SQLServer).
    • check: Adds a check constraint type to the column (might not be supported by all vendors).
  • columnDefinition: DDL SQL snippet that starts after the column name and specifies the complete (non-portable!) column definition. This attribute allows to make use of advanced RMDBS features. However you should make careful use of this feature and the consequences. SchemaTool will not detect changes on the column correctly anymore if you use columnDefinition.

    Additionally you should remember that the type attribute still handles the conversion between PHP and Database values. If you use this attribute on a column that is used for joins between tables you should also take a look at @JoinColumn.

For more detailed information on each attribute, please refer to the DBAL Schema-Representation documentation.

Examples:

1<?php /** * @Column(type="string", length=32, unique=true, nullable=false) */ protected $username; /** * @Column(type="string", columnDefinition="CHAR(2) NOT NULL") */ protected $country; /** * @Column(type="decimal", precision=2, scale=1) */ protected $height; /** * @Column(type="string", length=2, options={"fixed":true, "comment":"Initial letters of first and last name"}) */ protected $initials; /** * @Column(type="integer", name="login_count", nullable=false, options={"unsigned":true, "default":0}) */ protected $loginCount; /** * Generated column * @Column(type="string", name="user_fullname", insertable=false, updatable=false) * MySQL example: full_name char(41) GENERATED ALWAYS AS (concat(firstname,' ',lastname)), */ protected $fullname;
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

@ColumnResult

References name of a column in the SELECT clause of a SQL query. Scalar result types can be included in the query result by specifying this annotation in the metadata.

Required attributes:

  • name: The name of a column in the SELECT clause of a SQL query

@Cache

Add caching strategy to a root entity or a collection.

Optional attributes:

  • usage: One of READ_ONLY, READ_WRITE or NONSTRICT_READ_WRITE, By default this is READ_ONLY.
  • region: An specific region name

@ChangeTrackingPolicy

The Change Tracking Policy annotation allows to specify how the Doctrine ORM UnitOfWork should detect changes in properties of entities during flush. By default each entity is checked according to a deferred implicit strategy, which means upon flush UnitOfWork compares all the properties of an entity to a previously stored snapshot. This works out of the box, however you might want to tweak the flush performance where using another change tracking policy is an interesting option.

The details on all the available change tracking policies can be found in the configuration section.

Example:

1<?php /** * @Entity * @ChangeTrackingPolicy("DEFERRED_IMPLICIT") * @ChangeTrackingPolicy("DEFERRED_EXPLICIT") * @ChangeTrackingPolicy("NOTIFY") */ class User {}
2
3
4
5
6
7
8

@CustomIdGenerator

This annotations allows you to specify a user-provided class to generate identifiers. This annotation only works when both @Id and @GeneratedValue(strategy="CUSTOM") are specified.

Required attributes:

  • class: name of the class which should extend DoctrineORMIdAbstractIdGenerator

Example:

1<?php /** * @Id * @Column(type="integer") * @GeneratedValue(strategy="CUSTOM") * @CustomIdGenerator(class="My\Namespace\MyIdGenerator") */ public $id;
2
3
4
5
6
7
8

@DiscriminatorColumn

This annotation is an optional annotation for the topmost/super class of an inheritance hierarchy. It specifies the details of the column which saves the name of the class, which the entity is actually instantiated as.

If this annotation is not specified, the discriminator column defaults to a string column of length 255 called dtype.

Required attributes:

  • name: The column name of the discriminator. This name is also used during Array hydration as key to specify the class-name.

Optional attributes:

  • type: By default this is string.
  • length: By default this is 255.

@DiscriminatorMap

The discriminator map is a required annotation on the topmost/super class in an inheritance hierarchy. Its only argument is an array which defines which class should be saved under which name in the database. Keys are the database value and values are the classes, either as fully- or as unqualified class names depending on whether the classes are in the namespace or not.

1<?php /** * @Entity * @InheritanceType("JOINED") * @DiscriminatorColumn(name="discr", type="string") * @DiscriminatorMap({"person" = "Person", "employee" = "Employee"}) */ class Person { // ... }
2
3
4
5
6
7
8
9
10
11

@Embeddable

The embeddable annotation is required on a class, in order to make it embeddable inside an entity. It works together with the @Embedded annotation to establish the relationship between the two classes.

1<?php /** * @Embeddable */ class Address { // ... class User { /** * @Embedded(class = "Address") */ private $address;
2
3
4
5
6
7
8
9
10
11
12
13
14

@Embedded

The embedded annotation is required on an entity's member variable, in order to specify that it is an embedded class.

Required attributes:

  • class: The embeddable class. You can omit this value if you use a PHP property type instead.
1<?php // ... class User { /** * @Embedded(class = "Address") */ private $address; /** * @Embeddable */ class Address { // ...
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

@Entity

Required annotation to mark a PHP class as an entity. Doctrine manages the persistence of all classes marked as entities.

Optional attributes:

  • repositoryClass: Specifies the FQCN of a subclass of the EntityRepository. Use of repositories for entities is encouraged to keep specialized DQL and SQL operations separated from the Model/Domain Layer.
  • readOnly: Specifies that this entity is marked as read only and not considered for change-tracking. Entities of this type can be persisted and removed though.

Example:

1<?php /** * @Entity(repositoryClass="MyProject\UserRepository", readOnly=true) */ class User { // ... }
2
3
4
5
6
7
8

@EntityResult

References an entity in the SELECT clause of a SQL query. If this annotation is used, the SQL statement should select all of the columns that are mapped to the entity object. This should include foreign key columns to related entities. The results obtained when insufficient data is available are undefined.

Required attributes:

  • entityClass: The class of the result.

Optional attributes:

  • fields: Array of @FieldResult, Maps the columns specified in the SELECT list of the query to the properties or fields of the entity class.
  • discriminatorColumn: Specifies the column name of the column in the SELECT list that is used to determine the type of the entity instance.

@FieldResult

Is used to map the columns specified in the SELECT list of the query to the properties or fields of the entity class.

Required attributes:

  • name: Name of the persistent field or property of the class.

Optional attributes:

  • column: Name of the column in the SELECT clause.

@GeneratedValue

Specifies which strategy is used for identifier generation for an instance variable which is annotated by @Id. This annotation is optional and only has meaning when used in conjunction with @Id.

If this annotation is not specified with @Id the NONE strategy is used as default.

Optional attributes:

  • strategy: Set the name of the identifier generation strategy. Valid values are AUTO, SEQUENCE, IDENTITY, UUID (deprecated), CUSTOM and NONE, explained in the Identifier Generation Strategies section. If not specified, default value is AUTO.

Example:

1<?php /** * @Id * @Column(type="integer") * @GeneratedValue(strategy="IDENTITY") */ protected $id = null;
2
3
4
5
6
7

@HasLifecycleCallbacks

Annotation which has to be set on the entity-class PHP DocBlock to notify Doctrine that this entity has entity lifecycle callback annotations set on at least one of its methods. Using @PostLoad, @PrePersist, @PostPersist, @PreRemove, @PostRemove, @PreUpdate or @PostUpdate without this marker annotation will make Doctrine ignore the callbacks.

Example:

1<?php /** * @Entity * @HasLifecycleCallbacks */ class User { /** * @PostPersist */ public function sendOptinMail() {} }
2
3
4
5
6
7
8
9
10
11
12

@Index

Annotation is used inside the @Table annotation on the entity-class level. It provides a hint to the SchemaTool to generate a database index on the specified table columns. It only has meaning in the SchemaTool schema generation context.

Required attributes:

  • name: Name of the Index
  • fields: Array of fields. Exactly one of fields, columns is required.
  • columns: Array of columns. Exactly one of fields, columns is required.

Optional attributes:

  • options: Array of platform specific options:

    • where: SQL WHERE condition to be used for partial indexes. It will only have effect on supported platforms.

Basic example:

1<?php /** * @Entity * @Table(name="ecommerce_products",indexes={@Index(name="search_idx", columns={"name", "email"})}) */ class ECommerceProduct { }
2
3
4
5
6
7
8

Basic example using fields:

1<?php /** * @Entity * @Table(name="ecommerce_products",indexes={@Index(name="search_idx", fields={"name", "email"})}) */ class ECommerceProduct { }
2
3
4
5
6
7
8

Example with partial indexes:

1<?php /** * @Entity * @Table(name="ecommerce_products",indexes={@Index(name="search_idx", columns={"name", "email"}, options={"where": "(((id IS NOT NULL) AND (name IS NULL)) AND (email IS NULL))"})}) */ class ECommerceProduct { }
2
3
4
5
6
7
8

@Id

The annotated instance variable will be marked as entity identifier, the primary key in the database. This annotation is a marker only and has no required or optional attributes. For entities that have multiple identifier columns each column has to be marked with @Id.

Example:

1<?php /** * @Id * @Column(type="integer") */ protected $id = null;
2
3
4
5
6

@InheritanceType

In an inheritance hierarchy you have to use this annotation on the topmost/super class to define which strategy should be used for inheritance. Currently Single Table and Class Table Inheritance are supported.

This annotation has always been used in conjunction with the @DiscriminatorMap and @DiscriminatorColumn annotations.

Examples:

1<?php /** * @Entity * @InheritanceType("SINGLE_TABLE") * @DiscriminatorColumn(name="discr", type="string") * @DiscriminatorMap({"person" = "Person", "employee" = "Employee"}) */ class Person { // ... } /** * @Entity * @InheritanceType("JOINED") * @DiscriminatorColumn(name="discr", type="string") * @DiscriminatorMap({"person" = "Person", "employee" = "Employee"}) */ class Person { // ... }
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

@JoinColumn

This annotation is used in the context of relations in @ManyToOne, @OneToOne fields and in the Context of @JoinTable nested inside a @ManyToMany. If this annotation or both name and referencedColumnName are missing they will be computed considering the field's name and the current naming strategy.

Optional attributes:

  • name: Column name that holds the foreign key identifier for this relation. In the context of @JoinTable it specifies the column name in the join table.
  • referencedColumnName: Name of the primary key identifier that is used for joining of this relation. Defaults to id.
  • unique: Determines whether this relation is exclusive between the affected entities and should be enforced as such on the database constraint level. Defaults to false.
  • nullable: Determine whether the related entity is required, or if null is an allowed state for the relation. Defaults to true.
  • onDelete: Cascade Action (Database-level)
  • columnDefinition: DDL SQL snippet that starts after the column name and specifies the complete (non-portable!) column definition. This attribute enables the use of advanced RMDBS features. Using this attribute on @JoinColumn is necessary if you need slightly different column definitions for joining columns, for example regarding NULL/NOT NULL defaults. However by default a "columnDefinition" attribute on @Column also sets the related @JoinColumn's columnDefinition. This is necessary to make foreign keys work.

Example:

1<?php /** * @OneToOne(targetEntity="Customer") * @JoinColumn(name="customer_id", referencedColumnName="id") */ private $customer;
2
3
4
5
6

@JoinColumns

An array of @JoinColumn annotations for a @ManyToOne or @OneToOne relation with an entity that has multiple identifiers.

@JoinTable

Using @OneToMany or @ManyToMany on the owning side of the relation requires to specify the @JoinTable annotation which describes the details of the database join table. If you do not specify @JoinTable on these relations reasonable mapping defaults apply using the affected table and the column names.

Optional attributes:

  • name: Database name of the join-table
  • joinColumns: An array of @JoinColumn annotations describing the join-relation between the owning entities table and the join table.
  • inverseJoinColumns: An array of @JoinColumn annotations describing the join-relation between the inverse entities table and the join table.

Example:

1<?php /** * @ManyToMany(targetEntity="Phonenumber") * @JoinTable(name="users_phonenumbers", * joinColumns={@JoinColumn(name="user_id", referencedColumnName="id")}, * inverseJoinColumns={@JoinColumn(name="phonenumber_id", referencedColumnName="id", unique=true)} * ) */ public $phonenumbers;
2
3
4
5
6
7
8
9

@ManyToOne

Defines that the annotated instance variable holds a reference that describes a many-to-one relationship between two entities.

Required attributes:

  • targetEntity: FQCN of the referenced target entity. Can be the unqualified class name if both classes are in the same namespace. You can omit this value if you use a PHP property type instead. IMPORTANT: No leading backslash!

Optional attributes:

  • cascade: Cascade Option
  • fetch: One of LAZY or EAGER
  • inversedBy - The inversedBy attribute designates the field in the entity that is the inverse side of the relationship.

Example:

1<?php /** * @ManyToOne(targetEntity="Cart", cascade={"all"}, fetch="EAGER") */ private $cart;
2
3
4
5

@ManyToMany

Defines that the annotated instance variable holds a many-to-many relationship between two entities. @JoinTable is an additional, optional annotation that has reasonable default configuration values using the table and names of the two related entities.

Required attributes:

  • targetEntity: FQCN of the referenced target entity. Can be the unqualified class name if both classes are in the same namespace. IMPORTANT: No leading backslash!

Optional attributes:

  • mappedBy: This option specifies the property name on the targetEntity that is the owning side of this relation. It is a required attribute for the inverse side of a relationship.
  • inversedBy: The inversedBy attribute designates the field in the entity that is the inverse side of the relationship.
  • cascade: Cascade Option
  • fetch: One of LAZY, EXTRA_LAZY or EAGER
  • indexBy: Index the collection by a field on the target entity.

For ManyToMany bidirectional relationships either side may be the owning side (the side that defines the @JoinTable and/or does not make use of the mappedBy attribute, thus using a default join table).

Example:

1<?php /** * Owning Side * * @ManyToMany(targetEntity="Group", inversedBy="features") * @JoinTable(name="user_groups", * joinColumns={@JoinColumn(name="user_id", referencedColumnName="id")}, * inverseJoinColumns={@JoinColumn(name="group_id", referencedColumnName="id")} * ) */ private $groups; /** * Inverse Side * * @ManyToMany(targetEntity="User", mappedBy="groups") */ private $features;
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

@MappedSuperclass

A mapped superclass is an abstract or concrete class that provides persistent entity state and mapping information for its subclasses, but which is not itself an entity. This annotation is specified on the Class docblock and has no additional attributes.

The @MappedSuperclass annotation cannot be used in conjunction with @Entity. See the Inheritance Mapping section for more details on the restrictions of mapped superclasses.

Optional attributes:

  • repositoryClass: Specifies the FQCN of a subclass of the EntityRepository. That will be inherited for all subclasses of that Mapped Superclass.

Example:

1<?php /** * @MappedSuperclass */ class MappedSuperclassBase { // ... fields and methods } /** * @Entity */ class EntitySubClassFoo extends MappedSuperclassBase { // ... fields and methods }
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

@NamedNativeQuery

Named Native Queries are deprecated as of version 2.9 and will be removed in ORM 3.0

Is used to specify a native SQL named query. The NamedNativeQuery annotation can be applied to an entity or mapped superclass.

Required attributes:

  • name: The name used to refer to the query with the EntityManager methods that create query objects.
  • query: The SQL query string.

Optional attributes:

  • resultClass: The class of the result.
  • resultSetMapping: The name of a SqlResultSetMapping, as defined in metadata.

Example:

1<?php /** * @NamedNativeQueries({ * @NamedNativeQuery( * name = "fetchJoinedAddress", * resultSetMapping= "mappingJoinedAddress", * query = "SELECT u.id, u.name, u.status, a.id AS a_id, a.country, a.zip, a.city FROM cms_users u INNER JOIN cms_addresses a ON u.id = a.user_id WHERE u.username = ?" * ), * }) * @SqlResultSetMappings({ * @SqlResultSetMapping( * name = "mappingJoinedAddress", * entities= { * @EntityResult( * entityClass = "__CLASS__", * fields = { * @FieldResult(name = "id"), * @FieldResult(name = "name"), * @FieldResult(name = "status"), * @FieldResult(name = "address.zip"), * @FieldResult(name = "address.city"), * @FieldResult(name = "address.country"), * @FieldResult(name = "address.id", column = "a_id"), * } * ) * } * ) * }) */ class User { /** @Id @Column(type="integer") @GeneratedValue */ public $id; /** @Column(type="string", length=50, nullable=true) */ public $status; /** @Column(type="string", length=255, unique=true) */ public $username; /** @Column(type="string", length=255) */ public $name; /** @OneToOne(targetEntity="Address") */ public $address; // .... }
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

@OneToOne

The @OneToOne annotation works almost exactly as the @ManyToOne with one additional option which can be specified. The configuration defaults for @JoinColumn using the target entity table and primary key column names apply here too.

Required attributes:

  • targetEntity: FQCN of the referenced target entity. Can be the unqualified class name if both classes are in the same namespace. When typed properties are used it is inherited from PHP type. IMPORTANT: No leading backslash!

Optional attributes:

  • cascade: Cascade Option
  • fetch: One of LAZY or EAGER
  • orphanRemoval: Boolean that specifies if orphans, inverse OneToOne entities that are not connected to any owning instance, should be removed by Doctrine. Defaults to false.
  • inversedBy: The inversedBy attribute designates the field in the entity that is the inverse side of the relationship.

Example:

1<?php /** * @OneToOne(targetEntity="Customer") * @JoinColumn(name="customer_id", referencedColumnName="id") */ private $customer;
2
3
4
5
6

@OneToMany

Required attributes:

  • targetEntity: FQCN of the referenced target entity. Can be the unqualified class name if both classes are in the same namespace. IMPORTANT: No leading backslash!

Optional attributes:

  • cascade: Cascade Option
  • orphanRemoval: Boolean that specifies if orphans, inverse OneToOne entities that are not connected to any owning instance, should be removed by Doctrine. Defaults to false.
  • mappedBy: This option specifies the property name on the targetEntity that is the owning side of this relation. Its a required attribute for the inverse side of a relationship.
  • fetch: One of LAZY, EXTRA_LAZY or EAGER.
  • indexBy: Index the collection by a field on the target entity.

Example:

1<?php /** * @OneToMany(targetEntity="Phonenumber", mappedBy="user", cascade={"persist", "remove", "merge"}, orphanRemoval=true) */ public $phonenumbers;
2
3
4
5

@OrderBy

Optional annotation that can be specified with a @ManyToMany or @OneToMany annotation to specify by which criteria the collection should be retrieved from the database by using an ORDER BY clause.

This annotation requires a single non-attributed value with an DQL snippet:

Example:

1<?php /** * @ManyToMany(targetEntity="Group") * @OrderBy({"name" = "ASC"}) */ private $groups;
2
3
4
5
6

The DQL Snippet in OrderBy is only allowed to consist of unqualified, unquoted field names and of an optional ASC/DESC positional statement. Multiple Fields are separated by a comma (,). The referenced field names have to exist on the targetEntity class of the @ManyToMany or @OneToMany annotation.

@PostLoad

Marks a method on the entity to be called as a @PostLoad event. Only works with @HasLifecycleCallbacks in the entity class PHP DocBlock.

@PostPersist

Marks a method on the entity to be called as a @PostPersist event. Only works with @HasLifecycleCallbacks in the entity class PHP DocBlock.

@PostRemove

Marks a method on the entity to be called as a @PostRemove event. Only works with @HasLifecycleCallbacks in the entity class PHP DocBlock.

@PostUpdate

Marks a method on the entity to be called as a @PostUpdate event. Only works with @HasLifecycleCallbacks in the entity class PHP DocBlock.

@PrePersist

Marks a method on the entity to be called as a @PrePersist event. Only works with @HasLifecycleCallbacks in the entity class PHP DocBlock.

@PreRemove

Marks a method on the entity to be called as a @PreRemove event. Only works with @HasLifecycleCallbacks in the entity class PHP DocBlock.

@PreUpdate

Marks a method on the entity to be called as a @PreUpdate event. Only works with @HasLifecycleCallbacks in the entity class PHP DocBlock.

@SequenceGenerator

For use with @GeneratedValue(strategy=SEQUENCE) this annotation allows to specify details about the sequence, such as the increment size and initial values of the sequence.

Required attributes:

  • sequenceName: Name of the sequence

Optional attributes:

  • allocationSize: Increment the sequence by the allocation size when its fetched. A value larger than 1 allows optimization for scenarios where you create more than one new entity per request. Defaults to 10
  • initialValue: Where the sequence starts, defaults to 1.

Example:

1<?php /** * @Id * @GeneratedValue(strategy="SEQUENCE") * @Column(type="integer") * @SequenceGenerator(sequenceName="tablename_seq", initialValue=1, allocationSize=100) */ protected $id = null;
2
3
4
5
6
7
8

@SqlResultSetMapping

The SqlResultSetMapping annotation is used to specify the mapping of the result of a native SQL query. The SqlResultSetMapping annotation can be applied to an entity or mapped superclass.

Required attributes:

  • name: The name given to the result set mapping, and used to refer to it in the methods of the Query API.

Optional attributes:

  • entities: Array of @EntityResult, Specifies the result set mapping to entities.
  • columns: Array of @ColumnResult, Specifies the result set mapping to scalar values.

Example:

1<?php /** * @NamedNativeQueries({ * @NamedNativeQuery( * name = "fetchUserPhonenumberCount", * resultSetMapping= "mappingUserPhonenumberCount", * query = "SELECT id, name, status, COUNT(phonenumber) AS numphones FROM cms_users INNER JOIN cms_phonenumbers ON id = user_id WHERE username IN (?) GROUP BY id, name, status, username ORDER BY username" * ), * @NamedNativeQuery( * name = "fetchMultipleJoinsEntityResults", * resultSetMapping= "mappingMultipleJoinsEntityResults", * query = "SELECT u.id AS u_id, u.name AS u_name, u.status AS u_status, a.id AS a_id, a.zip AS a_zip, a.country AS a_country, COUNT(p.phonenumber) AS numphones FROM cms_users u INNER JOIN cms_addresses a ON u.id = a.user_id INNER JOIN cms_phonenumbers p ON u.id = p.user_id GROUP BY u.id, u.name, u.status, u.username, a.id, a.zip, a.country ORDER BY u.username" * ), * }) * @SqlResultSetMappings({ * @SqlResultSetMapping( * name = "mappingUserPhonenumberCount", * entities= { * @EntityResult( * entityClass = "User", * fields = { * @FieldResult(name = "id"), * @FieldResult(name = "name"), * @FieldResult(name = "status"), * } * ) * }, * columns = { * @ColumnResult("numphones") * } * ), * @SqlResultSetMapping( * name = "mappingMultipleJoinsEntityResults", * entities= { * @EntityResult( * entityClass = "__CLASS__", * fields = { * @FieldResult(name = "id", column="u_id"), * @FieldResult(name = "name", column="u_name"), * @FieldResult(name = "status", column="u_status"), * } * ), * @EntityResult( * entityClass = "Address", * fields = { * @FieldResult(name = "id", column="a_id"), * @FieldResult(name = "zip", column="a_zip"), * @FieldResult(name = "country", column="a_country"), * } * ) * }, * columns = { * @ColumnResult("numphones") * } * ) *}) */ class User { /** @Id @Column(type="integer") @GeneratedValue */ public $id; /** @Column(type="string", length=50, nullable=true) */ public $status; /** @Column(type="string", length=255, unique=true) */ public $username; /** @Column(type="string", length=255) */ public $name; /** @OneToMany(targetEntity="Phonenumber") */ public $phonenumbers; /** @OneToOne(targetEntity="Address") */ public $address; // .... }
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79

@Table

Annotation describes the table an entity is persisted in. It is placed on the entity-class PHP DocBlock and is optional. If it is not specified the table name will default to the entity's unqualified classname.

Required attributes:

  • name: Name of the table

Optional attributes:

  • indexes: Array of @Index annotations
  • uniqueConstraints: Array of @UniqueConstraint annotations.
  • schema: Name of the schema the table lies in.

Example:

1<?php /** * @Entity * @Table(name="user", * uniqueConstraints={@UniqueConstraint(name="user_unique",columns={"username"})}, * indexes={@Index(name="user_idx", columns={"email"})} * schema="schema_name" * ) */ class User { }
2
3
4
5
6
7
8
9
10

@UniqueConstraint

Annotation is used inside the @Table annotation on the entity-class level. It allows to hint the SchemaTool to generate a database unique constraint on the specified table columns. It only has meaning in the SchemaTool schema generation context.

Required attributes:

  • name: Name of the Index
  • fields: Array of fields. Exactly one of fields, columns is required.
  • columns: Array of columns. Exactly one of fields, columns is required.

Optional attributes:

  • options: Array of platform specific options:

    • where: SQL WHERE condition to be used for partial indexes. It will only have effect on supported platforms.

Basic example:

1<?php /** * @Entity * @Table(name="ecommerce_products",uniqueConstraints={@UniqueConstraint(name="search_idx", columns={"name", "email"})}) */ class ECommerceProduct { }
2
3
4
5
6
7
8

Basic example using fields:

1<?php /** * @Entity * @Table(name="ecommerce_products",uniqueConstraints={@UniqueConstraint(name="search_idx", fields={"name", "email"})}) */ class ECommerceProduct { }
2
3
4
5
6
7
8

Example with partial indexes:

1<?php /** * @Entity * @Table(name="ecommerce_products",uniqueConstraints={@UniqueConstraint(name="search_idx", columns={"name", "email"}, options={"where": "(((id IS NOT NULL) AND (name IS NULL)) AND (email IS NULL))"})}) */ class ECommerceProduct { }
2
3
4
5
6
7
8

@Version

Marker annotation that defines a specified column as version attribute used in an optimistic locking scenario. It only works on @Column annotations that have the type integer or datetime. Combining @Version with @Id is not supported.

Example:

1<?php /** * @Column(type="integer") * @Version */ protected $version;
2
3
4
5
6