Creating and Editing Tables

Overview

You can use SkyPoint Datavault to develop an application with standard tables, custom tables, or both. SkyPoint Datavault provides standard tables by default to capture the most common concepts within an organization. These standard tables support core business capabilities.

View, add, or customize the Table

  1. Click one of the Datavault that you want to view tables in the Display name column.

Alt text

  1. By default, it displays Standard type tables that are configured and set by the system. There are three types of tables related to SkyPoint Datavault as mentioned below:
  • Standard - The standard tables are designed and configured by SkyPoint in accordance with best practices used across industries. The standard tables are compliant with Modern Data Stack Platform (MDSP) and collect the most common concepts to support core business application capabilities.
  • Custom - The custom tables are new tables created in the Datavault environment. The user can customize the custom tables.
  • Activity - The activity tables are special tables that store business data. The activity tables are imported into the environment as a part of a managed solution and are not customizable.
Item Description
Table Displays the name of the table that is created by a system or user.
Name Displays the name of the table.
Type Indicates the type of table such as Standard or Custom. By default, it displays standard tables.
Customizable Indicates whether the user can customize the table.
Tags Load and display Datavault data. The core type tag is not editable. You can edit the custom type tag.
Actions Option to edit or remove the table.

To create a Table

  1. Click New table.

The New table window opens.

Alt text

  1. Enter the Display name, Plural display name, and Name. When you enter the display name, the other fields get auto-populated.
Item Description
Display name Indicates the singular name of the table. You can change it later.
Plural display name Indicates the plural name for the table. You can change it later.
Name Indicates the name of the table. You cannot change it later.

imageNote

The name of your table is the unique name across your environment. Once a table is created, the name cannot be changed as it may be referenced in your applications or code. The name has a prefix that has been automatically generated by the system. This prefix is intended to give your objects a unique name if you wish to import them into another environment in the future.

  1. In the Primary Name Column, enter Display name and Name.

imageNote

By default, every table contains a Primary Name Column, which is used by lookup fields when establishing relationships with other tables.

  1. If you want to enable customization, select Enable customization check box.
  2. Expand More settings.
  3. In the Description box, provide a meaningful description of the purpose of the table.
  4. Choose Table type from the drop-down list.
  5. Click Create.

You can see the custom table in the Tables tab.

Edit and delete a Table

  1. Go to Datavaults > Table.
  2. Select the table that you want to edit.

Alt text

  1. Click the horizontal ellipsis in the Actions column and do the following:
If you want to Then
Modify the Table Select Edit.
Delete the Table Select Remove.

imageNote

You can configure additional relationships and keys for the standard tables, but you cannot delete them. The custom tables offer all configuration options that standard tables do. Also, you can delete the custom tables.

Alt text

  1. Click Save to apply your changes.