SQL DDL import Support roadmap about erd-editor

[dineug]

job brunch

[dineug]

DDL to JSON

create table

{
  "type": "create.table",
  "name": "",
  "comment": "",
  "columns": [
    {
      "name": "",
      "dataType": "",
      "default": "",
      "comment": "",
      "primaryKey": false,
      "autoIncrement": false,
      "unique": false,
      "nullable": true
    }
  ],
  "indexes": [
    {
      "name": "",
      "columns": [
        {
          "name": "",
          "sort": "ASC"
        }
      ]
    }
  ],
  "foreignKeys": [
    {
      "columnNames": [],
      "refTableName": "",
      "refColumnNames": []
    }
  ]
}

create index

{
  "type": "create.index",
  "name": "",
  "unique": false,
  "tableName": "",
  "columns": [
    {
      "name": "",
      "sort": "ASC"
    }
  ]
}

alter table add primaryKey

{
  "type": "alter.table.add.primaryKey",
  "name": "",
  "columnNames": []
}

alter table add foreignKey

{
  "type": "alter.table.add.foreignKey",
  "name": "",
  "columnNames": [],
  "refTableName": "",
  "refColumnNames": []
}

alter table add unique

{
  "type": "alter.table.add.unique",
  "name": "",
  "columnNames": []
}