MadMove/db.sql at master · eli-sr/MadMove · 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
32
33
34
create table LINEAS (
    `line`  char(3) PRIMARY KEY,
    `label` varchar(5),
    `nameA` varchar(30),
    `nameB` varchar(30),
    `group` varchar(3)
);

CREATE TABLE USUARIOS (
    `ID`    INT NOT NULL AUTO_INCREMENT ,
    `USER`  VARCHAR(30) NOT NULL ,
    `PASSWORD`  VARCHAR(30) NOT NULL ,
    `NAME`  VARCHAR(30) NOT NULL ,
    `SURNAME`  VARCHAR(30) NULL ,
    PRIMARY KEY (`ID`)
);

CREATE TABLE PARADAS (
    `id` INT NOT NULL AUTO_INCREMENT ,
    `name` VARCHAR(50) NOT NULL ,
    `lineas` JSON NOT NULL ,
    `geometry` JSON NOT NULL ,
    PRIMARY KEY (`id`)
);

CREATE TABLE RESERVAS (
    `id` INT NOT NULL AUTO_INCREMENT ,
    `date` VARCHAR(20) NOT NULL ,
    `time` VARCHAR(20) NOT NULL,
    `parkingId` INT NOT NULL ,
    `userId` INT NOT NULL ,
    `done` BOOLEAN NOT NULL ,
    PRIMARY KEY (`id`)
);