mirror of
https://grond.iut-fbleau.fr/stiti/SAE_2.02
synced 2024-09-19 11:28:19 +02:00
14 lines
255 B
MySQL
14 lines
255 B
MySQL
|
-- FOURNIT PAR DENIS MONNERAT
|
||
|
|
|
||
|
|
album (id,name,year,#artistid,#genreid,#coverid)
|
||
|
|
--
|
||
|
|
artist (id,name)
|
||
|
|
--
|
||
|
|
track (id,#albumid,#songid,diskNumber,number,duration)
|
||
|
|
--
|
||
|
|
song(id,name)
|
||
|
|
--
|
||
|
|
genre(id,name)
|
||
|
|
--
|
||
|
|
cover(id,jpeg)
|
||
|
|
--
|