{"id":363778,"date":"2023-10-25T16:48:45","date_gmt":"2023-10-25T08:48:45","guid":{"rendered":"https:\/\/www.idc.net\/help\/363778\/"},"modified":"2023-10-25T16:48:45","modified_gmt":"2023-10-25T08:48:45","slug":"%e5%bc%80%e5%8f%91%e8%80%85%e5%a6%82%e6%9e%9c%e7%90%86%e8%a7%a3er%e5%9b%be%ef%bc%88%e5%ae%9e%e4%bd%93-%e8%81%94%e7%b3%bb%e5%9b%be%ef%bc%89%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/idc.net\/help\/363778\/","title":{"rendered":"\u5f00\u53d1\u8005\u5982\u679c\u7406\u89e3ER\u56fe\uff08\u5b9e\u4f53-\u8054\u7cfb\u56fe\uff09\uff1f"},"content":{"rendered":"<p>E-R\u56fe\u4e5f\u79f0\u5b9e\u4f53-\u8054\u7cfb\u56fe(Entity Relationship Diagram)\uff0c\u63d0\u4f9b\u4e86\u8868\u793a\u5b9e\u4f53\u7c7b\u578b\u3001\u5c5e\u6027\u548c\u8054\u7cfb\u7684\u65b9\u6cd5\uff0c\u7528\u6765\u63cf\u8ff0\u73b0\u5b9e\u4e16\u754c\u7684\u6982\u5ff5\u6a21\u578b\u3002<\/p>\n<p>\u7528\u77e9\u5f62\u8868\u793a\u5b9e\u4f53\u578b\uff0c\u77e9\u5f62\u6846\u5185\u5199\u660e\u5b9e\u4f53\u540d;\u7528\u692d\u5706\u8868\u793a\u5b9e\u4f53\u7684\u5c5e\u6027\uff0c\u5e76\u7528\u65e0\u5411\u8fb9\u5c06\u5176\u4e0e\u76f8\u5e94\u7684\u5b9e\u4f53\u578b\u8fde\u63a5\u8d77\u6765;\u7528\u83f1\u5f62\u8868\u793a\u5b9e\u4f53\u578b\u4e4b\u95f4\u7684\u8054\u7cfb\uff0c\u5728\u83f1\u5f62\u6846\u5185\u5199\u660e\u8054\u7cfb\u540d\uff0c\u5e76\u7528\u65e0\u5411\u8fb9\u5206\u522b\u4e0e\u6709\u5173\u5b9e\u4f53\u578b\u8fde\u63a5\u8d77\u6765\uff0c\u540c\u65f6\u5728\u65e0\u5411\u8fb9\u65c1\u6807\u4e0a\u8054\u7cfb\u7684\u7c7b\u578b(1:1\uff0c1:n\u6216m:n)\u3002<\/p>\n<p>\u5b9e\u4f53\u8054\u7cfb\u6a21\u578b\uff0c\u662f\u6982\u5ff5\u6570\u636e\u6a21\u578b\u7684\u9ad8\u5c42\u63cf\u8ff0\u6240\u4f7f\u7528\u7684\u6570\u636e\u6a21\u578b\u6216\u6a21\u5f0f\u56fe\uff0c\u5b83\u4e3a\u8868\u8ff0\u8fd9\u79cd\u5b9e\u4f53\u8054\u7cfb\u6a21\u5f0f\u56fe\u5f62\u5f0f\u7684\u6570\u636e\u6a21\u578b\u63d0\u4f9b\u4e86\u56fe\u5f62\u7b26\u53f7\u3002<\/p>\n<p>\u4e0b\u9762\u662f\u4e00\u4e2a\u6700\u5e38\u89c1\u7684ER\u56fe\uff0c\u57fa\u672c\u4e0a\u53ea\u8981\u8bb2\u89e3ER\u56fe\u5c31\u4f1a\u78b0\u5230\u5b83\u3002<\/p>\n<p style=\"text-align: center\">\n<p>\u901a\u4fd7\u7684\u8bb2\uff0cER\u56fe\u662f\u628a\u73b0\u5b9e\u751f\u6d3b\u4e2d\u7684\u5404\u79cd\u5173\u7cfb\uff0c\u4ee5\u56fe\u7247\u7684\u5f62\u5f0f\uff0c\u62bd\u8c61\u51fa\u6765\uff0c\u5f62\u6210\u4e00\u4e2a\u601d\u7ef4\u5bfc\u56fe\uff0c\u901a\u8fc7ER\u56fe\u53ef\u4ee5\u4e86\u89e3\u73b0\u5b9e\u4e2d\u7684\u5404\u79cd\u5173\u7cfb\uff0c\u6bd4\u5982\u4e00\u4e2a\u73ed\u6709\u5f88\u591a\u5b66\u751f\u7ec4\u6210\u3002<\/p>\n<p>ER\u56fe\u7684\u5e94\u7528\uff0c\u6700\u6700\u96be\u7684\u5730\u65b9\u6211\u89c9\u5f97\u662f\u62bd\u8c61\u601d\u7ef4\u80fd\u529b\uff0c\u4f60\u9700\u8981\u628a\u73b0\u5b9e\u751f\u6d3b\u4e2d\u5404\u79cd\u5173\u7cfb\u6620\u5c04\u5230\u5927\u8111\u91cc\u9762\uff0c\u7136\u540e\u4ee5ER\u56fe\u7684\u5f62\u5f0f\u8f93\u51fa\u53ef\u5206\u6790\u548c\u53ef\u89c6\u5316\u7684\u4e1c\u897f\u3002<\/p>\n<p><strong>\u901a\u8fc7\u5b9e\u4f8b\u6765\u62c6\u89e3ER\u56fe<\/strong><\/p>\n<p><strong>\u4e00\u3001\u5b66\u6821\u91cc\u7684\u90a3\u70b9\u4e8b\u513f<\/strong><\/p>\n<p><strong>\u73b0\u5b9e\u751f\u6d3b<\/strong><\/p>\n<p>\u4e00\u4e2a\u73ed\u7ea7\u6709N\u591a\u7684\u5b66\u751f\u7ec4\u6210\uff0c\u6bcf\u4e2a\u73ed\u7ea7\u6709\u4e00\u4e2a\u73ed\u7ea7\u53f7\uff0c\u6bcf\u4e00\u540d\u5b66\u751f\u6709\u4e00\u4e2a\u5b66\u53f7;\u5b66\u751f\u53ef\u4ee5\u6839\u636e\u81ea\u5df1\u7684\u5174\u8da3\u7231\u597d\u9009\u4fee\u8bfe\u7a0b\uff0c\u5bf9\u4e8e\u9009\u4fee\u7684\u8bfe\u7a0b\u9700\u8981\u8003\u8bd5\uff0c\u7136\u540e\u51fa\u6210\u7ee9\u6709\u5b66\u5206;\u4e00\u540d\u8001\u5e08\u53ef\u4ee5\u6559\u6388\u51e0\u95e8\u8bfe\u7a0b\u3002<\/p>\n<p><strong>ER\u56fe<\/strong><\/p>\n<p>\u901a\u8fc7\u73b0\u5b9e\u7684\u63cf\u8ff0\u5206\u89e3\u51fa\u51e0\u4e2a\u5b9e\u4f53\uff0c\u5206\u522b\u4e3a\u73ed\u7ea7\u3001\u5b66\u751f\u3001\u8bfe\u7a0b\u3001\u6559\u5e08\u3002\u51fa\u73b0\u4e86\u51e0\u7ec4\u5173\u7cfb\uff0c\u5206\u522b\u4e3a\u4e00\u4e2a\u73ed\u7ea7\u7531\u591a\u540d\u5b66\u751f\u7ec4\u6210(1\u5bf9\u591a)\u3001\u4e00\u540d\u5b66\u751f\u53ef\u4ee5\u9009\u591a\u95e8\u8bfe\u7a0b\uff0c\u540c\u65f6\u4e00\u95e8\u8bfe\u7a0b\u53ef\u80fd\u88ab\u591a\u540d\u5b66\u751f\u9009\u4fee(\u591a\u5bf9\u591a)\u3001\u4e00\u540d\u6559\u5e08\u53ef\u4f20\u6388\u591a\u95e8\u8bfe\u7a0b\uff0c\u540c\u65f6\u4e00\u95e8\u8bfe\u7a0b\u53ef\u80fd\u88ab\u591a\u540d\u6559\u5e08\u4f20\u6388(\u591a\u5bf9\u591a)\u3002\u8fd9\u4e2a\u573a\u666f\u91cc\u9762\u6ca1\u6709\u4e00\u5bf9\u4e00\u7684\u5173\u7cfb\u3002<\/p>\n<p style=\"text-align: center\">\n<p><strong>\u5173\u7cfb\u6570\u636e\u5e93<\/strong><\/p>\n<p>ER\u56fe\u753b\u51fa\u6765\u4ee5\u540e\uff0c\u5982\u4f55\u6620\u5c04\u5230\u5173\u7cfb\u6570\u636e\u5e93\u4e2d\u7684\u8868\u5462?\u8fd9\u4e00\u6b65\u5c31\u975e\u5e38\u7b80\u5355\u4e86\uff0c\u5206\u6b65\u9aa4\u8fdb\u884c\u521b\u5efa\uff1a\u628a\u5b9e\u4f53\u6620\u5c04\u4e3a\u8868\u3001\u628a\u5173\u7cfb\u6620\u5c04\u4e3a\u8868\u3002\u5b9e\u4f53\u6620\u5c04\u4e3a\u8868\uff0c\u6bd4\u8f83\u7b80\u5355\uff0c\u4e0d\u518d\u8d58\u8ff0\u3002<\/p>\n<p>\u5173\u7cfb\u6620\u5c04\u4e3a\u8868\uff0c\u76f8\u5bf9\u6765\u8bf4\u6bd4\u8f83\u590d\u6742\uff0c\u4ee5\u8fd9\u91cc\u7684ER\u56fe\u4e3a\u4f8b\uff0c\u5b58\u57281\u5bf9\u591a\u548c\u591a\u5bf9\u591a\u4e24\u7c7b\u5173\u7cfb\u3002<\/p>\n<p>1\u5bf9\u591a\u6216\u8005\u591a\u5bf91\u65f6\uff0c\u5728\u591a\u65b9\u6dfb\u52a0\u4e00\u4e2a\u5916\u952e\uff0c\u5bf9\u5e94\u52301\u65b9\uff0c\u5982\u5b66\u751f\u8868\u91cc\u7684\u6240\u5728\u73ed\u7ea7\u8fd9\u4e2a\u5916\u952e\u3002\u591a\u5bf9\u591a\u65f6\uff0c\u9700\u8981\u65b0\u589e\u4e00\u4e2a\u5173\u7cfb\u8868\uff0c\u628a\u4e24\u4e2a\u5b9e\u4f53\u95f4\u7684\u5173\u7cfb\u8bb0\u5f55\u4e0b\u6765\uff0c\u6bd4\u5982\u4e0b\u9762\u7684\u5b66\u751f\u9009\u8bfe\u5173\u7cfb\u8868\u3001\u6559\u5e08\u4efb\u8bfe\u5173\u7cfb\u8868\u3002\u6839\u636eER\u56fe\u521b\u5efa\u8868\u5982\u4e0b\uff1a<\/p>\n<p>\u73ed\u7ea7\u8868(\u4e3b\u952e\uff1a\u73ed\u7ea7\u53f7 )<\/p>\n<ul>\n<li>\u73ed\u7ea7\u53f7 \u73ed\u7ea7\u540d \u4e13\u4e1a \u4eba\u6570<\/li>\n<li>C001 \u52a8\u6f2b\u4e00\u73ed \u52a8\u6f2b\u8bbe\u8ba1 60<\/li>\n<li>C002 \u52a8\u6f2b\u4e8c\u73ed \u52a8\u6f2b\u8bbe\u8ba1 80<\/li>\n<li>C003 \u8ba1\u7b97\u4e00\u73ed \u8ba1\u7b97\u673a\u5e94\u7528 70<\/li>\n<\/ul>\n<p>\u5b66\u751f\u8868(\u4e3b\u952e\uff1a\u5b66\u53f7\uff0c\u5916\u952e\uff1a\u6240\u5728\u73ed\u7ea7 )<\/p>\n<ul>\n<li>\u5b66\u53f7 \u59d3\u540d \u6027\u522b \u5e74\u9f84 \u6240\u5728\u73ed\u7ea7<\/li>\n<li>S001 \u5c0f\u660e \u7537 20 C001<\/li>\n<li>S002 \u5c0f\u738b \u5973 19 C002<\/li>\n<li>S003 \u5c0f\u6731 \u7537 21 C003<\/li>\n<\/ul>\n<p>\u8bfe\u7a0b\u8868(\u4e3b\u952e\uff1a\u8bfe\u7a0b\u53f7)<\/p>\n<ul>\n<li>\u8bfe\u7a0b\u53f7 \u8bfe\u7a0b\u540d \u8bfe\u65f6 \u5b66\u5206<\/li>\n<li>K001 PS 20 5<\/li>\n<li>K002 \u739b\u96c5 25 6<\/li>\n<li>K003 \u6570\u636e\u5e93 30 10<\/li>\n<\/ul>\n<p>\u6559\u5e08\u8868(\u4e3b\u952e\uff1a\u7f16\u53f7)<\/p>\n<ul>\n<li>\u7f16\u53f7 \u804c\u79f0 \u59d3\u540d \u6027\u522b \u5e74\u9f84<\/li>\n<li>T001 \u52a9\u6559 \u674e\u8001\u5e08 \u7537 30<\/li>\n<li>T002 \u8bb2\u5e08 \u6731\u8001\u5e08 \u5973 33<\/li>\n<li>T003 \u6559\u6388 \u738b\u8001\u5e08 \u7537 43<\/li>\n<\/ul>\n<p>\u5b66\u751f\u9009\u8bfe\u5173\u7cfb\u8868<\/p>\n<ul>\n<li>\u7f16\u53f7 \u5b66\u53f7 \u8bfe\u7a0b\u53f7 \u6210\u7ee9<\/li>\n<li>SK001 S001 K001 80<\/li>\n<li>SK002 S001 K002 76<\/li>\n<li>SK003 S002 K001 89<\/li>\n<li>SK004 S003 K002 90<\/li>\n<\/ul>\n<p>\u6559\u5e08\u4efb\u8bfe\u5173\u7cfb\u8868<\/p>\n<ul>\n<li>\u7f16\u53f7 \u6559\u5e08\u53f7 \u8bfe\u7a0b\u53f7 \u65f6\u95f4<\/li>\n<li>TK001 T001 K001 16:00<\/li>\n<li>TK002 T001 K002 14:00<\/li>\n<li>TK003 T002 K001 10:00<\/li>\n<li>TK004 T003 K002 15:00<\/li>\n<\/ul>\n<p><strong>\u4e8c\u3001\u8bf4\u8bf4\u7535\u5546<\/strong><\/p>\n<p><strong>\u73b0\u5b9e\u751f\u6d3b<\/strong><\/p>\n<p>\u6211\u6253\u5f00\u6dd8\u5b9d\uff0c\u767b\u5f55\u6211\u7684\u8d26\u6237\uff0c\u67e5\u770b\u4e86\u4e00\u4e0b\u6628\u5929\u4e0b\u7684\u5355\u5feb\u9012\u5230\u54ea\u91cc\u4e86\uff0c\u7136\u540e\u53c8\u901b\u4e86\u901b\uff0c\u628a\u51e0\u4e2a\u4e2d\u610f\u7684\u5c0f\u5bb6\u7535\u653e\u5230\u8d2d\u7269\u8f66\u91cc\u9762\uff0c\u8fd9\u6b21\u94b1\u4e0d\u591f\u4e86\uff0c\u4e0b\u6b21\u518d\u4e70\uff0c\u563f\u563f\u3002<\/p>\n<p><strong>ER\u56fe<\/strong><\/p>\n<p>\u901a\u8fc7\u4e0a\u9762\u7b80\u77ed\u7684\u63cf\u8ff0\u5206\u89e3\u51fa\u51e0\u4e2a\u5b9e\u4f53\uff0c\u5206\u522b\u4e3a\u7528\u6237\u3001\u8ba2\u5355\u3001\u8d2d\u7269\u8f66\u3001\u5546\u54c1\u3001\u4f9b\u5e94\u5546\u3002\u51fa\u73b0\u4e86\u51e0\u7ec4\u5173\u7cfb\uff0c\u5206\u522b\u4e3a\u4e00\u4e2a\u7528\u6237\u4f1a\u6709\u591a\u4e2a\u8ba2\u5355(1\u5bf9\u591a)\u3001\u4e00\u540d\u7528\u6237\u53ea\u6709\u4e00\u4e2a\u8d2d\u7269\u8f66(1\u5bf91)\uff0c\u4e00\u4e2a\u8d2d\u7269\u8f66\u9009\u8d2d\u591a\u79cd\u5546\u54c1\uff0c\u540c\u65f6\u4e00\u4e2a\u5546\u54c1\u53ef\u80fd\u5b58\u5728\u591a\u4e2a\u7528\u6237\u7684\u8d2d\u7269\u8f66\u4e2d(\u591a\u5bf9\u591a)\u3001\u4e00\u4e2a\u4f9b\u5e94\u5546\u53ef\u4ee5\u4f9b\u5e94\u591a\u79cd\u5546\u54c1\uff0c\u4e00\u4e2a\u5546\u54c1\u53ea\u80fd\u5c5e\u4e8e\u4e00\u4e2a\u4f9b\u5e94\u5546(\u591a\u5bf91)\u3002<\/p>\n<p style=\"text-align: center\">\n<p><strong>\u5173\u7cfb\u6570\u636e\u5e93<\/strong><\/p>\n<p>\u540c\u7406\uff0c\u6839\u636eER\u56fe\u6620\u5c04\u5230\u6570\u636e\u5e93\u8868\uff0c\u5b9e\u4f53\u9996\u5148\u6620\u5c04\uff0c\u7136\u540e\u518d\u6620\u5c04\u5173\u7cfb\uff0c1\u5bf91\u30011\u5bf9\u591a\u4ee5\u53ca\u591a\u5bf91\u4ee5\u4e3b\u5916\u952e\u7684\u5f62\u5f0f\u8fdb\u884c\u5173\u7cfb\u6620\u5c04\uff0c\u591a\u5bf9\u591a\u4ee5\u65b0\u589e\u4e00\u4e2a\u5173\u7cfb\u8868\u6765\u8fdb\u884c\u5173\u7cfb\u6620\u5c04\u3002\u6839\u636eER\u56fe\u521b\u5efa\u8868\u5982\u4e0b\uff1a<\/p>\n<p>\u7528\u6237\u8868(\u4e3b\u952e\uff1a\u7528\u6237ID)<\/p>\n<ul>\n<li>\u7528\u6237ID \u7528\u6237\u540d \u5bc6\u7801 \u6635\u79f0 \u8eab\u4efd\u8bc1<\/li>\n<li>U001 USER01 *** \u5c0f\u9a6c\u54e5 3729***<\/li>\n<li>U002 USER02 *** \u8d2d\u7269\u72c2 1010***<\/li>\n<li>U003 USER03 *** \u4e70\u4e70\u4e70 3302***<\/li>\n<\/ul>\n<p>\u8ba2\u5355\u8868(\u4e3b\u952e\uff1a\u8ba2\u5355ID\uff0c\u5916\u952e\uff1a\u7528\u6237ID)<\/p>\n<ul>\n<li>\u8ba2\u5355ID \u7528\u6237ID \u91d1\u989d \u72b6\u6001<\/li>\n<li>D001 U001 500\uffe5 \u5b8c\u6210<\/li>\n<li>D002 U001 600\uffe5 \u6d3e\u9001\u4e2d<\/li>\n<li>D003 U003 700\uffe5 \u5f85\u8bc4\u4ef7<\/li>\n<\/ul>\n<p>\u8d2d\u7269\u8f66\u8868(\u4e3b\u952e\uff1a\u8d2d\u7269\u8f66ID)<\/p>\n<ul>\n<li>\u8d2d\u7269\u8f66ID \u7528\u6237ID \u603b\u4ef7 \u4f18\u60e0\u4ef7<\/li>\n<li>C001 U001 50\uffe5 45\uffe5<\/li>\n<li>C002 U002 150\uffe5 120\uffe5<\/li>\n<li>C003 U003 50\uffe5 40\uffe5<\/li>\n<\/ul>\n<p>\u4f9b\u5e94\u5546\u8868(\u4e3b\u952e\uff1a\u6ce8\u518c\u53f7)<\/p>\n<ul>\n<li>\u6ce8\u518c\u53f7 \u540d\u79f0 \u8054\u7cfb\u4eba<\/li>\n<li>G001 xx\u7535\u5668\u516c\u53f8 \u9ad8\u5148\u751f<\/li>\n<li>G002 yy\u6d17\u5316\u516c\u53f8 \u674e\u5148\u751f<\/li>\n<li>G003 zz\u670d\u88c5\u516c\u53f8 \u738b\u5148\u751f<\/li>\n<\/ul>\n<p>\u5546\u54c1\u8868(\u4e3b\u952e\uff1a\u7f16\u7801\uff0c\u5916\u952e\uff1a\u4f9b\u5e94\u5546\u6ce8\u518c\u53f7)<\/p>\n<ul>\n<li>\u7f16\u7801 \u540d\u79f0 \u5206\u7c7b \u91cd\u91cf \u5355\u4ef7 \u4f9b\u5e94\u5546\u6ce8\u518c\u53f7<\/li>\n<li>P001 \u70ed\u6c34\u58f6 \u5bb6\u7535 1kg 50\uffe5 G001<\/li>\n<li>P002 \u6d17\u8863\u7c89 \u6d17\u5316 3kg 20\uffe5G001<\/li>\n<li>P003 \u6bdb\u8863 \u670d\u88c5 400g 150\uffe5G002<\/li>\n<\/ul>\n<p>\u9009\u8d2d\u5173\u7cfb\u8868<\/p>\n<ul>\n<li>\u7f16\u53f7 \u8d2d\u7269\u8f66ID \u5546\u54c1\u7f16\u7801<\/li>\n<li>X001 C001 P001<\/li>\n<li>X002 C001 P002<\/li>\n<li>X003 C002 P001<\/li>\n<li>X004 C003 P002<\/li>\n<\/ul>\n<p><strong>\u4e09\u3001\u4f60\u771f\u7684\u7406\u89e31\u5bf91\u30011\u5bf9\u591a\u548c\u591a\u5bf9\u591a\u5417?<\/strong><\/p>\n<p>\u8981\u60f3\u5f7b\u5e95\u7406\u89e3\u8fd9\u4e09\u7c7b\u5173\u7cfb\uff0c\u4e0d\u80fd\u53ea\u8bfb\u7406\u8bba\u5b9a\u4e49\uff0c\u800c\u662f\u4eceSQL\u67e5\u8be2\u7ed3\u679c\u51fa\u53d1\uff0c\u6765\u4ece\u5b9e\u8df5\u5c42\u9762\u52a0\u6df1\u7406\u89e3\u3002<\/p>\n<p><strong>1\u5bf91\uff0c\u5728\u4efb\u610f\u4e00\u5f20\u8868\u4e2d\u6dfb\u52a0\u5916\u952e<\/strong><\/p>\n<p>1\u5bf91\u7684\u610f\u601d\u662f\u6307\u7b2c\u4e00\u5f20\u8868\u4e2d\u7684\u67d0\u6761\u8bb0\u5f55\uff0c\u6839\u636e\u4e3b\u5916\u952e\u5173\u8054\uff0c\u53ea\u80fd\u67e5\u8be2\u5230\u53e6\u4e00\u5f20\u8868\u4e2d\u76840\u6761\u6216\u80051\u6761\u8bb0\u5f55\uff0c\u540c\u65f6\u8868\u4e2d\u7684\u6240\u6709\u5176\u4ed6\u8bb0\u5f55\u90fd\u6ee1\u8db3\u8fd9\u4e2a\u7279\u6027\uff0c\u53cd\u4e4b\u4ea6\u7136\u3002<\/p>\n<p>1\u5bf91\u65f6\uff0c\u9700\u8981\u6dfb\u52a0\u4e00\u4e2a\u5916\u952e\uff0c\u5916\u952e\u6dfb\u52a0\u5230\u4efb\u4f55\u4e00\u5f20\u8868\u4e2d\u90fd\u53ef\u4ee5\u3002<\/p>\n<p><strong>1\u5bf9\u591a\uff0c1\u65b9\u5c5e\u4e8e\u4e3b\u8868\uff0c\u591a\u65b9\u5c5e\u4e8e\u4ece\u8868\uff0c\u5728\u4ece\u8868\u6dfb\u52a0\u5916\u952e<\/strong><\/p>\n<p>1\u5bf9\u591a\u7684\u610f\u601d\u662f\u6307\u7b2c\u4e00\u5f20\u8868\u4e2d\u7684\u67d0\u6761\u8bb0\u5f55\uff0c\u6839\u636e\u4e3b\u5916\u952e\u5173\u8054\uff0c\u80fd\u67e5\u8be2\u5230\u53e6\u4e00\u5f20\u8868\u4e2d\u76840\u6761\u30011\u6761\u6216\u8005N\u6761\u8bb0\u5f55\uff0c\u540c\u65f6\u8868\u4e2d\u7684\u6240\u6709\u5176\u4ed6\u8bb0\u5f55\u90fd\u6ee1\u8db3\u8fd9\u4e2a\u7279\u6027\uff0c\u53cd\u4e4b\u662f\u591a\u5bf91\u3002<\/p>\n<p>1\u5bf9\u591a\u65f6\uff0c\u4ee51\u65b9\u4e3a\u4e3b\u8868\uff0c\u591a\u65b9\u4e3a\u4ece\u8868\uff0c\u5728\u591a\u65b9\u6dfb\u52a0\u4e00\u4e2a\u5916\u952e\u3002<\/p>\n<p><strong>\u591a\u5bf9\u591a\uff0c\u65b0\u589e\u4e00\u5f20\u5173\u7cfb\u8868<\/strong><\/p>\n<p>\u591a\u5bf9\u591a\u7684\u610f\u601d\u662f\u6307\u7b2c\u4e00\u5f20\u8868\u4e2d\u7684\u67d0\u6761\u8bb0\u5f55\uff0c\u6839\u636e\u4e3b\u5916\u952e\u5173\u8054\uff0c\u80fd\u67e5\u8be2\u5230\u53e6\u4e00\u5f20\u8868\u4e2d\u76840\u6761\u30011\u6761\u6216\u8005N\u6761\u8bb0\u5f55\uff0c\u540c\u65f6\u8868\u4e2d\u7684\u6240\u6709\u5176\u4ed6\u8bb0\u5f55\u90fd\u6ee1\u8db3\u8fd9\u4e2a\u7279\u6027\uff0c\u53cd\u4e4b\u4ea6\u7136\u3002<\/p>\n<p>\u591a\u5bf9\u591a\u65f6\uff0c\u8981\u65b0\u589e\u4e00\u5f20\u5173\u7cfb\u8868\uff0c\u4ee5\u8bb0\u5f55\u591a\u5bf9\u591a\u7684\u6570\u636e\u5173\u7cfb\uff0c\u4e3e\u4e2a\u6817\u5b50\uff1a<\/p>\n<p>\u8bfe\u7a0b\u8868(\u4e3b\u952e\uff1a\u8bfe\u7a0b\u53f7)<\/p>\n<ul>\n<li>\u8bfe\u7a0b\u53f7 \u8bfe\u7a0b\u540d \u8bfe\u65f6 \u5b66\u5206<\/li>\n<li>K001 PS\u7537 20 5<\/li>\n<li>K002 \u739b\u96c5 25 6<\/li>\n<li>K003 \u6570\u636e\u5e93 30 10<\/li>\n<\/ul>\n<p>\u6559\u5e08\u8868(\u4e3b\u952e\uff1a\u7f16\u53f7)<\/p>\n<ul>\n<li>\u7f16\u53f7 \u804c\u79f0 \u59d3\u540d \u6027\u522b \u5e74\u9f84<\/li>\n<li>T001 \u52a9\u6559 \u674e\u8001\u5e08 \u7537 30<\/li>\n<li>T002 \u8bb2\u5e08 \u6731\u8001\u5e08 \u5973 33<\/li>\n<li>T003 \u6559\u6388 \u738b\u8001\u5e08 \u7537 43<\/li>\n<\/ul>\n<p>\u6559\u5e08\u4efb\u8bfe\u8868(\u591a\u5bf9\u591a\u5173\u7cfb\u884d\u751f\u51fa\u6765\u7684\u8868)<\/p>\n<ul>\n<li>\u7f16\u53f7 \u6559\u5e08\u53f7 \u8bfe\u7a0b\u53f7 \u65f6\u95f4<\/li>\n<li>TK001 T001 K001 16:00<\/li>\n<li>TK002 T001 K002 14:00<\/li>\n<li>TK003 T002 K001 10:00<\/li>\n<li>TK004 T003 K002 15:00<\/li>\n<\/ul>\n<p style=\"text-align: left\">\u5982\u679c\u5927\u5bb6\u6709\u5174\u8da3\uff0c\u53ef\u4ee5\u8bd5\u7740\u5206\u6790\u4e0b\u9762ER\u56fe\u5982\u4f55\u5efa\u8868\uff0c\u4e0b\u7bc7\u6587\u7ae0\u516c\u5e03\u7b54\u6848\u3002<\/p>\n<p style=\"text-align: center\">\n<p>\u3010\u672c\u6587\u4e3a\u4e13\u680f\u4f5c\u8005\u201c\u6731\u56fd\u7acb\u201d\u7684\u539f\u521b\u7a3f\u4ef6\uff0c\u8f6c\u8f7d\u8bf7\u901a\u8fc7\u4f5c\u8005\u5fae\u4fe1\u516c\u4f17\u53f7\u201c\u5f00\u53d1\u8005\u5706\u684c\u201d\u83b7\u53d6\u8054\u7cfb\u548c\u6388\u6743\u3011<\/p>\n<p>\u6233\u8fd9\u91cc\uff0c\u770b\u8be5\u4f5c\u8005\u66f4\u591a\u597d\u6587<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>E-R\u56fe\u4e5f\u79f0\u5b9e\u4f53-\u8054\u7cfb\u56fe(Entity Relationship Diagram)\uff0c\u63d0\u4f9b\u4e86\u8868\u793a\u5b9e\u4f53\u7c7b\u578b\u3001\u5c5e\u6027\u548c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":363779,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61],"tags":[],"class_list":["post-363778","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-website"],"_links":{"self":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/363778","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/comments?post=363778"}],"version-history":[{"count":0,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/363778\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/media\/363779"}],"wp:attachment":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/media?parent=363778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/categories?post=363778"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/tags?post=363778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}