Zadatak 2 - Radojević Petar

CREATE TABLE firme (
  firma_id NUMBER(6) PRIMARY KEY,
  naziv VARCHAR2(30),
  adresa VARCHAR2(50),
);

CREATE TABLE korisnici (
  korisnik_id NUMBER(6) PRIMARY KEY,
  ime VARCHAR2(40),
  mail VARCHAR2(30),
  adresa VARCHAR2(50),
  plata NUMBER(10),
  firma REFERENCES firme(firma_id)
);

CREATE TABLE liste (
  lista_id NUMBER(6) PRIMARY KEY,
  ime VARCHAR2(20),
  korisnik REFERENCES korisnici(korisnik_id),
);

CREATE TABLE zadaci (
  zadatak_id NUMBER(6) PRIMARY KEY,
  datum TIMESTAMP DEFAULT SYSTIMESTAMP,
  naslov VARCHAR2(20),
  prioritet NUMBER(3),
  opis VARCHAR2(200),
  lista REFERENCES liste(lista_id)
);

CREATE TABLE fajlovi (
  fajl_id NUMBER(6) PRIMARY KEY,
  putanja_fajla VARCHAR2(100),
  ime_fajla VARCHAR2(100),
  tip_fajla VARCHAR2(3),
  zadatak REFERENCES zadaci(zadatak_id)
);