cKKZ6pp1

1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dec 12, 2017 at 05:23 PM
7-- Server version: 10.1.28-MariaDB
8-- PHP Version: 7.1.11
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15--
16-- Database: `fakultet`
17--
18CREATE DATABASE IF NOT EXISTS `fakultet` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
19USE `fakultet`;
20
21-- --------------------------------------------------------
22
23--
24-- Table structure for table `ispit`
25--
26
27DROP TABLE IF EXISTS `ispit`;
28CREATE TABLE IF NOT EXISTS `ispit` (
29  `id` int(11) NOT NULL AUTO_INCREMENT,
30  `Datum` varchar(50) NOT NULL,
31  `idkolegij` int(11) NOT NULL,
32  `idprofesor` int(11) NOT NULL,
33  `idstudent` int(11) NOT NULL,
34  `iducionica` int(11) NOT NULL,
35  PRIMARY KEY (`id`),
36  KEY `idstudent` (`idstudent`),
37  KEY `idprofesor` (`idprofesor`),
38  KEY `idkolegij` (`idkolegij`),
39  KEY `iducionica` (`iducionica`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `kolegij`
46--
47
48DROP TABLE IF EXISTS `kolegij`;
49CREATE TABLE IF NOT EXISTS `kolegij` (
50  `id` int(11) NOT NULL,
51  `naziv` varchar(200) NOT NULL,
52  `brojSati` int(11) NOT NULL,
53  `godina` int(11) NOT NULL,
54  `IDPROFESOR` int(11) NOT NULL,
55  PRIMARY KEY (`id`),
56  KEY `IDPROFESOR` (`IDPROFESOR`)
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58
59-- --------------------------------------------------------
60
61--
62-- Table structure for table `profesor`
63--
64
65DROP TABLE IF EXISTS `profesor`;
66CREATE TABLE IF NOT EXISTS `profesor` (
67  `id` int(11) NOT NULL AUTO_INCREMENT,
68  `ime` varchar(40) NOT NULL,
69  `prezime` varchar(40) NOT NULL,
70  `titula` varchar(40) NOT NULL,
71  `jmbg` int(11) DEFAULT NULL,
72  PRIMARY KEY (`id`)
73) ENGINE=InnoDB DEFAULT CHARSET=latin1;
74
75-- --------------------------------------------------------
76
77--
78-- Table structure for table `student`
79--
80
81DROP TABLE IF EXISTS `student`;
82CREATE TABLE IF NOT EXISTS `student` (
83  `ID` int(11) NOT NULL,
84  `Ime` varchar(255) NOT NULL,
85  `Prezime` varchar(255) DEFAULT NULL,
86  `BrojIndeksa` varchar(255) DEFAULT NULL,
87  `JMBG` int(11) DEFAULT NULL,
88  PRIMARY KEY (`ID`)
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90
91-- --------------------------------------------------------
92
93--
94-- Table structure for table `studentkolegij`
95--
96
97DROP TABLE IF EXISTS `studentkolegij`;
98CREATE TABLE IF NOT EXISTS `studentkolegij` (
99  `id` int(11) NOT NULL AUTO_INCREMENT,
100  `idstudent` int(11) NOT NULL,
101  `idkolegij` int(11) NOT NULL,
102  PRIMARY KEY (`id`),
103  KEY `idstudent` (`idstudent`),
104  KEY `idkolegij` (`idkolegij`)
105) ENGINE=InnoDB DEFAULT CHARSET=latin1;
106
107-- --------------------------------------------------------
108
109--
110-- Table structure for table `ucionica`
111--
112
113DROP TABLE IF EXISTS `ucionica`;
114CREATE TABLE IF NOT EXISTS `ucionica` (
115  `ID` int(11) NOT NULL,
116  `Naziv` varchar(255) NOT NULL,
117  `Lokacija` varchar(255) NOT NULL,
118  PRIMARY KEY (`ID`)
119) ENGINE=InnoDB DEFAULT CHARSET=latin1;
120
121--
122-- Constraints for dumped tables
123--
124
125--
126-- Constraints for table `ispit`
127--
128ALTER TABLE `ispit`
129  ADD CONSTRAINT `ispit_ibfk_1` FOREIGN KEY (`idstudent`) REFERENCES `student` (`ID`),
130  ADD CONSTRAINT `ispit_ibfk_2` FOREIGN KEY (`idprofesor`) REFERENCES `profesor` (`id`),
131  ADD CONSTRAINT `ispit_ibfk_3` FOREIGN KEY (`idkolegij`) REFERENCES `kolegij` (`id`),
132  ADD CONSTRAINT `ispit_ibfk_4` FOREIGN KEY (`iducionica`) REFERENCES `ucionica` (`ID`);
133
134--
135-- Constraints for table `kolegij`
136--
137ALTER TABLE `kolegij`
138  ADD CONSTRAINT `kolegij_ibfk_1` FOREIGN KEY (`IDPROFESOR`) REFERENCES `profesor` (`id`);
139
140--
141-- Constraints for table `studentkolegij`
142--
143ALTER TABLE `studentkolegij`
144  ADD CONSTRAINT `studentkolegij_ibfk_1` FOREIGN KEY (`idstudent`) REFERENCES `student` (`ID`),
145  ADD CONSTRAINT `studentkolegij_ibfk_2` FOREIGN KEY (`idkolegij`) REFERENCES `kolegij` (`id`);
146COMMIT;