Primary Key Generation information

Primary Key Generation

These fields define how the primary key is generated. These fields correspond to the @GeneratedValue annotation.

Generated Value

Strategy

• Auto

• Identity – Values are assigned by the database's Identity column.

• Sequence – Values are assigned by a sequence table (see Sequence Generator).

• Table – Values are assigned by a database table (see Table Generator).

Auto

Generator Name

Unique name of the generated value.

Table Generator

These fields define the database table used for generating the primary key and correspond to the @TableGenerator annotation.

These fields apply only when Strategy = Table.

Name

Unique name of the generator.

Table

Database table that stores the generated ID values.

Schema

Schema of the table

Catalog

Catalog of the table

Primary Key Column

The column in the table generator's Table that contains the primary key.

Value Column

The column that stores the generated ID values.

Primary Key Column Value

The value for the Primary Key Column in the generator table.

Allocation size

Initial value

Sequence Generator

These fields define the specific sequence used for generating the primary key and correspond to the @SequenceGenerator annotation.

These fields apply only when Strategy = Sequence.

Name

Name of the sequence table to use for defining primary key values.

Sequence

Unique name of the sequence.

Schema

Catalog

Allocation size

Initial value