issue_comments: 1302721916

Mocked up a quick HTML+JavaScript form for creating that JSON structure using some iteration against Copilot prompts: ```html

/* JSON format:
{
  "table": {
      "name": "my new table",
      "columns": [
          {
              "name": "id",
              "type": "integer"
          },
          {
              "name": "title",
              "type": "text"
          }
      ]
     "pk": "id"
  }
}

HTML form with Javascript for creating this JSON:
*/

<form id="create-table-form"> <label for="table-name">Table name</label>
<label for="table-pk">Primary key</label>
<label for="column-name">Column name</label> <label for="column-type">Column type</label> <button type="button" id="add-column">Add column</button>

Current columns:

<button type="button" id="create-table">Create table</button> </form> <script> var form = document.getElementById('create-table-form'); var tableName = document.getElementById('table-name'); var tablePk = document.getElementById('table-pk'); var columnName = document.getElementById('column-name'); var columnType = document.getElementById('column-type'); var addColumn = document.getElementById('add-column'); var createTable = document.getElementById('create-table'); var columns = []; addColumn.addEventListener('click', () => { columns.push({ name: columnName.value, type: columnType.value }); var li = document.createElement('li'); li.textContent = columnName.value + ' (' + columnType.value + ')'; // Add a delete button to each column var deleteButton = document.createElement('button'); deleteButton.textContent = 'Delete'; deleteButton.addEventListener('click', () => { columns.splice(columns.indexOf(li), 1); li.remove(); }); li.appendChild(deleteButton); document.getElementById('columns').appendChild(li); }); createTable.addEventListener('click', () => { var table = { name: tableName.value, pk: tablePk.value, columns: columns }; console.log(JSON.stringify(table, null, 2)); }); </script>

```