BDD2/ScriptBoston.sql at master · FrancoTruffa/BDD2 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
CREATE TABLE `HoraLookup` (
  `idhora` INT NOT NULL,
  `hora` INT NOT NULL);

CREATE TABLE `DistrictoLookup` (
  `iddistricto` INT NOT NULL,
  `districto` VARCHAR(45) NOT NULL);

CREATE TABLE `DiaSemanaLookup` (
  `idDiaSemana` INT NOT NULL,
  `DiaSemana`  VARCHAR(20) NOT NULL);

 CREATE TABLE `FechaLookup` (
  `idFecha` INT NOT NULL,
  `Fecha`  VARCHAR(100) NOT NULL);


 CREATE TABLE `TipoDeDelitoLookup` (
  `idTipoDelito` INT NOT NULL,
  `TipoDelito`  VARCHAR(200) NOT NULL);


 CREATE TABLE `DelitoFact` (
  `idTipoDelito` INT NOT NULL,
  `idFecha` INT NOT NULL,
  `iddistricto` INT NOT NULL,
  `idhora` INT NOT NULL,
  `idDiaSemana` INT NOT NULL,
  `Delito`  VARCHAR(200) NOT NULL);