MapKeyJoinColumn annotation is specified, a single
join column is assumed and the default values apply.
Example 1:
@Entity
public class Company {
@Id int id;
...
@OneToMany // unidirectional
@JoinTable(name="COMPANY_ORGANIZATION",
joinColumns=@JoinColumn(name="COMPANY"),
inverseJoinColumns=@JoinColumn(name="VICEPRESIDENT"))
@MapKeyJoinColumn(name="DIVISION")
Map<Division, VicePresident> organization;
}
Example 2:
@Entity
public class VideoStore {
@Id int id;
String name;
Address location;
...
@ElementCollection
@CollectionTable(name="INVENTORY",
joinColumns=@JoinColumn(name="STORE"))
@Column(name="COPIES_IN_STOCK")
@MapKeyJoinColumn(name="MOVIE", referencedColumnName="ID")
Map<Movie, Integer> videoInventory;
...
}
@Entity
public class Movie {
@Id long id;
String title;
...
}
Example 3:
@Entity
public class Student {
@Id int studentId;
...
@ManyToMany // students and courses are also many-many
@JoinTable(name="ENROLLMENTS",
joinColumns=@JoinColumn(name="STUDENT"),
inverseJoinColumns=@JoinColumn(name="SEMESTER"))
@MapKeyJoinColumn(name="COURSE")
Map<Course, Semester> enrollment;
...
}
ForeignKey
| Modifier and Type | Method and Description |
|---|---|
| public String | |
| public ForeignKey | foreignKey()
(Optional) Used to specify or control the generation of a foreign key constraint when table generation is in effect. |
| public boolean | insertable()
(Optional) Whether the column is included in SQL INSERT statements generated by the persistence provider. |
| public String | |
| public boolean | |
| public String | |
| public String | |
| public boolean | |
| public boolean | updatable()
(Optional) Whether the column is included in SQL UPDATE statements generated by the persistence provider. |
| columnDefinition | back to summary |
|---|---|
| public String columnDefinition() (Optional) The SQL fragment that is used when generating the DDL for the column. Defaults to SQL generated by the provider for the column. | |
| foreignKey | back to summary |
|---|---|
| public ForeignKey foreignKey() (Optional) Used to specify or control the generation of a foreign key constraint when table generation is in effect. If this element is not specified, the persistence provider's default foreign key strategy will apply.
| |
| insertable | back to summary |
|---|---|
| public boolean insertable() (Optional) Whether the column is included in SQL INSERT statements generated by the persistence provider. | |
| name | back to summary |
|---|---|
| public String name() (Optional) The name of the foreign key column for the map key. The table in which it is found depends upon the context.
Default (only applies if a single join column is used.) The concatenation of the following: the name of the referencing relationship property or field of the referencing entity or embeddable class; "_"; "KEY". | |
| nullable | back to summary |
|---|---|
| public boolean nullable() (Optional) Whether the foreign key column is nullable. | |
| referencedColumnName | back to summary |
|---|---|
| public String referencedColumnName() (Optional) The name of the column referenced by this foreign key column. The referenced column is in the table of the target entity. Default (only applies if single join column is being used.) The same name as the primary key column of the referenced table | |
| table | back to summary |
|---|---|
| public String table() (Optional) The name of the table that contains the foreign key column.
Default:
| |
| unique | back to summary |
|---|---|
| public boolean unique() (Optional) Whether the property is a unique key. This is a
shortcut for the | |
| updatable | back to summary |
|---|---|
| public boolean updatable() (Optional) Whether the column is included in SQL UPDATE statements generated by the persistence provider. | |