· 6 years ago · May 15, 2019, 08:40 AM
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema fudbalski_klub
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema fudbalski_klub
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `fudbalski_klub` DEFAULT CHARACTER SET utf8 ;
18USE `fudbalski_klub` ;
19
20-- -----------------------------------------------------
21-- Table `fudbalski_klub`.`grad`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `fudbalski_klub`.`grad` (
24 `GradID` INT(11) NOT NULL AUTO_INCREMENT,
25 `GradNaziv` VARCHAR(100) NOT NULL,
26 `PozivniBroj` VARCHAR(10) NOT NULL,
27 `PostanskiBroj` VARCHAR(10) NULL DEFAULT NULL,
28 `BrojStanovnika` INT(11) NULL DEFAULT NULL,
29 PRIMARY KEY (`GradID`))
30ENGINE = InnoDB
31AUTO_INCREMENT = 11
32DEFAULT CHARACTER SET = utf8;
33
34
35-- -----------------------------------------------------
36-- Table `fudbalski_klub`.`stadion`
37-- -----------------------------------------------------
38CREATE TABLE IF NOT EXISTS `fudbalski_klub`.`stadion` (
39 `StadionID` INT(11) NOT NULL AUTO_INCREMENT,
40 `GradID` INT(11) NULL DEFAULT NULL,
41 `NazivStadiona` VARCHAR(50) NOT NULL,
42 `AdresaStadiona` VARCHAR(150) NULL DEFAULT NULL,
43 `Kapacitet` INT(11) NULL DEFAULT NULL,
44 `BrojUlaza` INT(11) NULL DEFAULT NULL,
45 PRIMARY KEY (`StadionID`),
46 INDEX `FK_STADION_STADION2G_GRAD` (`GradID` ASC) VISIBLE,
47 CONSTRAINT `FK_STADION_STADION2G_GRAD`
48 FOREIGN KEY (`GradID`)
49 REFERENCES `fudbalski_klub`.`grad` (`GradID`)
50 ON DELETE RESTRICT
51 ON UPDATE RESTRICT)
52ENGINE = InnoDB
53AUTO_INCREMENT = 11
54DEFAULT CHARACTER SET = utf8;
55
56
57-- -----------------------------------------------------
58-- Table `fudbalski_klub`.`klub`
59-- -----------------------------------------------------
60CREATE TABLE IF NOT EXISTS `fudbalski_klub`.`klub` (
61 `KlubID` INT(11) NOT NULL AUTO_INCREMENT,
62 `StadionID` INT(11) NULL DEFAULT NULL,
63 `GradID` INT(11) NULL DEFAULT NULL,
64 `NazivKluba` VARCHAR(150) NOT NULL,
65 `AdresaKluba` VARCHAR(150) NULL DEFAULT NULL,
66 `TelefonKluba` VARCHAR(50) NULL DEFAULT NULL,
67 `EmailKluba` VARCHAR(50) NULL DEFAULT NULL,
68 `SajtKluba` VARCHAR(50) NULL DEFAULT NULL,
69 `ZiroRacun` VARCHAR(100) NULL DEFAULT NULL,
70 `BojeKluba` VARCHAR(100) NULL DEFAULT NULL,
71 PRIMARY KEY (`KlubID`),
72 INDEX `FK_KLUB_KLUB2GRAD_GRAD` (`GradID` ASC) VISIBLE,
73 INDEX `FK_KLUB_KLUB2STAD_STADION` (`StadionID` ASC) VISIBLE,
74 CONSTRAINT `FK_KLUB_KLUB2GRAD_GRAD`
75 FOREIGN KEY (`GradID`)
76 REFERENCES `fudbalski_klub`.`grad` (`GradID`)
77 ON DELETE RESTRICT
78 ON UPDATE RESTRICT,
79 CONSTRAINT `FK_KLUB_KLUB2STAD_STADION`
80 FOREIGN KEY (`StadionID`)
81 REFERENCES `fudbalski_klub`.`stadion` (`StadionID`)
82 ON DELETE RESTRICT
83 ON UPDATE RESTRICT)
84ENGINE = InnoDB
85AUTO_INCREMENT = 3
86DEFAULT CHARACTER SET = utf8;
87
88
89-- -----------------------------------------------------
90-- Table `fudbalski_klub`.`pozicijaigraca`
91-- -----------------------------------------------------
92CREATE TABLE IF NOT EXISTS `fudbalski_klub`.`pozicijaigraca` (
93 `PozicijaID` INT(11) NOT NULL AUTO_INCREMENT,
94 `NazivPozicije` VARCHAR(50) NOT NULL,
95 `OpisPozicije` VARCHAR(250) NULL DEFAULT NULL,
96 PRIMARY KEY (`PozicijaID`))
97ENGINE = InnoDB
98DEFAULT CHARACTER SET = utf8;
99
100
101-- -----------------------------------------------------
102-- Table `fudbalski_klub`.`igrac`
103-- -----------------------------------------------------
104CREATE TABLE IF NOT EXISTS `fudbalski_klub`.`igrac` (
105 `IgracID` INT(11) NOT NULL AUTO_INCREMENT,
106 `PozicijaID` INT(11) NULL DEFAULT NULL,
107 `KlubID` INT(11) NULL DEFAULT NULL,
108 `ImeIgraca` VARCHAR(100) NOT NULL,
109 `PrezimeIgraca` VARCHAR(100) NOT NULL,
110 `DatumRodjenja` DATE NULL DEFAULT NULL,
111 `TelefonIgraca` VARCHAR(50) NULL DEFAULT NULL,
112 PRIMARY KEY (`IgracID`),
113 INDEX `FK_IGRAC_IGRAC2KLU_KLUB` (`KlubID` ASC) VISIBLE,
114 INDEX `FK_IGRAC_IGRAC2POZ_POZICIJA` (`PozicijaID` ASC) VISIBLE,
115 CONSTRAINT `FK_IGRAC_IGRAC2KLU_KLUB`
116 FOREIGN KEY (`KlubID`)
117 REFERENCES `fudbalski_klub`.`klub` (`KlubID`)
118 ON DELETE RESTRICT
119 ON UPDATE RESTRICT,
120 CONSTRAINT `FK_IGRAC_IGRAC2POZ_POZICIJA`
121 FOREIGN KEY (`PozicijaID`)
122 REFERENCES `fudbalski_klub`.`pozicijaigraca` (`PozicijaID`)
123 ON DELETE RESTRICT
124 ON UPDATE RESTRICT)
125ENGINE = InnoDB
126DEFAULT CHARACTER SET = utf8;
127
128
129-- -----------------------------------------------------
130-- Table `fudbalski_klub`.`Utakmica`
131-- -----------------------------------------------------
132CREATE TABLE IF NOT EXISTS `fudbalski_klub`.`Utakmica` (
133 `idUtakmica` INT NOT NULL AUTO_INCREMENT,
134 `domacin` VARCHAR(45) NULL,
135 `gost` VARCHAR(45) NULL,
136 `datum` DATE NULL,
137 `vreme` TIME NULL,
138 `liga` VARCHAR(45) NULL,
139 PRIMARY KEY (`idUtakmica`))
140ENGINE = InnoDB;
141
142
143-- -----------------------------------------------------
144-- Table `fudbalski_klub`.`Statistika`
145-- -----------------------------------------------------
146CREATE TABLE IF NOT EXISTS `fudbalski_klub`.`Statistika` (
147 `Utakmica_idUtakmica` INT NOT NULL,
148 `igrac_IgracID` INT(11) NOT NULL,
149 `golovi` INT NULL,
150 `crveni` INT NULL,
151 `zuti` INT NULL,
152 `igracFauli` INT NULL,
153 `faulNadIgracem` INT NULL,
154 PRIMARY KEY (`Utakmica_idUtakmica`, `igrac_IgracID`),
155 INDEX `fk_Utakmica_has_igrac_igrac1_idx` (`igrac_IgracID` ASC) VISIBLE,
156 INDEX `fk_Utakmica_has_igrac_Utakmica1_idx` (`Utakmica_idUtakmica` ASC) VISIBLE,
157 CONSTRAINT `fk_Utakmica_has_igrac_Utakmica1`
158 FOREIGN KEY (`Utakmica_idUtakmica`)
159 REFERENCES `fudbalski_klub`.`Utakmica` (`idUtakmica`)
160 ON DELETE NO ACTION
161 ON UPDATE NO ACTION,
162 CONSTRAINT `fk_Utakmica_has_igrac_igrac1`
163 FOREIGN KEY (`igrac_IgracID`)
164 REFERENCES `fudbalski_klub`.`igrac` (`IgracID`)
165 ON DELETE NO ACTION
166 ON UPDATE NO ACTION)
167ENGINE = InnoDB;
168
169
170SET SQL_MODE=@OLD_SQL_MODE;
171SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
172SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;