Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE [RIS_SEMINARSKI_2909]
- CREATE TABLE Dispecer
- (
- DispecerId INTEGER NOT NULL,
- Ime_ NVARCHAR(50) NOT NULL,
- Prezime NVARCHAR(50) NOT NULL,
- IdentifikacioniBroj NVARCHAR(20) NOT NULL
- );
- CREATE TABLE Drzava
- (
- DrzavaId INTEGER NOT NULL,
- Naziv NVARCHAR(50) NOT NULL,
- Skracenica NVARCHAR(10) NULL
- );
- CREATE TABLE Grad
- (
- GradId INTEGER NOT NULL,
- Naziv NVARCHAR(50) NOT NULL,
- Drzava_DrzavaId INTEGER NOT NULL
- );
- CREATE TABLE Korisnici
- (
- KorisnikId INTEGER NOT NULL,
- Ime NVARCHAR(50) NOT NULL,
- Prezime NVARCHAR(50) NOT NULL,
- Telefon NVARCHAR(50) NOT NULL,
- Email NVARCHAR(50) NOT NULL,
- DatumRegistracije DATETIME NULL,
- Aktivan BIT NULL,
- Grad_GradId INTEGER NOT NULL
- );
- CREATE TABLE Kvarovi
- (
- KvarId INTEGER NOT NULL,
- NazivProblema NVARCHAR(50) NULL,
- OpisProblema NVARCHAR(255) NULL,
- Hitno BIT NULL,
- Aktivan BIT NULL,
- Vozilo_VoziloId INTEGER NOT NULL
- );
- CREATE TABLE Lokacije
- (
- LokacijaId INTEGER NOT NULL,
- Adresa NVARCHAR(50) NULL,
- Latituda_ DECIMAL NULL,
- Longituda DECIMAL NULL,
- Vozilo_VoziloId INTEGER NOT NULL
- );
- CREATE TABLE Narudzba
- (
- NarudzbaId INTEGER NOT NULL,
- Adresa NVARCHAR(50) NOT NULL,
- Longitude DECIMAL NOT NULL,
- Latitude DECIMAL NOT NULL,
- Napomena NVARCHAR(255) NULL,
- VrijemeDolaska DATETIME NULL,
- Aktivna BIT NULL,
- Korisnici_KorisnikId INTEGER NOT NULL,
- Voznja_VoznjaId INTEGER NOT NULL,
- Status_StatusId INTEGER NOT NULL
- );
- CREATE TABLE Status
- (
- StatusId INTEGER NOT NULL,
- Naziv NVARCHAR(20) NOT NULL
- );
- CREATE TABLE Vozilo
- (
- VoziloId INTEGER NOT NULL,
- Registracija NVARCHAR(20) NOT NULL,
- Marka NVARCHAR(50) NOT NULL,
- Tip NVARCHAR(50) NOT NULL,
- Boja NVARCHAR(50) NOT NULL,
- BrojSasije NVARCHAR(50) NOT NULL,
- TaxiOznaka NVARCHAR(50) NOT NULL,
- Voznja_VoznjaId INTEGER NOT NULL
- );
- CREATE TABLE Voznja
- (
- VoznjaId INTEGER NOT NULL,
- EstimiranoTrajanje INTEGER NULL,
- Aktivna BIT NOT NULL,
- Narudzba_NarudzbaId INTEGER NOT NULL,
- Dispecer_DispecerId INTEGER NOT NULL,
- Vozilo_VoziloId INTEGER NOT NULL
- );
- ALTER TABLE Dispecer
- ADD CONSTRAINT PK_Dispecer_Primary_Key PRIMARY KEY (
- DispecerId) ;
- ALTER TABLE Drzava
- ADD CONSTRAINT PK_Drzava_Primary_Key PRIMARY KEY (
- DrzavaId) ;
- ALTER TABLE Grad
- ADD CONSTRAINT PK_Grad_Primary_Key PRIMARY KEY (
- GradId) ;
- ALTER TABLE Korisnici
- ADD CONSTRAINT PK_Korisnici_Primary_Key PRIMARY KEY (
- KorisnikId) ;
- ALTER TABLE Kvarovi
- ADD CONSTRAINT PK_Kvarovi_Primary_Key PRIMARY KEY (
- KvarId) ;
- ALTER TABLE Lokacije
- ADD CONSTRAINT PK_Lokacije_Primary_Key PRIMARY KEY (
- LokacijaId) ;
- ALTER TABLE Narudzba
- ADD CONSTRAINT PK_Narudzba_Primary_Key PRIMARY KEY (
- NarudzbaId) ;
- ALTER TABLE Status
- ADD CONSTRAINT PK_Status_Primary_Key PRIMARY KEY (
- StatusId) ;
- ALTER TABLE Vozilo
- ADD CONSTRAINT PK_Vozilo_Primary_Key PRIMARY KEY (
- VoziloId) ;
- ALTER TABLE Voznja
- ADD CONSTRAINT PK_Voznja_Primary_Key PRIMARY KEY (
- VoznjaId) ;
- ALTER TABLE Korisnici
- ADD
- FOREIGN KEY (Grad_GradId)
- REFERENCES Grad;
- ALTER TABLE Narudzba
- ADD
- FOREIGN KEY (Korisnici_KorisnikId)
- REFERENCES Korisnici;
- ALTER TABLE Narudzba
- ADD
- FOREIGN KEY (Voznja_VoznjaId)
- REFERENCES Voznja;
- ALTER TABLE Narudzba
- ADD
- FOREIGN KEY (Status_StatusId)
- REFERENCES Status;
- ALTER TABLE Voznja
- ADD
- FOREIGN KEY (Narudzba_NarudzbaId)
- REFERENCES Narudzba;
- ALTER TABLE Voznja
- ADD
- FOREIGN KEY (Dispecer_DispecerId)
- REFERENCES Dispecer;
- ALTER TABLE Voznja
- ADD
- FOREIGN KEY (Vozilo_VoziloId)
- REFERENCES Vozilo;
- ALTER TABLE Vozilo
- ADD
- FOREIGN KEY (Voznja_VoznjaId)
- REFERENCES Voznja;
- ALTER TABLE Kvarovi
- ADD
- FOREIGN KEY (Vozilo_VoziloId)
- REFERENCES Vozilo;
- ALTER TABLE Lokacije
- ADD
- FOREIGN KEY (Vozilo_VoziloId)
- REFERENCES Vozilo
- ON DELETE CASCADE;
- ALTER TABLE Grad
- ADD
- FOREIGN KEY (Drzava_DrzavaId)
- REFERENCES Drzava
- ON DELETE CASCADE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement