Projekt

Allgemein

Profil

Datenmodell » ER-Diagram_1.svg

Christian Wolf, 25.06.2019 12:56

 
1
<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" version="1.1" width="777px" height="652px" viewBox="-0.5 -0.5 777 652" content="&lt;mxfile modified=&quot;2019-06-25T12:56:15.344Z&quot; host=&quot;www.draw.io&quot; agent=&quot;Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0&quot; version=&quot;10.8.0&quot; etag=&quot;lx7d6oSy7SwDiYXKE93D&quot;&gt;&lt;diagram name=&quot;Page-1&quot; id=&quot;0&quot;&gt;7Zpdb9sgFIZ/TW4mrTLGH8nl2rTbxXbVSWuvKmoTm5UYC5Mm6a8f2BB/kKxT1eLI2k2bcwBjXp5z4CiZwav17itHZf6DpZjOfC/dzeBy5vsABHP5T3n2jSeKYOPIOEl1p9ZxS16wdnrauyEprnodBWNUkLLvTFhR4ET0fIhztu13WzHan7VEGbYctwmitvcXSUXeeOd+1Pq/YZLlZmYQLZqWR5Q8ZZxtCj1fwQrctKyReYxeY5WjlG07Lng9g1ecMdF8Wu+uMFWyGsWacTcnWg+vzHEh/mUA9PQmVWJv1o1TKYM2GRc5y1iB6HXrvazXhtUjPGm1fb4zVkonkM7fWIi93lO0EUy6crGmulW+Hd/f6fG1ca+Mi9CYy123cbk/WOkXtbPSrEWtPTeEUt3erEUt4KQe2lWxDU+wEUFvnEA8w7ofBPPDfkjEMVtj+SayE8cUCfLcnwFp1rJDv1Z0+UHrfmoP9PTPiG70YxO6eXxQfypre1rxlZLbnAh8W6J6LVsZiH2h9YMxF3j3d0nsheoBMAyaITqMAy9u7G0bFMDwnHcCIvLeQRuTDBzzuSPiriVSWvedlhZOZbRsGqZbjO97FDtlGpiU2WW6k2M+mGkz/ZBptlphfn5QA6dM+2MyDTpEt3y/xvRZ5GkAjzDdZE8nTMPjTJdUkjo+0/6oeTr4n6ffxnQ46t3DTG8xzSoiCCvGxzqKFz2ufbdcR+fDtfcmrsFIXMfjch0f5bp62FTncP8YQh25hXp+POiVNg+oqlhyfgo5Ps4W5xP2rx1nHxK+RtmRrlpm+qPlw7kgOiwi3J5M/okK6wnvx5fGjy7CnjYgdqqNb2kDLE3k6kR/4RxX5AU91h1U7JSMFKJ+j/ByFi6lR8Vs1YSvGoAoyQr5meKVepSSjCSIftFuoeL+spJCkyL7WSeBz8E7sQcHt/0jFewxef13kdcuhD5NS14QDAEODFNOBA6mzm8w94YCm1uJE4HtsmdiBEdRYBEMHQocTV3g2IcDgcMFcCiwXeBMXuAgcnnI2UXS5ASOBwL7scsUYX/tNTmBh7cI6DJFQLuImtotwvMHAs8dAgztCmxiAAfe8JYGnAI8+TIu8MAwQ8wdnnFw8oVc4A0vER94xkmz/elO3db5aRS8/gM=&lt;/diagram&gt;&lt;/mxfile&gt;"><defs/><g><path d="M 450 420 L 654.67 420" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><rect x="330" y="390" width="120" height="60" rx="9" ry="9" fill="#ffffff" stroke="#000000" pointer-events="none"/><g transform="translate(360.5,413.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="59" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; width: 60px; white-space: nowrap; overflow-wrap: normal; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;white-space:normal;">club_clubs</div></div></foreignObject></g><path d="M 389.67 60 L 389.67 190" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><rect x="330" y="0" width="120" height="60" rx="9" ry="9" fill="#ffffff" stroke="#000000" pointer-events="none"/><g transform="translate(359.5,23.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="61" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; width: 62px; white-space: nowrap; overflow-wrap: normal; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;white-space:normal;">club_offers</div></div></foreignObject></g><path d="M 119.67 420 L 329.67 420" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><rect x="0" y="390" width="120" height="60" rx="9" ry="9" fill="#ffffff" stroke="#000000" pointer-events="none"/><g transform="translate(26.5,413.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="66" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; width: 67px; white-space: nowrap; overflow-wrap: normal; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;white-space:normal;">club_places</div></div></foreignObject></g><path d="M 714.67 250 L 714.67 390" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><rect x="655" y="190" width="120" height="60" rx="9" ry="9" fill="#ffffff" stroke="#000000" pointer-events="none"/><g transform="translate(675.5,213.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="79" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; width: 80px; white-space: nowrap; overflow-wrap: normal; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;white-space:normal;">club_positions</div></div></foreignObject></g><path d="M 714.67 590 L 714.67 450" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><rect x="655" y="590" width="120" height="60" rx="9" ry="9" fill="#ffffff" stroke="#000000" pointer-events="none"/><g transform="translate(681.5,613.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="66" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; width: 67px; white-space: nowrap; overflow-wrap: normal; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;white-space:normal;">clubs_users</div></div></foreignObject></g><rect x="655" y="390" width="120" height="60" rx="9" ry="9" fill="#ffffff" stroke="#000000" pointer-events="none"/><g transform="translate(665.5,413.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="99" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; width: 100px; white-space: nowrap; overflow-wrap: normal; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;white-space:normal;">club_user_assocs</div></div></foreignObject></g><path d="M 389.67 250 L 389.67 320 L 389.67 390" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><rect x="330" y="190" width="120" height="60" rx="9" ry="9" fill="#ffffff" stroke="#000000" pointer-events="none"/><g transform="translate(339.5,213.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="100" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; width: 101px; white-space: nowrap; overflow-wrap: normal; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;white-space:normal;">club_offer_assocs</div></div></foreignObject></g><rect x="2.5" y="160" width="120" height="60" rx="9" ry="9" fill="#ffffff" stroke="#000000" pointer-events="none"/><g transform="translate(34.5,183.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="55" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; width: 56px; white-space: nowrap; overflow-wrap: normal; text-align: center;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;white-space:normal;">club_keys</div></div></foreignObject></g><g transform="translate(311.5,402.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="7" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">1</div></div></foreignObject></g><g transform="translate(124.5,407.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="5" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">*</div></div></foreignObject></g><g transform="translate(458.5,403.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="7" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">1</div></div></foreignObject></g><g transform="translate(642.5,408.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="5" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">*</div></div></foreignObject></g><g transform="translate(701.5,576.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="5" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">*</div></div></foreignObject></g><g transform="translate(701.5,452.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="5" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">*</div></div></foreignObject></g><g transform="translate(705.5,258.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="5" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">*</div></div></foreignObject></g><g transform="translate(704.5,376.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="5" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">*</div></div></foreignObject></g><g transform="translate(380.5,68.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="7" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">1</div></div></foreignObject></g><g transform="translate(378.5,176.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="5" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">*</div></div></foreignObject></g><g transform="translate(379.5,372.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="7" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">1</div></div></foreignObject></g><g transform="translate(381.5,258.5)"><foreignObject style="overflow:visible;" pointer-events="all" width="5" height="12"><div xmlns="http://www.w3.org/1999/xhtml" style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; vertical-align: top; white-space: nowrap;"><div xmlns="http://www.w3.org/1999/xhtml" style="display:inline-block;text-align:inherit;text-decoration:inherit;">*</div></div></foreignObject></g></g></svg
(1-1/2)