Notes

CREATE TABLE Usuario (
id_usuario varchar(100),
password varchar(100) ,
email varchar(100) ,
edad numeric(100.0) ,
pais varchar(50) ,
PRIMARY KEY (id_usuario)
);


CREATE TABLE Playlist (
id_playlist varchar(100) ,
nomb_playlist varchar(50) ,
id_usuario varchar(100) ,
id_album varchar(100) ,
PRIMARY KEY (id_playlist)
);

CREATE INDEX ON Playlist
(id_usuario);
CREATE INDEX ON Playlist
(id_album);


CREATE TABLE Cancion_PlayList (
id_playlist varchar(100) NOT NULL,
id_cancion varchar(100) NOT NULL
);

CREATE INDEX ON Cancion_PlayList
(id_playlist);
CREATE INDEX ON Cancion_PlayList
(id_cancion);


CREATE TABLE Cancion (
id_cancion varchar(100) NOT NULL,
id_album varchar(80) NOT NULL,
nombre_cancion varchar(30) NOT NULL,
cod_genero numeric(10.0) NOT NULL,
PRIMARY KEY (id_cancion)
);

CREATE INDEX ON Cancion
(id_album);
CREATE INDEX ON Cancion
(cod_genero);


CREATE TABLE Letra (
id_letra varchar(100) NOT NULL,
id_cancion varchar(100) NOT NULL,
cod_idioma numeric(10.0) NOT NULL,
PRIMARY KEY (id_letra)
);

CREATE INDEX ON Letra
(id_cancion);
CREATE INDEX ON Letra
(cod_idioma);


CREATE TABLE Linea (
id_linea varchar(200) NOT NULL,
id_cancion varchar(100) NOT NULL,
orden numeric(200.0) NOT NULL,
frase varchar(500) NOT NULL,
inicio_linea varchar(100) NOT NULL,
fin_linea varchar(100) NOT NULL,
PRIMARY KEY (id_linea)
);

CREATE INDEX ON Linea
(id_cancion);


CREATE TABLE Artista (
id_artista varchar(100) NOT NULL,
nomb_artista varchar(30) NOT NULL,
pais varchar(50) NOT NULL,
cod_genero numeric(10.0) NOT NULL,
id_album varchar(100) NOT NULL,
PRIMARY KEY (id_artista)
);

CREATE INDEX ON Artista
(cod_genero);
CREATE INDEX ON Artista
(id_album);


CREATE TABLE Genero (
cod_genero numeric(10.0) NOT NULL,
tipo_genero varchar(30) NOT NULL,
id_cancion varchar(100) NOT NULL,
id_artista varchar(100) NOT NULL,
PRIMARY KEY (cod_genero)
);

CREATE INDEX ON Genero
(id_cancion);
CREATE INDEX ON Genero
(id_artista);


CREATE TABLE Album (
id_album varchar(100) NOT NULL,
nomb_album varchar(100) NOT NULL,
id_artista varchar(100) NOT NULL,
id_cancion varchar(100) NOT NULL,
PRIMARY KEY (id_album)
);

CREATE INDEX ON Album
(id_artista);
CREATE INDEX ON Album
(id_cancion);





CREATE TABLE Top (
id_top varchar(100) NOT NULL,
tipo_top numeric(3.0) NOT NULL,
id_tipo_top varchar(50) NOT NULL,
orden numeric(100.0) NOT NULL,
PRIMARY KEY (id_top)
);