host.table.create
Declare a table in this tenant's SQL table store -- a different store from host.state.'s key-value namespace and its own tables: use host.state. for a handful of small values, host.table.* when you want real SQL (joins, aggregates, read-only queries) over rows. columns is {"column": "text"|"integer"|"real"| "timestamp"|"boolean"|"json"}; primary_key, if given, must name one of columns's own entries.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Table name to declare. | |
| columns | Yes | Column name to type map, each type one of text|integer|real|timestamp|boolean|json, e.g. {"id": "integer"}. | |
| tenant_key | No | The key `signup` returned. Required only when this connection carries no Authorization: Bearer header -- when both are present, the header wins. | |
| primary_key | No | Column name (must be in columns); optional. |