Configure Properties

Configuring column properties ensures that your data is accurate and consistent in the database. Setting the right data types, constraints, and relationships prevents errors and improves data integrity. It keeps the database manageable and scalable, making future updates easier.

1. Column set up in PowerTable

After loading your data into PowerTable, you can configure the column properties in the Columns section.

The column properties include the input type, whether the column is editable or not, its default value, minimum and maximum values (constraints), lookup and relation, prefix, suffix, etc.

  • While importing CSV data or creating a database from scratch, you will be allowed to configure these properties during the initial steps.

  • When connecting to a database, PowerTable automatically detects and configures the input type and other basic settings. You can either retain them or change them as needed to meet specific business requirements.

You can modify the column properties at any time by selecting Setup > Columns.

Setup columns

You can also click on Manage Columns > Edit Config to configure the column properties.

Edit column properties

This opens the column setup window, as shown below.

Columns setup

2. Display

The 'Display' field allows you to display or hide a column from the table. You can clear this box to hide a specific column. This option can be useful when certain data does not need to be displayed but should remain in the table.

Display

To adjust the width of columns, click and drag the column headers manually or configure them from the Manage Columns menu.

3. Required

This field specifies whether the user must enter the values in the column or if they can be left blank. Checking this box makes the column mandatory. You can specify which columns are required.

Typically, primary keys and business keys are considered required columns.

Required

4. Configuring Column Properties

To edit a column's properties, click the pencil icon next to it or double-click the column name.

Edit column properties

The column properties are broadly classified into General and Display properties.

  • Configuring general properties includes defining the column's input type, constraints, and default value.

  • Display properties include a column's display name and its description. For number-type columns, you can also configure the required prefix, suffix, and thousand separator.

We will explain each of the above in the upcoming sections.

Last updated