doc/svg/Entity-Relationship-Diagram.svg

<?xml version="1.0" encoding="us-ascii" standalone="no"?><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" contentStyleType="text/css" height="682px" preserveAspectRatio="none" style="width:250px;height:682px;background:#FFFFFF;" version="1.1" viewBox="0 0 250 682" width="250px" zoomAndPan="magnify"><defs/><g><!--class Patient--><g id="elem_Patient"><rect codeLine="1" fill="#F1F1F1" height="118.4375" id="Patient" rx="2.5" ry="2.5" style="stroke:#181818;stroke-width:0.5;" width="76" x="7" y="7"/><ellipse cx="22" cy="23" fill="#ADD1B2" rx="11" ry="11" style="stroke:#181818;stroke-width:1.0;"/><path d="M20.8594,23.7969 L20.8594,26.2969 L25.1875,26.2969 L25.1875,25.375 Q25.1875,24.7656 25.4297,24.5 Q25.6719,24.2344 26.0469,24.2344 Q26.4219,24.2344 26.6563,24.5 Q26.8906,24.7656 26.8906,25.375 L26.8906,28 L18.8906,28 Q18.2656,28 18.0078,27.7656 Q17.75,27.5313 17.75,27.1406 Q17.75,26.7656 18.0156,26.5313 Q18.2813,26.2969 18.8906,26.2969 L19.1563,26.2969 L19.1563,19.6406 L18.8906,19.6406 Q18.2656,19.6406 18.0078,19.4063 Q17.75,19.1719 17.75,18.7813 Q17.75,18.4063 18.0078,18.1719 Q18.2656,17.9375 18.8906,17.9375 L26.5156,17.9375 L26.5156,20.5313 Q26.5156,21.1406 26.2891,21.3984 Q26.0625,21.6563 25.6719,21.6563 Q25.2969,21.6563 25.0625,21.3984 Q24.8281,21.1406 24.8281,20.5313 L24.8281,19.6406 L20.8594,19.6406 L20.8594,22.0938 L22.3438,22.0938 Q22.3438,21.4375 22.4688,21.25 Q22.7344,20.8438 23.2031,20.8438 Q23.5781,20.8438 23.8125,21.1016 Q24.0469,21.3594 24.0469,21.9688 L24.0469,23.9375 Q24.0469,24.4844 23.9219,24.6719 Q23.6563,25.0625 23.2031,25.0625 Q22.7344,25.0625 22.4688,24.6563 Q22.3438,24.4688 22.3438,23.7969 L20.8594,23.7969 Z " fill="#000000"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="44" x="36" y="28.7285">Patient</text><line style="stroke:#181818;stroke-width:0.5;" x1="8" x2="82" y1="39" y2="39"/><ellipse cx="18" cy="53.3047" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="13" x="27" y="57.5332">ID</text><line style="stroke:#181818;stroke-width:1.0;" x1="8" x2="82" y1="64.6094" y2="64.6094"/><ellipse cx="18" cy="78.9141" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="25" x="27" y="83.1426">Age</text><ellipse cx="18" cy="96.5234" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="48" x="27" y="100.752">Gender</text><ellipse cx="18" cy="114.1328" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="25" x="27" y="118.3613">PLZ</text></g><!--class Hospital--><g id="elem_Hospital"><rect codeLine="9" fill="#F1F1F1" height="100.8281" id="Hospital" rx="2.5" ry="2.5" style="stroke:#181818;stroke-width:0.5;" width="125" x="118.5" y="15.5"/><ellipse cx="152.85" cy="31.5" fill="#ADD1B2" rx="11" ry="11" style="stroke:#181818;stroke-width:1.0;"/><path d="M151.7094,32.2969 L151.7094,34.7969 L156.0375,34.7969 L156.0375,33.875 Q156.0375,33.2656 156.2797,33 Q156.5219,32.7344 156.8969,32.7344 Q157.2719,32.7344 157.5063,33 Q157.7406,33.2656 157.7406,33.875 L157.7406,36.5 L149.7406,36.5 Q149.1156,36.5 148.8578,36.2656 Q148.6,36.0313 148.6,35.6406 Q148.6,35.2656 148.8656,35.0313 Q149.1313,34.7969 149.7406,34.7969 L150.0063,34.7969 L150.0063,28.1406 L149.7406,28.1406 Q149.1156,28.1406 148.8578,27.9063 Q148.6,27.6719 148.6,27.2813 Q148.6,26.9063 148.8578,26.6719 Q149.1156,26.4375 149.7406,26.4375 L157.3656,26.4375 L157.3656,29.0313 Q157.3656,29.6406 157.1391,29.8984 Q156.9125,30.1563 156.5219,30.1563 Q156.1469,30.1563 155.9125,29.8984 Q155.6781,29.6406 155.6781,29.0313 L155.6781,28.1406 L151.7094,28.1406 L151.7094,30.5938 L153.1938,30.5938 Q153.1938,29.9375 153.3188,29.75 Q153.5844,29.3438 154.0531,29.3438 Q154.4281,29.3438 154.6625,29.6016 Q154.8969,29.8594 154.8969,30.4688 L154.8969,32.4375 Q154.8969,32.9844 154.7719,33.1719 Q154.5063,33.5625 154.0531,33.5625 Q153.5844,33.5625 153.3188,33.1563 Q153.1938,32.9688 153.1938,32.2969 L151.7094,32.2969 Z " fill="#000000"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="50" x="171.15" y="37.2285">Hospital</text><line style="stroke:#181818;stroke-width:0.5;" x1="119.5" x2="242.5" y1="47.5" y2="47.5"/><ellipse cx="129.5" cy="61.8047" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="13" x="138.5" y="66.0332">ID</text><line style="stroke:#181818;stroke-width:1.0;" x1="119.5" x2="242.5" y1="73.1094" y2="73.1094"/><ellipse cx="129.5" cy="87.4141" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="25" x="138.5" y="91.6426">PLZ</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="99" x="138.5" y="109.252">number of beds</text></g><!--class Treatment--><g id="elem_Treatment"><rect codeLine="16" fill="#F1F1F1" height="312.1406" id="Treatment" rx="2.5" ry="2.5" style="stroke:#181818;stroke-width:0.5;" width="168" x="29" y="185"/><ellipse cx="76.25" cy="201" fill="#ADD1B2" rx="11" ry="11" style="stroke:#181818;stroke-width:1.0;"/><path d="M75.1094,201.7969 L75.1094,204.2969 L79.4375,204.2969 L79.4375,203.375 Q79.4375,202.7656 79.6797,202.5 Q79.9219,202.2344 80.2969,202.2344 Q80.6719,202.2344 80.9063,202.5 Q81.1406,202.7656 81.1406,203.375 L81.1406,206 L73.1406,206 Q72.5156,206 72.2578,205.7656 Q72,205.5313 72,205.1406 Q72,204.7656 72.2656,204.5313 Q72.5313,204.2969 73.1406,204.2969 L73.4063,204.2969 L73.4063,197.6406 L73.1406,197.6406 Q72.5156,197.6406 72.2578,197.4063 Q72,197.1719 72,196.7813 Q72,196.4063 72.2578,196.1719 Q72.5156,195.9375 73.1406,195.9375 L80.7656,195.9375 L80.7656,198.5313 Q80.7656,199.1406 80.5391,199.3984 Q80.3125,199.6563 79.9219,199.6563 Q79.5469,199.6563 79.3125,199.3984 Q79.0781,199.1406 79.0781,198.5313 L79.0781,197.6406 L75.1094,197.6406 L75.1094,200.0938 L76.5938,200.0938 Q76.5938,199.4375 76.7188,199.25 Q76.9844,198.8438 77.4531,198.8438 Q77.8281,198.8438 78.0625,199.1016 Q78.2969,199.3594 78.2969,199.9688 L78.2969,201.9375 Q78.2969,202.4844 78.1719,202.6719 Q77.9063,203.0625 77.4531,203.0625 Q76.9844,203.0625 76.7188,202.6563 Q76.5938,202.4688 76.5938,201.7969 L75.1094,201.7969 Z " fill="#000000"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="65" x="96.75" y="206.7285">Treatment</text><line style="stroke:#181818;stroke-width:0.5;" x1="30" x2="196" y1="217" y2="217"/><ellipse cx="40" cy="231.3047" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="33" x="49" y="235.5332">index</text><ellipse cx="40" cy="248.9141" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="77" x="49" y="253.1426">ID &#171;Patient&#187;</text><ellipse cx="40" cy="266.5234" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="83" x="49" y="270.752">ID &#171;Hospital&#187;</text><line style="stroke:#181818;stroke-width:1.0;" x1="30" x2="196" y1="277.8281" y2="277.8281"/><ellipse cx="40" cy="292.1328" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="75" x="49" y="296.3613">Primary ICD</text><ellipse cx="40" cy="309.7422" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="142" x="49" y="313.9707">List of secondary ICDs</text><ellipse cx="40" cy="327.3516" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="66" x="49" y="331.5801">Ventilation</text><ellipse cx="40" cy="344.9609" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="44" x="49" y="349.1895">Weight</text><ellipse cx="40" cy="362.5703" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="71" x="49" y="366.7988">List of OPS</text><ellipse cx="40" cy="380.1797" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="30" x="49" y="384.4082">Date</text><ellipse cx="40" cy="397.7891" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="54" x="49" y="402.0176">Duration</text><ellipse cx="40" cy="415.3984" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="31" x="49" y="419.627">DRG</text><ellipse cx="40" cy="433.0078" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="35" x="49" y="437.2363">Claim</text><ellipse cx="40" cy="450.6172" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="97" x="49" y="454.8457">Potential Fraud</text><ellipse cx="40" cy="468.2266" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="86" x="49" y="472.4551">Fraud type ID</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="4" x="49" y="490.0645">&#160;</text></g><!--class TreatmentTable--><g id="elem_TreatmentTable"><rect codeLine="36" fill="#F1F1F1" height="118.4375" id="TreatmentTable" rx="2.5" ry="2.5" style="stroke:#181818;stroke-width:0.5;" width="144" x="41" y="557"/><ellipse cx="60.95" cy="573" fill="#ADD1B2" rx="11" ry="11" style="stroke:#181818;stroke-width:1.0;"/><path d="M59.8094,573.7969 L59.8094,576.2969 L64.1375,576.2969 L64.1375,575.375 Q64.1375,574.7656 64.3797,574.5 Q64.6219,574.2344 64.9969,574.2344 Q65.3719,574.2344 65.6063,574.5 Q65.8406,574.7656 65.8406,575.375 L65.8406,578 L57.8406,578 Q57.2156,578 56.9578,577.7656 Q56.7,577.5313 56.7,577.1406 Q56.7,576.7656 56.9656,576.5313 Q57.2313,576.2969 57.8406,576.2969 L58.1063,576.2969 L58.1063,569.6406 L57.8406,569.6406 Q57.2156,569.6406 56.9578,569.4063 Q56.7,569.1719 56.7,568.7813 Q56.7,568.4063 56.9578,568.1719 Q57.2156,567.9375 57.8406,567.9375 L65.4656,567.9375 L65.4656,570.5313 Q65.4656,571.1406 65.2391,571.3984 Q65.0125,571.6563 64.6219,571.6563 Q64.2469,571.6563 64.0125,571.3984 Q63.7781,571.1406 63.7781,570.5313 L63.7781,569.6406 L59.8094,569.6406 L59.8094,572.0938 L61.2938,572.0938 Q61.2938,571.4375 61.4188,571.25 Q61.6844,570.8438 62.1531,570.8438 Q62.5281,570.8438 62.7625,571.1016 Q62.9969,571.3594 62.9969,571.9688 L62.9969,573.9375 Q62.9969,574.4844 62.8719,574.6719 Q62.6063,575.0625 62.1531,575.0625 Q61.6844,575.0625 61.4188,574.6563 Q61.2938,574.4688 61.2938,573.7969 L59.8094,573.7969 Z " fill="#000000"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="101" x="76.05" y="578.7285">TreatmentTable</text><line style="stroke:#181818;stroke-width:0.5;" x1="42" x2="184" y1="589" y2="589"/><ellipse cx="52" cy="603.3047" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="33" x="61" y="607.5332">index</text><line style="stroke:#181818;stroke-width:1.0;" x1="42" x2="184" y1="614.6094" y2="614.6094"/><ellipse cx="52" cy="628.9141" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="118" x="61" y="633.1426">index &#171;Treatment&#187;</text><ellipse cx="52" cy="646.5234" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="77" x="61" y="650.752">ID &#171;Patient&#187;</text><ellipse cx="52" cy="664.1328" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="83" x="61" y="668.3613">ID &#171;Hospital&#187;</text></g><!--link Patient to Treatment--><g id="link_Patient_Treatment"><path codeLine="44" d="M61.4352,132.9924 C65.8852,150.8424 67.1366,155.8671 72.4066,177.0271 " fill="none" id="Patient-Treatment" style="stroke:#181818;stroke-width:1.0;"/><line style="stroke:#181818;stroke-width:1.0;" x1="56.5864" x2="64.3488" y1="130.0788" y2="128.1436"/><line style="stroke:#181818;stroke-width:1.0;" x1="57.3121" x2="65.0745" y1="132.9897" y2="131.0545"/><line style="stroke:#181818;stroke-width:1.0;" x1="61.4352" x2="59.5" y1="132.9924" y2="125.23"/><line style="stroke:#181818;stroke-width:1.0;" x1="77.2547" x2="69.4919" y1="179.9419" y2="181.8753"/><line style="stroke:#181818;stroke-width:1.0;" x1="76.5297" x2="68.7669" y1="177.0308" y2="178.9642"/><line style="stroke:#181818;stroke-width:1.0;" x1="72.4066" x2="74.34" y1="177.0271" y2="184.79"/></g><!--link Hospital to Treatment--><g id="link_Hospital_Treatment"><path codeLine="45" d="M166.6744,124.5123 C161.7644,144.2023 159.7158,152.4777 153.5758,177.0977 " fill="none" id="Hospital-Treatment" style="stroke:#181818;stroke-width:1.0;"/><line style="stroke:#181818;stroke-width:1.0;" x1="163.761" x2="171.5233" y1="119.6633" y2="121.599"/><line style="stroke:#181818;stroke-width:1.0;" x1="163.0352" x2="170.7975" y1="122.5742" y2="124.5098"/><line style="stroke:#181818;stroke-width:1.0;" x1="166.6744" x2="168.61" y1="124.5123" y2="116.75"/><line style="stroke:#181818;stroke-width:1.0;" x1="156.489" x2="148.7268" y1="181.9468" y2="180.011"/><line style="stroke:#181818;stroke-width:1.0;" x1="157.215" x2="149.4527" y1="179.0359" y2="177.1001"/><line style="stroke:#181818;stroke-width:1.0;" x1="153.5758" x2="151.64" y1="177.0977" y2="184.86"/></g><!--link Treatment to TreatmentTable--><g id="link_Treatment_TreatmentTable"><path codeLine="46" d="M113,505.24 C113,526.37 113,530.89 113,548.72 " fill="none" id="Treatment-TreatmentTable" style="stroke:#181818;stroke-width:1.0;stroke-dasharray:7.0,7.0;"/><line style="stroke:#181818;stroke-width:1.0;" x1="113" x2="107" y1="505.24" y2="497.24"/><line style="stroke:#181818;stroke-width:1.0;" x1="113" x2="119" y1="505.24" y2="497.24"/><line style="stroke:#181818;stroke-width:1.0;" x1="113" x2="113" y1="505.24" y2="497.24"/><line style="stroke:#181818;stroke-width:1.0;" x1="109" x2="117" y1="507.24" y2="507.24"/><line style="stroke:#181818;stroke-width:1.0;" x1="117" x2="109" y1="552.72" y2="552.72"/><line style="stroke:#181818;stroke-width:1.0;" x1="117" x2="109" y1="549.72" y2="549.72"/><line style="stroke:#181818;stroke-width:1.0;" x1="113" x2="113" y1="548.72" y2="556.72"/></g><!--SRC=[XL51QiCm4Bph5NikE2y8XXBJD128QKCBlSdrDXNOKf3MK5Fbxrqvakh6X_eWZsOrEwiHQb8qGYr9eIRu5dUmgqHHyF_-XBnkKRTe6TJxDt4H0g-2H-FEYcJ72k1lKWN0oki-70z83ts35im7DDYwMOUZHKazRr87nKPVkHkirt6eifoJoRWiuSRGgbxQ4NQRAZ9xvIWOEtmtkeqr5uilOOoE7OoEp2kgqoVTQ0_rSsGgIGW93tQkh9ws4MqwgVeqaA7WmHazM3cqaPqmq7Z655d8P17AKJOTBfF9jvqeZYCB_gRqJtJ1CZsvzqNX_Q-po4-xg6G45xzQpKlJk3y0]--></g></svg>