Configure a table definition

In this topic, you learn how to configure a table definition for a database table in Table Definition.

Prerequisites

  • There are no prerequisites.

Procedure

  1. In the Cockpit, go to Tools and select Table Definition.

  2. Select Add to create a new database table.

  3. In the Create Definition dialog, enter a meaningful Name.

  4. In ID Format, choose between UUID and Incremental:.

    • UUID: A Universally Unique Identifier (UUID) is a 128-bit, uniquely generated label number. Neptune recommends you use UUIDs when entering table data.

    • Incremental: Select Incremental if your data requires a clear order, for example for the IDs of invoices with ascending invoice numbers. If you delete a table row, the order of the remaining IDs is still preserved.

  5. Select Create.

    Result: You have created a table definition. The General tab of the table definition opens.

  6. Enter a short and meaningful Description.

  7. If you want to track logs of your database table in the Table Audit, activate Enable Table Audit.

  8. If you are working on a development package, you can include the metadata when using Git.

  9. Select Save.