Create a Table in the Data Store

Next, let’s create a table in the Data Store in the CatalystDialerApp project. As discussed earlier, this table is used to store to-do list items created by the user.

To create a table:

  1. Navigate to the Catalyst CloudScale DataStore component in the console. Click Start Exploring. cloudscale

  2. Click Create a new Table.

create-table

  1. Enter the table’s name as “CallLog”, then click Create. table-name
Note : Ensure that you enter the name exactly as instructed, because the application's code contains the same name.

The table is now created and displayed in the Data Store page.

Create Columns

Next, let’s create a column to store the details of the call.

  1. Click New Column in the Schema View section of the table. new-column

  2. Enter the column’s name as “callDuration”. Select the data type as ‘int’ and click the ‘Is Mandatory’ toggle switch to enable it.

column-details You can learn about the various data types supported by Catalyst and the other properties of a column from the Data Store help page.
Note: Ensure that you enter the name exactly as instructed, because the application's code contains the same name.
  1. Click Create.

The column is now created and listed in the Schema View section.

You must now create five other columns in the same way. The table must contain six columns in total with the following mandatory properties :

Column Name Data Type Max Length
callStatus varchar 255
calledCountry varchar 255
timeOfCall varchar 255
fromNumber varchar
toNumber text
created-columns

You have now configured all the necessary components from the console. You will now be working on coding the application from your local system.

Last Updated 2024-06-12 17:37:03 +0530 +0530

RELATED LINKS

Data Store