Design/DB_STRUCTURE/Relational.svg


<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" version="1.1"  width="1108" height="535">
<defs id="dmw_defs" >
<svg id="fk_sym" viewBox="0 0 48.665 48.665" style="enable-background:new 0 0 48.665 48.665;" >
<g>
<path d="M40.332,31.592c-2.377,0-4.515,1-6.033,2.598l-17.737-8.686c0.061-0.406,0.103-0.82,0.103-1.246    c0-0.414-0.04-0.818-0.098-1.215l17.711-8.589c1.519,1.609,3.666,2.619,6.054,2.619c4.603,0,8.333-3.731,8.333-8.333    c0-4.603-3.73-8.333-8.333-8.333s-8.333,3.73-8.333,8.333c0,0.414,0.04,0.817,0.098,1.215l-17.709,8.589    c-1.519-1.609-3.666-2.619-6.054-2.619C3.73,15.925,0,19.656,0,24.258c0,4.603,3.73,8.333,8.333,8.333    c2.377,0,4.515-1,6.033-2.596l17.736,8.685c-0.062,0.406-0.104,0.82-0.104,1.245c0,4.604,3.73,8.333,8.333,8.333    s8.333-3.729,8.333-8.333C48.665,35.322,44.935,31.592,40.332,31.592z" fill="#13bf3b"/>
</g>
</svg>
<svg id="pk_sym" viewBox="0 0 480.509 480.509" style="enable-background:new 0 0 480.509 480.509;" >
<g>
<path d="M418.119,331.046c4.094,4.374,7.766,8.186,10.996,11.416c3.237,3.238,6.714,6.376,10.427,9.422   c3.71,3.042,6.427,4.568,8.135,4.568c3.241,0,9.517-4.661,18.843-13.99c9.328-9.321,13.989-15.604,13.989-18.842   c0-1.523-2.714-5.421-8.138-11.704c-5.421-6.276-12.364-13.702-20.838-22.271c-8.473-8.565-16.703-16.744-24.694-24.55   c-8.001-7.81-15.8-15.373-23.417-22.703c-7.611-7.327-11.992-11.56-13.135-12.703c-1.902-1.902-4.093-2.853-6.563-2.853   c-3.237,0-9.521,4.661-18.843,13.988c-9.328,9.322-13.989,15.605-13.989,18.843c0,1.711,1.522,4.421,4.568,8.138   c3.046,3.71,6.188,7.187,9.421,10.424c3.23,3.23,7.047,6.899,11.42,10.992c4.377,4.093,6.848,6.423,7.423,6.995l-27.408,27.404   L254.954,222.268c24.94-33.498,37.408-68.236,37.408-104.211c0-31.024-9.761-56.293-29.263-75.801   c-19.512-19.511-44.778-29.265-75.805-29.265c-30.454,0-60.244,9.042-89.363,27.119c-29.121,18.083-52.727,41.686-70.808,70.808   C9.042,140.038,0,169.828,0,200.28c0,31.029,9.753,56.286,29.265,75.803c19.511,19.517,44.777,29.27,75.801,29.27   c35.976,0,70.71-12.467,104.212-37.407l191.574,191.579c5.332,5.328,11.796,7.994,19.417,7.994c7.991,0,15.704-3.72,23.12-11.14   c7.426-7.426,11.143-15.129,11.143-23.127c0-7.617-2.666-14.092-7.994-19.417l-62.811-62.811l27.405-27.404   C411.699,324.195,414.033,326.666,418.119,331.046z M221.556,161.458c-10.656,10.657-23.601,15.987-38.828,15.987   c-7.996,0-15.896-1.812-23.7-5.43c3.617,7.808,5.426,15.706,5.426,23.7c0,15.229-5.327,28.171-15.987,38.828   c-10.66,10.655-23.606,15.986-38.831,15.986c-15.227,0-28.168-5.325-38.828-15.986c-10.657-10.657-15.987-23.599-15.987-38.828   c0-15.227,5.327-28.171,15.987-38.828C81.464,146.23,94.409,140.9,109.636,140.9c7.992,0,15.893,1.809,23.695,5.424   c-3.616-7.804-5.424-15.706-5.424-23.699c0-15.227,5.327-28.171,15.987-38.828c10.66-10.657,23.604-15.987,38.831-15.987   c15.227,0,28.171,5.327,38.828,15.987c10.657,10.66,15.987,23.601,15.987,38.828C237.539,137.852,232.209,150.797,221.556,161.458z   " fill="#ff8345"/>
</g>
</svg>
<svg id="uk_sym" viewBox="0 0 490 490" style="enable-background:new 0 0 490 490;" >
<g>
	<polygon points="236.99,11.41 0,246.348 236.99,478.678 236.99,350.609 129.864,245 236.99,139.391  " fill="#0064fb"/>
<polygon points="253.01,478.59 490,243.651 253.01,11.322 253.01,139.391 360.136,245 253.01,350.609  " fill="#0064fb"/>
</g>
</svg>
<svg id="link_sym" viewBox="0 0 1000 900" style="enable-background:new 0 0 1000 900;" >
<g>
<path fill="black" d="M660.224 422.656c6.976 16.192-0.512 35.008-16.768 42.048-16.128 6.976-34.944-0.448-41.984-16.768-8.448-19.776-20.736-37.696-36.224-53.248-64.64-64.64-177.344-64.64-241.92 0l-145.216 145.28c-66.688 66.688-66.688 175.232 0 241.984 66.688 66.688 175.104 66.752 241.92 0l92.8-92.864c12.48-12.48 32.768-12.48 45.248 0s12.48 32.768 0 45.248l-92.8 92.864c-91.648 91.648-240.832 91.52-332.416 0-91.712-91.648-91.712-240.832 0-332.48l145.216-145.28c44.352-44.416 103.424-68.864 166.272-68.864s121.792 24.448 166.208 68.864c21.248 21.312 38.016 45.952 49.664 73.216zM891.136 401.344l-145.216 145.216c-88.768 88.832-243.712 88.832-332.416 0-21.312-21.312-38.080-45.952-49.728-73.216-7.040-16.256 0.448-35.072 16.704-42.048 16.064-6.784 35.008 0.512 41.984 16.768 8.512 19.776 20.8 37.696 36.288 53.248 64.64 64.64 177.344 64.64 241.92 0l145.216-145.216c66.688-66.688 66.688-175.232 0-241.984-66.752-66.624-175.168-66.688-241.92 0l-92.8 92.864c-12.48 12.48-32.768 12.48-45.248 0s-12.48-32.768 0-45.248l92.8-92.864c45.824-45.824 105.984-68.736 166.208-68.736s120.448 22.912 166.272 68.736c91.584 91.648 91.584 240.768-0.064 332.48z" />
</g>
</svg>
<clipPath clipPathUnits="userSpaceOnUse" id="clipPath4_0_">
<rect x="0" y="0" width="253" height="140" />
</clipPath>
<clipPath clipPathUnits="userSpaceOnUse" id="clipPath7_0_">
<rect x="0" y="0" width="235" height="127" />
</clipPath>
<clipPath clipPathUnits="userSpaceOnUse" id="clipPath8_0_">
<rect x="0" y="0" width="204" height="110" />
</clipPath>
<clipPath clipPathUnits="userSpaceOnUse" id="clipPath3_0_">
<rect x="0" y="0" width="266" height="127" />
</clipPath>
<clipPath clipPathUnits="userSpaceOnUse" id="clipPath5_0_">
<rect x="0" y="0" width="306" height="142" />
</clipPath>
<clipPath clipPathUnits="userSpaceOnUse" id="clipPath6_0_">
<rect x="0" y="0" width="263" height="139" />
</clipPath>
<clipPath clipPathUnits="userSpaceOnUse" id="clipPath2_0_">
<rect x="0" y="0" width="233" height="137" />
</clipPath>
<clipPath clipPathUnits="userSpaceOnUse" id="clipPath1_0_">
<rect x="0" y="0" width="234" height="118" />
</clipPath>
</defs>
<g stroke-linecap="butt" >
<path stroke="rgb(0,0,0)" fill="none" stroke-opacity="1.0"  stroke-width="1" d="M483 307 L578 307" />
<polygon stroke="rgb(0,0,0)" stroke-dasharray="none" points="483 307 489 304 489 310" fill="rgb(0,0,0)" stroke-width="1" stroke-opacity="1.0"  />
<path stroke-dasharray="none" d=" M578.0 313.0 L566.0 307.0 L578.0 301.0 M563.0 311.0 L557.0 303.0 M557.0 311.0 L563.0 303.0" fill="none" stroke-width="1" stroke-opacity="1.0" stroke="rgb(0,0,0)" />
</g>
<g stroke-linecap="butt" >
<path stroke="rgb(0,0,0)" fill="none" stroke-opacity="1.0"  stroke-width="1" d="M130 390 L130 172" />
<polygon stroke="rgb(0,0,0)" stroke-dasharray="none" points="130 390 127 384 133 384" fill="rgb(0,0,0)" stroke-width="1" stroke-opacity="1.0"  />
<path stroke-dasharray="none" d="M136.0 172.0 L130.0 184.0 L124.0 172.0 M136.0 184.5999994277954 L124.0 184.5999994277954" fill="none" stroke-width="1" stroke-opacity="1.0" stroke="rgb(0,0,0)" />
</g>
<g stroke-linecap="butt" >
<path stroke="rgb(0,0,0)" fill="none" stroke-opacity="1.0"  stroke-width="1" d="M590 467 L519 467" />
<polygon stroke="rgb(0,0,0)" stroke-dasharray="none" points="590 467 584 470 584 464" fill="rgb(0,0,0)" stroke-width="1" stroke-opacity="1.0"  />
</g>
<g stroke-linecap="butt" >
<path stroke="rgb(0,0,0)" fill="none" stroke-opacity="1.0"  stroke-width="1" d="M408 240 L408 162" />
<polygon stroke="rgb(0,0,0)" stroke-dasharray="none" points="408 240 405 234 411 234" fill="rgb(0,0,0)" stroke-width="1" stroke-opacity="1.0"  />
</g>
<g stroke-linecap="butt" >
<path stroke="rgb(0,0,0)" fill="none" stroke-opacity="1.0"  stroke-width="1" d="M692 412 L692 345" />
<polygon stroke="rgb(0,0,0)" stroke-dasharray="none" points="692 412 689 406 695 406" fill="rgb(0,0,0)" stroke-width="1" stroke-opacity="1.0"  />
<path stroke-dasharray="none" d=" M698.0 345.0 L692.0 357.0 L686.0 345.0 M696.0 360.0 L688.0 366.0 M696.0 366.0 L688.0 360.0" fill="none" stroke-width="1" stroke-opacity="1.0" stroke="rgb(0,0,0)" />
</g>
<g stroke-linecap="butt" >
<path stroke="rgb(0,0,0)" fill="none" stroke-opacity="1.0"  stroke-width="1" d="M262 240 L262 172" />
<polygon stroke="rgb(0,0,0)" stroke-dasharray="none" points="262 240 259 234 265 234" fill="rgb(0,0,0)" stroke-width="1" stroke-opacity="1.0"  />
<path stroke-dasharray="none" d="M268.0 172.0 L262.0 184.0 L256.0 172.0 M268.0 184.5999994277954 L256.0 184.5999994277954" fill="none" stroke-width="1" stroke-opacity="1.0" stroke="rgb(0,0,0)" />
</g>
<g stroke-linecap="butt" >
<path stroke="rgb(0,0,0)" fill="none" stroke-opacity="1.0"  stroke-width="1" d="M794 467 L845 467" />
<polygon stroke="rgb(0,0,0)" stroke-dasharray="none" points="794 467 800 464 800 470" fill="rgb(0,0,0)" stroke-width="1" stroke-opacity="1.0"  />
</g>
<g  fill="rgb(255,255,180)" stroke="rgb(0,0,255)" fill-opacity="1.0" stroke-opacity="1.0" clip-path="url(#clipPath4_0_)" transform="translate(4,390)" >
<rect x="0" y="0" width="252" height="139" />
<text id="Playlist" x="108" y="14" fill="rgb(0,0,255)" font-weight="bold"  fill-opacity="1.0" font-size="10" stroke="none">
Playlist
</text>
<line x1="0" y1="18" x2="251" y2="18" fill="none" stroke="rgb(0,0,255)"/>
<text x="16" y="32" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="32" fill="rgb(0,0,255)" fill-opacity="1.0" font-size="10" stroke="none">
P
</text>
<text x="26" y="32" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
playlist_unique_id
</text>
<text x="133" y="32" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (256 CHAR)
</text>
<text x="16" y="46" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="26" y="46" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
playlist_id
</text>
<text x="133" y="46" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (256 CHAR)
</text>
<text x="16" y="60" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="60" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
number_elements
</text>
<text x="133" y="60" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<text x="16" y="74" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="74" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
times_requested
</text>
<text x="133" y="74" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<text x="16" y="88" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="88" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
playlist_quality
</text>
<text x="133" y="88" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<text x="16" y="102" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="102" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
playlist_format
</text>
<text x="133" y="102" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<line x1="0" y1="108" x2="251" y2="108" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#pk_sym" x="4" y="115" width="8" height="8" fill-opacity="1.0"/>
<text x="16" y="122" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Playlist_PK (playlist_unique_id)
</text>
</g>
<g  fill="rgb(255,255,180)" stroke="rgb(0,0,255)" fill-opacity="1.0" stroke-opacity="1.0" clip-path="url(#clipPath7_0_)" transform="translate(284,402)" >
<rect x="0" y="0" width="234" height="126" />
<text id="Statistics" x="94" y="14" fill="rgb(0,0,255)" font-weight="bold"  fill-opacity="1.0" font-size="10" stroke="none">
Statistics
</text>
<line x1="0" y1="18" x2="233" y2="18" fill="none" stroke="rgb(0,0,255)"/>
<text x="16" y="32" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="32" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
lang
</text>
<text x="124" y="32" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (5 CHAR)
</text>
<text x="16" y="46" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="46" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
downloads
</text>
<text x="124" y="46" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<text x="16" y="60" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="60" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
last_time_active
</text>
<text x="124" y="60" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
DATE
</text>
<text x="16" y="74" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="74" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
F
</text>
<text x="26" y="74" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
User_user_id
</text>
<text x="124" y="74" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<line x1="0" y1="80" x2="233" y2="80" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#fk_sym" x="4" y="87" width="8" height="8" fill-opacity="1.0"/><a xlink:href="#User" >
<text x="16" y="94" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Statistics_User_FK (User_user_id)
</text></a>
<line x1="0" y1="100" x2="233" y2="100" fill="none" stroke="rgb(0,0,255)"/>
<text x="2" y="114" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
U
</text>
<text x="16" y="114" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Statistics__IDX (User_user_id)
</text>
</g>
<g  fill="rgb(255,255,180)" stroke="rgb(0,0,255)" fill-opacity="1.0" stroke-opacity="1.0" clip-path="url(#clipPath8_0_)" transform="translate(590,412)" >
<rect x="0" y="0" width="203" height="109" />
<text id="User" x="90" y="14" fill="rgb(0,0,255)" font-weight="bold"  fill-opacity="1.0" font-size="10" stroke="none">
User
</text>
<line x1="0" y1="18" x2="202" y2="18" fill="none" stroke="rgb(0,0,255)"/>
<text x="16" y="32" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="32" fill="rgb(0,0,255)" fill-opacity="1.0" font-size="10" stroke="none">
P
</text>
<text x="26" y="32" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
user_id
</text>
<text x="84" y="32" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<text x="16" y="46" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="46" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
username
</text>
<text x="84" y="46" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (45 CHAR)
</text>
<text x="16" y="60" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="60" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
name
</text>
<text x="84" y="60" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
CLOB
</text>
<text x="16" y="74" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="74" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
first_use
</text>
<text x="84" y="74" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
DATE
</text>
<line x1="0" y1="80" x2="202" y2="80" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#pk_sym" x="4" y="87" width="8" height="8" fill-opacity="1.0"/>
<text x="16" y="94" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
User_PK (user_id)
</text>
</g>
<g  fill="rgb(255,255,180)" stroke="rgb(0,0,255)" fill-opacity="1.0" stroke-opacity="1.0" clip-path="url(#clipPath3_0_)" transform="translate(217,240)" >
<rect x="0" y="0" width="265" height="126" />
<text id="Music" x="118" y="14" fill="rgb(0,0,255)" font-weight="bold"  fill-opacity="1.0" font-size="10" stroke="none">
Music
</text>
<line x1="0" y1="18" x2="264" y2="18" fill="none" stroke="rgb(0,0,255)"/>
<text x="16" y="32" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="32" fill="rgb(0,0,255)" fill-opacity="1.0" font-size="10" stroke="none">
P
</text>
<text x="26" y="32" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
file_id
</text>
<text x="146" y="32" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (256 CHAR)
</text>
<text x="16" y="46" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="46" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
video_id
</text>
<text x="146" y="46" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (20 CHAR)
</text>
<text x="16" y="60" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="60" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
audio_quality
</text>
<text x="146" y="60" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<text x="16" y="74" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="74" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
audio_format
</text>
<text x="146" y="74" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<text x="16" y="88" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="88" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
times_requested
</text>
<text x="146" y="88" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<text x="16" y="102" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="102" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
is_metadata_by_user
</text>
<text x="146" y="102" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
CHAR (1)
</text>
<line x1="0" y1="108" x2="264" y2="108" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#pk_sym" x="4" y="115" width="8" height="8" fill-opacity="1.0"/>
<text x="16" y="122" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Music_PK (file_id)
</text>
</g>
<g  fill="rgb(255,255,180)" stroke="rgb(0,0,255)" fill-opacity="1.0" stroke-opacity="1.0" clip-path="url(#clipPath5_0_)" transform="translate(2,30)" >
<rect x="0" y="0" width="305" height="141" />
<text id="Playlist_has_Music" x="105" y="14" fill="rgb(0,0,255)" font-weight="bold"  fill-opacity="1.0" font-size="10" stroke="none">
Playlist_has_Music
</text>
<line x1="0" y1="18" x2="304" y2="18" fill="none" stroke="rgb(0,0,255)"/>
<text x="16" y="32" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="32" fill="rgb(0,0,255)" fill-opacity="1.0" font-size="10" stroke="none">
PF
</text>
<text x="26" y="32" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
playlist_unique_id
</text>
<text x="133" y="32" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (256 CHAR)
</text>
<text x="16" y="46" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="46" fill="rgb(0,0,255)" fill-opacity="1.0" font-size="10" stroke="none">
PF
</text>
<text x="26" y="46" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Music_file_id
</text>
<text x="133" y="46" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (256 CHAR)
</text>
<line x1="0" y1="52" x2="304" y2="52" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#pk_sym" x="4" y="59" width="8" height="8" fill-opacity="1.0"/>
<text x="16" y="66" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Playlist_has_Music_PK (Music_file_id, playlist_unique_id)
</text>
<line x1="0" y1="72" x2="304" y2="72" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#fk_sym" x="4" y="79" width="8" height="8" fill-opacity="1.0"/><a xlink:href="#Playlist" >
<text x="16" y="86" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Playlist_has_Music_Playlist_FK (playlist_unique_id)
</text></a>
<use xlink:href="#fk_sym" x="4" y="93" width="8" height="8" fill-opacity="1.0"/><a xlink:href="#Music" >
<text x="16" y="100" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Playlist_has_Music_Music_FK (Music_file_id)
</text></a>
</g>
<g  fill="rgb(255,255,180)" stroke="rgb(0,0,255)" fill-opacity="1.0" stroke-opacity="1.0" clip-path="url(#clipPath6_0_)" transform="translate(845,396)" >
<rect x="0" y="0" width="262" height="138" />
<text id="Preferences" x="101" y="14" fill="rgb(0,0,255)" font-weight="bold"  fill-opacity="1.0" font-size="10" stroke="none">
Preferences
</text>
<line x1="0" y1="18" x2="261" y2="18" fill="none" stroke="rgb(0,0,255)"/>
<text x="16" y="32" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="32" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
audio_quality
</text>
<text x="148" y="32" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (5 CHAR)
</text>
<text x="16" y="46" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="46" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
audio_format
</text>
<text x="148" y="46" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (5 CHAR)
</text>
<text x="16" y="60" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="60" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
os
</text>
<text x="148" y="60" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (10 CHAR)
</text>
<text x="16" y="74" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="74" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
should_ask_metadata
</text>
<text x="148" y="74" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
CHAR (1)
</text>
<text x="16" y="88" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="88" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
F
</text>
<text x="26" y="88" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
User_user_id
</text>
<text x="148" y="88" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<line x1="0" y1="94" x2="261" y2="94" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#fk_sym" x="4" y="101" width="8" height="8" fill-opacity="1.0"/><a xlink:href="#User" >
<text x="16" y="108" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Preferences_User_FK (User_user_id)
</text></a>
<line x1="0" y1="114" x2="261" y2="114" fill="none" stroke="rgb(0,0,255)"/>
<text x="2" y="128" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
U
</text>
<text x="16" y="128" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Preferences__IDX (User_user_id)
</text>
</g>
<g  fill="rgb(255,255,180)" stroke="rgb(0,0,255)" fill-opacity="1.0" stroke-opacity="1.0" clip-path="url(#clipPath2_0_)" transform="translate(333,25)" >
<rect x="0" y="0" width="232" height="136" />
<text id="Metadata" x="94" y="14" fill="rgb(0,0,255)" font-weight="bold"  fill-opacity="1.0" font-size="10" stroke="none">
Metadata
</text>
<line x1="0" y1="18" x2="231" y2="18" fill="none" stroke="rgb(0,0,255)"/>
<text x="16" y="32" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="32" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
title
</text>
<text x="110" y="32" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (256 CHAR)
</text>
<text x="16" y="46" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="46" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
artist
</text>
<text x="110" y="46" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (256 CHAR)
</text>
<text x="16" y="60" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="60" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
cover
</text>
<text x="110" y="60" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
CLOB
</text>
<text x="16" y="74" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">

</text>
<text x="26" y="74" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
duration
</text>
<text x="110" y="74" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (20 CHAR)
</text>
<text x="16" y="88" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="88" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
F
</text>
<text x="26" y="88" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Music_file_id
</text>
<text x="110" y="88" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (256 CHAR)
</text>
<line x1="0" y1="94" x2="231" y2="94" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#fk_sym" x="4" y="101" width="8" height="8" fill-opacity="1.0"/><a xlink:href="#Music" >
<text x="16" y="108" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Metadata_Music_FK (Music_file_id)
</text></a>
<line x1="0" y1="114" x2="231" y2="114" fill="none" stroke="rgb(0,0,255)"/>
<text x="2" y="128" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
U
</text>
<text x="16" y="128" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Metadata__IDX (Music_file_id)
</text>
</g>
<g  fill="rgb(255,255,180)" stroke="rgb(0,0,255)" fill-opacity="1.0" stroke-opacity="1.0" clip-path="url(#clipPath1_0_)" transform="translate(578,227)" >
<rect x="0" y="0" width="233" height="117" />
<text id="History" x="100" y="14" fill="rgb(0,0,255)" font-weight="bold"  fill-opacity="1.0" font-size="10" stroke="none">
History
</text>
<line x1="0" y1="18" x2="232" y2="18" fill="none" stroke="rgb(0,0,255)"/>
<text x="16" y="32" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="32" fill="rgb(0,0,255)" fill-opacity="1.0" font-size="10" stroke="none">
PF
</text>
<text x="26" y="32" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
User_user_id
</text>
<text x="110" y="32" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
INTEGER
</text>
<text x="16" y="46" fill="rgb(255,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
*
</text>
<text x="2" y="46" fill="rgb(0,0,255)" fill-opacity="1.0" font-size="10" stroke="none">
PF
</text>
<text x="26" y="46" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
Music_file_id
</text>
<text x="110" y="46" fill="rgb(0,128,0)" fill-opacity="1.0" font-size="10" stroke="none">
VARCHAR2 (256 CHAR)
</text>
<line x1="0" y1="52" x2="232" y2="52" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#pk_sym" x="4" y="59" width="8" height="8" fill-opacity="1.0"/>
<text x="16" y="66" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
History_PK (User_user_id, Music_file_id)
</text>
<line x1="0" y1="72" x2="232" y2="72" fill="none" stroke="rgb(0,0,255)"/>
<use xlink:href="#fk_sym" x="4" y="79" width="8" height="8" fill-opacity="1.0"/><a xlink:href="#User" >
<text x="16" y="86" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
History_User_FK (User_user_id)
</text></a>
<use xlink:href="#fk_sym" x="4" y="93" width="8" height="8" fill-opacity="1.0"/><a xlink:href="#Music" >
<text x="16" y="100" fill="rgb(0,0,0)" fill-opacity="1.0" font-size="10" stroke="none">
History_Music_FK (Music_file_id)
</text></a>
</g>

</svg>