Creating Data
Learn how to save data to your tables
Last updated
Learn how to save data to your tables
Last updated
When inserting data into a table, a form will be created for you. Each input represents one column of the table. When you are finished, click the submit button to add this data to your table.
Master and Part Tables are handled by Helium as well. If the chosen table has Part Tables, additional form entries will be created for it. In the next example, Master has two parts: Part and Part2.
A master table always has one entry. A part table has zero or more entries and can be added/removed through the interface. The purple button at the bottom of each card adds an additional entry. The gray button to the right of each entry removes it.
Any foreign key in a part table that references its master table's primary key is considered a binding constraint. In this example, Part's master column is a foreign key that references Master's pk column. Helium disables these foreign key inputs and updates their values whenever the master table's primary key is updated. Here's an example:
On tables with foreign keys, the Pluck Button will pull up a modal Data Table for you to pick a row out of. In the next example, the ceo_id column references the Customer table.
