Table Definition
With Table Definition, you create and maintain database tables.
A table definition contains a table schema definition and metadata describing the table. Metadata are, for example, data types and data properties. You can add new table definitions or import them.
After you created a table definition, you can use the Table Browser to add data or the API Designer to create a table definition API. With the table definition API, you can integrate data from the table into an application and use API methods to interact with it.
Keys and indices
Neptune DXP - Open Edition supports both unique and foreign keys, and the use of indices in database tables.
When you create a table definition, you can add foreign keys from other table definitions and mark individual columns as Unique if you want to disallow duplicate values in that column.
When you create a table definition, you can add indices to individual columns. When you work with large tables, assigning indices to columns makes searching for data records in that column faster.