ID generator

Last modified: April 3, 2025

The ID generator produces unique identifiers for rows in a database table. These IDs can be used to distinguish records and maintain database integrity.

The ID generator includes the following generators:

• ID (sequential)
• ID (random)
• ID (numeric sequential)
• ID (hexadecimal sequential)
• ID (composite sequential)
• ID (globally unique identifier)

ID (sequential) generator

The ID (Sequential) generator creates unique, sequential numeric identifiers for rows in a database table. These identifiers increase incrementally and are commonly used as primary keys or other unique fields to ensure each record can be distinguished from others.

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Example of generated data	Data type matching	Country-specific
ID (s)	1, 2, 3, 4, …, 9, 10, 11, 12, …	bigintintegersmallintdouble precision	Default

Matching rules

The generator can be assigned to a column whose name is ‘ID’, regardless of the table name.

Configure additional options

The tool allows you to specify the minimum and maximum values. The default range is from 1 to 9223372036854775807.

Note

The default maximum value varies depending on the data type.

Preview of the column data generated by the ID (sequential) generator

The screenshot shows the maximum value for the bigint data type. Note that the maximum values for other data types may vary.

ID (random) generator

The ID (random) generator creates unique identifiers, account numbers or codes, or numeric values, such as serial or ticket numbers, for database records using randomization rather than sequential order.

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Example of generated data	Data type matching	Country-specific
ID (r)	54470, 16912, 43814, 06728, 36017, 82433, 95664, …	character varyingcharactertext	Default

Matching rules

The generator can be assigned to a column whose name is ‘ID’, ‘ACC’, or ‘NUM’, regardless of the table name.

Configure additional options

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

Preview of the table data generated by the ID (random) generator

ID (numeric sequential) generator

The ID (numeric sequential) generator creates a series of unique, sequential numeric identifiers.

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Example of generated data	Data type matching	Country-specific
ID (ns)	00000, 00001, 00002, …, 99997, 99998, 99999	character varyingcharactertext	Default

Matching rules

The generator can be assigned to a column whose name is ‘ID’, ‘ACC’, or ‘NUM’, regardless of the table name.

Configure additional options

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

Preview of the column data generated by the ID (numeric sequential) generator

ID (hexadecimal sequential) generator

The ID (hexadecimal sequential) generator produces unique identifiers in hexadecimal format that follow a sequential order.

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Example of generated data	Data type matching	Country-specific
ID (hs)	00000, 00001, 00002, …, FFFFD, FFFFE, FFFFF	character varyingcharactertext	Default

Matching rules

The generator can be assigned to a column whose name is ‘ID’, ‘ACC’, or ‘NUM’, regardless of the table name.

Configure additional options

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

Preview of the column data generated by the ID (hexadecimal sequential) generator

ID (composite sequential) generator

The ID (composite sequential) generator produces unique identifiers that combine multiple elements or fields (e.g., numeric, alphanumeric, or other data types), with each part of the identifier following a sequential pattern.

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Example of generated data	Data type matching	Country-specific
ID (cs)	ID000, ID001, ID002, …, ID997, ID998, ID999	character varyingcharactertext	Default

Matching rules

The generator can be assigned to a column whose name is ‘ID’, ‘ACC’, or ‘NUM’, regardless of the table name.

Configure additional options

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

Preview of the column data generated by the ID (composite sequential) generator

ID (globally unique identifier) generator

The ID (globally unique identifier) generator creates a unique identifier that is guaranteed to be globally unique across different systems and instances. This identifier is typically represented as a UUID (Universally Unique Identifier) or GUID (Globally Unique Identifier).

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Example of generated data	Data type matching	Country-specific
ID (guid)	25f64401-1ec2-39c6-87b2-ca571da4a630, 6ab83b1e-2094-2176-16d1-b5f6e90d259e, …	character varyingcharactertext	Default

Matching rules

The generator can be assigned to a column whose name is ‘GUID’ or ‘UUID’, regardless of the table name.

Configure additional options

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

Preview of the column data generated by the ID (globally unique identifier) generator