SecondaryTable (EclipseLink 2.6.4, API Reference)

@Target(value=TYPE)
@Retention(value=RUNTIME)
public @interface SecondaryTable

Specifies a secondary table for the annotated entity class. Specifying one or more secondary tables indicates that the data for the entity class is stored across multiple tables.

If no SecondaryTable annotation is specified, it is assumed that all persistent fields or properties of the entity are mapped to the primary table. If no primary key join columns are specified, the join columns are assumed to reference the primary key columns of the primary table, and have the same names and types as the referenced primary key columns of the primary table.

    Example 1: Single secondary table with a single primary key column.

    @Entity
    @Table(name="CUSTOMER")
    @SecondaryTable(name="CUST_DETAIL", 
        pkJoinColumns=@PrimaryKeyJoinColumn(name="CUST_ID"))
    public class Customer { ... } 


    Example 2: Single secondary table with multiple primary key columns.

    @Entity
    @Table(name="CUSTOMER")
    @SecondaryTable(name="CUST_DETAIL",
        pkJoinColumns={
            @PrimaryKeyJoinColumn(name="CUST_ID"),
            @PrimaryKeyJoinColumn(name="CUST_TYPE")})
    public class Customer { ... }

Since:: Java Persistence 1.0

Required Element Summary

Required Elements
Modifier and Type Required Element and Description

java.lang.String name
(Required) The name of the table.

Required Elements
Modifier and Type	Required Element and Description
`java.lang.String`	`name` (Required) The name of the table.

Optional Element Summary

Optional Elements
Modifier and Type	Optional Element and Description
`java.lang.String`	`catalog` (Optional) The catalog of the table.
`ForeignKey`	`foreignKey` (Optional) Used to specify or control the generation of a foreign key constraint for the columns corresponding to the `pkJoinColumns` element when table generation is in effect.
`Index[]`	`indexes` (Optional) Indexes for the table.
`PrimaryKeyJoinColumn[]`	`pkJoinColumns` (Optional) The columns that are used to join with the primary table.
`java.lang.String`	`schema` (Optional) The schema of the table.
`UniqueConstraint[]`	`uniqueConstraints` (Optional) Unique constraints that are to be placed on the table.

- Element Detail
  - name
```
public abstract java.lang.String name
```
    (Required) The name of the table.
  - catalog
```
public abstract java.lang.String catalog
```
    (Optional) The catalog of the table.
    Defaults to the default catalog.
    
    Default:
    
    ""
  - schema
```
public abstract java.lang.String schema
```
    (Optional) The schema of the table.
    Defaults to the default schema for user.
    
    Default:
    
    ""
  - pkJoinColumns
```
public abstract PrimaryKeyJoinColumn[] pkJoinColumns
```
    (Optional) The columns that are used to join with the primary table.
    Defaults to the column(s) of the same name(s) as the primary key column(s) in the primary table.
    
    Default:
    
    {}
  - foreignKey
```
public abstract ForeignKey foreignKey
```
    (Optional) Used to specify or control the generation of a foreign key constraint for the columns corresponding to the pkJoinColumns element when table generation is in effect. If both this element and the foreignKey element of any of the pkJoinColumns elements are specified, the behavior is undefined. If no foreign key annotation element is specified in either location, the persistence provider's default foreign key strategy will apply.
    
    Since:
    
    Java Persistence 2.1
    
    Default:
    
    @javax.persistence.ForeignKey(javax.persistence.ConstraintMode.PROVIDER_DEFAULT)
  - uniqueConstraints
```
public abstract UniqueConstraint[] uniqueConstraints
```
    (Optional) Unique constraints that are to be placed on the table. These are typically only used if table generation is in effect. These constraints apply in addition to any constraints specified by the Column and JoinColumn annotations and constraints entailed by primary key mappings.
    Defaults to no additional constraints.
    
    Default:
    
    {}
  - indexes
```
public abstract Index[] indexes
```
    (Optional) Indexes for the table. These are only used if table generation is in effect.
    
    Since:
    
    Java Persistence 2.1
    
    Default:
    
    {}

Annotation Type SecondaryTable

Required Element Summary

Optional Element Summary

Element Detail

name

catalog

schema

pkJoinColumns

foreignKey

uniqueConstraints

indexes