Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE DonatorPsa (
- OIB CHAR(11) PRIMARY KEY,
- Ime VARCHAR(15),
- Prezime VARCHAR(15),
- );
- CREATE TABLE Kućica (
- IDKucice CHAR(5) PRIMARY KEY,
- Visina DECIMAL(3,1),
- Duljina DECIMAL(3,1),
- Širina DECIMAL(3,1),
- Zauzetost BIT,
- );
- CREATE TABLE Volonter (
- IDVolontera CHAR(11) PRIMARY KEY,
- Ime VARCHAR(15),
- Prezime VARCHAR(15),
- DatPočetka DATETIME,
- DatKraj DATETIME,
- );
- CREATE TABLE Djelatnik (
- OIB CHAR(11) PRIMARY KEY,
- Ime VARCHAR(15),
- Prezime VARCHAR(15),
- Telefon VARCHAR(15),
- Plaća DECIMAL(6,2),
- );
- CREATE TABLE Cjepivo (
- Šifra CHAR(8),
- Naziv VARCHAR(20),
- );
- CREATE TABLE Imunizacija(
- IDPsa CHAR(5)PRIMARY KEY,
- Šifra CHAR(8)PRIMARY KEY,
- Datum DATE,
- );
- CREATE TABLE Pas (
- IDPsa CHAR(5)PRIMARY KEY,
- ImePsa VARCHAR(15),
- Kastriran BIT,
- Čip BIT,
- Spol CHAR,
- Dob INT,
- BojaDlake VARCHAR(20),
- Dlaka VARCHAR(10),
- Pasmina VARCHAR(20),
- Udomljen BIT,
- IDKućice CHAR(5),
- OIBDjelatnika CHAR(11),
- OIBUdomitelja CHAR(11),
- OIBDonatora CHAR(11),
- CONSTRAINT fkKucica FOREIGN KEY(IDKućice) REFERENCES Kućica(IDKućice),
- CONSTRAINT fkDjelatnik FOREIGN KEY(OIBDjelatnika) REFERENCES Djelatnik(OIB),
- CONSTRAINT fkUdomitelj FOREIGN KEY(OIBUdomitelja) REFERENCES Udomitelj(OIB),
- CONSTRAINT fkDonator FOREIGN KEY(OIBDonatora) REFERENCES Donator(OIB)
- );
- CREATE TABLE BrineO (
- IDVolontera CHAR(11) PRIMARY KEY,
- IDPsa CHAR(5) PRIMARY KEY,
- );
- CREATE TABLE Udomitelj (
- OIB CHAR(11) PRIMARY KEY,
- BrojDjece INT,
- Email VARCHAR(50),
- PBR CHAR(5),
- Grad VARCHAR(15),
- Adresa VARCHAR(50),
- Ime VARCHAR(15),
- Prezime VARCHAR(15),
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement