databaseId | string | Yes | Id of the database the table belongs to, from ListDatabases. |
tableId | string | Yes | Id of the table to add the column to, from DescribeDatabase or CreateTable. It must belong to databaseId. |
name | string | Yes | Display name of the column, as the user would head it — e.g. “Dietary Needs”. SQL refers to it by this name, quoted. |
dataType | "text" | "number" | "boolean" | "date" | "link" | "select" | "select_number" | "tag" | "entity" | Yes | The value type of a column, as the model names it. A deliberate mirror of [DataType] rather than a re-export: the property system’s names are internal, and the tool vocabulary has to stay stable independently of them. |
isMultiSelect | boolean | No | True if a cell can hold several values at once. Defaults to false. Multi-valued cells are written as lists in SQL; test membership with col HAS 'x'. |
options | string[] | No | For a select, select_number, or tag column, the allowed labels — e.g. [“Going”, “Maybe”, “Declined”]. SQL writes and reads these labels verbatim, and anything else is rejected by the statement, so list every value the data actually has. A select_number column’s labels must be numbers. Omit for other column types; add more later with AddColumnOptions. |
specificEntityType | "USER" | "DOCUMENT" | "TASK" | "COMPANY" | "CALL_RECORD" | "CHANNEL" | "CHAT" | "PROJECT" | "THREAD" | "CALENDAR_EVENT" | "INITIATIVE" | No | Required for dataType entity without linkToTableId, and refused otherwise: what the ids reference, e.g. USER for a person column or DOCUMENT. |
linkToTableId | string | No | Id of another table of this database, making this a relation whose cells hold that table’s row ids. Omit for any other column. |
