Creating Data
Learn how to save data to your tables
Simple Tables
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.
Plucking Foreign Keys
Master and Part Tables
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.
Binding Constraints
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:
Last updated
