UqE2cDgk

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema baza_b22
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `baza_b22` ;
14
15-- -----------------------------------------------------
16-- Schema baza_b22
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `baza_b22` DEFAULT CHARACTER SET utf8mb4 ;
19USE `baza_b22` ;
20
21-- -----------------------------------------------------
22-- Table `baza_b22`.`angazman`
23-- -----------------------------------------------------
24CREATE TABLE IF NOT EXISTS `baza_b22`.`angazman` (
25  `RadnikID` INT(11) NULL,
26  `ProjekatID` INT(11) NULL DEFAULT NULL,
27  `DatumAngazovanja` VARCHAR(19) NULL DEFAULT NULL,
28  `BrojSati` VARCHAR(4) NULL DEFAULT NULL,
29  `OpisPosla` VARCHAR(10) NULL DEFAULT NULL)
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `baza_b22`.`istorija_rm_radnika`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `baza_b22`.`istorija_rm_radnika` (
37  `RadnikID` INT(11) NULL DEFAULT NULL,
38  `RadnoMestoID` INT(11) NULL DEFAULT NULL,
39  `DatumPocetka` VARCHAR(19) NULL DEFAULT NULL,
40  `DatumZavrsetka` VARCHAR(19) NULL DEFAULT NULL)
41ENGINE = InnoDB;
42
43
44-- -----------------------------------------------------
45-- Table `baza_b22`.`kvalifikacija`
46-- -----------------------------------------------------
47CREATE TABLE IF NOT EXISTS `baza_b22`.`kvalifikacija` (
48  `KvalifikacijaID` INT(11) NULL DEFAULT NULL,
49  `Naziv` VARCHAR(6) NULL DEFAULT NULL,
50  `Koeficijent` DECIMAL(2,1) NULL DEFAULT NULL)
51ENGINE = InnoDB;
52
53
54-- -----------------------------------------------------
55-- Table `baza_b22`.`projekat`
56-- -----------------------------------------------------
57CREATE TABLE IF NOT EXISTS `baza_b22`.`projekat` (
58  `ProjekatID` INT(11) NULL DEFAULT NULL,
59  `Naziv` VARCHAR(18) NULL DEFAULT NULL,
60  `DatumPocetka` VARCHAR(19) NULL DEFAULT NULL,
61  `Budzet` INT(11) NULL DEFAULT NULL,
62  `ProjekatZavrsen` VARCHAR(5) NULL DEFAULT NULL,
63  `Opis` VARCHAR(21) NULL DEFAULT NULL)
64ENGINE = InnoDB;
65
66
67-- -----------------------------------------------------
68-- Table `baza_b22`.`radnik`
69-- -----------------------------------------------------
70CREATE TABLE IF NOT EXISTS `baza_b22`.`radnik` (
71  `RadnikID` INT(11) NULL DEFAULT NULL,
72  `Ime` VARCHAR(10) NULL DEFAULT NULL,
73  `Prezime` VARCHAR(10) NULL DEFAULT NULL,
74  `Datum Rodjenja` VARCHAR(19) NULL DEFAULT NULL,
75  `Datum Zaposlenja` VARCHAR(19) NULL DEFAULT NULL,
76  `KvalifikacijaID` INT(11) NULL DEFAULT NULL,
77  `Telefon` VARCHAR(12) NULL DEFAULT NULL)
78ENGINE = InnoDB;
79
80
81-- -----------------------------------------------------
82-- Table `baza_b22`.`radno_mesto`
83-- -----------------------------------------------------
84CREATE TABLE IF NOT EXISTS `baza_b22`.`radno_mesto` (
85  `RadnoMestoID` INT(11) NULL DEFAULT NULL,
86  `Naziv` VARCHAR(21) NULL DEFAULT NULL,
87  `Opis` VARCHAR(10) NULL DEFAULT NULL,
88  `PocetnaPlata` INT(11) NULL DEFAULT NULL,
89  `NajvisaPlata` VARCHAR(5) NULL DEFAULT NULL)
90ENGINE = InnoDB;
91
92
93SET SQL_MODE=@OLD_SQL_MODE;
94SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
95SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;