\n| <\/td>\n | 4.3 \u8bb0\u5f55\u751f\u6210\u5386\u53f2，\u652f\u6301\u56de\u6eaf<\/td>\n | \u65b9\u4fbf\u7528\u6237\u5bf9\u6bd4\u4e0d\u540c\u7248\u672c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n2. \u5927\u6a21\u578b\u63d0\u793a\u8bcd\u8bbe\u8ba1<\/h4>\n\u4e3a\u4e86\u8ba9\u5927\u6a21\u578b\u7a33\u5b9a\u8f93\u51fa\u7ed3\u6784\u5316\u7684\u591a\u8868\u4fe1\u606f，\u6211\u4eec\u9700\u8981\u7cbe\u5fc3\u8bbe\u8ba1\u63d0\u793a\u8bcd，\u660e\u786e\u8f93\u51fa\u683c\u5f0f\u3002\u4ee5\u4e0b\u662f\u4e00\u4e2a\u793a\u4f8b\u63d0\u793a\u8bcd\u6a21\u677f（\u9002\u7528\u4e8e GPT \u7cfb\u5217）：<\/p>\n \u4f60\u662f\u4e00\u4e2a\u6570\u636e\u5e93\u8bbe\u8ba1\u4e13\u5bb6\u3002\u8bf7\u6839\u636e\u7528\u6237\u7684\u9700\u6c42，\u8bbe\u8ba1\u4e00\u5957\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7684\u8868\u7ed3\u6784，\u5e76\u4ee5\u4e25\u683c\u7684 JSON \u683c\u5f0f\u8f93\u51fa\u3002
\n\u9700\u6c42\u63cf\u8ff0：{user_input}<\/p>\n \u8981\u6c42：
\n1. \u8f93\u51fa\u5fc5\u987b\u662f\u4e00\u4e2a JSON \u5bf9\u8c61，\u5305\u542b\u4e00\u4e2a "tables" \u6570\u7ec4\u3002
\n2. \u6bcf\u4e2a\u8868\u5bf9\u8c61\u5305\u542b：
\n – "name": \u8868\u540d（\u82f1\u6587\u5c0f\u5199，\u4e0b\u5212\u7ebf\u5206\u9694）
\n – "comment": \u8868\u6ce8\u91ca
\n – "columns": \u5b57\u6bb5\u6570\u7ec4，\u6bcf\u4e2a\u5b57\u6bb5\u5305\u542b：
\n – "name": \u5b57\u6bb5\u540d（\u82f1\u6587\u5c0f\u5199）
\n – "type": \u6570\u636e\u7c7b\u578b（\u5982 int, varchar(255), date, decimal(10,2), text \u7b49）
\n – "nullable": \u662f\u5426\u53ef\u4e3a\u7a7a，true\/false
\n – "primary": \u662f\u5426\u4e3b\u952e，true\/false
\n – "default": \u9ed8\u8ba4\u503c（\u53ef\u9009）
\n – "comment": \u5b57\u6bb5\u6ce8\u91ca
\n – "indexes": \u7d22\u5f15\u6570\u7ec4（\u53ef\u9009），\u6bcf\u4e2a\u7d22\u5f15\u5305\u542b：
\n – "name": \u7d22\u5f15\u540d
\n – "columns": \u5b57\u6bb5\u540d\u6570\u7ec4
\n – "unique": \u662f\u5426\u552f\u4e00
\n3. \u8868\u4e4b\u95f4\u7684\u5173\u7cfb\u7528\u5916\u952e\u8868\u793a，\u53ef\u4ee5\u5728\u5b57\u6bb5\u4e2d\u901a\u8fc7 "foreignKey" \u5c5e\u6027\u63cf\u8ff0：
\n – "foreignKey": { "table": "\u5173\u8054\u8868\u540d", "column": "\u5173\u8054\u5b57\u6bb5" }
\n \u6216\u8005\u5355\u72ec\u7528\u4e00\u4e2a "relations" \u6570\u7ec4\u6765\u63cf\u8ff0，\u4f46\u66f4\u63a8\u8350\u5728\u5b57\u6bb5\u4e2d\u76f4\u63a5\u6807\u6ce8\u5916\u952e\u3002
\n4. \u8bf7\u786e\u4fdd\u8868\u540d\u3001\u5b57\u6bb5\u540d\u7b26\u5408\u547d\u540d\u89c4\u8303，\u5e76\u5305\u542b\u5fc5\u8981\u7684\u6ce8\u91ca\u3002
\n5. \u5982\u679c\u9700\u6c42\u4e2d\u6709\u660e\u663e\u7684\u591a\u5bf9\u591a\u5173\u7cfb，\u8bf7\u521b\u5efa\u4e2d\u95f4\u8868\u3002<\/p>\n \u8bf7\u76f4\u63a5\u8f93\u51fa JSON，\u4e0d\u8981\u5305\u542b\u5176\u4ed6\u89e3\u91ca\u6587\u5b57\u3002<\/p>\n \u793a\u4f8b\u8f93\u51fa（\u57fa\u4e8e\u201cOA\u7cfb\u7edf\u542b\u5458\u5de5\u3001\u90e8\u95e8\u3001\u8bf7\u5047\u7533\u8bf7\u201d）：<\/p>\n json<\/p>\n {
\n "tables": [
\n {
\n "name": "department",
\n "comment": "\u90e8\u95e8\u8868",
\n "columns": [
\n { "name": "id", "type": "int", "nullable": false, "primary": true, "comment": "\u90e8\u95e8ID" },
\n { "name": "name", "type": "varchar(100)", "nullable": false, "comment": "\u90e8\u95e8\u540d\u79f0" },
\n { "name": "parent_id", "type": "int", "nullable": true, "comment": "\u4e0a\u7ea7\u90e8\u95e8ID", "foreignKey": { "table": "department", "column": "id" } }
\n ],
\n "indexes": []
\n },
\n {
\n "name": "employee",
\n "comment": "\u5458\u5de5\u8868",
\n "columns": [
\n { "name": "id", "type": "int", "nullable": false, "primary": true, "comment": "\u5458\u5de5ID" },
\n { "name": "name", "type": "varchar(50)", "nullable": false, "comment": "\u59d3\u540d" },
\n { "name": "department_id", "type": "int", "nullable": true, "comment": "\u6240\u5c5e\u90e8\u95e8", "foreignKey": { "table": "department", "column": "id" } },
\n { "name": "hire_date", "type": "date", "nullable": true, "comment": "\u5165\u804c\u65e5\u671f" }
\n ],
\n "indexes": []
\n },
\n {
\n "name": "leave_application",
\n "comment": "\u8bf7\u5047\u7533\u8bf7\u8868",
\n "columns": [
\n { "name": "id", "type": "int", "nullable": false, "primary": true, "comment": "\u7533\u8bf7ID" },
\n { "name": "employee_id", "type": "int", "nullable": false, "comment": "\u7533\u8bf7\u4eba", "foreignKey": { "table": "employee", "column": "id" } },
\n { "name": "start_date", "type": "date", "nullable": false, "comment": "\u5f00\u59cb\u65e5\u671f" },
\n { "name": "end_date", "type": "date", "nullable": false, "comment": "\u7ed3\u675f\u65e5\u671f" },
\n { "name": "reason", "type": "text", "nullable": true, "comment": "\u4e8b\u7531" },
\n { "name": "status", "type": "varchar(20)", "nullable": false, "default": "'pending'", "comment": "\u72b6\u6001" }
\n ],
\n "indexes": [
\n { "name": "idx_employee_id", "columns": ["employee_id"], "unique": false }
\n ]
\n }
\n ]
\n}<\/p>\n
\n3. \u540e\u7aef\u8be6\u7ec6\u8bbe\u8ba1<\/h4>\n3.1 \u6280\u672f\u6808\u5047\u8bbe<\/h5>\n\n- \n
\u540e\u7aef\u8bed\u8a00：Java（Spring Boot）\u6216 Python（FastAPI）<\/p>\n<\/li>\n - \n
\u6570\u636e\u5e93：MySQL 8.0+ \/ PostgreSQL<\/p>\n<\/li>\n - \n
\u5927\u6a21\u578b\u8c03\u7528：HTTP \u8bf7\u6c42（\u73b0\u6709\u63a5\u53e3）<\/p>\n<\/li>\n - \n
\u5143\u6570\u636e\u5b58\u50a8：MySQL \u8868（\u5982\u00a0table_meta,\u00a0column_meta,\u00a0relation_meta）<\/p>\n<\/li>\n<\/ul>\n 3.2 \u6838\u5fc3\u6570\u636e\u6a21\u578b<\/h5>\n\u5b9a\u4e49\u5185\u90e8\u5b9e\u4f53\u7c7b（\u4ee5 Java \u4e3a\u4f8b）：<\/p>\n java<\/p>\n \/\/ TableSchema.java
\npublic class TableSchema {
\n private String name;
\n private String comment;
\n private List<ColumnSchema> columns;
\n private List<IndexSchema> indexes;
\n \/\/ getters\/setters
\n}<\/p>\n public class ColumnSchema {
\n private String name;
\n private String type; \/\/ \u4f8b\u5982 "varchar(255)"
\n private boolean nullable;
\n private boolean primary;
\n private String defaultValue;
\n private String comment;
\n private ForeignKey foreignKey; \/\/ \u5916\u952e\u4fe1\u606f，\u53ef\u4e3a\u7a7a
\n \/\/ getters\/setters
\n}<\/p>\n public class ForeignKey {
\n private String table; \/\/ \u5173\u8054\u8868\u540d
\n private String column; \/\/ \u5173\u8054\u5b57\u6bb5
\n \/\/ getters\/setters
\n}<\/p>\n public class IndexSchema {
\n private String name;
\n private List<String> columns;
\n private boolean unique;
\n \/\/ getters\/setters
\n}<\/p>\n 3.3 \u6838\u5fc3\u6d41\u7a0b<\/h5>\n - \n
\u63a5\u6536\u8bf7\u6c42：POST \/api\/schema\/generate\u00a0\u5e26\u53c2\u6570\u00a0{ "prompt": "…" }<\/p>\n<\/li>\n - \n
\u8c03\u7528\u5927\u6a21\u578b：\u5c06\u7528\u6237\u63d0\u793a\u8bcd\u4e0e\u9884\u8bbe\u6a21\u677f\u7ec4\u5408，\u8bf7\u6c42\u73b0\u6709 LLM \u63a5\u53e3，\u83b7\u53d6\u54cd\u5e94\u6587\u672c\u3002<\/p>\n<\/li>\n - \n
\u89e3\u6790 JSON：<\/p>\n \n- \n
\u5c1d\u8bd5\u89e3\u6790\u4e3a\u00a0TablesSchema\u00a0\u5bf9\u8c61（\u5305\u542b tables \u6570\u7ec4）\u3002<\/p>\n<\/li>\n - \n
\u9a8c\u8bc1\u5fc5\u586b\u5b57\u6bb5，\u68c0\u67e5\u6570\u636e\u7c7b\u578b\u5408\u6cd5\u6027（\u5982 type \u662f\u5426\u7b26\u5408 SQL \u89c4\u8303）\u3002<\/p>\n<\/li>\n - \n
\u82e5\u89e3\u6790\u5931\u8d25，\u8fd4\u56de\u53cb\u597d\u9519\u8bef\u63d0\u793a，\u6216\u5c1d\u8bd5\u8ba9\u6a21\u578b\u91cd\u65b0\u751f\u6210（\u91cd\u8bd5\u673a\u5236）\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n - \n
\u6784\u5efa\u9884\u89c8\u54cd\u5e94：\u5c06\u89e3\u6790\u540e\u7684\u7ed3\u6784\u8fd4\u56de\u524d\u7aef，\u540c\u65f6\u751f\u6210 DDL \u9884\u89c8（\u4f46\u4e0d\u5b9e\u9645\u6267\u884c）\u3002<\/p>\n<\/li>\n - \n
\u7528\u6237\u786e\u8ba4\u540e：\u8c03\u7528\u00a0POST \/api\/schema\/apply，\u4f20\u5165\u524d\u7aef\u53ef\u80fd\u4fee\u6539\u540e\u7684\u6700\u7ec8 JSON\u3002<\/p>\n \n- \n
\u5728\u4e8b\u52a1\u4e2d：\u5148\u6839\u636e JSON \u751f\u6210\u7269\u7406\u8868（\u6267\u884c CREATE TABLE \u8bed\u53e5），\u540c\u65f6\u5c06\u5143\u6570\u636e\u63d2\u5165\u5143\u6570\u636e\u5e93\u3002<\/p>\n<\/li>\n - \n
\u82e5\u5df2\u6709\u540c\u540d\u8868，\u53ef\u63d0\u793a\u51b2\u7a81，\u6216\u63d0\u4f9b\u201c\u8986\u76d6\/\u65b0\u5efa\u201d\u9009\u9879（\u9700\u8c28\u614e）\u3002<\/p>\n<\/li>\n - \n
\u8bb0\u5f55\u64cd\u4f5c\u65e5\u5fd7\u3002<\/p>\n<\/li>\n<\/ul>\n<\/li>\n 3.4 \u751f\u6210 DDL<\/h5>\n\u6839\u636e\u00a0TableSchema\u00a0\u751f\u6210 SQL \u8bed\u53e5（\u4ee5 MySQL \u4e3a\u4f8b）：<\/p>\n java<\/p>\n public String generateCreateTableSQL(TableSchema table) {
\n StringBuilder ddl = new StringBuilder("CREATE TABLE `")
\n .append(table.getName()).append("` (\\\\n");
\n List<String> columnDefs = new ArrayList<>();
\n List<String> primaryKeys = new ArrayList<>();<\/p>\n for (ColumnSchema col : table.getColumns()) {
\n StringBuilder colDef = new StringBuilder(" `")
\n .append(col.getName()).append("` ").append(col.getType());
\n if (!col.isNullable()) {
\n colDef.append(" NOT NULL");
\n }
\n if (col.getDefaultValue() != null) {
\n colDef.append(" DEFAULT ").append(col.getDefaultValue());
\n }
\n if (col.isPrimary()) {
\n primaryKeys.add("`" + col.getName() + "`");
\n }
\n if (col.getComment() != null && !col.getComment().isEmpty()) {
\n colDef.append(" COMMENT '").append(col.getComment()).append("'");
\n }
\n columnDefs.add(colDef.toString());
\n }<\/p>\n \/\/ \u4e3b\u952e\u7ea6\u675f
\n if (!primaryKeys.isEmpty()) {
\n columnDefs.add(" PRIMARY KEY (" + String.join(", ", primaryKeys) + ")");
\n }<\/p>\n \/\/ \u5916\u952e\u7ea6\u675f（\u5728\u5efa\u8868\u8bed\u53e5\u540e\u6dfb\u52a0，\u6216\u4f7f\u7528\u5355\u72ec\u7684 ALTER \u8bed\u53e5，\u8fd9\u91cc\u9009\u62e9\u540e\u52a0）
\n ddl.append(String.join(",\\\\n", columnDefs));
\n ddl.append("\\\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='")
\n .append(table.getComment()).append("';");<\/p>\n \/\/ \u6dfb\u52a0\u5916\u952e\u7ea6\u675f（ALTER TABLE）
\n StringBuilder fkSQL = new StringBuilder();
\n for (ColumnSchema col : table.getColumns()) {
\n if (col.getForeignKey() != null) {
\n fkSQL.append("ALTER TABLE `").append(table.getName())
\n .append("` ADD FOREIGN KEY (`").append(col.getName())
\n .append("`) REFERENCES `").append(col.getForeignKey().getTable())
\n .append("` (`").append(col.getForeignKey().getColumn())
\n .append("`);\\\\n");
\n }
\n }<\/p>\n \/\/ \u7d22\u5f15
\n StringBuilder indexSQL = new StringBuilder();
\n if (table.getIndexes() != null) {
\n for (IndexSchema idx : table.getIndexes()) {
\n indexSQL.append("CREATE ");
\n if (idx.isUnique()) indexSQL.append("UNIQUE ");
\n indexSQL.append("INDEX `").append(idx.getName())
\n .append("` ON `").append(table.getName())
\n .append("` (").append(
\n idx.getColumns().stream().map(c -> "`" + c + "`").collect(Collectors.joining(", "))
\n ).append(");\\\\n");
\n }
\n }<\/p>\n return ddl.toString() + "\\\\n" + fkSQL.toString() + "\\\\n" + indexSQL.toString();
\n}<\/p>\n 3.5 \u5143\u6570\u636e\u5b58\u50a8\u8bbe\u8ba1<\/h5>\n\u5728\u5e73\u53f0\u7684\u5143\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u4ee5\u4e0b\u8868：<\/p>\n sql<\/p>\n CREATE TABLE `table_meta` (
\n `id` int PRIMARY KEY AUTO_INCREMENT,
\n `name` varchar(100) NOT NULL COMMENT '\u7269\u7406\u8868\u540d',
\n `display_name` varchar(100) COMMENT '\u663e\u793a\u540d\u79f0',
\n `comment` text,
\n `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
\n UNIQUE KEY `uniq_name` (`name`)
\n);<\/p>\n CREATE TABLE `column_meta` (
\n `id` int PRIMARY KEY AUTO_INCREMENT,
\n `table_id` int NOT NULL,
\n `name` varchar(100) NOT NULL,
\n `type` varchar(50) NOT NULL,
\n `nullable` tinyint(1) DEFAULT 0,
\n `primary` tinyint(1) DEFAULT 0,
\n `default_value` varchar(255),
\n `comment` text,
\n `foreign_key_table` varchar(100) COMMENT '\u5173\u8054\u8868\u540d',
\n `foreign_key_column` varchar(100) COMMENT '\u5173\u8054\u5b57\u6bb5\u540d',
\n FOREIGN KEY (`table_id`) REFERENCES `table_meta`(`id`) ON DELETE CASCADE
\n);<\/p>\n CREATE TABLE `index_meta` (
\n `id` int PRIMARY KEY AUTO_INCREMENT,
\n `table_id` int NOT NULL,
\n `name` varchar(100),
\n `columns` text NOT NULL COMMENT '\u9017\u53f7\u5206\u9694\u7684\u5b57\u6bb5\u540d',
\n `unique` tinyint(1) DEFAULT 0,
\n FOREIGN KEY (`table_id`) REFERENCES `table_meta`(`id`) ON DELETE CASCADE
\n);<\/p>\n
\n4. \u524d\u7aef\u8be6\u7ec6\u8bbe\u8ba1<\/h4>\n4.1 \u754c\u9762\u5e03\u5c40<\/h5>\n\u91c7\u7528\u5de6\u53f3\u7ed3\u6784\u6216\u4e0a\u4e0b\u7ed3\u6784\u3002\u8fd9\u91cc\u5efa\u8bae\u4e0a\u4e0b\u5e03\u5c40：<\/p>\n \n- \n
\u9876\u90e8：\u8f93\u5165\u533a\u57df + \u201c\u751f\u6210\u201d\u6309\u94ae + \u793a\u4f8b\u4e0b\u62c9<\/p>\n<\/li>\n - \n
\u4e2d\u90e8：\u751f\u6210\u7ed3\u679c\u5c55\u793a（\u53ef\u5207\u6362\u201c\u8868\u683c\u89c6\u56fe\u201d\u548c\u201cER\u56fe\u9884\u89c8\u201d）<\/p>\n<\/li>\n - \n
\u5e95\u90e8：\u64cd\u4f5c\u6309\u94ae（\u786e\u8ba4\u5e94\u7528\u3001\u53d6\u6d88\u3001\u5bfc\u51faSQL\u7b49）<\/p>\n<\/li>\n<\/ul>\n 4.2 \u6838\u5fc3\u7ec4\u4ef6<\/h5>\n\n- \n
PromptInput：\u6587\u672c\u57df，\u652f\u6301 placeholder \u63d0\u793a\u3002<\/p>\n<\/li>\n - \n
TableList：\u5c55\u793a\u6240\u6709\u8868，\u6bcf\u4e2a\u8868\u53ef\u5c55\u5f00\u663e\u793a\u5b57\u6bb5\u5217\u8868\u3002\u652f\u6301：<\/p>\n \n- \n
\u6dfb\u52a0\u65b0\u8868\u6309\u94ae（\u5f39\u7a97\u8f93\u5165\u8868\u540d\u3001\u6ce8\u91ca）<\/p>\n<\/li>\n - \n
\u6bcf\u4e2a\u8868\u53f3\u4fa7\u7684\u7f16\u8f91\/\u5220\u9664\u56fe\u6807<\/p>\n<\/li>\n - \n
\u6bcf\u4e2a\u5b57\u6bb5\u7684\u7f16\u8f91\/\u5220\u9664，\u4ee5\u53ca\u6dfb\u52a0\u5b57\u6bb5\u6309\u94ae<\/p>\n<\/li>\n<\/ul>\n<\/li>\n - \n
ForeignKeyEditor：\u5f53\u7f16\u8f91\u5b57\u6bb5\u65f6，\u5982\u679c\u5b57\u6bb5\u7c7b\u578b\u9002\u5408\u4f5c\u4e3a\u5916\u952e（\u5982 int），\u663e\u793a\u201c\u8bbe\u7f6e\u4e3a\u5916\u952e\u201d\u590d\u9009\u6846，\u5e76\u9009\u62e9\u76ee\u6807\u8868\u548c\u5b57\u6bb5\u3002<\/p>\n<\/li>\n - \n
ERDiagram（\u53ef\u9009）：\u7528\u7b80\u5355\u7684 SVG \u6216 Canvas \u7ed8\u5236\u8868\u6846\u548c\u8fde\u7ebf，\u6839\u636e\u5916\u952e\u4fe1\u606f\u7ed8\u5236\u3002<\/p>\n<\/li>\n<\/ul>\n 4.3 \u72b6\u6001\u7ba1\u7406<\/h5>\n\n- \n
\u4f7f\u7528 Vue3 \u6216 React \u7684\u54cd\u5e94\u5f0f\u6570\u636e\u5b58\u50a8\u5f53\u524d\u751f\u6210\u7684 schema\u3002<\/p>\n<\/li>\n - \n
\u5f53\u7528\u6237\u7f16\u8f91\u65f6，\u5b9e\u65f6\u66f4\u65b0\u672c\u5730\u72b6\u6001，\u4f46\u4e0d\u4f1a\u81ea\u52a8\u89e6\u53d1\u540e\u7aef\u3002<\/p>\n<\/li>\n - \n
\u786e\u8ba4\u5e94\u7528\u65f6，\u5c06\u5f53\u524d schema \u53d1\u9001\u5230\u540e\u7aef\u3002<\/p>\n<\/li>\n<\/ul>\n 4.4 \u4e0e\u540e\u7aef\u4ea4\u4e92<\/h5>\n\n- \n
\u8c03\u7528\u751f\u6210\u63a5\u53e3：POST \/api\/schema\/generate，\u4f20\u9012 prompt，\u8fd4\u56de schema JSON\u3002<\/p>\n<\/li>\n - \n
\u8c03\u7528\u5e94\u7528\u63a5\u53e3：POST \/api\/schema\/apply，\u4f20\u9012\u6700\u7ec8\u7684 schema JSON\u3002<\/p>\n<\/li>\n<\/ul>\n 4.5 \u5173\u952e\u4ee3\u7801\u793a\u4f8b（Vue3 + Element Plus）<\/h5>\nvue<\/p>\n <template>
\n <div class="container">
\n <el-input
\n v-model="prompt"
\n type="textarea"
\n :rows="4"
\n placeholder="\u8bf7\u8f93\u5165\u7cfb\u7edf\u9700\u6c42，\u4f8b\u5982：\u8bbe\u8ba1\u4e00\u4e2a\u7b80\u5355\u7684OA\u7cfb\u7edf，\u5305\u542b\u5458\u5de5\u3001\u90e8\u95e8\u3001\u8bf7\u5047\u7533\u8bf7…"
\n \/>
\n <el-button type="primary" @click="generate" :loading="generating">\u751f\u6210<\/el-button><\/p>\n <div v-if="schema" class="schema-preview">
\n <el-tabs>
\n <el-tab-pane label="\u8868\u7ed3\u6784">
\n <div v-for="table in schema.tables" :key="table.name" class="table-card">
\n <el-card>
\n <template #header>
\n <span>{{ table.name }} ({{ table.comment }})<\/span>
\n <el-button type="text" @click="editTable(table)">\u7f16\u8f91<\/el-button>
\n <el-button type="text" @click="deleteTable(table)">\u5220\u9664<\/el-button>
\n <\/template>
\n <el-table :data="table.columns" style="width: 100%">
\n <el-table-column prop="name" label="\u5b57\u6bb5\u540d" \/>
\n <el-table-column prop="type" label="\u7c7b\u578b" \/>
\n <el-table-column prop="nullable" label="\u53ef\u7a7a">
\n <template #default="{ row }">{{ row.nullable ? '\u662f' : '\u5426' }}<\/template>
\n <\/el-table-column>
\n <el-table-column prop="primary" label="\u4e3b\u952e">
\n <template #default="{ row }">{{ row.primary ? '\u662f' : '\u5426' }}<\/template>
\n <\/el-table-column>
\n <el-table-column prop="comment" label="\u6ce8\u91ca" \/>
\n <el-table-column label="\u5916\u952e" width="120">
\n <template #default="{ row }">
\n <span v-if="row.foreignKey">{{ row.foreignKey.table }}.{{ row.foreignKey.column }}<\/span>
\n <\/template>
\n <\/el-table-column>
\n <el-table-column label="\u64cd\u4f5c" width="120">
\n <template #default="{ row }">
\n <el-button type="text" @click="editColumn(table, row)">\u7f16\u8f91<\/el-button>
\n <el-button type="text" @click="deleteColumn(table, row)">\u5220\u9664<\/el-button>
\n <\/template>
\n <\/el-table-column>
\n <\/el-table>
\n <el-button type="primary" size="small" @click="addColumn(table)">\u6dfb\u52a0\u5b57\u6bb5<\/el-button>
\n <\/el-card>
\n <\/div>
\n <el-button type="success" @click="addTable">\u6dfb\u52a0\u8868<\/el-button>
\n <\/el-tab-pane>
\n <el-tab-pane label="ER\u56fe">\u7b80\u6613ER\u56fe\u5360\u4f4d<\/el-tab-pane>
\n <\/el-tabs>
\n <\/div><\/p>\n <div class="actions" v-if="schema">
\n <el-button type="primary" @click="applySchema">\u786e\u8ba4\u5e94\u7528<\/el-button>
\n <el-button @click="cancel">\u53d6\u6d88<\/el-button>
\n <\/div>
\n <\/div>
\n<\/template><\/p>\n <script setup>
\nimport { ref } from 'vue'
\nimport axios from 'axios'<\/p>\n const prompt = ref('')
\nconst generating = ref(false)
\nconst schema = ref(null)<\/p>\n const generate = async () => {
\n generating.value = true
\n try {
\n const res = await axios.post('\/api\/schema\/generate', { prompt: prompt.value })
\n schema.value = res.data
\n } catch (e) {
\n ElMessage.error('\u751f\u6210\u5931\u8d25：' + e.message)
\n } finally {
\n generating.value = false
\n }
\n}<\/p>\n const applySchema = async () => {
\n try {
\n await axios.post('\/api\/schema\/apply', schema.value)
\n ElMessage.success('\u5e94\u7528\u6210\u529f')
\n } catch (e) {
\n ElMessage.error('\u5e94\u7528\u5931\u8d25：' + e.message)
\n }
\n}<\/p>\n \/\/ \u5176\u4ed6\u7f16\u8f91\u65b9\u6cd5\u7565…
\n<\/script><\/p>\n
\n5. \u5173\u7cfb\u5904\u7406\u4e0e\u6ce8\u610f\u4e8b\u9879<\/h4>\n5.1 \u591a\u5bf9\u591a\u5173\u7cfb\u81ea\u52a8\u8bc6\u522b<\/h5>\n\n- \n
\u5728\u63d0\u793a\u8bcd\u4e2d\u5f15\u5bfc\u6a21\u578b：\u9047\u5230\u591a\u5bf9\u591a（\u5982\u201c\u5b66\u751f\u548c\u8bfe\u7a0b\u201d），\u5e94\u521b\u5efa\u4e2d\u95f4\u8868，\u5e76\u5728\u4e2d\u95f4\u8868\u4e2d\u8bbe\u7f6e\u4e24\u4e2a\u5916\u952e\u3002<\/p>\n<\/li>\n - \n
\u82e5\u6a21\u578b\u672a\u81ea\u52a8\u521b\u5efa，\u524d\u7aef\u53ef\u63d0\u4f9b\u201c\u6dfb\u52a0\u4e2d\u95f4\u8868\u201d\u7684\u5feb\u6377\u64cd\u4f5c\u3002<\/p>\n<\/li>\n<\/ul>\n 5.2 \u6570\u636e\u7c7b\u578b\u6620\u5c04<\/h5>\n\n- \n
\u53ef\u914d\u7f6e\u4e00\u4e2a\u6620\u5c04\u8868，\u5c06\u5e38\u89c1\u4e2d\u6587\u63cf\u8ff0（\u5982\u201c\u6574\u6570\u201d\u3001\u201c\u5b57\u7b26\u4e32\u201d\u3001\u201c\u65e5\u671f\u201d）\u6620\u5c04\u5230\u5177\u4f53 SQL \u7c7b\u578b\u3002<\/p>\n<\/li>\n - \n
\u4f8b\u5982\u6a21\u578b\u8f93\u51fa\u00a0"type": "int"\u00a0\u76f4\u63a5\u53ef\u7528，\u4f46\u82e5\u8f93\u51fa\u00a0"type": "\u6574\u6570"，\u5219\u9700\u8981\u540e\u5904\u7406\u8f6c\u6362\u3002<\/p>\n<\/li>\n<\/ul>\n 5.3 \u5b57\u6bb5\u9ed8\u8ba4\u503c\u5904\u7406<\/h5>\n\n- \n
\u6ce8\u610f SQL \u8bed\u6cd5\u4e2d\u9ed8\u8ba4\u503c\u7684\u5f15\u53f7\u95ee\u9898：\u5b57\u7b26\u4e32\u9700\u52a0\u5355\u5f15\u53f7，\u6570\u5b57\u548c\u5e03\u5c14\u65e0\u9700\u3002<\/p>\n<\/li>\n - \n
\u89e3\u6790\u65f6\u53ef\u6839\u636e\u7c7b\u578b\u81ea\u52a8\u5904\u7406\u3002<\/p>\n<\/li>\n<\/ul>\n 5.4 \u8868\u540d\u51b2\u7a81<\/h5>\n\n- \n
\u5982\u679c\u5143\u6570\u636e\u5e93\u4e2d\u5df2\u5b58\u5728\u540c\u540d\u8868，\u5e94\u5728\u5e94\u7528\u524d\u63d0\u793a\u7528\u6237\u9009\u62e9：\u8986\u76d6\u3001\u91cd\u547d\u540d\u6216\u8df3\u8fc7\u3002<\/p>\n<\/li>\n - \n
\u8986\u76d6\u53ef\u80fd\u5bfc\u81f4\u6570\u636e\u4e22\u5931，\u9700\u8c28\u614e，\u901a\u5e38\u5efa\u8bae\u4ec5\u7528\u4e8e\u5f00\u53d1\u73af\u5883\u3002<\/p>\n<\/li>\n<\/ul>\n 5.5 \u4e8b\u52a1\u6027\u4fdd\u8bc1<\/h5>\n\n- \n
\u5e94\u7528\u63a5\u53e3\u5e94\u5728\u6570\u636e\u5e93\u4e8b\u52a1\u4e2d\u6267\u884c：\u5148\u63d2\u5165\u5143\u6570\u636e，\u518d\u6267\u884c DDL\u3002\u82e5 DDL \u5931\u8d25，\u56de\u6eda\u5143\u6570\u636e\u63d2\u5165\u3002<\/p>\n<\/li>\n - \n
\u6ce8\u610f：DDL \u662f\u9690\u5f0f\u63d0\u4ea4\u7684，\u5728 MySQL \u4e2d\u65e0\u6cd5\u56de\u6eda，\u6240\u4ee5\u66f4\u597d\u7684\u987a\u5e8f\u662f：\u5148\u521b\u5efa\u7269\u7406\u8868，\u6210\u529f\u540e\u518d\u63d2\u5165\u5143\u6570\u636e\u3002\u5982\u679c\u5143\u6570\u636e\u63d2\u5165\u5931\u8d25，\u9700\u624b\u52a8\u5220\u9664\u5df2\u521b\u5efa\u7684\u8868（\u6216\u8bb0\u5f55\u65e5\u5fd7\u7531\u7ba1\u7406\u5458\u5904\u7406）\u3002\u4f46\u4e3a\u4e86\u7b80\u5316，\u53ef\u5148\u63d2\u5165\u5143\u6570\u636e（\u8bbe\u7f6e\u72b6\u6001\u4e3a\u201c\u521b\u5efa\u4e2d\u201d），\u7136\u540e\u521b\u5efa\u8868，\u6210\u529f\u540e\u66f4\u65b0\u72b6\u6001\u3002<\/p>\n<\/li>\n<\/ul>\n 5.6 \u5927\u6a21\u578b\u8f93\u51fa\u8d28\u91cf\u63d0\u5347<\/h5>\n\n- \n
\u53ef\u901a\u8fc7 few-shot \u793a\u4f8b\u5f3a\u5316\u6a21\u578b\u5bf9 JSON \u683c\u5f0f\u7684\u9075\u5faa\u3002<\/p>\n<\/li>\n - \n
\u589e\u52a0\u540e\u5904\u7406\u6821\u9a8c，\u5982\u68c0\u67e5\u4e3b\u952e\u662f\u5426\u5b58\u5728\u3001\u5916\u952e\u5f15\u7528\u662f\u5426\u5b58\u5728\u7b49\u3002<\/p>\n<\/li>\n - \n
\u82e5\u6a21\u578b\u8f93\u51fa\u4e0d\u7b26\u5408\u8981\u6c42，\u53ef\u5c1d\u8bd5\u91cd\u65b0\u751f\u6210\u6216\u63d0\u793a\u7528\u6237\u624b\u52a8\u4fee\u6b63\u3002<\/p>\n<\/li>\n<\/ul>\n
\n6. \u6269\u5c55\u601d\u8003<\/h4>\n6.1 \u751f\u6210\u521d\u59cb\u6570\u636e<\/h5>\n |