Skip to main content
Version: Latest

Specific DB type

Create a Specific DB Type field​

  1. Click on + icon to the right of Fields header
  2. On the dropdown modal, enter the field name (Optional).
  3. Select the field type as Specific DB Type from the dropdown.
  4. Configure default value for the field (Optional)
  5. Provide DB specific data type configurations
  6. Click on Save Field button.

image

Advanced field attributes​

  • NN Not Null : Ensures that a column cannot have a NULL value, requiring that a value must always be provided.
  • PK Primary Key : Uniquely identifies each record in a table.
  • AI Auto Increment : Automatically generates a unique number for each new record, typically used with primary keys.
  • UN Unsigned : Ensures that a column can only store non-negative numbers, commonly used for counters, identifiers, or monetary values.
  • AU Auto Update : Automatically updates a column to the current timestamp when a record is updated, often used for timestamp or datetime columns.
note

Specific DB type is available only for external Data source connections