Configuring table settings
Last updated
Last updated
To change the name of a table:
Click the table name.
In the name field, provide the new name.
Click the save icon.
Within a table, you can configure constraints to either:
Guarantee that the value of a column is unique.
Guarantee that a specified list of columns does not have the same value. For example, for an airline flight, the origin city and destination city should be different values.
The constraints list is on the table settings panel. To display the settings panel, in the table heading, click the settings icon.
To add a constraint, click Add Constraint.
To configure a constraint:
From the Type dropdown list, select the type of constraint.
For a uniqueness constraint, select Unique.
For a not equal constraint, select Not Equal.
For each column to add to the constraint, click Add column, then select the column to add.
To remove a column from the constraint, click its delete icon.
To remove a constraint, click the delete icon.
By default, each table is included in the exported data.
From the settings panel, you can configure a table to be excluded from the exported data.
To exclude the table, check Hide this table when exporting.
By default, every time you generate data, Fabricate generates a completely different set of values.
To generate the same set of data across the table, you can set a seed value for the table.
On the settings panel, in the Seed field, provide the seed value to use.
To have Fabricate generate a new seed value, click the generate icon next to the field.
By default, for a new table, Fabricate generates 100 rows. The row count is displayed above the table.
The free tier is limited to maximum of 100 rows per table.
When the row count is derived, then the row count does not display as a number of fields. Instead, Fabricate displays how the number of rows is calculated.
If the row count is not derived, then you can configure the number of rows in the table.
To configure a specific number of rows:
From the comparison dropdown, select exactly.
In the field, either provide a number or an expression that evaluates to a number.
Alternatively, you can set the number of rows based on the number of unique values of a specific type in the table. For example, for a list of orders, you can set the number of rows to be equal to the number of possible payment types or the number of locations.
From the comparison dropdown, select unique values of. Note that if there is not an appropriate value to use, then the unique values of option is not available.
From the value type dropdown list, select the value to use.
Note that you can also .
In some cases, the row count is derived based on column configuration. For example, when you configure a , you can configure the number of rows to generate for each primary key value.
