{"id":2114,"date":"2026-05-26T07:38:24","date_gmt":"2026-05-26T07:38:24","guid":{"rendered":"https:\/\/www.vpascode.com\/cn\/docs\/uncategorized\/plantuml-erd-syntax-guide\/"},"modified":"2026-05-26T07:38:24","modified_gmt":"2026-05-26T07:38:24","slug":"plantuml-erd-syntax-guide","status":"publish","type":"ld_docs","link":"https:\/\/www.vpascode.com\/cn\/docs\/vpascode-docs\/plantuml-erd-syntax-guide\/","title":{"rendered":"PlantUML ERD \u8bed\u6cd5\u6307\u5357"},"content":{"rendered":"

\u4ec0\u4e48\u662f\u5b9e\u4f53\u5173\u7cfb\u56fe\uff08ERD\uff09\uff1f<\/h2>\n

\u4e00\u4e2a\u5b9e\u4f53\u5173\u7cfb\u56fe\uff08ERD\uff09<\/strong>\u662f\u4e00\u79cd\u7528\u4e8e\u8bbe\u8ba1\u3001\u6587\u6863\u5316\u548c\u5206\u6790\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7684\u7ed3\u6784\u84dd\u56fe\u3002\u5b83\u53ef\u89c6\u5316\u7cfb\u7edf\u4e2d\u7684\u8868\uff08\u5b9e\u4f53\uff09\u3001\u5b83\u4eec\u5305\u542b\u7684\u7279\u5b9a\u5217\uff08\u5c5e\u6027\uff09\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u8868\u4e4b\u95f4\u7684\u5173\u8054\u65b9\u5f0f\u3002\u5728 PlantUML \u4e2d\uff0cERD \u4f7f\u7528\u4fe1\u606f\u5de5\u7a0b\uff08IE\uff09\u8868\u793a\u6cd5<\/strong>\uff0c\u91c7\u7528\u6807\u51c6\u4e4c\u9e26\u8db3\u8868\u793a\u6cd5<\/strong>\u6765\u8868\u793a\u5173\u7cfb\u7ea6\u675f\u3002<\/p>\n

\u65e0\u8bba\u4f60\u662f\u8bbe\u8ba1\u5fae\u670d\u52a1\u6570\u636e\u5b58\u50a8\u3001\u4f18\u5316 SQL \u8fde\u63a5\u8def\u5f84\uff0c\u8fd8\u662f\u89c4\u5212\u4f01\u4e1a\u7ea7\u6570\u636e\u4ed3\u5e93\u67b6\u6784\uff0c\u57fa\u4e8e\u6587\u672c\u7684 UML ERD \u90fd\u80fd\u786e\u4fdd\u4f60\u7684\u6570\u636e\u5e93\u6a21\u5f0f\u6e05\u6670\u660e\u4e86\u3002\u501f\u52a9VPasCode<\/strong>\uff0c\u4f60\u53ef\u4ee5\u4f7f\u7528\u7b80\u6d01\u3001\u58f0\u660e\u5f0f\u7684\u8bed\u6cd5\u6765\u5b9a\u4e49\u6570\u636e\u5e93\u8868\u3001\u7d22\u5f15\u952e\u548c\u903b\u8f91\u5173\u7cfb\u3002\u5f15\u64ce\u4f1a\u81ea\u52a8\u5904\u7406\u8868\u683c\u6846\u7684\u5927\u5c0f\u8c03\u6574\uff0c\u5e76\u81ea\u52a8\u8def\u7531\u5916\u952e\u8fde\u63a5\u7ebf\uff0c\u800c\u4e0d\u4f1a\u51fa\u73b0\u91cd\u53e0\u7684\u5e03\u5c40\u7ebf\u6761\u3002<\/p>\n

\u6838\u5fc3\u8bed\u6cd5\u6307\u5357\uff1a\u5143\u7d20\u4e0e\u7ed3\u6784<\/h2>\n

\u5728 PlantUML \u4e2d\u6784\u5efa\u7a33\u5065\u7684 IE \u98ce\u683c ERD\uff0c\u4f9d\u8d56\u4e8e\u7ed3\u6784\u5316\u7684\u5b9e\u4f53\u5757\u3001\u660e\u786e\u7684\u952e\u6807\u8bc6\u4ee5\u53ca\u4e4c\u9e26\u8db3\u57fa\u6570\u4fee\u9970\u7b26\u3002<\/p>\n

1. \u58f0\u660e\u5b9e\u4f53\uff08\u6570\u636e\u5e93\u8868\uff09<\/h3>\n

\u4f60\u4f7f\u7528entity<\/code>\u5173\u952e\u5b57\uff0c\u540e\u8ddf\u8868\u540d\u548c\u4e00\u5bf9\u82b1\u62ec\u53f7\u3002\u5728\u82b1\u62ec\u53f7\u5185\uff0c\u5217\u51fa\u4f60\u7684\u8868\u5217\u3002\u4e3a\u4e86\u4f7f\u4f60\u7684\u6a21\u5f0f\u6e05\u6670\u6613\u8bfb\uff0c\u4f7f\u7528\u6c34\u5e73\u5206\u9694\u7ebf\uff08--<\/code>\uff09\u5c06\u4e3b\u952e\/\u5916\u952e\u4e0e\u6807\u51c6\u6570\u636e\u5c5e\u6027\u5206\u9694\u5f00\uff1a<\/p>\n

\n
\nPlantuml<\/span>
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7f16\u8f91 Plantuml<\/span>
\n<\/a>\n<\/div>\n
\n
\r\n
\r\n Plantuml<\/span>\r\n \r\n <\/path><\/path><\/svg>\r\n Edit Plantuml in VPasCode<\/span>\r\n <\/a>\r\n <\/div>\r\n
\r\n 
entity \"users\" as users_table {\r\n    id : INT [PK]\r\n    --\r\n    email : VARCHAR(255)\r\n    created_at : TIMESTAMP\r\n}<\/code><\/pre>                <\/div>\r\n                
\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Plantuml 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\u7f16\u8f91 Plantuml<\/span>
\n<\/a>\n<\/div>\n<\/div>\n
\"\"<\/p>\n
2. \u6807\u8bc6\u4e3b\u952e\u548c\u5916\u952e<\/h3>\n
\u867d\u7136\u50cf `[PK]` \u6216 `[FK]` \u8fd9\u6837\u7684\u6587\u672c\u6807\u8bc6\u7b26\u6548\u679c\u826f\u597d\uff0c\u4f46 PlantUML \u7684 IE \u5f15\u64ce\u8fd8\u652f\u6301\u89c6\u89c9\u5316\u7684\u952e\u56fe\u6807\u3002\u5728\u5c5e\u6027\u524d\u653e\u7f6e\u4e00\u4e2a\u661f\u53f7\uff08*<\/code>\uff09\u8868\u793a\u8be5\u5217\u662f**\u5f3a\u5236\u6027\uff08\u975e\u7a7a\uff09**\u7684\uff0c\u800c\u5e72\u51c0\u7684\u6587\u672c\u5b57\u7b26\u4e32\u6216\u6807\u7b7e\u5219\u6dfb\u52a0\u4e86\u660e\u786e\u7684\u7d22\u5f15\u4e0a\u4e0b\u6587\uff1a<\/p>\n
\n
\nPlantuml<\/span>
\n
\n<\/path><\/path><\/svg>
\n\u5728 VPasCode \u4e2d\u7f16\u8f91 Plantuml<\/span>
\n<\/a>\n<\/div>\n
\n            
\r\n                                
\r\n                    Plantuml<\/span>\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Plantuml in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n                                
\r\n                    
\u5b9e\u4f53 \"orders\" {\r\n    * id : INT <<PK>>\r\n    --\r\n    * user_id : INT <<FK>>\r\n    discount_code : VARCHAR(50)\r\n}<\/code><\/pre>                <\/div>\r\n                
\r\n                    \r\n                        <\/path><\/path><\/svg>\r\n                        Edit Plantuml 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\u7f16\u8f91 PlantUML<\/span>
\n<\/a>\n<\/div>\n<\/div>\n
\"\"<\/p>\n
3. \u6620\u5c04\u4e4c\u9e26\u8db3\u57fa\u6570\u548c\u5173\u7cfb<\/h3>\n
\u8981\u8fde\u63a5\u8868\u5e76\u5f3a\u5236\u6267\u884c\u5f15\u7528\u5b8c\u6574\u6027\u7ea6\u675f\uff0c\u8bf7\u4f7f\u7528\u8fde\u5b57\u7b26\u3001\u65b9\u62ec\u53f7\u548c\u7ba1\u9053\u5b57\u7b26\u7684\u7ec4\u5408\u3002\u5728 IE \u8868\u793a\u6cd5\u4e2d\uff0c\u8fd9\u4e9b\u7b26\u53f7\u5f62\u6210\u4e0d\u540c\u7684 **\u4e4c\u9e26\u8db3** \u5934\u90e8\uff0c\u8868\u793a\u6570\u636e\u5e93\u5173\u7cfb\uff1a<\/p>\n