{"id":2310,"date":"2026-08-18T07:03:18","date_gmt":"2026-08-18T07:03:18","guid":{"rendered":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/"},"modified":"2026-08-18T07:03:18","modified_gmt":"2026-08-18T07:03:18","slug":"building-a-hotel-management-erd-with-plantuml-and-vpascode","status":"publish","type":"post","link":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/","title":{"rendered":"\u4f7f\u7528 PlantUML \u548c VPasCode \u5efa\u7acb\u9152\u5e97\u7ba1\u7406 ERD"},"content":{"rendered":"<p><img fetchpriority=\"high\" alt='A YouTube thumbnail-style graphic featuring the bold text \"BUILD PROFESSIONAL DATABASE DIAGRAMS\" in large uppercase letters, with a pointing finger icon on the right and a rendered Entity Relationship Diagram displayed in the background.' class=\"alignnone size-full wp-image-2717\" decoding=\"async\" fetchpriority=\"high\" height=\"768\" sizes=\"(max-width: 1376px) 100vw, 1376px\" src=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg\" srcset=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg 1376w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/build-professional-database-diagrams-thumbnail-300x167.jpg 300w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/build-professional-database-diagrams-thumbnail-1024x572.jpg 1024w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/build-professional-database-diagrams-thumbnail-768x429.jpg 768w\" width=\"1376\"\/><\/p>\n<p>\u5728\u8a2d\u8a08\u8907\u96dc\u9818\u57df\uff08\u5982\u9152\u5e97\u696d\uff09\u7684\u7a69\u5065\u8cc7\u6599\u5eab\u67b6\u69cb\u6642\uff0c\u6e05\u6670\u5730\u53ef\u8996\u5316\u95dc\u4fc2\u81f3\u95dc\u91cd\u8981\u3002\u7121\u8ad6\u60a8\u662f\u5728\u7e6a\u88fd\u5ba2\u6236\u8cc7\u6599\u3001\u8ffd\u8e64\u623f\u9593\u5eab\u5b58\uff0c\u9084\u662f\u7ba1\u7406\u5e33\u55ae\uff0c\u4e00\u500b\u7d50\u69cb\u826f\u597d\u7684\u5be6\u9ad4\u95dc\u4fc2\u5716\uff08ERD\uff09\u90fd\u80fd\u5728\u958b\u767c\u904e\u7a0b\u4e2d\u7bc0\u7701\u7121\u6578\u6642\u9593\u3002\u5728\u9019\u5802\u9032\u968e\u8ab2\u7a0b\u4e2d\uff0c\u6211\u5c07\u5e36\u60a8\u4e00\u6b65\u6b65\u4e86\u89e3\u6211\u5982\u4f55\u4f7f\u7528 PlantUML \u5728 <a href=\"https:\/\/www.vpascode.com\/editor\/\">\u514d\u8cbb\u7684 PlantUML \u7de8\u8f2f\u5668<\/a>, <a href=\"https:\/\/vpascode.com\/\">VPasCode<\/a>.<\/p>\n<p id=\"LzlMgfr\"><img alt=\"\" class=\"alignnone size-full wp-image-2661\" decoding=\"async\" height=\"738\" sizes=\"(max-width: 1508px) 100vw, 1508px\" src=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83fec0372f7.png\" srcset=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83fec0372f7.png 1508w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83fec0372f7-300x147.png 300w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83fec0372f7-1024x501.png 1024w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83fec0372f7-768x376.png 768w\" width=\"1508\"\/><\/p>\n<h2>1. \u521d\u59cb\u5316 PlantUML \u74b0\u5883<\/h2>\n<p>\u6211\u9996\u5148\u5efa\u7acb\u8173\u672c\u7684\u57fa\u790e\u7d50\u69cb\u3002\u5728\u8655\u7406\u5305\u542b\u5927\u91cf\u5c6c\u6027\u7684\u8907\u96dc\u8cc7\u6599\u7d50\u69cb\u6642\uff0c\u4f48\u5c40\u7684\u53ef\u8b80\u6027\u81f3\u95dc\u91cd\u8981\u3002\u6211\u8a2d\u5b9a PlantUML \u4ee5\u96b1\u85cf\u4e0d\u5fc5\u8981\u7684\u96dc\u4e82\u5143\u7d20\uff0c\u4e26\u512a\u5316\u5716\u8868\u7684\u4f48\u5c40\u65b9\u5411\uff1a<\/p>\n<pre><code class=\"language-plantuml\">\r\n@startuml \r\ntitle \u9152\u5e97\u7ba1\u7406 ERD\r\n\r\nhide circle\r\nleft to right direction\r\n    <\/code><\/pre>\n<p><strong>\u70ba\u4ec0\u9ebc\u63a1\u7528\u9019\u7a2e\u65b9\u6cd5\uff1f<\/strong>\u96b1\u85cf\u9810\u8a2d\u7684\u5c6c\u6027\u5713\u5708\u53ef\u8b93\u5be6\u9ad4\u6846\u4fdd\u6301\u4e7e\u6de8\u4e14\u73fe\u4ee3\u5316\u3002\u8a2d\u5b9a\u65b9\u5411\u70ba<code>\u5f9e\u5de6\u5230\u53f3\u65b9\u5411<\/code>\u53ef\u9632\u6b62\u5bec\u5ee3\u7684 ERD \u8b8a\u5f97\u5782\u76f4\u4e0a\u96e3\u4ee5\u7ba1\u7406\uff0c\u4e26\u908f\u8f2f\u6027\u5730\u5c55\u958b\u591a\u8868\u4e4b\u9593\u7684\u95dc\u4fc2\u3002<\/p>\n<h2>2. \u5b9a\u7fa9\u6838\u5fc3\u5be6\u9ad4\u8207\u5c6c\u6027<\/h2>\n<p>\u63a5\u4e0b\u4f86\uff0c\u6211\u9700\u8981\u5b9a\u7fa9\u4ee3\u8868\u6211\u5011\u696d\u52d9\u9818\u57df\u7684\u6838\u5fc3\u5be6\u9ad4\u3002\u6211\u4ee5\u4e3b\u9375\u3001\u552f\u4e00\u6027\u7d04\u675f\u548c\u985e\u578b\u5316\u5c6c\u6027\u4f86\u7d50\u69cb\u5316\u6bcf\u500b\u5be6\u9ad4\u3002\u8b93\u6211\u5011\u4f86\u770b\u770b\u6211\u5982\u4f55\u5efa\u7acb\u6838\u5fc3<code>Customer<\/code> \u548c <code>RoomType<\/code>\u5be6\u9ad4\uff1a<\/p>\n<pre><code class=\"language-plantuml\">\r\nentity \"Customer\" as customer {\r\n  * customer_id : UUID &lt;&lt;PK&gt;&gt;\r\n  --\r\n  first_name : VARCHAR(50)\r\n  last_name : VARCHAR(50)\r\n  email : VARCHAR(100) &lt;&lt;UK&gt;&gt;\r\n  phone : VARCHAR(20)\r\n  address : TEXT\r\n  loyalty_points : INTEGER\r\n  total_stays : INTEGER\r\n  date_registered : TIMESTAMP\r\n  date_of_birth : DATE\r\n  nationality : VARCHAR(50)\r\n}\r\n\r\nentity \"RoomType\" as roomtype {\r\n  * room_type_id : UUID &lt;&lt;PK&gt;&gt;\r\n  --\r\n  type_name : VARCHAR(50) &lt;&lt;UK&gt;&gt;\r\n  description : TEXT\r\n  standard_capacity : INTEGER\r\n  base_price : DECIMAL(10,2)\r\n  extra_bed_charge : DECIMAL(10,2)\r\n  has_kitchenette : BOOLEAN\r\n  has_balcony : BOOLEAN\r\n}\r\n    <\/code><\/pre>\n<p>\u900f\u904e\u5b9a\u7fa9\u660e\u78ba\u7684\u6a19\u8a18\uff0c\u4f8b\u5982<code>&lt;&lt;PK&gt;&gt;<\/code> \u548c <code>&lt;&lt;UK&gt;&gt;<\/code>\uff0c\u4efb\u4f55\u5be9\u95b1\u7a0b\u5f0f\u78bc\u7684\u4eba\u90fd\u80fd\u7acb\u5373\u7406\u89e3\u7d22\u5f15\u8207\u552f\u4e00\u6027\u898f\u5247\uff0c\u751a\u81f3\u5728\u64b0\u5beb\u8cc7\u6599\u5eab\u9077\u79fb\u8173\u672c\u4e4b\u524d\u5c31\u6e05\u695a\u638c\u63e1\u3002<\/p>\n<h2>3. \u5efa\u7acb\u64cd\u4f5c\u6027\u5be6\u9ad4\uff08\u623f\u9593\u3001\u9810\u8a02\u8207\u54e1\u5de5\uff09<\/h2>\n<p>\u5728\u53c3\u8003\u8cc7\u6599\u8a2d\u5b9a\u5b8c\u6210\u5f8c\uff0c\u6211\u63a5\u8457\u9032\u5165\u9152\u5e97\u7ba1\u7406\u7cfb\u7d71\u7684\u4ea4\u6613\u6838\u5fc3\uff1a\u623f\u9593\u3001\u9810\u8a02\u8207\u54e1\u5de5\u5de5\u4f5c\u6d41\u7a0b\u3002\u6bcf\u500b\u5be6\u9ad4\u90fd\u900f\u904e\u5916\u9375\u9023\u7d50\u56de\u6211\u5011\u7684\u57fa\u790e\u8cc7\u6599\u8868\uff1a<\/p>\n<pre><code class=\"language-plantuml\">\r\nentity \"Room\" as room {\r\n  * room_id : UUID &lt;&lt;PK&gt;&gt;\r\n  --\r\n  room_number : VARCHAR(10) &lt;&lt;UK&gt;&gt;\r\n  floor_number : INTEGER\r\n  room_type_id : UUID &lt;&lt;FK&gt;&gt;\r\n  capacity : INTEGER\r\n  base_price : DECIMAL(10,2)\r\n  is_available : BOOLEAN\r\n  has_view : BOOLEAN\r\n  square_feet : INTEGER\r\n  last_renovated : DATE\r\n}\r\n\r\nentity \"Reservation\" as reservation {\r\n  * reservation_id : UUID &lt;&lt;PK&gt;&gt;\r\n  --\r\n  customer_id : UUID &lt;&lt;FK&gt;&gt;\r\n  room_id : UUID &lt;&lt;FK&gt;&gt;\r\n  check_in_date : DATE\r\n  check_out_date : DATE\r\n  number_of_guests : INTEGER\r\n  total_amount : DECIMAL(10,2)\r\n  status : VARCHAR(20)\r\n  special_requests : TEXT\r\n  created_at : TIMESTAMP\r\n  updated_at : TIMESTAMP\r\n  confirmation_code : VARCHAR(20) &lt;&lt;UK&gt;&gt;\r\n}\r\n    <\/code><\/pre>\n<h2>4. \u5efa\u7acb\u8ca1\u52d9\u8207\u670d\u52d9\u95dc\u4fc2<\/h2>\n<p>\u70ba\u4e86\u5b8c\u6210\u67b6\u69cb\u8a2d\u8a08\uff0c\u6211\u7e6a\u88fd\u51fa\u5e33\u55ae\u8a18\u9304\uff08\u4ed8\u6b3e\u8207\u767c\u7968\uff09\uff0c\u4ee5\u53ca\u7531\u9152\u5e97\u54e1\u5de5\u8655\u7406\u7684\u8f14\u52a9\u670d\u52d9\uff08\u5982\u5ba2\u623f\u670d\u52d9\uff09\u3002\u70ba\u4e86\u5c07\u6240\u6709\u5167\u5bb9\u9023\u7d50\u8d77\u4f86\uff0c\u6211\u4f7f\u7528\u6a19\u6e96\u7684 PlantUML \u8a18\u6cd5\u660e\u78ba\u5b9a\u7fa9\u4e86\u95dc\u4fc2\u7684\u57fa\u6578\u3002<\/p>\n<pre><code class=\"language-plantuml\">\r\n' \u95dc\u4fc2\r\ncustomer ||--o{ reservation : \"\u5efa\u7acb\"\r\nroom ||--o{ reservation : \"\u6307\u6d3e\u7d66\"\r\nreservation ||--|| payment : \"\u64c1\u6709\"\r\nreservation ||--|| invoice : \"\u7522\u751f\"\r\nreservation ||--o{ roomservice : \"\u8acb\u6c42\"\r\nstaff ||--o{ roomservice : \"\u57f7\u884c\"\r\nroomtype ||--o{ room : \"\u5206\u985e\"\r\n\r\n@enduml\r\n    <\/code><\/pre>\n<p><strong>\u8a2d\u8a08\u9078\u64c7\uff1a<\/strong> \u4f7f\u7528\u7cbe\u78ba\u7684\u70cf\u9d09\u8173\u7b26\u865f\uff08\u4f8b\u5982 <code>||--o{<\/code> \u7528\u65bc\u5f37\u5236\u6027\u81f3\u53ef\u9078\u6027\u7684\u4e00\u5c0d\u591a\u95dc\u4fc2\uff09\u53ef\u78ba\u4fdd\u5546\u696d\u908f\u8f2f\u898f\u5247\u2014\u2014\u4f8b\u5982\u9810\u8a02\u5fc5\u9808\u6709\u5ba2\u6236\uff0c\u4f46\u5ba2\u6236\u53ef\u80fd\u6709\u96f6\u500b\u6216\u591a\u500b\u6d3b\u8e8d\u9810\u8a02\u2014\u2014\u88ab\u6e96\u78ba\u5730\u5efa\u6a21\u3002<\/p>\n<section class=\"post-section\">\u00a0<\/section>\n<hr\/>\n<h2>\u5b8c\u6574\u7684 PlantUML \u7a0b\u5f0f\u78bc<\/h2>\n<p>\u4ee5\u4e0b\u662f\u6211\u5011\u9152\u5e97\u7ba1\u7406\u5be6\u9ad4\u95dc\u4fc2\u5716\u7684\u5b8c\u6574\u7d44\u5408\u539f\u59cb\u78bc\u3002\u60a8\u53ef\u4ee5\u76f4\u63a5\u5c07\u6b64\u7a0b\u5f0f\u78bc\u8907\u88fd\u8cbc\u4e0a\u81f3\u60a8\u6700\u559c\u611b\u7684 <strong>\u514d\u8cbb PlantUML \u7de8\u8f2f\u5668<\/strong> \u4ee5\u9032\u884c\u7de8\u8f2f\u6216\u6e32\u67d3\u5411\u91cf\u5716\u5f62\uff1a<\/p>\n<div class=\"vpascode-viewer-container vpascode-fancy-active\">\n<div class=\"vpascode-header\">\n<span class=\"vpascode-lang-label\">Plantuml<\/span><br \/>\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#plantuml:nPRVRzis4CVV3VX_8FAojLY0BCDUWcAe5nkhWQOj77VO6t6MJXOHYbJ9arklwV--8sKfaYKLQ5xs8eZy7dzzxex7rvx0KLLeCP_DPwH8etXZ2RMu0mDxBD2GM6sMGSrLYY9HBj4udsdCI90LJkrp4gboc92o9jZz99QOAOE2nofIwCLdHRa08gTs5Q6Vpw9o51UtbITReBiGu4LoQeYlyvaGBzksLAcu4Hy_hfVYrHz1khmCtqmvJz90WQp-lTZSlbbiVlxzwaNGD4nAM83IdUvVhwvUdEOjSskw8wxh4P2c3hrdORlwPnkdjqVGT9IbLOQ2i7wtNVsrsWIDB86MZFLu9gH0A1tkbITq68wqNT-jxhUBkm-jR3EvKuvXtOZbOhiA_GO2Lz21rzbXlWNQ3SgDjKN4wFYdGHZ-9_15oLJ5Ze5tQJGmCcsjUpBe72IEf6E9WvaJA26fDzgntu57MJgL1BRBrUtwRl6M5_hbEj9LNiA1NG8x7VG_txz_krgy2qeENXuKVkxt-ayLE9GP8lMNYJvtQEo1IQOjmG6aBU-y1HMEqOCrUgwQM9I6GNMoIT4dJfN1MPr8uJWmARXKFWSDVY47SeSyEWUt7xK9a1uK9JaQ91eXk0ETM7Fi2dqawD4TOf3LL9xQBPYdhWaqawaw6e2ysUH1AYD3p7T2lUwt5PqBTHI6xDXNwCSp3WfR6Hf3n3wWoW_psfUOA1xfy5CpQ-Esn6488WbqdgPLcKueJ9clfAB6bDZqx2Q9P--H_m37SBr6wcNztn0_DQTIzpl-cCRGp7bYszjxenL8kKqx6_-jHiLnQ3maJoiEut-ACXS6vBIGbTCTm0wpogIJJkjnMfk3vGo9d5Jztt0wDP_1gHavk06lsnCfxolsz5aifXMUT_bg5sDmZ3h1bz6Ov8s5vQSJ-tbHtGDtJv1b4PiFVmsqsFY_Ywgp6eTnblCxOa0NDBZZA89SPIGzNnjffKTs5KeBn-m1foy_lfxkQrUq9U7acfRMoLC_7cBZd9lvOkKPR7cyYfnkA4cgmE6rKvGQumR6vAcqd2Wwt-e7t0PrF1CJBlcvrhxC7XylB-tNNesu4HS5FA2_cC_YosFS1BnNUyDbcMmmx8Z1_l6nlG3PbglMk4sJ_6opvtBdE4x6BCFg7J-oTNF3it6T2UDcMQKpfNLpbEYXZcKmINZDlNNgtxZoVFOQJSglv_y0\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 8px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>\u5728 VPasCode \u4e2d\u7de8\u8f2f Plantuml<\/span><br \/>\n<\/a>\n<\/div>\n<div class=\"vpascode-code-wrapper\">\n            <div class=\"vpascode-viewer-container vpascode-fancy-active\">\r\n                                <div class=\"vpascode-header\">\r\n                    <span class=\"vpascode-lang-label\">Plantuml<\/span>\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#plantuml:nPRlQnn56CVV7zp_iEIDLWp4Y6-AIC_cq43JIhoAxuQvtMUpGtTtjZEpPu-ce87MQ2eM4reheJM5rafAfA0jj9ByCzszt7_XpEoFxDxE2kQDRuxR-Nxdr-TvdfavnmLc8WvygzlfTWGHFbZJcpybh-vD3lOcTsubVpoPxkzCx-s-ETf8TkygaqSSi6p2R1-w7HzSOGbgCRBc2SiX36n1QAXyRrd9mI-Jmz-p8P8VlqzklaYUFqk__gtRWL1EDRRcaeD7wUQBEGjpouwve04mwtgtOrdlbD-8EDPPw_BbvINhmu-KD3-lVbt2k40X3a2gN_HMpt_QMttxWuKpIlDngmG19dwb-Rs5XJFvk957msgFnQm7TXm6d4jXqFzoe8UdO-oBCOee2OKIbYyE-f_qLvKcgC0-ab37CuA31I06QuGBOA2sD5XUwNy-wAryLihKHKF2X2V5fTwWhzf3h71YNz6QsSmD1Ra0cMuUJUzkQv2Cqg20gFwt0DHI60T3YRpAey3X-fIo4qDbAxgd64VG6Dd64RQpfLRyGym1HOpOYkvI__poIk-2dEZTHSsNS8H7CYXuw2lzuqkNBlHx5vNYOOv61Bwgj_AhCMQ0N01HdqP7dK58HvAbKp8qO9hkFKWUR9Mmr5Pgm8nxowXfgPbQkSS1RZCIgP1LyaLcG-XWvg3Ju85hWc4q1DdRmspDw56WhX1XUn2240QAG-pRD1nNXHgMwQztZfzkP4200nlfh2kPd3IrK6cjLMF-oNNQLn09aKhwIgvdxJGMiqAMXAeyrcBWvfB30Or3OQ8ZyOkODmkRHs0JsPF1rMBK8c8s0vL328lPEeqZfqMHWEMP56IOREhC72LwxpNeRrx_d3uxrD0ZF0vaSm4y_smht7y9Hpk5OimSRMtfXHQ0yAXJMVVx6IcPWI77zicCpSnlWopl0v05WMBcL_WoSEFGQOrP3TFa_j-Jnqyr9XAEg2gJ75F-UGfCHS_6yRTOReXm7iiupsIY4yDi4u-7EWDDq0M-Pin8kJ0rVNj5dowdQzoIxRtavMFDJRfTjw2cF_xlIvLH7vfvviddGmClzZ4R6nbun1M8orF3YNt3gjJ58dDs1At7ddvz7AMxFoHRzylR80zEYIkFrNzFCZFeOZnzwJJMRBv0yXCA2H90yzW98X_q0anoMrsst3StieTRzjxhTietsVhw_3ozNhiSpaf-hrzDzhVckXtzv31xqjlVfdyUJlvwecmLIRdNrykJJpctlqbtlpFRYigNjidEeydEGuDDpLs9dxGUxs-bppUaDIi0iobv-F9uxtQ-2HsLYayRDc_91yES8dCEGaU-bVy1\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 8px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit Plantuml in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n                                <div class=\"vpascode-code-wrapper\">\r\n                    <pre class=\"language-plantuml\"><code class=\"language-plantuml\" data-language=\"plantuml\" class=\"language-plantuml\">@startuml \r\n\r\ntitle \u9152\u5e97\u7ba1\u7406\u5be6\u9ad4\u95dc\u4fc2\u5716\r\n\r\nhide circle\r\nleft to right direction\r\n\r\n' \u5b9a\u7fa9\u5be6\u9ad4\u53ca\u5176\u5c6c\u6027\r\nentity \"\u5ba2\u6236\" as customer {\r\n  * customer_id : UUID &lt;&gt;\r\n  --\r\n  first_name : VARCHAR(50)\r\n  last_name : VARCHAR(50)\r\n  email : VARCHAR(100) &lt;&gt;\r\n  phone : VARCHAR(20)\r\n  address : TEXT\r\n  loyalty_points : INTEGER\r\n  total_stays : INTEGER\r\n  date_registered : TIMESTAMP\r\n  date_of_birth : DATE\r\n  nationality : VARCHAR(50)\r\n}\r\n\r\nentity \"\u623f\u9593\" as room {\r\n  * room_id : UUID &lt;&gt;\r\n  --\r\n  room_number : VARCHAR(10) &lt;&gt;\r\n  floor_number : INTEGER\r\n  room_type_id : UUID &lt;&gt;\r\n  capacity : INTEGER\r\n  base_price : DECIMAL(10,2)\r\n  is_available : BOOLEAN\r\n  has_view : BOOLEAN\r\n  square_feet : INTEGER\r\n  last_renovated : DATE\r\n}\r\n\r\nentity \"\u623f\u9593\u985e\u578b\" as roomtype {\r\n  * room_type_id : UUID &lt;&gt;\r\n  --\r\n  type_name : VARCHAR(50) &lt;&gt;\r\n  description : TEXT\r\n  standard_capacity : INTEGER\r\n  base_price : DECIMAL(10,2)\r\n  extra_bed_charge : DECIMAL(10,2)\r\n  has_kitchenette : BOOLEAN\r\n  has_balcony : BOOLEAN\r\n}\r\n\r\nentity \"\u9810\u8a02\" as reservation {\r\n  * reservation_id : UUID &lt;&gt;\r\n  --\r\n  customer_id : UUID &lt;&gt;\r\n  room_id : UUID &lt;&gt;\r\n  check_in_date : DATE\r\n  check_out_date : DATE\r\n  number_of_guests : INTEGER\r\n  total_amount : DECIMAL(10,2)\r\n  status : VARCHAR(20)\r\n  special_requests : TEXT\r\n  created_at : TIMESTAMP\r\n  updated_at : TIMESTAMP\r\n  confirmation_code : VARCHAR(20) &lt;&gt;\r\n}\r\n\r\nentity \"\u4ed8\u6b3e\" as payment {\r\n  * payment_id : UUID &lt;&gt;\r\n  --\r\n  reservation_id : UUID &lt;&gt;\r\n  amount : DECIMAL(10,2)\r\n  payment_date : TIMESTAMP\r\n  payment_method : VARCHAR(30)\r\n  transaction_id : VARCHAR(50) &lt;&gt;\r\n  status : VARCHAR(20)\r\n  receipt_url : TEXT\r\n  refund_amount : DECIMAL(10,2)\r\n}\r\n\r\nentity \"\u767c\u7968\" as invoice {\r\n  * invoice_id : UUID &lt;&gt;\r\n  --\r\n  reservation_id : UUID &lt;&gt;\r\n  invoice_number : VARCHAR(20) &lt;&gt;\r\n  issued_date : DATE\r\n  due_date : DATE\r\n  subtotal : DECIMAL(10,2)\r\n  tax : DECIMAL(10,2)\r\n  service_charge : DECIMAL(10,2)\r\n  total_amount : DECIMAL(10,2)\r\n  status : VARCHAR(20)\r\n}\r\n\r\nentity \"\u54e1\u5de5\" as staff {\r\n  * staff_id : UUID &lt;&gt;\r\n  --\r\n  first_name : VARCHAR(50)\r\n  last_name : VARCHAR(50)\r\n  email : VARCHAR(100) &lt;&gt;\r\n  phone : VARCHAR(20)\r\n  role : VARCHAR(30)\r\n  hire_date : DATE\r\n  salary : DECIMAL(10,2)\r\n  shift_schedule : VARCHAR(50)\r\n  is_active : BOOLEAN\r\n}\r\n\r\nentity \"\u5ba2\u623f\u670d\u52d9\" as roomservice {\r\n  * service_id : UUID &lt;&gt;\r\n  --\r\n  reservation_id : UUID &lt;&gt;\r\n  staff_id : UUID &lt;&gt;\r\n  service_type : VARCHAR(50)\r\n  description : TEXT\r\n  request_time : TIMESTAMP\r\n  completion_time : TIMESTAMP\r\n  status : VARCHAR(20)\r\n  price : DECIMAL(10,2)\r\n}\r\n\r\n' \u95dc\u4fc2\r\ncustomer ||--o{ reservation : \"\u5efa\u7acb\"\r\nroom ||--o{ reservation : \"\u6307\u6d3e\u7d66\"\r\nreservation ||--|| payment : \"\u64c1\u6709\"\r\nreservation ||--|| invoice : \"\u7522\u751f\"\r\nreservation ||--o{ roomservice : \"\u8acb\u6c42\"\r\nstaff ||--o{ roomservice : \"\u57f7\u884c\"\r\nroomtype ||--o{ room : \"\u5206\u985e\"\r\n\r\n@enduml<\/code><\/pre>                <\/div>\r\n                <div class=\"vpascode-actions\">\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#plantuml:nPRlQnn56CVV7zp_iEIDLWp4Y6-AIC_cq43JIhoAxuQvtMUpGtTtjZEpPu-ce87MQ2eM4reheJM5rafAfA0jj9ByCzszt7_XpEoFxDxE2kQDRuxR-Nxdr-TvdfavnmLc8WvygzlfTWGHFbZJcpybh-vD3lOcTsubVpoPxkzCx-s-ETf8TkygaqSSi6p2R1-w7HzSOGbgCRBc2SiX36n1QAXyRrd9mI-Jmz-p8P8VlqzklaYUFqk__gtRWL1EDRRcaeD7wUQBEGjpouwve04mwtgtOrdlbD-8EDPPw_BbvINhmu-KD3-lVbt2k40X3a2gN_HMpt_QMttxWuKpIlDngmG19dwb-Rs5XJFvk957msgFnQm7TXm6d4jXqFzoe8UdO-oBCOee2OKIbYyE-f_qLvKcgC0-ab37CuA31I06QuGBOA2sD5XUwNy-wAryLihKHKF2X2V5fTwWhzf3h71YNz6QsSmD1Ra0cMuUJUzkQv2Cqg20gFwt0DHI60T3YRpAey3X-fIo4qDbAxgd64VG6Dd64RQpfLRyGym1HOpOYkvI__poIk-2dEZTHSsNS8H7CYXuw2lzuqkNBlHx5vNYOOv61Bwgj_AhCMQ0N01HdqP7dK58HvAbKp8qO9hkFKWUR9Mmr5Pgm8nxowXfgPbQkSS1RZCIgP1LyaLcG-XWvg3Ju85hWc4q1DdRmspDw56WhX1XUn2240QAG-pRD1nNXHgMwQztZfzkP4200nlfh2kPd3IrK6cjLMF-oNNQLn09aKhwIgvdxJGMiqAMXAeyrcBWvfB30Or3OQ8ZyOkODmkRHs0JsPF1rMBK8c8s0vL328lPEeqZfqMHWEMP56IOREhC72LwxpNeRrx_d3uxrD0ZF0vaSm4y_smht7y9Hpk5OimSRMtfXHQ0yAXJMVVx6IcPWI77zicCpSnlWopl0v05WMBcL_WoSEFGQOrP3TFa_j-Jnqyr9XAEg2gJ75F-UGfCHS_6yRTOReXm7iiupsIY4yDi4u-7EWDDq0M-Pin8kJ0rVNj5dowdQzoIxRtavMFDJRfTjw2cF_xlIvLH7vfvviddGmClzZ4R6nbun1M8orF3YNt3gjJ58dDs1At7ddvz7AMxFoHRzylR80zEYIkFrNzFCZFeOZnzwJJMRBv0yXCA2H90yzW98X_q0anoMrsst3StieTRzjxhTietsVhw_3ozNhiSpaf-hrzDzhVckXtzv31xqjlVfdyUJlvwecmLIRdNrykJJpctlqbtlpFRYigNjidEeydEGuDDpLs9dxGUxs-bppUaDIi0iobv-F9uxtQ-2HsLYayRDc_91yES8dCEGaU-bVy1\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 6px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit Plantuml in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n            <\/div>\r\n            \n<\/p><\/div>\n<div class=\"vpascode-actions\">\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#plantuml:nPRVRzis4CVV3VX_8FAojLY0BCDUWcAe5nkhWQOj77VO6t6MJXOHYbJ9arklwV--8sKfaYKLQ5xs8eZy7dzzxex7rvx0KLLeCP_DPwH8etXZ2RMu0mDxBD2GM6sMGSrLYY9HBj4udsdCI90LJkrp4gboc92o9jZz99QOAOE2nofIwCLdHRa08gTs5Q6Vpw9o51UtbITReBiGu4LoQeYlyvaGBzksLAcu4Hy_hfVYrHz1khmCtqmvJz90WQp-lTZSlbbiVlxzwaNGD4nAM83IdUvVhwvUdEOjSskw8wxh4P2c3hrdORlwPnkdjqVGT9IbLOQ2i7wtNVsrsWIDB86MZFLu9gH0A1tkbITq68wqNT-jxhUBkm-jR3EvKuvXtOZbOhiA_GO2Lz21rzbXlWNQ3SgDjKN4wFYdGHZ-9_15oLJ5Ze5tQJGmCcsjUpBe72IEf6E9WvaJA26fDzgntu57MJgL1BRBrUtwRl6M5_hbEj9LNiA1NG8x7VG_txz_krgy2qeENXuKVkxt-ayLE9GP8lMNYJvtQEo1IQOjmG6aBU-y1HMEqOCrUgwQM9I6GNMoIT4dJfN1MPr8uJWmARXKFWSDVY47SeSyEWUt7xK9a1uK9JaQ91eXk0ETM7Fi2dqawD4TOf3LL9xQBPYdhWaqawaw6e2ysUH1AYD3p7T2lUwt5PqBTHI6xDXNwCSp3WfR6Hf3n3wWoW_psfUOA1xfy5CpQ-Esn6488WbqdgPLcKueJ9clfAB6bDZqx2Q9P--H_m37SBr6wcNztn0_DQTIzpl-cCRGp7bYszjxenL8kKqx6_-jHiLnQ3maJoiEut-ACXS6vBIGbTCTm0wpogIJJkjnMfk3vGo9d5Jztt0wDP_1gHavk06lsnCfxolsz5aifXMUT_bg5sDmZ3h1bz6Ov8s5vQSJ-tbHtGDtJv1b4PiFVmsqsFY_Ywgp6eTnblCxOa0NDBZZA89SPIGzNnjffKTs5KeBn-m1foy_lfxkQrUq9U7acfRMoLC_7cBZd9lvOkKPR7cyYfnkA4cgmE6rKvGQumR6vAcqd2Wwt-e7t0PrF1CJBlcvrhxC7XylB-tNNesu4HS5FA2_cC_YosFS1BnNUyDbcMmmx8Z1_l6nlG3PbglMk4sJ_6opvtBdE4x6BCFg7J-oTNF3it6T2UDcMQKpfNLpbEYXZcKmINZDlNNgtxZoVFOQJSglv_y0\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 6px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>\u5728 VPasCode \u4e2d\u7de8\u8f2f Plantuml<\/span><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p id=\"ANJCSUi\"><img alt=\"Editing a ERD in Visual Paradigm VPasCode\" class=\"alignnone wp-image-2662 size-full\" decoding=\"async\" height=\"856\" sizes=\"(max-width: 1311px) 100vw, 1311px\" src=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83ff8445766.png\" srcset=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83ff8445766.png 1311w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83ff8445766-300x196.png 300w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83ff8445766-1024x669.png 1024w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a83ff8445766-768x501.png 768w\" width=\"1311\"\/><\/p>\n<hr\/>\n<section class=\"post-section\"><span style=\"font-size: 1.7em; font-weight: bold;\">\u900f\u904e VPasCode \u8b93\u60a8\u7684\u8cc7\u6599\u5eab\u8a2d\u8a08\u6829\u6829\u5982\u751f<\/span><\/section>\n<p>\u5efa\u7acb\u8907\u96dc\u7684\u8cc7\u6599\u5eab\u6a21\u578b\u4e0d\u4e00\u5b9a\u8981\u8207\u7b28\u62d9\u7684\u62d6\u653e\u5f0f\u4f7f\u7528\u8005\u4ecb\u9762\u640f\u9b25\u3002\u900f\u904e\u63a1\u7528\u5716\u5f62\u5373\u7a0b\u5f0f\u78bc\u7684\u65b9\u6cd5\uff0c\u60a8\u7684\u67b6\u69cb\u5c07\u4fdd\u6301\u7248\u672c\u63a7\u5236\u3001\u4e7e\u6de8\u4e14\u8f15\u9b06\u7dad\u8b77\u3002<\/p>\n<p>\u6e96\u5099\u597d\u5617\u8a66\u5efa\u7acb\u81ea\u5df1\u7684\u7cfb\u7d71\u67b6\u69cb\u4e86\u55ce\uff1f\u7acb\u5373\u524d\u5f80 <a href=\"https:\/\/www.vpascode.com\/editor\/\">VPasCode<\/a> \u4f86\u9ad4\u9a57\u5373\u6642\u6e32\u67d3\u3001\u81ea\u52d5\u683c\u5f0f\u5075\u6e2c\uff0c\u4ee5\u53ca\u70ba\u60a8\u7684\u6280\u8853\u6587\u4ef6\u8f15\u9b06\u532f\u51fa\u7684\u529f\u80fd\u5427\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u8a2d\u8a08\u8907\u96dc\u9818\u57df\uff08\u5982\u9152\u5e97\u696d\uff09\u7684\u7a69\u5065\u8cc7\u6599\u5eab\u67b6\u69cb\u6642\uff0c\u6e05\u6670\u5730\u53ef\u8996\u5316\u95dc\u4fc2\u81f3\u95dc\u91cd\u8981\u3002\u7121\u8ad6\u60a8\u662f&#8230;<\/p>\n","protected":false},"author":4,"featured_media":2311,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[19],"tags":[],"class_list":["post-2310","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials-guides"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Build a Hotel Management ERD Using PlantUML &amp; VPasCode<\/title>\n<meta name=\"description\" content=\"Learn how to create a comprehensive Hotel Management Entity Relationship Diagram (ERD) from scratch using PlantUML and the free VPasCode editor.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build a Hotel Management ERD Using PlantUML &amp; VPasCode\" \/>\n<meta property=\"og:description\" content=\"Learn how to create a comprehensive Hotel Management Entity Relationship Diagram (ERD) from scratch using PlantUML and the free VPasCode editor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/\" \/>\n<meta property=\"og:site_name\" content=\"VPasCode\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-18T07:03:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vpascode.com\/tw\/wp-content\/uploads\/sites\/2\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1376\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"jick\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005:\" \/>\n\t<meta name=\"twitter:data1\" content=\"\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9810\u4f30\u95b1\u8b80\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\u9418\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\"},\"author\":{\"name\":\"jick\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/#\\\/schema\\\/person\\\/cd8aa8455bd8bc6827b3efdfa79ad3a6\"},\"headline\":\"\u4f7f\u7528 PlantUML \u548c VPasCode \u5efa\u7acb\u9152\u5e97\u7ba1\u7406 ERD\",\"datePublished\":\"2026-08-18T07:03:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\"},\"wordCount\":20,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/08\\\/build-professional-database-diagrams-thumbnail.jpg\",\"articleSection\":[\"Tutorials &amp; Guides\"],\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\",\"name\":\"Build a Hotel Management ERD Using PlantUML & VPasCode\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/08\\\/build-professional-database-diagrams-thumbnail.jpg\",\"datePublished\":\"2026-08-18T07:03:18+00:00\",\"description\":\"Learn how to create a comprehensive Hotel Management Entity Relationship Diagram (ERD) from scratch using PlantUML and the free VPasCode editor.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/08\\\/build-professional-database-diagrams-thumbnail.jpg\",\"contentUrl\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/08\\\/build-professional-database-diagrams-thumbnail.jpg\",\"width\":1376,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528 PlantUML \u548c VPasCode \u5efa\u7acb\u9152\u5e97\u7ba1\u7406 ERD\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/#website\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/\",\"name\":\"VPasCode\",\"description\":\"by Visual Paradigm\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-TW\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/#organization\",\"name\":\"VPasCode\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/06\\\/cropped-vp-online-logo-v1.png\",\"contentUrl\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/06\\\/cropped-vp-online-logo-v1.png\",\"width\":128,\"height\":138,\"caption\":\"VPasCode\"},\"image\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/#\\\/schema\\\/person\\\/cd8aa8455bd8bc6827b3efdfa79ad3a6\",\"name\":\"jick\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0c89451a99649a6ebefa14a9167db0960c327e8c33ea79fdb68fc38aa18d768a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0c89451a99649a6ebefa14a9167db0960c327e8c33ea79fdb68fc38aa18d768a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0c89451a99649a6ebefa14a9167db0960c327e8c33ea79fdb68fc38aa18d768a?s=96&d=mm&r=g\",\"caption\":\"jick\"},\"url\":\"https:\\\/\\\/www.vpascode.com\\\/tw\\\/author\\\/jick\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Build a Hotel Management ERD Using PlantUML & VPasCode","description":"Learn how to create a comprehensive Hotel Management Entity Relationship Diagram (ERD) from scratch using PlantUML and the free VPasCode editor.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/","og_locale":"zh_TW","og_type":"article","og_title":"Build a Hotel Management ERD Using PlantUML & VPasCode","og_description":"Learn how to create a comprehensive Hotel Management Entity Relationship Diagram (ERD) from scratch using PlantUML and the free VPasCode editor.","og_url":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/","og_site_name":"VPasCode","article_published_time":"2026-08-18T07:03:18+00:00","og_image":[{"width":1376,"height":768,"url":"https:\/\/www.vpascode.com\/tw\/wp-content\/uploads\/sites\/2\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg","type":"image\/jpeg"}],"author":"jick","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005:":false,"\u9810\u4f30\u95b1\u8b80\u6642\u9593":"3 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#article","isPartOf":{"@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/"},"author":{"name":"jick","@id":"https:\/\/www.vpascode.com\/tw\/#\/schema\/person\/cd8aa8455bd8bc6827b3efdfa79ad3a6"},"headline":"\u4f7f\u7528 PlantUML \u548c VPasCode \u5efa\u7acb\u9152\u5e97\u7ba1\u7406 ERD","datePublished":"2026-08-18T07:03:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/"},"wordCount":20,"commentCount":0,"publisher":{"@id":"https:\/\/www.vpascode.com\/tw\/#organization"},"image":{"@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vpascode.com\/tw\/wp-content\/uploads\/sites\/2\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg","articleSection":["Tutorials &amp; Guides"],"inLanguage":"zh-TW","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/","url":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/","name":"Build a Hotel Management ERD Using PlantUML & VPasCode","isPartOf":{"@id":"https:\/\/www.vpascode.com\/tw\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#primaryimage"},"image":{"@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vpascode.com\/tw\/wp-content\/uploads\/sites\/2\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg","datePublished":"2026-08-18T07:03:18+00:00","description":"Learn how to create a comprehensive Hotel Management Entity Relationship Diagram (ERD) from scratch using PlantUML and the free VPasCode editor.","breadcrumb":{"@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/"]}]},{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#primaryimage","url":"https:\/\/www.vpascode.com\/tw\/wp-content\/uploads\/sites\/2\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg","contentUrl":"https:\/\/www.vpascode.com\/tw\/wp-content\/uploads\/sites\/2\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg","width":1376,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/www.vpascode.com\/tw\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vpascode.com\/tw\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528 PlantUML \u548c VPasCode \u5efa\u7acb\u9152\u5e97\u7ba1\u7406 ERD"}]},{"@type":"WebSite","@id":"https:\/\/www.vpascode.com\/tw\/#website","url":"https:\/\/www.vpascode.com\/tw\/","name":"VPasCode","description":"by Visual Paradigm","publisher":{"@id":"https:\/\/www.vpascode.com\/tw\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vpascode.com\/tw\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-TW"},{"@type":"Organization","@id":"https:\/\/www.vpascode.com\/tw\/#organization","name":"VPasCode","url":"https:\/\/www.vpascode.com\/tw\/","logo":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/www.vpascode.com\/tw\/#\/schema\/logo\/image\/","url":"https:\/\/www.vpascode.com\/tw\/wp-content\/uploads\/sites\/2\/2026\/06\/cropped-vp-online-logo-v1.png","contentUrl":"https:\/\/www.vpascode.com\/tw\/wp-content\/uploads\/sites\/2\/2026\/06\/cropped-vp-online-logo-v1.png","width":128,"height":138,"caption":"VPasCode"},"image":{"@id":"https:\/\/www.vpascode.com\/tw\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.vpascode.com\/tw\/#\/schema\/person\/cd8aa8455bd8bc6827b3efdfa79ad3a6","name":"jick","image":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/secure.gravatar.com\/avatar\/0c89451a99649a6ebefa14a9167db0960c327e8c33ea79fdb68fc38aa18d768a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0c89451a99649a6ebefa14a9167db0960c327e8c33ea79fdb68fc38aa18d768a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c89451a99649a6ebefa14a9167db0960c327e8c33ea79fdb68fc38aa18d768a?s=96&d=mm&r=g","caption":"jick"},"url":"https:\/\/www.vpascode.com\/tw\/author\/jick\/"}]}},"_links":{"self":[{"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/posts\/2310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/comments?post=2310"}],"version-history":[{"count":0,"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/posts\/2310\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/media\/2311"}],"wp:attachment":[{"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/media?parent=2310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/categories?post=2310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vpascode.com\/tw\/wp-json\/wp\/v2\/tags?post=2310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}