Note
Refer to the main article to gain more insights on data table.
You can create a data table using two distinct methods.
In this article, let's get to know how create a data table from Scratch.
Citizen Developers can use plain text commands to instruct our Caddie to create data tables, including multiple tables with relationships and keys, automatically. Caddie generates a high-level ER diagram and allows for iterative adjustments through simple text instructions until requirements are met.
A key in the Manage Columns pop-up refers to a column or set of columns that uniquely identify each row in the table. In Quixy's database, there are three distinct types of keys: Primary Key, Composite Key, and Foreign Key.
1. Primary Key: A primary key is a special column in a relational database table designated to uniquely identify all table records. The Features of a primary key value are:
Example
Students are assigned unique identification (ID) numbers, and all adults receive government-assigned and uniquely identifiable Social Security numbers.
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)
Note
To create a data table for storing data, it is not necessary to include all the fields from the corresponding application. You can select only the required fields for the data table.
Caution
For an app to save data in a data table, the form fields in the app and the fields in the data table must match.
Note
Natural Sorting Capabilities: Configure your data tables by enabling Natural Sorting at the field level such as text, auto-generated content, email addresses, calculated strings, or connected records. This feature ensures that your alpha-numeric data is presented in a seamlessly sorted manner in Grid Reports and List Views, as our regular sorting method sometimes fell short in providing the right sorting experience for alpha-numeric data.
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.
This functionality makes it safer and easier for organizational 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...
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.
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.