Awee

app:field

Retrieves the definition of a single field within a table

Retrieves the definition of a single field within a table

Options

NameTypeDescription
org_idstringThe organisation ID that scopes the operation
schema_idstringThe name of the schema (database) that contains the table
tablestringThe name of the table that contains the field
fieldstringThe name of the field to retrieve

Outputs

NameTypeDescription
fieldFieldThe retrieved field definition
  ↳ namestringIs the column name. Must be unique within the table and must not collide with reserved record fields (id, created_at, updated_at, deleted_at).
  ↳ typeFieldTypeIs the field's data type. See the FieldType constants for the supported values.
  ↳ requiredboolMarks the field as non-nullable. Inserts and updates that omit a required field (and provide no Default) are rejected.
  ↳ defaultanyIs the value applied when a record is inserted without an explicit value for this field. A nil or zero value means no default is applied.
  ↳ related_tablestringIs the name of the target table for relation fields. Required when Type is has_one, has_many, or belongs_to; ignored otherwise.
  ↳ related_fieldstringIs the name of the foreign-key field on the related table. Used only by has_many to identify which column on RelatedTable points back to this record.
  ↳ descriptionstringIs a human-readable explanation of the field's purpose. Surfaced in generated documentation and GUI tooling; has no effect on storage or validation.

How is this guide?

On this page