AI 提示词：SQL结构解析转换器

转换结果概览

• 原始DDL语句摘要
  • CREATE TABLE app_user (...)
  • ALTER TABLE app_user ADD COLUMN last_login TIMESTAMP
  • CREATE TABLE user_profile (...)
  • CREATE INDEX idx_app_user_email ON app_user(email)
• 解析状态标识
  • 成功

JSON数据结构

{
  "tables": [
    {
      "table_name": "app_user",
      "columns": [
        {
          "name": "id",
          "type": "BIGINT",
          "constraints": ["PRIMARY KEY"]
        },
        {
          "name": "username",
          "type": "VARCHAR(32)",
          "constraints": ["NOT NULL"]
        },
        {
          "name": "email",
          "type": "VARCHAR(64)",
          "constraints": []
        },
        {
          "name": "created_at",
          "type": "TIMESTAMP",
          "constraints": ["DEFAULT CURRENT_TIMESTAMP"]
        },
        {
          "name": "last_login",
          "type": "TIMESTAMP",
          "constraints": []
        }
      ],
      "constraints": {
        "primary_key": "PRIMARY KEY (id)",
        "foreign_keys": [],
        "indexes": [
          {
            "name": "idx_app_user_email",
            "columns": ["email"]
          }
        ]
      }
    },
    {
      "table_name": "user_profile",
      "columns": [
        {
          "name": "user_id",
          "type": "BIGINT",
          "constraints": ["PRIMARY KEY"]
        },
        {
          "name": "nickname",
          "type": "VARCHAR(32)",
          "constraints": []
        },
        {
          "name": "bio",
          "type": "VARCHAR(128)",
          "constraints": []
        }
      ],
      "constraints": {
        "primary_key": "PRIMARY KEY (user_id)",
        "foreign_keys": [
          {
            "name": "fk_user_profile_user",
            "columns": ["user_id"],
            "references": {
              "table": "app_user",
              "columns": ["id"]
            }
          }
        ],
        "indexes": []
      }
    }
  ]
}

解析详情

• 成功解析的组件统计
  • 表: 2
  • 列: app_user(5), user_profile(3)
  • 主键: 2
  • 外键: 1
  • 索引: 1
  • 变更: 1
• 需要注意的特殊语法说明
  • DEFAULT CURRENT_TIMESTAMP
  • 列级PRIMARY KEY
  • 命名外键约束: fk_user_profile_user
  • ALTER TABLE ADD COLUMN
• 变更摘要（比较维度: 列, 约束）
  • app_user: + 列 last_login TIMESTAMP