The SQLIdGenerator service uses this table to generate IDs.

Column

Data Type

Constraint

id_space_name

VARCHAR(60)

NOT NULL

A string that uniquely identifies an IdSpace within an IdGenerator. An IdGenerator can refer to an IdSpace using this name.

seed

NUMERIC(19)

NOT NULL

The first ID in the space to reserve.

batch_size

INTEGER

NOT NULL

How many IDs to reserve at a time.

prefix

VARCHAR(10)

NULL

A string to prepend to the beginning of all string IDs generated from this IdSpace.

suffix

VARCHAR(10)

NULL

A string to append to the end of all string IDs generated from this IdSpace.