Create a Table in the Data Store

Next, let’s create a table in the Data Store in the ZCDrive project. This table stores the metadata of the files that are uploaded in the Android app.

To create a table:

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

2. Click Data Store under Storage. Click Create a New Table.
3. Enter the table's name as "Files" and click Create.

Create Columns

We will create five columns in this table to store the file ID, name, type, and the uploaded time of the file.

1. Click + New Column in the Schema View section for the table.

2. Enter the column's name as "file_id". Select the data type as Var Char and enter the max length as 100. You must enable the Is Mandatory toggle.

You can learn about the various data types supported by Catalyst and the other properties of a column from the Data Store help page.

3. Click Create.

Create the other columns in the same way with the values shown in the images:

uploaded_time:

file_type:

bucket_name:

version_id:

All columns will be created and listed in the Schema View section.

The Data Store is now configured for the app.

Each time you upload a file in the app, a row will get created for it in the Files table. When you delete a file, its data row will also be deleted from the table automatically.