{"id":2752,"date":"2026-07-14T14:23:12","date_gmt":"2026-07-14T06:23:12","guid":{"rendered":"https:\/\/updates.visual-paradigm.com\/tw\/releases\/free-sql-to-erd-tool-online-editor\/"},"modified":"2026-07-14T14:23:12","modified_gmt":"2026-07-14T06:23:12","slug":"free-sql-to-erd-tool-online-editor","status":"publish","type":"releases","link":"https:\/\/updates.visual-paradigm.com\/tw\/releases\/free-sql-to-erd-tool-online-editor\/","title":{"rendered":"\u7acb\u5373\u5c07 SQL \u8f49\u63db\u70ba\u8996\u89ba\u5316 ERD\uff1aVPasCode \u63a8\u51fa\u4e92\u52d5\u5f0f SQL \u8f49\u5716\u5f62\u652f\u63f4"},"content":{"rendered":"

\u8cc7\u6599\u5eab\u8a2d\u8a08\u8207\u6587\u4ef6\u7de8\u8f2f\u73fe\u5728\u8b8a\u5f97\u66f4\u52a0\u9806\u66a2\u3002\u5982\u679c\u4f60\u66fe\u7d93\u82b1\u8cbb\u6578\u5c0f\u6642\u624b\u52d5\u62d6\u66f3\u3001\u653e\u7f6e\u4e26\u5c0d\u9f4a\u65b9\u6846\u4f86\u5efa\u7acb\u5be6\u9ad4\u95dc\u4fc2\u5716\uff08ERD\uff09\uff0cVisual Paradigm \u70ba\u4f60\u5e36\u4f86\u4e86\u4ee4\u4eba\u8208\u596e\u7684\u597d\u6d88\u606f\u3002\u6211\u5011\u5df2\u6b63\u5f0f\u5f37\u5316\u6211\u5011\u7684\u7d71\u4e00\u6587\u5b57\u8f49\u5716\u5f62\u5e73\u53f0\uff0cVPasCode<\/strong>\uff0c\u900f\u904e\u5f15\u5165\u5c0d\u539f\u751f SQL \u7a0b\u5f0f\u78bc\u7684\u5f37\u5927\u652f\u63f4\u3002<\/p>\n

\u85c9\u7531\u9019\u9805\u6700\u65b0\u589e\u5f37\u529f\u80fd\uff0cVPasCode \u73fe\u5728\u53ef\u4f5c\u70ba\u4e00\u500b\u9ad8\u5ea6\u76f4\u89ba\u7684\u514d\u8cbb SQL \u8f49 ERD \u5de5\u5177<\/strong>\u3002\u4f60\u53ea\u9700\u5c07\u539f\u59cb\u7684 SQL DDL \u8173\u672c\u8cbc\u5165\u6211\u5011\u7684\u74b0\u5883\uff0c\u5373\u53ef\u7acb\u5373\u770b\u5230\u5b8c\u6574\u7684\u5be6\u9ad4\u95dc\u4fc2\u5716\u5728\u773c\u524d\u5448\u73fe\u3002<\/p>\n

\"A<\/p>\n

\u7121\u8ad6\u4f60\u662f\u8a2d\u8a08\u4f01\u696d\u751f\u614b\u7cfb\u7d71\u7684\u8cc7\u6599\u67b6\u69cb\u5e2b\u3001\u539f\u578b\u958b\u767c\u65b0\u529f\u80fd\u7684\u5168\u7aef\u958b\u767c\u8005\uff0c\u9084\u662f\u5b78\u7fd2\u95dc\u4fc2\u578b\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\u7684\u5b78\u751f\uff0c\u9019\u500b\u5f37\u5927\u7684\u7dda\u4e0a SQL ERD \u5de5\u5177<\/strong>\u7686\u65e8\u5728\u7bc0\u7701\u4f60\u7684\u6642\u9593\uff0c\u4e26\u6d88\u9664\u624b\u52d5\u7e6a\u88fd\u5716\u5f62\u7684\u74f6\u9838\u3002<\/p>\n\n

\u4ec0\u9ebc\u662f VPasCode\uff1f\u7d42\u6975\u7684\u5716\u5f62\u5373\u7a0b\u5f0f\u78bc\u5e73\u53f0<\/h2>\n

\u5982\u679c\u4f60\u662f\u9996\u6b21\u4f7f\u7528\u6b64\u5e73\u53f0\uff0c\u9019\u88e1\u6709\u4e00\u500b\u5feb\u901f\u56de\u9867\uff1aVPasCode<\/a>\u662f Visual Paradigm \u7684\u7d71\u4e00\u6587\u5b57\u8f49\u5716\u5f62\u4e2d\u5fc3\u3002\u8207\u50b3\u7d71\u7684\u9ede\u9078\u62d6\u66f3\u7e6a\u5716\u5de5\u5177\u4e0d\u540c\uff0cVPasCode \u63a1\u7528\u300c\u5716\u5f62\u5373\u7a0b\u5f0f\u78bc<\/a>\u300d\uff08DaC\uff09\u54f2\u5b78\u3002\u5b83\u8b93\u4f60\u80fd\u5920\u4f7f\u7528\u7c21\u55ae\u4e14\u6613\u8b80\u7684\u6587\u5b57\u8a9e\u6cd5\uff0c\u5efa\u7acb\u3001\u7dad\u8b77\u4e26\u7248\u672c\u63a7\u5236\u8907\u96dc\u7684\u7cfb\u7d71\u67b6\u69cb\u3001\u6d41\u7a0b\u5716\u8207\u5e8f\u5217\u5716\u3002<\/p>\n

\u8a72\u5e73\u53f0\u5de6\u5074\u914d\u5099\u5feb\u901f\u4e14\u514d\u8cbb\u7684\u7a0b\u5f0f\u78bc\u7de8\u8f2f\u5668\uff0c\u53f3\u5074\u5247\u6709\u5373\u6642\u5716\u5f62\u6e32\u67d3\u5668\u3002\u7531\u65bc\u5b83\u662f\u4e00\u500b\u771f\u6b63\u6574\u5408\u7684\u74b0\u5883\uff0cVPasCode \u7406\u8ad6\u4e0a\u652f\u63f4\u6240\u6709\u6d41\u884c\u7684\u6587\u5b57\u8f49\u5716\u5f62\u6a19\u6e96\uff0c\u5305\u62ec\u5b8c\u6574\u7684 PlantUML \u8207 Mermaid \u8a9e\u6cd5\u3002\u5b83\u7d50\u5408\u4e86\u958b\u6e90\u6e32\u67d3\u5f15\u64ce\u7684\u6700\u4f73\u529f\u80fd\u8207 Visual Paradigm \u7cbe\u7dfb\u7684\u7db2\u8def\u751f\u614b\u7cfb\u7d71\u3002<\/p>\n\n

\u96d9\u5f15\u64ce\u5f48\u6027\uff1a\u7d42\u6975\u7684 SQL ERD \u7de8\u8f2f\u5668<\/h2>\n

\u96d6\u7136\u4e00\u822c\u6587\u5b57\u8f49\u5716\u5f62\u5de5\u5177\u6703\u5c07\u4f60\u9396\u5b9a\u5728\u55ae\u4e00\u4f48\u5c40\u5f15\u64ce\u4e2d\uff0c\u4f46 VPasCode \u7d66\u4e88\u4f60\u5b8c\u5168\u7684\u5275\u610f\u8207\u67b6\u69cb\u63a7\u5236\u6b0a\u3002\u8207\u6211\u5011\u652f\u63f4\u7684\u5176\u4ed6\u8a9e\u8a00\u4e0d\u540c\uff0c\u6211\u5011\u7684\u65b0SQL ERD \u7de8\u8f2f\u5668<\/strong>\u5f15\u5165\u4e86\u7368\u7279\u7684\u96d9\u6e32\u67d3\u5207\u63db\u529f\u80fd\u3002<\/p>\n

\u5728\u5de6\u5074\u7684 SQL \u7a0b\u5f0f\u78bc\u7de8\u8f2f\u5668\u4e0a\u65b9\uff0c\u4f60\u6703\u627e\u5230\u4e00\u500b\u9810\u8a2d\u70ba\u300cMermaid\u300d<\/strong>\u7684\u4e0b\u62c9\u5f0f\u9078\u55ae\u3002\u5982\u679c\u4f60\u60f3\u6539\u7528 PlantUML \u8a9e\u6cd5\u898f\u5247\u4f86\u6aa2\u8996\u6216\u532f\u51fa\u4f60\u7684\u8cc7\u6599\u5eab\u8a2d\u8a08\uff0c\u53ea\u9700\u9ede\u64ca\u4e0b\u62c9\u5f0f\u9078\u55ae\u4e26\u5c07\u5176\u5207\u63db\u70ba\u300cPlantUML\u300d<\/strong>\u3002\u7cfb\u7d71\u6703\u81ea\u52d5\u8655\u7406\u4f60\u7684 SQL \u7a0b\u5f0f\u78bc\uff0c\u4e26\u7acb\u5373\u4f7f\u7528\u4f60\u6240\u9078\u7684\u5f15\u64ce\u9032\u884c\u8f49\u63db\u3002<\/p>\n\n

\u7acb\u5373\u9ad4\u9a57\uff1a4 \u500b\u771f\u5be6\u4e16\u754c\u7684\u4e92\u52d5\u7bc4\u4f8b<\/h2>\n

\u70ba\u4e86\u8b49\u660e\u6b64\u65b0\u529f\u80fd\u5728\u4e0d\u540c\u8cc7\u6599\u5eab\u8a9e\u6cd5\u8207\u8edf\u9ad4\u67b6\u69cb\u4e2d\u7684\u591a\u529f\u80fd\u6027\uff0c\u6211\u5011\u6e96\u5099\u4e86\u56db\u500b\u4e92\u52d5\u7bc4\u4f8b\u3002\u4f60\u53ef\u4ee5\u9ede\u64ca\u6bcf\u500b\u7bc4\u4f8b\u4e0b\u65b9\u7684\u9023\u7d50\uff0c\u76f4\u63a5\u5728\u5373\u6642\u7684\u7dda\u4e0a SQL ERD \u5de5\u5177<\/strong>\u74b0\u5883\u4e2d\u958b\u555f\u3002<\/p>\n

1. \u96fb\u5546\u8cc7\u6599\u5eab\u7d50\u69cb\uff08\u6a19\u6e96 SQL\uff09<\/h3>\n

\u6b64\u6a19\u6e96\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7d50\u69cb\u5c55\u793a\u4e86\u7d93\u5178\u7684\u96fb\u5546\u95dc\u4fc2\uff1a\u4f7f\u7528\u8005\u3001\u5730\u5740\u3001\u7522\u54c1\u3001\u8a02\u55ae\u3001\u8a02\u55ae\u660e\u7d30\u9805\u76ee\u4ee5\u53ca\u7522\u54c1\u8a55\u8ad6\uff0c\u4e26\u5177\u5099\u6a19\u6e96\u7684\u4e3b\u9375\u8207\u5916\u9375\u53c3\u8003\u3002<\/p>\n

\"A<\/p>\n

\n
\nSql<\/span>
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7de8\u8f2f Sql<\/span>
\n<\/a>\n<\/div>\n
\n
\r\n
\r\n Sql<\/span>\r\n \r\n <\/path><\/path><\/svg>\r\n Edit Sql in VPasCode<\/span>\r\n <\/a>\r\n <\/div>\r\n
\r\n 
\r\nCREATE TABLE users (\r\n  id BIGINT PRIMARY KEY,\r\n  email VARCHAR(255) NOT NULL UNIQUE,\r\n  full_name VARCHAR(120),\r\n  created_at TIMESTAMP NOT NULL\r\n);\r\n\r\nCREATE TABLE addresses (\r\n  id BIGINT PRIMARY KEY,\r\n  user_id BIGINT NOT NULL REFERENCES users(id),\r\n  line1 VARCHAR(255) NOT NULL,\r\n  city VARCHAR(80),\r\n  country CHAR(2) NOT NULL\r\n);\r\n\r\nCREATE TABLE products (\r\n  id BIGINT PRIMARY KEY,\r\n  sku VARCHAR(64) NOT NULL UNIQUE,\r\n  name VARCHAR(200) NOT NULL,\r\n  price_cents INT NOT NULL,\r\n  active BOOLEAN NOT NULL\r\n);\r\n\r\nCREATE TABLE orders (\r\n  id BIGINT PRIMARY KEY,\r\n  user_id BIGINT NOT NULL,\r\n  address_id BIGINT,\r\n  status VARCHAR(32) NOT NULL,\r\n  total_cents INT NOT NULL,\r\n  placed_at TIMESTAMP NOT NULL,\r\n  FOREIGN KEY (user_id) REFERENCES users(id),\r\n  FOREIGN KEY (address_id) REFERENCES addresses(id)\r\n);\r\n\r\nCREATE TABLE order_items (\r\n  id BIGINT PRIMARY KEY,\r\n  order_id BIGINT NOT NULL,\r\n  product_id BIGINT NOT NULL,\r\n  quantity INT NOT NULL,\r\n  unit_cents INT NOT NULL,\r\n  CONSTRAINT fk_oi_order FOREIGN KEY (order_id) REFERENCES orders(id),\r\n  CONSTRAINT fk_oi_product FOREIGN KEY (product_id) REFERENCES products(id)\r\n);\r\n\r\nCREATE TABLE reviews (\r\n  id BIGINT PRIMARY KEY,\r\n  product_id BIGINT NOT NULL REFERENCES products(id),\r\n  user_id BIGINT NOT NULL REFERENCES users(id),\r\n  rating SMALLINT NOT NULL,\r\n  body TEXT,\r\n  created_at TIMESTAMP NOT NULL\r\n);\r\n<\/code><\/pre>                <\/div>\r\n                
\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Sql in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n            <\/div>\r\n            \n<\/p><\/div>\n
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7de8\u8f2f Sql<\/span>
\n<\/a>\n<\/div>\n<\/div>\n
2. \u5167\u5bb9\u7ba1\u7406\u90e8\u843d\u683c\u8cc7\u6599\u5eab\u7d50\u69cb\uff08PostgreSQL \u8a9e\u6cd5\uff09<\/h3>\n
\u73fe\u4ee3\u61c9\u7528\u7a0b\u5f0f\u9700\u8981\u5148\u9032\u7684\u8cc7\u6599\u7d50\u69cb\u3002\u6b64 PostgreSQL \u5c0e\u5411\u7684\u8cc7\u6599\u5eab\u7d50\u69cb\u5305\u542b\u9032\u968e\u8a2d\u5b9a\uff0c\u4f8b\u5982\u8907\u96dc\u9663\u5217\uff08TEXT[]<\/code>\uff09\uff0c\u73fe\u4ee3 JSON \u7269\u4ef6\uff08JSONB<\/code>\uff09\uff0c\u4ee5\u53ca\u7528\u65bc\u4e3b\u9375\u7684 UUID \u8cc7\u6599\u985e\u578b\u3002<\/p>\n
\"A<\/p>\n
\n
\nSql<\/span>
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7de8\u8f2f Sql<\/span>
\n<\/a>\n<\/div>\n
\n            
\r\n                                
\r\n                    Sql<\/span>\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Sql in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n                                
\r\n                    
\r\nCREATE TABLE authors (\r\n  id UUID PRIMARY KEY,\r\n  name VARCHAR(200) NOT NULL,\r\n  email VARCHAR(255) NOT NULL UNIQUE,\r\n  bio TEXT,\r\n  avatar_url VARCHAR(500),\r\n  meta JSONB DEFAULT '{}',\r\n  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()\r\n);\r\n\r\nCREATE TABLE categories (\r\n  id UUID PRIMARY KEY,\r\n  name VARCHAR(100) NOT NULL UNIQUE,\r\n  slug VARCHAR(120) NOT NULL UNIQUE,\r\n  description TEXT,\r\n  parent_id UUID REFERENCES categories(id),\r\n  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()\r\n);\r\n\r\nCREATE TABLE posts (\r\n  id UUID PRIMARY KEY,\r\n  author_id UUID NOT NULL REFERENCES authors(id),\r\n  category_id UUID REFERENCES categories(id),\r\n  title VARCHAR(300) NOT NULL,\r\n  slug VARCHAR(350) NOT NULL UNIQUE,\r\n  body TEXT NOT NULL,\r\n  excerpt TEXT,\r\n  tags TEXT[],\r\n  published BOOLEAN NOT NULL DEFAULT FALSE,\r\n  views INTEGER NOT NULL DEFAULT 0,\r\n  published_at TIMESTAMPTZ,\r\n  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),\r\n  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()\r\n);\r\n\r\nCREATE TABLE comments (\r\n  id UUID PRIMARY KEY,\r\n  post_id UUID NOT NULL REFERENCES posts(id),\r\n  author_name VARCHAR(120) NOT NULL,\r\n  author_email VARCHAR(255) NOT NULL,\r\n  body TEXT NOT NULL,\r\n  approved BOOLEAN NOT NULL DEFAULT FALSE,\r\n  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()\r\n);\r\n\r\nCREATE TABLE post_tags (\r\n  post_id UUID NOT NULL REFERENCES posts(id),\r\n  tag VARCHAR(60) NOT NULL,\r\n  PRIMARY KEY (post_id, tag),\r\n  CONSTRAINT fk_tags_post FOREIGN KEY (post_id) REFERENCES posts(id)\r\n);\r\n<\/code><\/pre>                <\/div>\r\n                
\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Sql in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n            <\/div>\r\n            \n<\/p><\/div>\n
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7de8\u8f2f Sql<\/span>
\n<\/a>\n<\/div>\n<\/div>\n
3. \u591a\u79df\u6236 SaaS \u5f15\u64ce\uff08MySQL \u8a9e\u6cd5\uff09<\/h3>\n
\u6b64 MySQL DDL \u7bc4\u4f8b\u6982\u8ff0\u4e86\u4e00\u500b\u591a\u79df\u6236\u4f01\u696d\u7cfb\u7d71\uff0c\u7528\u65bc\u8ffd\u8e64\u7d44\u7e54\u3001\u5718\u968a\u5c64\u7d1a\u7d50\u69cb\u3001\u4f7f\u7528\u8005\u6b0a\u9650\u3001\u5c08\u6848\u5206\u914d\u4ee5\u53ca\u5e33\u55ae\u767c\u7968\uff0c\u4e26\u4f7f\u7528\u539f\u751fAUTO_INCREMENT<\/code>, ENUM<\/code>\u6b04\u4f4d\u8207\u660e\u78ba\u7684\u5341\u9032\u4f4d\u6578\u503c\u3002<\/p>\n
\"A<\/p>\n
\n
\nSql<\/span>
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7de8\u8f2f Sql<\/span>
\n<\/a>\n<\/div>\n
\n            
\r\n                                
\r\n                    Sql<\/span>\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Sql in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n                                
\r\n                    
\r\nCREATE TABLE organizations (\r\n  id INT AUTO_INCREMENT PRIMARY KEY,\r\n  name VARCHAR(200) NOT NULL,\r\n  slug VARCHAR(120) NOT NULL UNIQUE,\r\n  plan TINYINT NOT NULL DEFAULT 0,\r\n  active BOOLEAN NOT NULL DEFAULT TRUE,\r\n  max_users INT NOT NULL DEFAULT 10,\r\n  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP\r\n);\r\n\r\nCREATE TABLE teams (\r\n  id INT AUTO_INCREMENT PRIMARY KEY,\r\n  org_id INT NOT NULL,\r\n  name VARCHAR(120) NOT NULL,\r\n  description TEXT,\r\n  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  FOREIGN KEY (org_id) REFERENCES organizations(id)\r\n);\r\n\r\nCREATE TABLE users (\r\n  id INT AUTO_INCREMENT PRIMARY KEY,\r\n  org_id INT NOT NULL,\r\n  email VARCHAR(255) NOT NULL UNIQUE,\r\n  password_hash VARCHAR(255) NOT NULL,\r\n  display_name VARCHAR(120) NOT NULL,\r\n  role ENUM('admin', 'member', 'viewer') NOT NULL DEFAULT 'member',\r\n  active BOOLEAN NOT NULL DEFAULT TRUE,\r\n  last_login DATETIME,\r\n  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  FOREIGN KEY (org_id) REFERENCES organizations(id)\r\n);\r\n\r\nCREATE TABLE projects (\r\n  id INT AUTO_INCREMENT PRIMARY KEY,\r\n  org_id INT NOT NULL,\r\n  name VARCHAR(200) NOT NULL,\r\n  description TEXT,\r\n  budget DECIMAL(12, 2) NOT NULL DEFAULT 0.00,\r\n  status ENUM('planning', 'active', 'completed', 'archived') NOT NULL DEFAULT 'planning',\r\n  start_date DATE,\r\n  end_date DATE,\r\n  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  FOREIGN KEY (org_id) REFERENCES organizations(id)\r\n);\r\n\r\nCREATE TABLE invoices (\r\n  id INT AUTO_INCREMENT PRIMARY KEY,\r\n  org_id INT NOT NULL,\r\n  user_id INT NOT NULL,\r\n  project_id INT,\r\n  invoice_no VARCHAR(32) NOT NULL UNIQUE,\r\n  amount DECIMAL(12, 2) NOT NULL,\r\n  tax DECIMAL(12, 2) NOT NULL DEFAULT 0.00,\r\n  total DECIMAL(12, 2) NOT NULL,\r\n  currency CHAR(3) NOT NULL DEFAULT 'USD',\r\n  status ENUM('draft', 'sent', 'paid', 'cancelled') NOT NULL DEFAULT 'draft',\r\n  due_date DATE NOT NULL,\r\n  paid_at DATETIME,\r\n  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  FOREIGN KEY (org_id) REFERENCES organizations(id),\r\n  FOREIGN KEY (user_id) REFERENCES users(id),\r\n  FOREIGN KEY (project_id) REFERENCES projects(id)\r\n);\r\n<\/code><\/pre>                <\/div>\r\n                
\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Sql in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n            <\/div>\r\n            \n<\/p><\/div>\n
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7de8\u8f2f Sql<\/span>
\n<\/a>\n<\/div>\n<\/div>\n
4. \u5716\u66f8\u9928\u7ba1\u7406\u76ee\u9304\uff08SQLite \u8a9e\u6cd5\uff09<\/h3>\n
\u975e\u5e38\u9069\u5408\u672c\u5730\u5316\u61c9\u7528\u7d50\u69cb\uff0c\u6b64 SQLite \u8cc7\u6599\u96c6\u5305\u542b\u5b8c\u6574\u7684\u8a2d\u5b9a\uff0c\u7528\u65bc\u51fa\u7248\u5546\u76ee\u9304\u3001\u5177\u7d50\u69cb\u6027\u4ea4\u53c9\u53c3\u8003\u9650\u5236\u7684\u76ee\u9304\u5eab\u5b58\u3001\u6703\u54e1\u8cc7\u6599\u5eab\u3001\u5be6\u9ad4\u501f\u95b1\u4ee5\u53ca\u7b49\u5019\u540d\u55ae\u4fdd\u7559\u3002<\/p>\n
\"A<\/p>\n
\n
\nSql<\/span>
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7de8\u8f2f Sql<\/span>
\n<\/a>\n<\/div>\n
\n            
\r\n                                
\r\n                    Sql<\/span>\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Sql in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n                                
\r\n                    
\r\nCREATE TABLE \u51fa\u7248\u5546 (\r\n  id INTEGER PRIMARY KEY,\r\n  \u540d\u7a31 VARCHAR(200) NOT NULL,\r\n  \u5730\u5740 TEXT,\r\n  \u7db2\u7ad9 VARCHAR(300),\r\n  \u6210\u7acb\u5e74\u4efd INT\r\n);\r\n\r\nCREATE TABLE \u66f8\u7c4d (\r\n  id INTEGER PRIMARY KEY,\r\n  \u51fa\u7248\u5546ID INT,\r\n  isbn VARCHAR(20) NOT NULL UNIQUE,\r\n  \u6a19\u984c VARCHAR(300) NOT NULL,\r\n  \u526f\u6a19\u984c VARCHAR(300),\r\n  \u8a9e\u8a00 VARCHAR(30) NOT NULL DEFAULT '\u82f1\u6587',\r\n  \u9801\u6578 INT,\r\n  \u51fa\u7248\u5e74\u4efd INT,\r\n  \u7248\u6b21 INT DEFAULT 1,\r\n  \u5c01\u9762\u5716\u7247 BLOB,\r\n  \u63cf\u8ff0 TEXT,\r\n  \u8a55\u5206 REAL DEFAULT 0.0,\r\n  \u50f9\u683c DECIMAL(8, 2),\r\n  \u5eab\u5b58\u72c0\u614b BOOLEAN NOT NULL DEFAULT TRUE,\r\n  \u8cfc\u5165\u6642\u9593 DATE,\r\n  \u5efa\u7acb\u6642\u9593 TIMESTAMP NOT NULL,\r\n  FOREIGN KEY (\u51fa\u7248\u5546ID) REFERENCES \u51fa\u7248\u5546(id)\r\n);\r\n\r\nCREATE TABLE \u4f5c\u8005 (\r\n  id INTEGER PRIMARY KEY,\r\n  \u540d\u5b57 VARCHAR(80) NOT NULL,\r\n  \u59d3\u6c0f VARCHAR(80) NOT NULL,\r\n  \u51fa\u751f\u65e5\u671f DATE,\r\n  \u570b\u7c4d VARCHAR(60),\r\n  \u751f\u5e73\u4ecb\u7d39 TEXT,\r\n  \u7db2\u7ad9 VARCHAR(300)\r\n);\r\n\r\nCREATE TABLE \u66f8\u7c4d\u4f5c\u8005 (\r\n  \u66f8\u7c4dID INT NOT NULL,\r\n  \u4f5c\u8005ID INT NOT NULL,\r\n  \u89d2\u8272 VARCHAR(60) DEFAULT '\u4f5c\u8005',\r\n  \u6392\u5e8f\u9806\u5e8f INT NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (\u66f8\u7c4dID, \u4f5c\u8005ID),\r\n  CONSTRAINT fk_ba_book FOREIGN KEY (\u66f8\u7c4dID) REFERENCES \u66f8\u7c4d(id),\r\n  CONSTRAINT fk_ba_author FOREIGN KEY (\u4f5c\u8005ID) REFERENCES \u4f5c\u8005(id)\r\n);\r\n\r\nCREATE TABLE \u6703\u54e1 (\r\n  id INTEGER PRIMARY KEY,\r\n  \u5361\u865f VARCHAR(20) NOT NULL UNIQUE,\r\n  \u540d\u5b57 VARCHAR(80) NOT NULL,\r\n  \u59d3\u6c0f VARCHAR(80) NOT NULL,\r\n  \u96fb\u5b50\u90f5\u4ef6 VARCHAR(255) NOT NULL UNIQUE,\r\n  \u96fb\u8a71 VARCHAR(30),\r\n  \u5730\u5740 TEXT,\r\n  \u6703\u54e1\u985e\u578b VARCHAR(30) NOT NULL DEFAULT '\u6a19\u6e96',\r\n  \u52a0\u5165\u6642\u9593 DATE NOT NULL,\r\n  \u5230\u671f\u6642\u9593 DATE NOT NULL,\r\n  \u662f\u5426\u6709\u6548 BOOLEAN NOT NULL DEFAULT TRUE\r\n);\r\n\r\nCREATE TABLE \u501f\u95b1\u8a18\u9304 (\r\n  id INTEGER PRIMARY KEY,\r\n  \u66f8\u7c4dID INT NOT NULL,\r\n  \u6703\u54e1ID INT NOT NULL,\r\n  \u501f\u51fa\u6642\u9593 TIMESTAMP NOT NULL,\r\n  \u61c9\u9084\u6642\u9593 DATE NOT NULL,\r\n  \u6b78\u9084\u6642\u9593 TIMESTAMP,\r\n  \u7e8c\u501f\u6b21\u6578 INT NOT NULL DEFAULT 0,\r\n  \u5099\u8a3b TEXT,\r\n  FOREIGN KEY (\u66f8\u7c4dID) REFERENCES \u66f8\u7c4d(id),\r\n  FOREIGN KEY (\u6703\u54e1ID) REFERENCES \u6703\u54e1(id)\r\n);\r\n\r\nCREATE TABLE \u9810\u7d04\u8a18\u9304 (\r\n  id INTEGER PRIMARY KEY,\r\n  \u66f8\u7c4dID INT NOT NULL,\r\n  \u6703\u54e1ID INT NOT NULL,\r\n  \u9810\u7d04\u6642\u9593 TIMESTAMP NOT NULL,\r\n  \u5230\u671f\u6642\u9593 DATE,\r\n  \u5df2\u8655\u7406\u6642\u9593 TIMESTAMP,\r\n  \u662f\u5426\u53d6\u6d88 BOOLEAN NOT NULL DEFAULT FALSE,\r\n  FOREIGN KEY (\u66f8\u7c4dID) REFERENCES \u66f8\u7c4d(id),\r\n  FOREIGN KEY (\u6703\u54e1ID) REFERENCES \u6703\u54e1(id)\r\n);\r\n<\/code><\/pre>                <\/div>\r\n                
\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Sql in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n            <\/div>\r\n            \n<\/p><\/div>\n
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7de8\u8f2f SQL<\/span>
\n<\/a>\n<\/div>\n<\/div>\n\n
\u70ba\u4ec0\u9ebc\u8981\u4f7f\u7528\u7dda\u4e0a SQL ERD \u5de5\u5177\uff1f<\/h2>\n
\u96a8\u8457\u67b6\u69cb\u5728\u7a0b\u5f0f\u78bc\u5be9\u67e5\u548c\u8fed\u4ee3\u958b\u767c\u4e2d\u4e0d\u65b7\u6f14\u9032\uff0c\u7dad\u8b77\u7cbe\u78ba\u7684\u6587\u4ef6\u53ef\u80fd\u6210\u70ba\u4e00\u9805\u7e41\u7463\u7684\u5de5\u4f5c\u3002VPasCode \u5c07\u8cc7\u6599\u6a21\u578b\u8f49\u5411\u4ee5\u7a0b\u5f0f\u78bc\u70ba\u5148\u7684\u6a21\u5f0f\uff1a<\/p>\n