You can create a data table using two distinct methods.
- Create from Scratch
- Create using Excel
In this article, you shall learn to create a data table from Scratch.
Create a Data Table from Scratch
- On dashboard page, click Admin Menu
> Database > Create Data Table.
- Select Create from Scratch.
- On Create Data Table pop-up, provide a Name to the data table and select a confined space for the data table to save, i.e., Global Level or Workspace Level.
- Global Level: A globally saved data table can be utilized to store data from any application or retrieve data into any application from any workspace.
- Workspace Level: A data table that is limited to a workspace can store data from an application or retrieve data into an application that is linked to the same workspace.
- Click Create.
The global data table can be used in any workspace Once a data table is created as global, in future it cannot be confined to a specific workspace
- Once you initiate the data table creation process, the platform will navigate you to the table configuration page.
- Click Manage Columns to establish the data fields in the data table.
- The platform will display a pop-up where in you can add data fields by dragging and dropping them onto the canvas, and then configuring their properties.
What is Key in the Manage Columns pop-up?
A key is a column or set of columns that uniquely identifies each row in the table. In Quixy data base there 3 distinct types of keys: Primary Key, Composite Key, and Foreign Key.
1. Primary Key: A primary key is a special relational database table column designated to uniquely identify all table records.
A primary key’s main features are:
- It must contain a unique value for each row of data.
- It cannot contain null values.
2. Composite Key: A composite key is a candidate key that consists of two or more attributes (table columns) that together uniquely identify an entity occurrence (table row).
3. Foreign Key: A foreign key, is a column or set of columns in one table that refers to the primary key of another table, establishing a relationship between the two tables. (Refer to the Relational Database section in this article!)
- Select Key Value.
- Click Save, to finish creating the data table. However, you can even connect the data tables and create a Relational Data base structure to make it easy to maintain consistency and accuracy of the data.
Relational Data base
A relational database is a collection of information that stores data in one or more tables (or "relations") with columns and rows. This makes it easy to see how different data structures relate to each other. Relationships are logical links between tables that are set up by how the tables interact with each other. Learn More...
- Once you finish establishing everything, Save the table. The platform will ask your permission to create Basic CRUD Functions.
- If you select NO, the system will save the data table without creating the CRUD Functions.
- If you select YES, the system will create the CRUD Functions and then save the data table. Further You can edit these functions according to your requirements.
- By now, your data table creation will be completed.
- Now, If you wish to connect the Quixy data table to 3rd party platform to automatically sync data into Quixy data base. You can use Data Sync.
Data Sync
This functionality makes it safer and easier for Org.admins to import data automatically into the Quixy database from 3rd party databases at regular intervals. With API calls and authentication, this functionality assures data confidentiality and credibility.
Typically this functionality can be used in transactional processes (such as Employee data sync). On the one hand, data is collected on an ongoing basis, and on the other, you can set up a daily, weekly, or monthly schedule for the collected data to be automatically synced into Quixy database. Learn More...
Data table Indexes
A data table index is a feature that helps make database queries faster and more efficient (i.e., retrieving/fetching data from a data table). It works by creating a special list of all the values in a specific column of a table, along with the locations of the rows where those values appear. Learn More...
There are best practices that you can follow while creating a data table to get yield best results.