Create Table

Next, let’s create a table in the Data Store. This table is used to create the following columns to store the required details:

To create a table:

1. Navigate to the Catalyst Cloud Scale service section in the console and click Start Exploring.

   
   

2. Navigate to the Data Store component under the STORAGE section and click Create a new Table.

   
   

3. Enter the table’s name as “BirthDayReminder” and click Create.

   
   

Now, let’s create the required columns.

4. Click New Column in the Schema View section.

   
   

5. Enter the column’s name as “Name”. Select the data type as Var Char, and enter “100” as the Max Length.

   
   

6. Click Create.

   
   

7. Click the New Column button again to create the second column. Name it “Message”, select Text as its data type, and click Create.

   
   

8. Click the New Column button again to create the third column. Name it “BirthDay”, select Date as its data type, and click Create.

   
   

9. Click the New Column button again to create the fourth column. Name it “Email”, select Var Char as its data type, enter “120” as the Max Length, and click Create.

   
   

10. Lastly, click the New Column button again to create the fifth column. Name it “AutoSend”, select Boolean as its data type, select True as the Default Value, and click Create.

    
    

All of the required columns have been created.

Configure Scopes and Permissions

To allow any user of the Birthday Greetings application to create and manage birthday messages from the client application, you must enable CRUD operations for the App User profile and set its role as User.

To enable the required permissions:

1. Click the Scopes & Permissions tab.

   
   

2. Select the User profile for the App User role.

   
   

3. Select the Update, Insert, and Delete permissions for the App User by clicking the respective check boxes. Ensure that you do not change any other permission setting.

   
   

The Data Store component is now configured for the application.