Create fields in a table
How to edit the fields in a table. Detail of the available options.
You begin editing a new field in the table by clicking the "Create a new field" button on the table menu.
![Entry point to create a new field](https://files.readme.io/c2b0e4b-Capture_decran_2024-05-29_a_11.48.19.png)
Entry point to create a new field
You are invited to choose values for the following inputs:
Input | Values | Description |
---|---|---|
Name | alphanumeric + "_ " | Unique per table. Case sensitive |
Description | free text | Description for the scenario builders |
Required | true / false | Do you want to allow ingestion of objects where this value is missing |
Type | string / boolean / timestamp / number | Select one of the four values |
Is an enumerated value | true / false | Do you want to keep track of distinct values seen (for contextual help in the rule builder). Incompatible with "unique". Only available for string and number type fields. |
Is unique | true / false | Is the field unique, i.e. can there be only of row (one object_id for every distinct value of this field). Only available for string and number type fields. |
![Empty field creation modale](https://files.readme.io/0ba44f4-Capture_decran_2024-05-29_a_11.43.42.png)
Empty field creation modale
![Filled field creation modale](https://files.readme.io/41f4550-Capture_decran_2024-05-29_a_11.46.37.png)
Filled field creation modale
Once you're done editing your table, you should be left with something like the following
![Filled table (table view)](https://files.readme.io/fd4ad41-Capture_decran_2024-05-29_a_12.00.34.png)
Filled table (table view)
![Filled table (schema view)](https://files.readme.io/928d8a6-Capture_decran_2024-05-29_a_12.00.44.png)
Filled table (schema view)
At this point, your entity is ready and you can develop a first scenario for decisions on it - though you may want to define linked tables first (more on this in the following).
Updated 3 months ago