Steps to Create a Table in Digisquare Platform

Pre-requisite: Create Integration

Before creating a table, make sure to set up the database integration. Follow the integration steps to connect your database.

Table Name and Columns

Start by specifying a unique name for your new table. Next, add the necessary columns by entering their names, specifying the data types (such as text, integer, date, etc.), and defining the attributes for each column. Attributes include options like NULL/NOT NULL to indicate whether the column can have null values, and setting default values if applicable.

Adding Indexes

Create indexes to enhance query performance by specifying a unique name for each index and selecting the appropriate index type (e.g., primary, unique, full-text). Determine which columns should be included in the index to optimize data retrieval.