🔥 会员专享文生文工具

快速数据库结构生成助手

👁️ 450 次查看

📅 Nov 24, 2025

💡 核心价值： 根据用户输入的表名称、字段和关系信息，快速生成标准化数据库结构和DDL语句，自动匹配字段类型，支持表间关系描述，便于初学者和原型设计用户快速搭建数据库。

终身会员免费复制

🎯 可自定义参数（5个）

项目名称

数据库项目的标识名称

表名称

需要生成的数据库表名称

字段列表

以逗号分隔的字段列表，用于定义表结构

主键字段

在字段列表中唯一的主键字段

表间关系

遵循特定格式的表间关系描述

🎨 效果示例

{ "databaseSchema": "CREATE TABLE users (\n id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n username VARCHAR(50) NOT NULL,\n email VARCHAR(255) NOT NULL,\n phone VARCHAR(20),\n password_hash VARCHAR(255) NOT NULL,\n avatar_url VARCHAR(512),\n status TINYINT NOT NULL DEFAULT 1,\n signup_ip VARCHAR(45),\n last_login_at DATETIME,\n created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (id),\n UNIQUE KEY uk_users_username (username),\n UNIQUE KEY uk_users_email (email),\n INDEX idx_users_phone (phone)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\nCREATE TABLE roles (\n id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n name VARCHAR(50) NOT NULL,\n description VARCHAR(255),\n created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (id),\n UNIQUE KEY uk_roles_name (name)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\nCREATE TABLE orders (\n id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n user_id BIGINT UNSIGNED NOT NULL,\n status TINYINT NOT NULL DEFAULT 0,\n total_amount DECIMAL(10,2) NOT NULL DEFAULT 0.00,\n created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (id),\n INDEX idx_orders_user_id (user_id),\n CONSTRAINT fk_orders_user FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\nCREATE TABLE profiles (\n user_id BIGINT UNSIGNED NOT NULL,\n full_name VARCHAR(100),\n birthday DATE,\n bio TEXT,\n created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (user_id),\n CONSTRAINT fk_profiles_user FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\nCREATE TABLE user_roles (\n user_id BIGINT UNSIGNED NOT NULL,\n role_id BIGINT UNSIGNED NOT NULL,\n assigned_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (user_id, role_id),\n INDEX idx_ur_role_id (role_id),\n CONSTRAINT fk_user_roles_user FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT fk_user_roles_role FOREIGN KEY (role_id) REFERENCES roles(id) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;", "tables": [ { "tableName": "users", "fields": [ {"name": "id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "username", "type": "VARCHAR(50)", "isPrimaryKey": false}, {"name": "email", "type": "VARCHAR(255)", "isPrimaryKey": false}, {"name": "phone", "type": "VARCHAR(20)", "isPrimaryKey": false}, {"name": "password_hash", "type": "VARCHAR(255)", "isPrimaryKey": false}, {"name": "avatar_url", "type": "VARCHAR(512)", "isPrimaryKey": false}, {"name": "status", "type": "TINYINT", "isPrimaryKey": false}, {"name": "signup_ip", "type": "VARCHAR(45)", "isPrimaryKey": false}, {"name": "last_login_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "created_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "updated_at", "type": "DATETIME", "isPrimaryKey": false} ] }, { "tableName": "roles", "fields": [ {"name": "id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "name", "type": "VARCHAR(50)", "isPrimaryKey": false}, {"name": "description", "type": "VARCHAR(255)", "isPrimaryKey": false}, {"name": "created_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "updated_at", "type": "DATETIME", "isPrimaryKey": false} ] }, { "tableName": "orders", "fields": [ {"name": "id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "user_id", "type": "BIGINT UNSIGNED", "isPrimaryKey": false}, {"name": "status", "type": "TINYINT", "isPrimaryKey": false}, {"name": "total_amount", "type": "DECIMAL(10,2)", "isPrimaryKey": false}, {"name": "created_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "updated_at", "type": "DATETIME", "isPrimaryKey": false} ] }, { "tableName": "profiles", "fields": [ {"name": "user_id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "full_name", "type": "VARCHAR(100)", "isPrimaryKey": false}, {"name": "birthday", "type": "DATE", "isPrimaryKey": false}, {"name": "bio", "type": "TEXT", "isPrimaryKey": false}, {"name": "created_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "updated_at", "type": "DATETIME", "isPrimaryKey": false} ] }, { "tableName": "user_roles", "fields": [ {"name": "user_id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "role_id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "assigned_at", "type": "DATETIME", "isPrimaryKey": false} ] } ], "relationships": [ "orders.user_id -> users.id", "profiles.user_id -> users.id", "user_roles.user_id -> users.id", "user_roles.role_id -> roles.id" ] }

{ "databaseSchema": "CREATE TABLE articles (\n id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,\n title VARCHAR(255) NOT NULL,\n content TEXT,\n created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP\n);\n\nCREATE TABLE tags (\n id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,\n name VARCHAR(100) NOT NULL,\n description VARCHAR(255),\n created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n CONSTRAINT uq_tags_name UNIQUE (name)\n);\n\nCREATE TABLE article_tags (\n id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,\n article_id INTEGER NOT NULL,\n tag_id INTEGER NOT NULL,\n tag_label VARCHAR(100),\n created_by INTEGER,\n created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n CONSTRAINT fk_article_tags_article FOREIGN KEY (article_id) REFERENCES articles(id) ON DELETE CASCADE,\n CONSTRAINT fk_article_tags_tag FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE,\n CONSTRAINT uq_article_tag UNIQUE (article_id, tag_id)\n);\n\nCREATE INDEX idx_article_tags_article ON article_tags(article_id);\nCREATE INDEX idx_article_tags_tag ON article_tags(tag_id);\n\nCREATE TABLE comments (\n id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,\n article_id INTEGER NOT NULL,\n content TEXT NOT NULL,\n created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n CONSTRAINT fk_comments_article FOREIGN KEY (article_id) REFERENCES articles(id) ON DELETE CASCADE\n);\n\nCREATE INDEX idx_comments_article ON comments(article_id);\n", "tables": [ { "tableName": "articles", "fields": [ {"name": "id", "type": "INTEGER", "isPrimaryKey": true}, {"name": "title", "type": "VARCHAR(255)", "isPrimaryKey": false}, {"name": "content", "type": "TEXT", "isPrimaryKey": false}, {"name": "created_at", "type": "TIMESTAMP", "isPrimaryKey": false} ] }, { "tableName": "tags", "fields": [ {"name": "id", "type": "INTEGER", "isPrimaryKey": true}, {"name": "name", "type": "VARCHAR(100)", "isPrimaryKey": false}, {"name": "description", "type": "VARCHAR(255)", "isPrimaryKey": false}, {"name": "created_at", "type": "TIMESTAMP", "isPrimaryKey": false} ] }, { "tableName": "article_tags", "fields": [ {"name": "id", "type": "INTEGER", "isPrimaryKey": true}, {"name": "article_id", "type": "INTEGER", "isPrimaryKey": false}, {"name": "tag_id", "type": "INTEGER", "isPrimaryKey": false}, {"name": "tag_label", "type": "VARCHAR(100)", "isPrimaryKey": false}, {"name": "created_by", "type": "INTEGER", "isPrimaryKey": false}, {"name": "created_at", "type": "TIMESTAMP", "isPrimaryKey": false} ] }, { "tableName": "comments", "fields": [ {"name": "id", "type": "INTEGER", "isPrimaryKey": true}, {"name": "article_id", "type": "INTEGER", "isPrimaryKey": false}, {"name": "content", "type": "TEXT", "isPrimaryKey": false}, {"name": "created_at", "type": "TIMESTAMP", "isPrimaryKey": false} ] } ], "relationships": [ "article_tags.article_id -> articles.id", "article_tags.tag_id -> tags.id", "comments.article_id -> articles.id" ] }