tables_db_create_enum_column
Add an enumeration column to a database table by defining a list of allowed values. This tool restricts column entries to specified options and configures requirements, defaults, and array settings.
Instructions
Create an enumeration column. The elements param acts as a white-list of accepted values for this column.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_id | Yes | Database ID. | |
| table_id | Yes | Table ID. | |
| key | Yes | Column Key. | |
| elements | Yes | Array of enum values. | |
| required | Yes | Is column required? | |
| default | No | Default value for column when not provided. Cannot be set when column is required. | |
| array | No | Is column an array? |