{"id":2139,"date":"2026-08-18T07:03:18","date_gmt":"2026-08-18T07:03:18","guid":{"rendered":"https:\/\/www.vpascode.com\/cn\/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\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/","title":{"rendered":"\u4f7f\u7528PlantUML\u548cVPasCode\u6784\u5efa\u9152\u5e97\u7ba1\u7406ERD"},"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\u4e3a\u9152\u5e97\u4e1a\u7b49\u590d\u6742\u9886\u57df\u8bbe\u8ba1\u7a33\u5065\u7684\u6570\u636e\u5e93\u67b6\u6784\u65f6\uff0c\u6e05\u6670\u5730\u53ef\u89c6\u5316\u5173\u7cfb\u81f3\u5173\u91cd\u8981\u3002\u65e0\u8bba\u4f60\u662f\u7ed8\u5236\u5ba2\u6237\u6863\u6848\u3001\u8ddf\u8e2a\u5ba2\u623f\u5e93\u5b58\uff0c\u8fd8\u662f\u7ba1\u7406\u8d26\u5355\uff0c\u4e00\u4e2a\u7ed3\u6784\u826f\u597d\u7684\u5b9e\u4f53\u5173\u7cfb\u56fe\uff08ERD\uff09\u90fd\u80fd\u5728\u5f00\u53d1\u8fc7\u7a0b\u4e2d\u8282\u7701\u65e0\u6570\u5c0f\u65f6\u3002\u5728\u8fd9\u5802\u5927\u5e08\u8bfe\u4e2d\uff0c\u6211\u5c06\u5e26\u4f60\u4e00\u6b65\u6b65\u4e86\u89e3\u6211\u5982\u4f55\u4f7f\u7528PlantUML\u5728\u201c\u201d\u4e2d\u4ece\u96f6\u5f00\u59cb\u6784\u5efa\u4e00\u4e2a\u5168\u9762\u7684\u9152\u5e97\u7ba1\u7406ERD\u3002<a href=\"https:\/\/www.vpascode.com\/editor\/\">\u514d\u8d39\u7684PlantUML\u7f16\u8f91\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\u5316PlantUML\u73af\u5883<\/h2>\n<p>\u6211\u9996\u5148\u8bbe\u7f6e\u811a\u672c\u7684\u57fa\u7840\u7ed3\u6784\u3002\u5728\u5904\u7406\u5305\u542b\u5927\u91cf\u5c5e\u6027\u7684\u590d\u6742\u6a21\u5f0f\u65f6\uff0c\u5e03\u5c40\u7684\u53ef\u8bfb\u6027\u81f3\u5173\u91cd\u8981\u3002\u6211\u914d\u7f6ePlantUML\u4ee5\u9690\u85cf\u4e0d\u5fc5\u8981\u7684\u6742\u4e71\u4fe1\u606f\uff0c\u5e76\u4f18\u5316\u56fe\u8868\u7684\u5e03\u5c40\u65b9\u5411\uff1a<\/p>\n<pre><code class=\"language-plantuml\">\r\n@startuml \r\ntitle \u9152\u5e97\u7ba1\u7406ERD\r\n\r\nhide circle\r\nleft to right direction\r\n    <\/code><\/pre>\n<p><strong>\u4e3a\u4ec0\u4e48\u91c7\u7528\u8fd9\u79cd\u65b9\u6cd5\uff1f<\/strong>\u9690\u85cf\u9ed8\u8ba4\u7684\u5c5e\u6027\u5706\u5708\u53ef\u4ee5\u4f7f\u5b9e\u4f53\u6846\u4fdd\u6301\u7b80\u6d01\u73b0\u4ee3\u3002\u5c06\u65b9\u5411\u8bbe\u7f6e\u4e3a<code>\u4ece\u5de6\u5230\u53f3\u65b9\u5411<\/code>\u6709\u52a9\u4e8e\u9632\u6b62\u5bbd\u5e45ERD\u53d8\u5f97\u5728\u5782\u76f4\u65b9\u5411\u4e0a\u96be\u4ee5\u7ba1\u7406\uff0c\u4f7f\u591a\u8868\u5173\u7cfb\u5f97\u4ee5\u903b\u8f91\u6027\u5730\u5c55\u5f00\u3002<\/p>\n<h2>2. \u5b9a\u4e49\u6838\u5fc3\u5b9e\u4f53\u548c\u5c5e\u6027<\/h2>\n<p>\u63a5\u4e0b\u6765\uff0c\u6211\u9700\u8981\u5b9a\u4e49\u4ee3\u8868\u6211\u4eec\u4e1a\u52a1\u9886\u57df\u7684\u6838\u5fc3\u5b9e\u4f53\u3002\u6211\u4e3a\u6bcf\u4e2a\u5b9e\u4f53\u7ed3\u6784\u5316\u5176\u4e3b\u952e\u3001\u552f\u4e00\u6027\u7ea6\u675f\u548c\u7c7b\u578b\u5316\u5c5e\u6027\u3002\u8ba9\u6211\u4eec\u770b\u770b\u6211\u662f\u5982\u4f55\u8bbe\u7f6e\u6838\u5fc3<code>Customer<\/code>\u548c<code>RoomType<\/code>\u5b9e\u4f53\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>\u901a\u8fc7\u5b9a\u4e49\u8bf8\u5982<code>&lt;&lt;PK&gt;&gt;<\/code>\u548c<code>&lt;&lt;UK&gt;&gt;<\/code>\u4e4b\u7c7b\u7684\u663e\u5f0f\u6807\u8bb0\uff0c\u4efb\u4f55\u5ba1\u67e5\u4ee3\u7801\u7684\u4eba\u90fd\u80fd\u5728\u6570\u636e\u5e93\u8fc1\u79fb\u811a\u672c\u7f16\u5199\u4e4b\u524d\u7acb\u5373\u7406\u89e3\u7d22\u5f15\u548c\u552f\u4e00\u6027\u89c4\u5219\u3002<\/p>\n<h2>3. \u6620\u5c04\u64cd\u4f5c\u6027\u5b9e\u4f53\uff08\u5ba2\u623f\u3001\u9884\u8ba2\u548c\u5458\u5de5\uff09<\/h2>\n<p>\u5728\u53c2\u8003\u6570\u636e\u5c31\u4f4d\u540e\uff0c\u6211\u8f6c\u5411\u9152\u5e97\u7ba1\u7406\u7cfb\u7edf\u7684\u4e8b\u52a1\u6838\u5fc3\uff1a\u5ba2\u623f\u3001\u9884\u8ba2\u548c\u5458\u5de5\u5de5\u4f5c\u6d41\u7a0b\u3002\u6bcf\u4e2a\u5b9e\u4f53\u90fd\u4f7f\u7528\u5916\u952e\u4e0e\u6211\u4eec\u7684\u57fa\u7840\u8868\u5173\u8054\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\u8d22\u52a1\u548c\u670d\u52a1\u5173\u7cfb<\/h2>\n<p>\u4e3a\u4e86\u5b8c\u5584\u6574\u4e2a\u67b6\u6784\uff0c\u6211\u7ed8\u5236\u4e86\u8d26\u5355\u8bb0\u5f55\uff08\u4ed8\u6b3e\u548c\u53d1\u7968\uff09\u4ee5\u53ca\u7531\u9152\u5e97\u5458\u5de5\u5904\u7406\u7684\u8f85\u52a9\u670d\u52a1\uff08\u5982\u5ba2\u623f\u670d\u52a1\uff09\u3002\u4e3a\u4e86\u5c06\u6240\u6709\u5185\u5bb9\u8fde\u63a5\u8d77\u6765\uff0c\u6211\u4f7f\u7528\u6807\u51c6\u7684PlantUML\u7b26\u53f7\u663e\u5f0f\u5b9a\u4e49\u4e86\u57fa\u6570\u5173\u7cfb\uff1a<\/p>\n<pre><code class=\"language-plantuml\">\r\n' \u5173\u7cfb\r\ncustomer ||--o{ reservation : \"\u521b\u5efa\"\r\nroom ||--o{ reservation : \"\u5206\u914d\u7ed9\"\r\nreservation ||--|| payment : \"\u62e5\u6709\"\r\nreservation ||--|| invoice : \"\u751f\u6210\"\r\nreservation ||--o{ roomservice : \"\u8bf7\u6c42\"\r\nstaff ||--o{ roomservice : \"\u5b8c\u6210\"\r\nroomtype ||--o{ room : \"\u5206\u7c7b\"\r\n\r\n@enduml\r\n    <\/code><\/pre>\n<p><strong>\u8bbe\u8ba1\u9009\u62e9\uff1a<\/strong> \u4f7f\u7528\u7cbe\u786e\u7684\u4e4c\u9e26\u8db3\u7b26\u53f7\uff08\u4f8b\u5982<code>||--o{<\/code> \u8868\u793a\u5f3a\u5236\u5230\u53ef\u9009\u7684\u4e00\u5bf9\u591a\u5173\u7cfb\uff09\u53ef\u4ee5\u786e\u4fdd\u4e1a\u52a1\u903b\u8f91\u89c4\u5219\u2014\u2014\u4f8b\u5982\u9884\u8ba2\u5fc5\u987b\u5173\u8054\u5ba2\u6237\uff0c\u4f46\u5ba2\u6237\u53ef\u80fd\u62e5\u6709\u591a\u4e2a\u6216\u96f6\u4e2a\u6d3b\u8dc3\u9884\u8ba2\u2014\u2014\u88ab\u51c6\u786e\u5efa\u6a21\u3002<\/p>\n<section class=\"post-section\">\u00a0<\/section>\n<hr\/>\n<h2>\u5b8c\u6574\u7684 PlantUML \u811a\u672c<\/h2>\n<p>\u4ee5\u4e0b\u662f\u6211\u4eec\u7684\u9152\u5e97\u7ba1\u7406 ERD \u7684\u5b8c\u6574\u7ec4\u88c5\u6e90\u4ee3\u7801\u3002\u60a8\u53ef\u4ee5\u76f4\u63a5\u5c06\u6b64\u4ee3\u7801\u590d\u5236\u5e76\u7c98\u8d34\u5230\u60a8\u6700\u559c\u6b22\u7684<strong>\u514d\u8d39 PlantUML \u7f16\u8f91\u5668<\/strong> \u4e2d\u8fdb\u884c\u7f16\u8f91\u6216\u6e32\u67d3\u77e2\u91cf\u56fe\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\u7f16\u8f91 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:nPPTQnmt58Rl5_O_3BvfKsfmNNeJIiasNbf3d1HtKtedjACp7X7DQ29fjbdYG2brS9A696qWQHjSOZ3jrGQJKjCi9N_6inl_YqgQ3y_ip1JYczuiEtgFlfxp7aaNfC92nG5pkfrkHr75m3dP-J5vzMG-UJv_UDlfRwuPnQS479SAbq6tmy1JZkAEe5k-SWWLu2hAGnFtZfDCVZd--quosJl-vwVamTravw_aS6_sxU_T3eHw_B6pb4psPxj7ImwMZXjBnGCGpirknt7UAxuH9Svvv-hLzJNduq-CjBniVZqgf48X3a2hN_KsBtxUstptevLpHcEuLO80KrPg_c1bvLmsRkJpiDnZDUs12H4WfHO6_Qy7TdW-naoDKSHfg8omVddG_wo_QJJ55MP8anml20GhG0Asg5GWm6nfiBxH_tBGs_YYaBc7XbGeNujhlK7Vj8VOuCJCq5hOp2q3EGSvstrzykHF2r9m7kGGpVyMW5OAus2eaPTvv3Wynhau3IXjnVPKumXg8xiumcwwr5By44j0aQ2keRlMlxY-qRka9tf_rVAb4k6HJWeUCgD_UkNAfNxlib5yBD68mZVLLdaznWAG1w2gqzYi2mZvIBCa1SD5JCdUlGAJsKG5LUEkKbvMgfigYo4WNK4ZawoIKxGFGe85GMS10pUKm6W8khUFnLPZZ45qZIhNXn2KQk0tnCpbuRWiL82Sx7__PhAV0W49OcJzLZ0vRMgXqbgbZSxJwtIl8HeYO_UIozDs7gj58RMVAOoj66HpiU60nw5gegFngrZMIrf6u5BTKy3rVDGyOwu0unw4rMA5nX5fKJHWVHe5AIQNauL3nEwzwiB7BuwdJotq28y3tPm3ppxRIlO_qj5E8HypGrjPUgu5e7nEIkl-C2Mb7HXAx9xEM7T-6sHz4u0k21GBLk8hm8j3qfgp2gRamQFvmHyM4mr7t9H9XYdxF0Ecl6Vju5ijDaIbZ7MU5vn8ObXial7GEh09ki8t6Xsf5sQcRw_eitcwoktHq-Jem7BJqPwNKxCV__TrAZY3kizy_N2euSKCYt4Z0vzw2abzQf2ODQpAN2dQioDeFVRik-FrxDdzvExpuZR8abFWodBrzYPh1fsFPo-TsfgRBv3iX4AA1b0_TeA8WLr0aznMbottpQtioRRpSlvoskqKhx7jxULbVhDoEPpN_7P_JQQlbheT-zXeYxbzidD_FltPX9Ka4xszNPnyEd9sxs3sx4vpM5xvEcp--BVPxiE6C3DtANywzCsBezdXTpeqBO3ce6JoGpPU_XGenMKxc1zEbmoP2n0I_JJ-5m00\" \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 ERD\r\n\r\nhide circle\r\nleft to right direction\r\n\r\n' \u5b9a\u4e49\u5b9e\u4f53\u53ca\u5176\u5c5e\u6027\r\nentity \"\u5ba2\u6237\" 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\u95f4\" 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\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 \"\u9884\u8ba2\" 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 \"\u652f\u4ed8\" 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 \"\u53d1\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 \"\u5458\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\u52a1\" 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' \u5173\u7cfb\r\ncustomer ||--o{ reservation : \"\u521b\u5efa\"\r\nroom ||--o{ reservation : \"\u5206\u914d\u7ed9\"\r\nreservation ||--|| payment : \"\u62e5\u6709\"\r\nreservation ||--|| invoice : \"\u751f\u6210\"\r\nreservation ||--o{ roomservice : \"\u8bf7\u6c42\"\r\nstaff ||--o{ roomservice : \"\u5b8c\u6210\"\r\nroomtype ||--o{ room : \"\u5206\u7c7b\"\r\n\r\n@enduml<\/code><\/pre>                <\/div>\r\n                <div class=\"vpascode-actions\">\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#plantuml:nPPTQnmt58Rl5_O_3BvfKsfmNNeJIiasNbf3d1HtKtedjACp7X7DQ29fjbdYG2brS9A696qWQHjSOZ3jrGQJKjCi9N_6inl_YqgQ3y_ip1JYczuiEtgFlfxp7aaNfC92nG5pkfrkHr75m3dP-J5vzMG-UJv_UDlfRwuPnQS479SAbq6tmy1JZkAEe5k-SWWLu2hAGnFtZfDCVZd--quosJl-vwVamTravw_aS6_sxU_T3eHw_B6pb4psPxj7ImwMZXjBnGCGpirknt7UAxuH9Svvv-hLzJNduq-CjBniVZqgf48X3a2hN_KsBtxUstptevLpHcEuLO80KrPg_c1bvLmsRkJpiDnZDUs12H4WfHO6_Qy7TdW-naoDKSHfg8omVddG_wo_QJJ55MP8anml20GhG0Asg5GWm6nfiBxH_tBGs_YYaBc7XbGeNujhlK7Vj8VOuCJCq5hOp2q3EGSvstrzykHF2r9m7kGGpVyMW5OAus2eaPTvv3Wynhau3IXjnVPKumXg8xiumcwwr5By44j0aQ2keRlMlxY-qRka9tf_rVAb4k6HJWeUCgD_UkNAfNxlib5yBD68mZVLLdaznWAG1w2gqzYi2mZvIBCa1SD5JCdUlGAJsKG5LUEkKbvMgfigYo4WNK4ZawoIKxGFGe85GMS10pUKm6W8khUFnLPZZ45qZIhNXn2KQk0tnCpbuRWiL82Sx7__PhAV0W49OcJzLZ0vRMgXqbgbZSxJwtIl8HeYO_UIozDs7gj58RMVAOoj66HpiU60nw5gegFngrZMIrf6u5BTKy3rVDGyOwu0unw4rMA5nX5fKJHWVHe5AIQNauL3nEwzwiB7BuwdJotq28y3tPm3ppxRIlO_qj5E8HypGrjPUgu5e7nEIkl-C2Mb7HXAx9xEM7T-6sHz4u0k21GBLk8hm8j3qfgp2gRamQFvmHyM4mr7t9H9XYdxF0Ecl6Vju5ijDaIbZ7MU5vn8ObXial7GEh09ki8t6Xsf5sQcRw_eitcwoktHq-Jem7BJqPwNKxCV__TrAZY3kizy_N2euSKCYt4Z0vzw2abzQf2ODQpAN2dQioDeFVRik-FrxDdzvExpuZR8abFWodBrzYPh1fsFPo-TsfgRBv3iX4AA1b0_TeA8WLr0aznMbottpQtioRRpSlvoskqKhx7jxULbVhDoEPpN_7P_JQQlbheT-zXeYxbzidD_FltPX9Ka4xszNPnyEd9sxs3sx4vpM5xvEcp--BVPxiE6C3DtANywzCsBezdXTpeqBO3ce6JoGpPU_XGenMKxc1zEbmoP2n0I_JJ-5m00\" \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\u7f16\u8f91 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;\">\u4f7f\u7528 VPasCode \u8ba9\u60a8\u7684\u6570\u636e\u5e93\u8bbe\u8ba1\u6829\u6829\u5982\u751f<\/span><\/section>\n<p>\u6784\u5efa\u590d\u6742\u7684\u6570\u636e\u5e93\u6a21\u578b\u5e76\u4e0d\u610f\u5473\u7740\u8981\u4e0e\u7b28\u62d9\u7684\u62d6\u653e\u7528\u6237\u754c\u9762\u640f\u6597\u3002\u901a\u8fc7\u91c7\u7528\u56fe\u8868\u5373\u4ee3\u7801\u7684\u65b9\u6cd5\uff0c\u60a8\u7684\u67b6\u6784\u5c06\u4fdd\u6301\u7248\u672c\u63a7\u5236\u3001\u6574\u6d01\u4e14\u6613\u4e8e\u7ef4\u62a4\u3002<\/p>\n<p>\u51c6\u5907\u597d\u5c1d\u8bd5\u6784\u5efa\u60a8\u81ea\u5df1\u7684\u7cfb\u7edf\u67b6\u6784\u4e86\u5417\uff1f\u524d\u5f80<a href=\"https:\/\/www.vpascode.com\/editor\/\">VPasCode<\/a>\uff0c\u4f53\u9a8c\u5b9e\u65f6\u6e32\u67d3\u3001\u81ea\u52a8\u683c\u5f0f\u68c0\u6d4b\u4ee5\u53ca\u65e0\u7f1d\u5bfc\u51fa\u6280\u672f\u6587\u6863\u7684\u529f\u80fd\uff0c\u4ece\u4eca\u5929\u5f00\u59cb\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u4e3a\u9152\u5e97\u4e1a\u7b49\u590d\u6742\u9886\u57df\u8bbe\u8ba1\u7a33\u5065\u7684\u6570\u636e\u5e93\u67b6\u6784\u65f6\uff0c\u6e05\u6670\u5730\u53ef\u89c6\u5316\u5173\u7cfb\u81f3\u5173\u91cd\u8981\u3002\u65e0\u8bba\u4f60\u662f\u7ed8&#8230;<\/p>\n","protected":false},"author":4,"featured_media":2140,"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-2139","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\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\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\/cn\/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\/cn\/wp-content\/uploads\/sites\/3\/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=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\"},\"author\":{\"name\":\"jick\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/#\\\/schema\\\/person\\\/cd8aa8455bd8bc6827b3efdfa79ad3a6\"},\"headline\":\"\u4f7f\u7528PlantUML\u548cVPasCode\u6784\u5efa\u9152\u5e97\u7ba1\u7406ERD\",\"datePublished\":\"2026-08-18T07:03:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\"},\"wordCount\":22,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2026\\\/08\\\/build-professional-database-diagrams-thumbnail.jpg\",\"articleSection\":[\"Tutorials &amp; Guides\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\",\"name\":\"Build a Hotel Management ERD Using PlantUML & VPasCode\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/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\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2026\\\/08\\\/build-professional-database-diagrams-thumbnail.jpg\",\"contentUrl\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2026\\\/08\\\/build-professional-database-diagrams-thumbnail.jpg\",\"width\":1376,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/building-a-hotel-management-erd-with-plantuml-and-vpascode\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528PlantUML\u548cVPasCode\u6784\u5efa\u9152\u5e97\u7ba1\u7406ERD\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/#website\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/\",\"name\":\"VPasCode\",\"description\":\"by Visual Paradigm\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/#organization\",\"name\":\"VPasCode\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2026\\\/06\\\/cropped-vp-online-logo-v1.png\",\"contentUrl\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2026\\\/06\\\/cropped-vp-online-logo-v1.png\",\"width\":128,\"height\":138,\"caption\":\"VPasCode\"},\"image\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/cn\\\/#\\\/schema\\\/person\\\/cd8aa8455bd8bc6827b3efdfa79ad3a6\",\"name\":\"jick\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@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\\\/cn\\\/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\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/","og_locale":"zh_CN","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\/cn\/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\/cn\/wp-content\/uploads\/sites\/3\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg","type":"image\/jpeg"}],"author":"jick","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":false,"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#article","isPartOf":{"@id":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/"},"author":{"name":"jick","@id":"https:\/\/www.vpascode.com\/cn\/#\/schema\/person\/cd8aa8455bd8bc6827b3efdfa79ad3a6"},"headline":"\u4f7f\u7528PlantUML\u548cVPasCode\u6784\u5efa\u9152\u5e97\u7ba1\u7406ERD","datePublished":"2026-08-18T07:03:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/"},"wordCount":22,"commentCount":0,"publisher":{"@id":"https:\/\/www.vpascode.com\/cn\/#organization"},"image":{"@id":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vpascode.com\/cn\/wp-content\/uploads\/sites\/3\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg","articleSection":["Tutorials &amp; Guides"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/","url":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/","name":"Build a Hotel Management ERD Using PlantUML & VPasCode","isPartOf":{"@id":"https:\/\/www.vpascode.com\/cn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#primaryimage"},"image":{"@id":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vpascode.com\/cn\/wp-content\/uploads\/sites\/3\/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\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#primaryimage","url":"https:\/\/www.vpascode.com\/cn\/wp-content\/uploads\/sites\/3\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg","contentUrl":"https:\/\/www.vpascode.com\/cn\/wp-content\/uploads\/sites\/3\/2026\/08\/build-professional-database-diagrams-thumbnail.jpg","width":1376,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/www.vpascode.com\/cn\/building-a-hotel-management-erd-with-plantuml-and-vpascode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vpascode.com\/cn\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528PlantUML\u548cVPasCode\u6784\u5efa\u9152\u5e97\u7ba1\u7406ERD"}]},{"@type":"WebSite","@id":"https:\/\/www.vpascode.com\/cn\/#website","url":"https:\/\/www.vpascode.com\/cn\/","name":"VPasCode","description":"by Visual Paradigm","publisher":{"@id":"https:\/\/www.vpascode.com\/cn\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vpascode.com\/cn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Organization","@id":"https:\/\/www.vpascode.com\/cn\/#organization","name":"VPasCode","url":"https:\/\/www.vpascode.com\/cn\/","logo":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.vpascode.com\/cn\/#\/schema\/logo\/image\/","url":"https:\/\/www.vpascode.com\/cn\/wp-content\/uploads\/sites\/3\/2026\/06\/cropped-vp-online-logo-v1.png","contentUrl":"https:\/\/www.vpascode.com\/cn\/wp-content\/uploads\/sites\/3\/2026\/06\/cropped-vp-online-logo-v1.png","width":128,"height":138,"caption":"VPasCode"},"image":{"@id":"https:\/\/www.vpascode.com\/cn\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.vpascode.com\/cn\/#\/schema\/person\/cd8aa8455bd8bc6827b3efdfa79ad3a6","name":"jick","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@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\/cn\/author\/jick\/"}]}},"_links":{"self":[{"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/posts\/2139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/comments?post=2139"}],"version-history":[{"count":0,"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/posts\/2139\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/media\/2140"}],"wp:attachment":[{"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/media?parent=2139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/categories?post=2139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vpascode.com\/cn\/wp-json\/wp\/v2\/tags?post=2139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}