Lab07-CVDS/tables.sql at master · FlypCode/Lab07-CVDS · 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
35
36
37
38
39
40
CREATE TABLE IF NOT EXISTS `VI_CLIENTES` (
  `documento` BIGINT(20) NOT NULL,
  `nombre` VARCHAR(50)  NOT NULL,
  `telefono` VARCHAR(20)  NOT NULL,
  `direccion` VARCHAR(150)  NOT NULL,
  `email` VARCHAR(150)  NOT NULL,
  `vetado` TINYINT(1) NOT NULL);


-- -----------------------------------------------------
-- Table `VI_TIPOITEM`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `VI_TIPOITEM` (
  `id` INT(11) NOT NULL,
  `descripcion` VARCHAR(50)  NOT NULL);


-- -----------------------------------------------------
-- Table `VI_ITEMS`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `VI_ITEMS` (
  `id` INT(11) NOT NULL,
  `nombre` VARCHAR(50)  NOT NULL,
  `descripcion` VARCHAR(500)  NOT NULL,
  `fechalanzamiento` DATE NOT NULL,
  `tarifaxdia` BIGINT(20) NOT NULL,
  `formatorenta` VARCHAR(20) NOT NULL,
  `genero` VARCHAR(20)  NOT NULL,
  `TIPOITEM_id` INT(11) NOT NULL);


-- -----------------------------------------------------
-- Table `VI_ITEMRENTADO`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `VI_ITEMRENTADO` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `CLIENTES_documento` BIGINT(20) NOT NULL,
  `ITEMS_id` INT(11) NOT NULL,
  `fechainiciorenta` DATE NOT NULL,
  `fechafinrenta` DATE NOT NULL);