s8H9KFXV

1CREATE DATABASE IF NOT EXISTS grade_spark;
2
3USE grade_spark;
4
5DROP TABLE IF EXISTS Grade;
6DROP TABLE IF EXISTS Rating;
7DROP TABLE IF EXISTS Prison;
8CREATE TABLE IF NOT EXISTS Prison
9(
10  id varchar(255),
11  states varchar(255),
12  prisons varchar(255),
13  male int,
14  female int,
15  total int,
16  rating int,
17  PRIMARY KEY (ID)
18);
19
20CREATE TABLE  IF NOT EXISTS Rating
21(
22  personId varchar(255),
23  prisonId varchar(255),
24  rating int,
25  PRIMARY KEY(prisonId, personId),
26  FOREIGN KEY (prisonId) 
27    REFERENCES Prison(id)
28);
29
30CREATE TABLE  IF NOT EXISTS Grade
31(
32  personId varchar(255),
33  prisonId varchar(255),
34  prediction float,
35  PRIMARY KEY(personId, prisonId),
36  FOREIGN KEY (prisonId) 
37    REFERENCES Prison(id)
38);