Slide 21
Slide 21 text
Passo 2: Criar o Modelo de Dados
-- create_db.sql
CREATE DATABASE TEST;
-- create_movies.sql
CREATE TABLE MOVIES(
id varchar(255),
title varchar(255),
genre varchar(255),
PRIMARY KEY (id));
-- create_ratings.sql
CREATE TABLE RATINGS(
userId varchar(255),
movieId varchar(255),
rating float,
PRIMARY KEY (userId, movieId),
FOREIGN KEY (movieId) REFERENCES MOVIES(id));
-- create_recommendations.sql
CREATE TABLE RECOMMENDATIONS(
userId varchar(255),
movieId varchar(255),
prediction float,
PRIMARY KEY (userId, movieId),
FOREIGN KEY (userId,movieId)
REFERENCES RATINGS(userId,movieId));