ER-диаграмма

<?xml version="1.0" encoding="UTF-8"?> <svg width="800px" height="800px" viewBox="0 0 73 73" version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"> <title>databases-and-servers/databases/er-diagram</title> <desc>Created with Sketch.</desc> <defs> </defs> <g id="databases-and-servers/databases/er-diagram" stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"> <g id="container" transform="translate(2.000000, 2.000000)" fill="#FFFFFF" fill-rule="nonzero" stroke="#062B4C" stroke-width="2"> <rect id="mask" x="-1" y="-1" width="71" height="71" rx="14"> </rect> </g> <g id="workflow" transform="translate(10.000000, 11.000000)" fill-rule="nonzero"> <g id="Group" transform="translate(3.830078, 9.730469)" fill="#ADACB2"> <path d="M39.0662793,8.18249609 L23.3414277,8.18249609 L23.3414277,1.08463672 C23.3414277,0.535693359 22.8965176,0.0907832031 22.3475742,0.0907832031 C21.7987344,0.0907832031 21.3537207,0.535693359 21.3537207,1.08463672 L21.3537207,8.18249609 L5.62897266,8.18249609 C2.53282031,8.18249609 0.0137675781,10.7014453 0.0137675781,13.7977012 L0.0137675781,15.5270332 C0.0137675781,16.0759766 0.458677734,16.5208867 1.00762109,16.5208867 C1.55656445,16.5208867 2.00147461,16.0759766 2.00147461,15.5270332 L2.00147461,13.7974941 C2.00147461,11.7972617 3.62874023,10.1698926 5.62917969,10.1698926 L39.0664863,10.1698926 C41.0667187,10.1698926 42.6941914,11.7973652 42.6941914,13.7975977 L42.6941914,15.7919297 C42.6941914,16.340873 43.1391016,16.7857832 43.6880449,16.7857832 C44.2369883,16.7857832 44.6817949,16.340873 44.6817949,15.7919297 L44.6817949,13.7973906 C44.6814844,10.7013418 42.1624316,8.18249609 39.0662793,8.18249609 Z" id="Shape"> </path> <path d="M40.4911719,19.6167285 L26.1149219,19.6167285 C25.566082,19.6167285 25.1210684,19.1718184 25.1210684,18.6229785 C25.1210684,18.0740352 25.5659785,17.629125 26.1149219,17.629125 L40.4911719,17.629125 C41.0400117,17.629125 41.4850254,18.0740352 41.4850254,18.6229785 C41.4849219,19.1718184 41.0400117,19.6167285 40.4911719,19.6167285 Z" id="Shape"> </path> <path d="M9.86141602,19.6167285 L4.45106836,19.6167285 C3.90222852,19.6167285 3.45721484,19.1718184 3.45721484,18.6229785 C3.45721484,18.0740352 3.902125,17.629125 4.45106836,17.629125 L9.86141602,17.629125 C10.4102559,17.629125 10.8552695,18.0740352 10.8552695,18.6229785 C10.8552695,19.1718184 10.4102559,19.6167285 9.86141602,19.6167285 Z" id="Shape"> </path> <path d="M18.4299219,19.6167285 L13.3950254,19.6167285 C12.8461855,19.6167285 12.4011719,19.1718184 12.4011719,18.6229785 C12.4011719,18.0740352 12.846082,17.629125 13.3950254,17.629125 L18.4299219,17.629125 C18.9787617,17.629125 19.4237754,18.0740352 19.4237754,18.6229785 C19.4237754,19.1718184 18.9787617,19.6167285 18.4299219,19.6167285 Z" id="Shape"> </path> <path d="M22.3475742,32.6857832 C21.7987344,32.6857832 21.3537207,32.240873 21.3537207,31.6919297 L21.3537207,22.2844297 C21.3537207,21.7354863 21.7986309,21.2906797 22.3475742,21.2906797 C22.8964141,21.2906797 23.3414277,21.7355898 23.3414277,22.2844297 L23.3414277,31.6919297 C23.3414277,32.2409766 22.8964141,32.6857832 22.3475742,32.6857832 Z" id="Shape"> </path> <path d="M37.9593867,35.573248 L27.4054512,35.573248 C26.8566113,35.573248 26.4115977,35.1283379 26.4115977,34.579498 C26.4115977,34.0305547 26.8565078,33.5856445 27.4054512,33.5856445 L37.9593867,33.5856445 C38.5082266,33.5856445 38.9532402,34.0305547 38.9532402,34.579498 C38.9530332,35.1284414 38.508123,35.573248 37.9593867,35.573248 Z" id="Shape"> </path> </g> <path d="M33.5502422,8.50028906 L18.805166,8.50028906 L18.805166,0.705769531 C18.805166,0.339841797 19.1017383,0.0432695312 19.467666,0.0432695312 L32.8877422,0.0432695312 C33.2536699,0.0432695312 33.5502422,0.339841797 33.5502422,0.705769531 L33.5502422,8.50028906 Z" id="Shape" fill="#30D8B8"> </path> <polygon id="Shape" fill="#00C6A5" points="33.5501387 8.50028906 26.1773418 9.58182031 18.805166 8.50028906 18.805166 5.91312305 33.5501387 5.91312305"> </polygon> <path d="M32.8876387,11.7157949 L19.467666,11.7157949 C19.1017383,11.7157949 18.805166,11.4192227 18.805166,11.0532949 L18.805166,8.50028906 L33.5502422,8.50028906 L33.5502422,11.0533984 C33.5501387,11.4192227 33.2535664,11.7157949 32.8876387,11.7157949 Z" id="Shape" fill="#E0E0E3"> </path> <g id="Group" transform="translate(22.152344, 2.794922)" fill="#EFEFEF"> <path d="M7.01214844,2.85454687 C6.46330859,2.85454687 6.01829492,2.40963672 6.01829492,1.86069336 L6.01829492,1.09271094 C6.01829492,0.543767578 6.46320508,0.0988574219 7.01214844,0.0988574219 C7.56098828,0.0988574219 8.00589844,0.543767578 8.00589844,1.09271094 L8.00589844,1.86069336 C8.00589844,2.40974023 7.56098828,2.85454687 7.01214844,2.85454687 Z" id="Shape"> </path> <path d="M4.02541211,2.85454687 C3.47657227,2.85454687 3.03155859,2.40963672 3.03155859,1.86069336 L3.03155859,1.09271094 C3.03155859,0.543767578 3.47646875,0.0988574219 4.02541211,0.0988574219 C4.57425195,0.0988574219 5.01926562,0.543767578 5.01926562,1.09271094 L5.01926562,1.86069336 C5.01916211,2.40974023 4.57425195,2.85454687 4.02541211,2.85454687 Z" id="Shape"> </path> <path d="M1.03857227,2.85454687 C0.489732422,2.85454687 0.04471875,2.40963672 0.04471875,1.86069336 L0.04471875,1.09271094 C0.04471875,0.543767578 0.489628906,0.0988574219 1.03857227,0.0988574219 C1.58741211,0.0988574219 2.03242578,0.543767578 2.03242578,1.09271094 L2.03242578,1.86069336 C2.03232227,2.40974023 1.58741211,2.85454687 1.03857227,2.85454687 Z" id="Shape"> </path> </g> <g id="Group" transform="translate(0.414062, 23.912109)" fill="#FF318E"> <circle id="Oval" cx="4.42363672" cy="4.44123437" r="4.4175293"> </circle> <circle id="Oval" cx="47.1031289" cy="4.44123437" r="4.4175293"> </circle> </g> <circle id="Oval" fill="#30D8B8" cx="46.8379219" cy="44.3096562" r="6.16187109"> </circle> <path d="M25.7092441,33.4014902 L21.1296094,28.8218555 C20.8709238,28.5631699 20.8709238,28.1436211 21.1296094,27.8849355 L25.7092441,23.3053008 C25.9679297,23.0466152 26.3874785,23.0466152 26.6461641,23.3053008 L31.2257988,27.8849355 C31.4844844,28.1436211 31.4844844,28.5630664 31.2257988,28.8218555 L26.6461641,33.4014902 C26.387375,33.6601758 25.9679297,33.6601758 25.7092441,33.4014902 Z" id="Shape" fill="#00A5FF"> </path> <g id="Group" transform="translate(0.414062, 26.603516)" fill="#EA1F8E"> <path d="M8.8410625,1.75055273 C8.8410625,4.18989844 6.86287891,6.16673633 4.4235332,6.16673633 C1.9841875,6.16673633 0.00590039063,4.18979492 0.00590039063,1.75055273 C0.00590039063,1.15161133 0.125253906,0.581964844 0.339841797,0.0611777344 C1.0036875,1.66173633 2.5817832,2.78798633 4.4235332,2.78798633 C6.26517969,2.78798633 7.84337891,1.66163281 8.50722461,0.0611777344 C8.7218125,0.581964844 8.8410625,1.15161133 8.8410625,1.75055273 Z" id="Shape"> </path> <path d="M51.5206582,1.75055273 C51.5206582,4.18989844 49.5437168,6.16673633 47.1030254,6.16673633 C44.6636797,6.16673633 42.6854961,4.18979492 42.6854961,1.75055273 C42.6854961,1.15161133 42.8046426,0.581964844 43.0194375,0.0611777344 C43.6832832,1.66173633 45.2613789,2.78798633 47.1030254,2.78798633 C48.9448789,2.78798633 50.5228711,1.66163281 51.1867168,0.0611777344 C51.4013047,0.581964844 51.5206582,1.15161133 51.5206582,1.75055273 Z" id="Shape"> </path> </g> <path d="M31.2255918,28.8224766 L26.6464746,33.4015937 C26.3877891,33.6602793 25.9682402,33.6602793 25.7095547,33.4016973 L21.1292988,28.8224766 C20.8706133,28.563791 20.8705098,28.1443457 21.1291953,27.8854531 L22.3500586,26.6645898 L26.1779629,30.4911484 L30.0045215,26.6645898 L31.2254883,27.8855566 C31.4842773,28.1443457 31.4842773,28.563791 31.2255918,28.8224766 Z" id="Shape" fill="#0087FF"> </path> <path d="M28.5218672,48.7944707 L4.34869141,48.7944707 C1.94692187,48.7944707 0,46.8475488 0,44.4458828 C0,42.0442168 1.94692187,40.0971914 4.34869141,40.0971914 L28.5218672,40.0971914 C30.9235332,40.0971914 32.8705586,42.0441133 32.8705586,44.4458828 C32.8705586,46.8475488 30.9236367,48.7944707 28.5218672,48.7944707 Z" id="Shape" fill="#FFE97B"> </path> <path d="M53,44.3097598 C53,47.7136641 50.2413086,50.4723555 46.8388535,50.4723555 C43.4349492,50.4723555 40.6762578,47.7136641 40.6762578,44.3097598 C40.6762578,43.6962227 40.7663164,43.1026641 40.9332871,42.5435762 C41.6924707,45.0849883 44.0483828,46.9385391 46.83875,46.9385391 C49.627875,46.9385391 51.9837871,45.0848848 52.7429707,42.5435762 C52.9099414,43.1026641 53,43.6962227 53,44.3097598 Z" id="Shape" fill="#00C6A5"> </path> <path d="M32.8705586,44.4460898 C32.8705586,45.646457 32.3842422,46.732957 31.5972129,47.5200898 C30.8101836,48.3071191 29.7223379,48.7946777 28.5218672,48.7946777 L4.34869141,48.7946777 C1.9464043,48.7948848 0,46.8470313 0,44.4460898 C0,43.817957 0.133845703,43.2204648 0.373691406,42.6799063 C1.05078711,44.2009648 2.5757793,45.2609648 4.34869141,45.2609648 L28.5219707,45.2609648 C29.7224414,45.2609648 30.8102871,44.7746484 31.5973164,43.9876191 C31.9723535,43.612582 32.2784492,43.1701563 32.4969707,42.6798027 C32.7368164,43.2205684 32.8705586,43.8181641 32.8705586,44.4460898 Z" id="Shape" fill="#FFD527"> </path> <path d="M46.089918,46.9570684 C45.8264707,46.9570684 45.5736855,46.8524141 45.3872539,46.6660859 L43.7339023,45.0128379 C43.3458223,44.6247578 43.3458223,43.9955898 43.7339023,43.6075098 C44.1219824,43.2193262 44.7511504,43.2194297 45.1392305,43.6074062 L46.089918,44.5580937 L48.4738828,42.1741289 C48.8619629,41.7859453 49.4911309,41.7860488 49.8792109,42.1740254 C50.267291,42.5621055 50.267291,43.1912734 49.8792109,43.5793535 L46.7926855,46.6659824 C46.6062539,46.8523105 46.3534687,46.9570684 46.089918,46.9570684 Z" id="Shape" fill="#EFEFEF"> </path> <path d="M26.1961816,45.3037168 L6.67458398,45.3037168 C6.12574414,45.3037168 5.68073047,44.8588066 5.68073047,44.3099668 C5.68073047,43.7610234 6.12564062,43.3161133 6.67458398,43.3161133 L26.1961816,43.3161133 C26.7450215,43.3161133 27.1900352,43.7610234 27.1900352,44.3099668 C27.1898281,44.8589102 26.7450215,45.3037168 26.1961816,45.3037168 Z" id="Shape" fill="#00A5FF"> </path> </g> </g> </svg>