Projekt

Allgemein

Profil

Datenmodell » ER-Diagram_2.svg

Christian Wolf, 26.06.2019 05:28

 
1
<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" version="1.1" width="776px" height="651px" viewBox="-0.5 -0.5 776 651" content="&lt;mxfile modified=&quot;2019-06-26T05:28:12.172Z&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; etag=&quot;bi2QsSYEI_2SltxkdBMD&quot; version=&quot;10.8.0&quot;&gt;&lt;diagram name=&quot;Page-1&quot; id=&quot;0&quot;&gt;7ZrPb9sgFMf/mlwmrTLGsZNj27TdYTt10tpTRWxisxITYdIk/esHNtQ/SNZqSrFl7ZL4PcCGL5/3zFMygdfr/R1Hm+wHSzCd+F6yn8DFxPcBjGbyS3kOlSeag8qRcpLoTrXjnrxi7fS0d0sSXLQ6CsaoIJu2M2Z5jmPR8iHO2a7dbcVo+6kblGLLcR8jant/kURklXfmh7X/GyZpZp4MwnnVskTxc8rZNtfPy1mOq5Y1MrfRaywylLBdwwVvJvCaMyaqq/X+GlMlq1GsGnd7ovVtyhzn4iMDoKc3qRAHs26cSBm0ybjIWMpyRG9q71W5Nqxu4Umr7vOdsY10Aun8jYU46D1FW8GkKxNrqlvl7PjhQY8vjUdlXEyNudg3GxeHNyu5VDsrzVLU0nNLKNXt9vK1IgXb8hibNet9EoinWPeDQAuhVt8YqmW7w2yN5UxkB44pEuSlDQnSrKVv/WrR5YXW/dQe6Pm8ILrVt43pdvmkPgpre2rxlZK7jAh8v0Hl4nYyENtCnxTkBXOB939dqG6F06AaosM48KLK3tVBAQzPWSMgQu8M2phk4JjPPREPNZHSemy01HAqo2bTMF1j/Nii+DOZBiZDNpk2u9ID02Y+XabZaoX58KAGTpn2+2QaNIiu+X6P6T7yNIBHmDbJsg+m4XGmN1SS2j/Tfq95Ovifpz/E9HRYZw8zH4tpVhBBWN4/1mE0b3Htu+U6HA7X3j9xDdxwHQ2M6+go18XTthjC+aMLdegW6tnxoFfaPKGiYPHwFHL8OpsPJ+zfe52dI3yNkEM5apn5HC0fhoJot4hw+2byT1RYz/jQvzR+eDFtaQMip9r4ljbA0kQuRbQXznFBXtGy7KBiZ8NILsp5TK8m04X0qJgtqvBVAxAlaS6vKV6pWyl9SIzopXYLFfdXhRSa5OnPMgl8Dc7EHuyc9o9UsMfk9c8ir10IfRmXvCDoAhwYppwIHIyd32DmdQU2pxInAttlz8gIDsPAIhg6FDgcO8GRDzsCT2cuc7Bd4IyMYFvgIHQpsF0kjY7gqCOwH7lMEfbPXqMjuHuKgOY3cBcCQ7uIGhnBged3BJ45BBjaFdjIAA687ikNOAV49GVc4IFuhnB5iICjL+QCr3uI+MR3nDTrv+6UbY2/RsGbPw==&lt;/diagram&gt;&lt;/mxfile&gt;"><defs/><g><path d="M 450 420 L 655 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 390 60 L 390 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 120 420 L 330 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 715 250 L 715 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 715 590 L 715 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 390 250 L 390 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,572.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(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="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(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
(2-2/2)