Specific DB Type
Create a Specific DB Type field
- Click the
+icon to the right ofFields header. - In the dropdown modal, enter the field name (Optional).
- In the dropdown, select the field type
Specific DB Type. - Configure the default value for the field (Optional).
- Enter the configuration of the DB specific data type.
- Click
Save Field.
Advanced field attributes
| Attribute | What it does |
|---|---|
NN Not Null | Makes sure that a column cannot have a NULL value. A value must always be given. |
PK Primary Key | Identifies each record in a table uniquely. |
AI Auto Increment | Makes a unique number automatically for each new record. Usually used with primary keys. |
UN Unsigned | Makes sure that a column stores only non-negative numbers. Frequently used for counters, identifiers or monetary values. |
AU Auto Update | Sets a column to the current timestamp automatically when a record is updated. Frequently used for timestamp or datetime columns. |
:::note Specific DB type is available only for external Data source connections :::
Last updated on
Latest product updates?See Changelog