Ono sto meni treba jeste da napravim aplikaciju,koja bi ucitala to iz sql.file...Kda otvorim to pomocu notepad vidim sql jezik,za pravljenje tabela,polja i slicno...U stvari,evo prekopiracu,sta mi je u njemu...
--------------------------------------------------------
-- File created - ??????-???????-23-2016
--------------------------------------------------------
DROP TABLE "STEFAN"."ADRESA" cascade constraints;
DROP TABLE "STEFAN"."CARINARNICA" cascade constraints;
DROP TABLE "STEFAN"."CENAROBE" cascade constraints;
DROP TABLE "STEFAN"."DELATNOST" cascade constraints;
DROP TABLE "STEFAN"."FAKTURA" cascade constraints;
DROP TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" cascade constraints;
DROP TABLE "STEFAN"."JEDINICAMERE" cascade constraints;
DROP TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" cascade constraints;
DROP TABLE "STEFAN"."MESTO" cascade constraints;
DROP TABLE "STEFAN"."NARUDZBENICA" cascade constraints;
DROP TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" cascade constraints;
DROP TABLE "STEFAN"."POSLOVNIPARTNER" cascade constraints;
DROP TABLE "STEFAN"."RADNIK" cascade constraints;
DROP TABLE "STEFAN"."ROBA" cascade constraints;
DROP TABLE "STEFAN"."STAVKAJCI" cascade constraints;
DROP TABLE "STEFAN"."STAVKANARUDZBENICE" cascade constraints;
DROP TABLE "STEFAN"."STAVKAOCD" cascade constraints;
DROP TABLE "STEFAN"."STAVKEFAKTURE" cascade constraints;
DROP TABLE "STEFAN"."TRANSPORTNOSREDSTVO" cascade constraints;
DROP TABLE "STEFAN"."ULICA" cascade constraints;
DROP TABLE "STEFAN"."VALUTA" cascade constraints;
DROP TABLE "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" cascade constraints;
DROP TABLE "STEFAN"."ZEMLJA" cascade constraints;
--------------------------------------------------------
-- DDL for Table ADRESA
--------------------------------------------------------
CREATE TABLE "STEFAN"."ADRESA"
( "SIFRAMESTA" NUMBER,
"SIFRAULICE" NUMBER,
"BROJ" NUMBER,
"SPRAT" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table CARINARNICA
--------------------------------------------------------
CREATE TABLE "STEFAN"."CARINARNICA"
( "SIFRACARINARNICE" NUMBER,
"NAZIVCARINARNIICE" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table CENAROBE
--------------------------------------------------------
CREATE TABLE "STEFAN"."CENAROBE"
( "SIFRAROBE" NUMBER,
"DATUMOD" DATE,
"VREDNOST" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table DELATNOST
--------------------------------------------------------
CREATE TABLE "STEFAN"."DELATNOST"
( "SIFRADELATNOSTI" NUMBER,
"NAZIVDELATNOSTI" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table FAKTURA
--------------------------------------------------------
CREATE TABLE "STEFAN"."FAKTURA"
( "BROJFAKTURE" NUMBER,
"DATUMFAKTURE" DATE,
"ROKUPLATE" DATE,
"SIFRARADNIKA" NUMBER,
"SIFRAPP" NUMBER,
"SIFRAVALUTE" NUMBER,
"BROJNARUDZBENICE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table IZJAVADOVOZENJAVOZILA
--------------------------------------------------------
CREATE TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA"
( "SIFRAIZJAVE" NUMBER,
"OPIS" VARCHAR2(1024 BYTE),
"SIFRARADNIKA" NUMBER,
"SIFRATS" NUMBER,
"SIFRAPP" NUMBER,
"BROJFAKTURE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table JEDINICAMERE
--------------------------------------------------------
CREATE TABLE "STEFAN"."JEDINICAMERE"
( "SIFRAJM" NUMBER,
"NAZIVJM" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table JEDINSTVENACARINSKAISPRAVA
--------------------------------------------------------
CREATE TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA"
( "REFERENTNIBROJ" NUMBER,
"DATUMJCI" DATE,
"OPIS" VARCHAR2(1024 BYTE),
"BROJFAKTURE" NUMBER,
"SIFRARADNIKA" NUMBER,
"SIFRAPP" NUMBER,
"SIFRAVALUTE" NUMBER,
"SIFRACARINARNICE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table MESTO
--------------------------------------------------------
CREATE TABLE "STEFAN"."MESTO"
( "SIFRAMESTA" NUMBER,
"NAZIVMESTA" VARCHAR2(144 BYTE),
"PTTBROJ" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table NARUDZBENICA
--------------------------------------------------------
CREATE TABLE "STEFAN"."NARUDZBENICA"
( "BROJNARUDZBENICE" NUMBER,
"DATUMNARUDZBENICE" DATE,
"DATUMDO" DATE,
"NAPOMENA" VARCHAR2(1024 BYTE),
"SIFRARADNIKA" NUMBER,
"SIFRAPP" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table OBRACUNCARINSKOGDUGA
--------------------------------------------------------
CREATE TABLE "STEFAN"."OBRACUNCARINSKOGDUGA"
( "BROJOBRACUNA" NUMBER,
"DATUMOBRACUNA" DATE,
"NAPOMENA" VARCHAR2(1024 BYTE),
"REFERENTNIBROJ" NUMBER,
"SIFRARADNIKA" NUMBER,
"SIFRAPP" NUMBER,
"SIFRACARINARNICE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table POSLOVNIPARTNER
--------------------------------------------------------
CREATE TABLE "STEFAN"."POSLOVNIPARTNER"
( "SIFRAPP" NUMBER,
"NAZIVPP" VARCHAR2(144 BYTE),
"TELEFON" NUMBER,
"FAX" NUMBER,
"EMAIL" VARCHAR2(144 BYTE),
"SIFRAZEMLJE" NUMBER,
"SIFRADELATNOSTI" NUMBER,
"SIFRAMESTA" NUMBER,
"SIFRAULICE" NUMBER,
"BROJ" NUMBER,
"SPRAT" NUMBER,
"NAZIVDELATNOSTI" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table RADNIK
--------------------------------------------------------
CREATE TABLE "STEFAN"."RADNIK"
( "SIFRARADNIKA" NUMBER,
"IMEPREZIME" VARCHAR2(144 BYTE),
"TELEFON" NUMBER,
"JMBG" NUMBER(13,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table ROBA
--------------------------------------------------------
CREATE TABLE "STEFAN"."ROBA"
( "SIFRAROBE" NUMBER,
"NAZIVROBE" VARCHAR2(144 BYTE),
"SIFRAJM" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table STAVKAJCI
--------------------------------------------------------
CREATE TABLE "STEFAN"."STAVKAJCI"
( "REFERENTNIBROJ" NUMBER,
"RBSTAVKEJCI" NUMBER,
"KOLICINA" NUMBER,
"BROJFAKTURE" NUMBER,
"RBSTAVKEFAKTURE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table STAVKANARUDZBENICE
--------------------------------------------------------
CREATE TABLE "STEFAN"."STAVKANARUDZBENICE"
( "BROJNARUDZBENICE" NUMBER,
"RB" NUMBER,
"KOLICINA" NUMBER,
"SIFRAROBE" NUMBER,
"DATUMNARUDZBENICE" DATE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table STAVKAOCD
--------------------------------------------------------
CREATE TABLE "STEFAN"."STAVKAOCD"
( "BROJOBRACUNA" NUMBER,
"RBSTAVKEOCD" NUMBER,
"KOLICINA" NUMBER,
"REFERENTNIBROJ" NUMBER,
"RBSTAVKEJCI" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table STAVKEFAKTURE
--------------------------------------------------------
CREATE TABLE "STEFAN"."STAVKEFAKTURE"
( "BROJFAKTURE" NUMBER,
"RBSTAVKEFAKTURE" NUMBER,
"KOLICINA" NUMBER,
"BROJNARUDZBENICE" NUMBER,
"RB" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table TRANSPORTNOSREDSTVO
--------------------------------------------------------
CREATE TABLE "STEFAN"."TRANSPORTNOSREDSTVO"
( "SIFRATS" NUMBER,
"NAZIVTS" VARCHAR2(144 BYTE),
"SIFRAVTS" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table ULICA
--------------------------------------------------------
CREATE TABLE "STEFAN"."ULICA"
( "SIFRAULICE" NUMBER,
"NAZIVULICE" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table VALUTA
--------------------------------------------------------
CREATE TABLE "STEFAN"."VALUTA"
( "SIFRAVALUTE" NUMBER,
"NAZIVVALUTE" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table VRSTETRANSPORTNOGSREDSTVA
--------------------------------------------------------
CREATE TABLE "STEFAN"."VRSTETRANSPORTNOGSREDSTVA"
( "SIFRAVTS" NUMBER,
"NAZIVVTS" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table ZEMLJA
--------------------------------------------------------
CREATE TABLE "STEFAN"."ZEMLJA"
( "SIFRAZEMLJE" NUMBER,
"NAZIVZEMLJE" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
REM INSERTING into STEFAN.ADRESA
SET DEFINE OFF;
Insert into STEFAN.ADRESA (SIFRAMESTA,SIFRAULICE,BROJ,SPRAT) values ('1','1','10','2');
Insert into STEFAN.ADRESA (SIFRAMESTA,SIFRAULICE,BROJ,SPRAT) values ('2','2','15','3');
Insert into STEFAN.ADRESA (SIFRAMESTA,SIFRAULICE,BROJ,SPRAT) values ('3','4','20','4');
REM INSERTING into STEFAN.CARINARNICA
SET DEFINE OFF;
Insert into STEFAN.CARINARNICA (SIFRACARINARNICE,NAZIVCARINARNIICE) values ('1','CARINALUKABEOGRAD');
Insert into STEFAN.CARINARNICA (SIFRACARINARNICE,NAZIVCARINARNIICE) values ('2','CARINATERMINAL');
REM INSERTING into STEFAN.CENAROBE
SET DEFINE OFF;
Insert into STEFAN.CENAROBE (SIFRAROBE,DATUMOD,VREDNOST) values ('1',to_date('23.02.2016','DD.MM.RRRR'),'31900');
Insert into STEFAN.CENAROBE (SIFRAROBE,DATUMOD,VREDNOST) values ('2',to_date('23.02.2016','DD.MM.RRRR'),'65000');
REM INSERTING into STEFAN.DELATNOST
SET DEFINE OFF;
Insert into STEFAN.DELATNOST (SIFRADELATNOSTI,NAZIVDELATNOSTI) values ('1','TEGOVINANAVELIKO');
Insert into STEFAN.DELATNOST (SIFRADELATNOSTI,NAZIVDELATNOSTI) values ('2','KOMERCIJALA');
Insert into STEFAN.DELATNOST (SIFRADELATNOSTI,NAZIVDELATNOSTI) values ('3','SPEDICIJA');
REM INSERTING into STEFAN.FAKTURA
SET DEFINE OFF;
Insert into STEFAN.FAKTURA (BROJFAKTURE,DATUMFAKTURE,ROKUPLATE,SIFRARADNIKA,SIFRAPP,SIFRAVALUTE,BROJNARUDZBENICE) values ('1',to_date('31.03.2015','DD.MM.RRRR'),to_date('30.05.2015','DD.MM.RRRR'),'1','1','2','1');
REM INSERTING into STEFAN.IZJAVADOVOZENJAVOZILA
SET DEFINE OFF;
Insert into STEFAN.IZJAVADOVOZENJAVOZILA (SIFRAIZJAVE,OPIS,SIFRARADNIKA,SIFRATS,SIFRAPP,BROJFAKTURE) values ('1','VAZIUZFAKTURU','2','1','1','1');
REM INSERTING into STEFAN.JEDINICAMERE
SET DEFINE OFF;
Insert into STEFAN.JEDINICAMERE (SIFRAJM,NAZIVJM) values ('1','KOM');
Insert into STEFAN.JEDINICAMERE (SIFRAJM,NAZIVJM) values ('2','KG');
Insert into STEFAN.JEDINICAMERE (SIFRAJM,NAZIVJM) values ('3','M');
REM INSERTING into STEFAN.JEDINSTVENACARINSKAISPRAVA
SET DEFINE OFF;
Insert into STEFAN.JEDINSTVENACARINSKAISPRAVA (REFERENTNIBROJ,DATUMJCI,OPIS,BROJFAKTURE,SIFRARADNIKA,SIFRAPP,SIFRAVALUTE,SIFRACARINARNICE) values ('1',to_date('31.03.2015','DD.MM.RRRR'),'OCARINJENO','1','1','1','2','1');
REM INSERTING into STEFAN.MESTO
SET DEFINE OFF;
Insert into STEFAN.MESTO (SIFRAMESTA,NAZIVMESTA,PTTBROJ) values ('1','BEOGRAD','11000');
Insert into STEFAN.MESTO (SIFRAMESTA,NAZIVMESTA,PTTBROJ) values ('2','NOVI SAD','21000');
Insert into STEFAN.MESTO (SIFRAMESTA,NAZIVMESTA,PTTBROJ) values ('3','TORINO','10156');
REM INSERTING into STEFAN.NARUDZBENICA
SET DEFINE OFF;
Insert into STEFAN.NARUDZBENICA (BROJNARUDZBENICE,DATUMNARUDZBENICE,DATUMDO,NAPOMENA,SIFRARADNIKA,SIFRAPP) values ('1',to_date('11.12.2014','DD.MM.RRRR'),to_date('13.02.2015','DD.MM.RRRR'),'STOPRE','1','1');
REM INSERTING into STEFAN.OBRACUNCARINSKOGDUGA
SET DEFINE OFF;
Insert into STEFAN.OBRACUNCARINSKOGDUGA (BROJOBRACUNA,DATUMOBRACUNA,NAPOMENA,REFERENTNIBROJ,SIFRARADNIKA,SIFRAPP,SIFRACARINARNICE) values ('1',to_date('31.03.2015','DD.MM.RRRR'),'OBRACUNCARINSKOGDUGAIZVRSENPREMAJCI','1','1','1','1');
REM INSERTING into STEFAN.POSLOVNIPARTNER
SET DEFINE OFF;
Insert into STEFAN.POSLOVNIPARTNER (SIFRAPP,NAZIVPP,TELEFON,FAX,EMAIL,SIFRAZEMLJE,SIFRADELATNOSTI,SIFRAMESTA,SIFRAULICE,BROJ,SPRAT,NAZIVDELATNOSTI) values ('1','SLODES','3512255','3512256','
[email protected]','1','3','1','1','10','2','SPEDICIJA');
Insert into STEFAN.POSLOVNIPARTNER (SIFRAPP,NAZIVPP,TELEFON,FAX,EMAIL,SIFRAZEMLJE,SIFRADELATNOSTI,SIFRAMESTA,SIFRAULICE,BROJ,SPRAT,NAZIVDELATNOSTI) values ('2','IVECO','125401621','125401622','
[email protected]','2','1','3','4','20','4','TRGOVINANAVELIKO');
REM INSERTING into STEFAN.RADNIK
SET DEFINE OFF;
Insert into STEFAN.RADNIK (SIFRARADNIKA,IMEPREZIME,TELEFON,JMBG) values ('1','JOVANJOVANOVIC','633322145','1201985710288');
Insert into STEFAN.RADNIK (SIFRARADNIKA,IMEPREZIME,TELEFON,JMBG) values ('2','PERAPERIC','692255146','2510965710298');
Insert into STEFAN.RADNIK (SIFRARADNIKA,IMEPREZIME,TELEFON,JMBG) values ('3','VENICPIRC','665252511','226316626462');
REM INSERTING into STEFAN.ROBA
SET DEFINE OFF;
Insert into STEFAN.ROBA (SIFRAROBE,NAZIVROBE,SIFRAJM) values ('1','KOMBI','1');
Insert into STEFAN.ROBA (SIFRAROBE,NAZIVROBE,SIFRAJM) values ('2','KAMION','1');
REM INSERTING into STEFAN.STAVKAJCI
SET DEFINE OFF;
Insert into STEFAN.STAVKAJCI (REFERENTNIBROJ,RBSTAVKEJCI,KOLICINA,BROJFAKTURE,RBSTAVKEFAKTURE) values ('1','1','1','1','1');
REM INSERTING into STEFAN.STAVKANARUDZBENICE
SET DEFINE OFF;
Insert into STEFAN.STAVKANARUDZBENICE (BROJNARUDZBENICE,RB,KOLICINA,SIFRAROBE,DATUMNARUDZBENICE) values ('1','1','1','1',to_date('11.12.2014','DD.MM.RRRR'));
REM INSERTING into STEFAN.STAVKAOCD
SET DEFINE OFF;
Insert into STEFAN.STAVKAOCD (BROJOBRACUNA,RBSTAVKEOCD,KOLICINA,REFERENTNIBROJ,RBSTAVKEJCI) values ('1','1','1','1','1');
REM INSERTING into STEFAN.STAVKEFAKTURE
SET DEFINE OFF;
Insert into STEFAN.STAVKEFAKTURE (BROJFAKTURE,RBSTAVKEFAKTURE,KOLICINA,BROJNARUDZBENICE,RB) values ('1','1','1','1','1');
REM INSERTING into STEFAN.TRANSPORTNOSREDSTVO
SET DEFINE OFF;
Insert into STEFAN.TRANSPORTNOSREDSTVO (SIFRATS,NAZIVTS,SIFRAVTS) values ('1','KAMIONSAPRIKOLICOM','1');
Insert into STEFAN.TRANSPORTNOSREDSTVO (SIFRATS,NAZIVTS,SIFRAVTS) values ('2','VOZ','2');
Insert into STEFAN.TRANSPORTNOSREDSTVO (SIFRATS,NAZIVTS,SIFRAVTS) values ('3','BROD','3');
Insert into STEFAN.TRANSPORTNOSREDSTVO (SIFRATS,NAZIVTS,SIFRAVTS) values ('4','AVION','4');
REM INSERTING into STEFAN.ULICA
SET DEFINE OFF;
Insert into STEFAN.ULICA (SIFRAULICE,NAZIVULICE) values ('1','BORSKA');
Insert into STEFAN.ULICA (SIFRAULICE,NAZIVULICE) values ('2','BEOGRADSKA');
Insert into STEFAN.ULICA (SIFRAULICE,NAZIVULICE) values ('3','VUKA KARADZICA');
Insert into STEFAN.ULICA (SIFRAULICE,NAZIVULICE) values ('4','VIA PUGILIA');
REM INSERTING into STEFAN.VALUTA
SET DEFINE OFF;
Insert into STEFAN.VALUTA (SIFRAVALUTE,NAZIVVALUTE) values ('1','EUR');
Insert into STEFAN.VALUTA (SIFRAVALUTE,NAZIVVALUTE) values ('2','DIN');
REM INSERTING into STEFAN.VRSTETRANSPORTNOGSREDSTVA
SET DEFINE OFF;
Insert into STEFAN.VRSTETRANSPORTNOGSREDSTVA (SIFRAVTS,NAZIVVTS) values ('1','KAMIONSAPRIKOLICOM');
Insert into STEFAN.VRSTETRANSPORTNOGSREDSTVA (SIFRAVTS,NAZIVVTS) values ('2','VOZ');
Insert into STEFAN.VRSTETRANSPORTNOGSREDSTVA (SIFRAVTS,NAZIVVTS) values ('3','BROD');
Insert into STEFAN.VRSTETRANSPORTNOGSREDSTVA (SIFRAVTS,NAZIVVTS) values ('4','AVION');
REM INSERTING into STEFAN.ZEMLJA
SET DEFINE OFF;
Insert into STEFAN.ZEMLJA (SIFRAZEMLJE,NAZIVZEMLJE) values ('1','BEOGRAD');
Insert into STEFAN.ZEMLJA (SIFRAZEMLJE,NAZIVZEMLJE) values ('2','ITALIJA');
--------------------------------------------------------
-- DDL for Index ULICA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."ULICA_PK" ON "STEFAN"."ULICA" ("SIFRAULICE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index OBRACUN_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."OBRACUN_PK" ON "STEFAN"."OBRACUNCARINSKOGDUGA" ("BROJOBRACUNA")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index STFAKTURA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."STFAKTURA_PK" ON "STEFAN"."STAVKEFAKTURE" ("BROJFAKTURE", "RBSTAVKEFAKTURE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index STAVKAJCI_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."STAVKAJCI_PK" ON "STEFAN"."STAVKAJCI" ("REFERENTNIBROJ", "RBSTAVKEJCI")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index PP_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."PP_PK" ON "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index MESTO_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."MESTO_PK" ON "STEFAN"."MESTO" ("SIFRAMESTA")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index IZJAVA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."IZJAVA_PK" ON "STEFAN"."IZJAVADOVOZENJAVOZILA" ("SIFRAIZJAVE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index CENAROBA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."CENAROBA_PK" ON "STEFAN"."CENAROBE" ("SIFRAROBE", "DATUMOD")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index VTS_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."VTS_PK" ON "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" ("SIFRAVTS")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index OCD_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."OCD_PK" ON "STEFAN"."STAVKAOCD" ("BROJOBRACUNA", "RBSTAVKEOCD")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index ISPRAVA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."ISPRAVA_PK" ON "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ("REFERENTNIBROJ")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index RADNIK_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."RADNIK_PK" ON "STEFAN"."RADNIK" ("SIFRARADNIKA")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index VALUTA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."VALUTA_PK" ON "STEFAN"."VALUTA" ("SIFRAVALUTE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index FAKTURA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."FAKTURA_PK" ON "STEFAN"."FAKTURA" ("BROJFAKTURE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index ADRESA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."ADRESA_PK" ON "STEFAN"."ADRESA" ("SIFRAMESTA", "SIFRAULICE", "BROJ", "SPRAT")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index ZEMLJA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."ZEMLJA_PK" ON "STEFAN"."ZEMLJA" ("SIFRAZEMLJE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index DELATNOST_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."DELATNOST_PK" ON "STEFAN"."DELATNOST" ("SIFRADELATNOSTI")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index CARINARNICA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."CARINARNICA_PK" ON "STEFAN"."CARINARNICA" ("SIFRACARINARNICE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index JM_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."JM_PK" ON "STEFAN"."JEDINICAMERE" ("SIFRAJM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index TS_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."TS_PK" ON "STEFAN"."TRANSPORTNOSREDSTVO" ("SIFRATS")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index STNARUDZBENICE_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."STNARUDZBENICE_PK" ON "STEFAN"."STAVKANARUDZBENICE" ("BROJNARUDZBENICE", "RB")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index ROBA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."ROBA_PK" ON "STEFAN"."ROBA" ("SIFRAROBE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index NARUDZBENICA_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "STEFAN"."NARUDZBENICA_PK" ON "STEFAN"."NARUDZBENICA" ("BROJNARUDZBENICE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- Constraints for Table VRSTETRANSPORTNOGSREDSTVA
--------------------------------------------------------
ALTER TABLE "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" ADD CONSTRAINT "VTS_PK" PRIMARY KEY ("SIFRAVTS")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" MODIFY ("SIFRAVTS" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table DELATNOST
--------------------------------------------------------
ALTER TABLE "STEFAN"."DELATNOST" ADD CONSTRAINT "DELATNOST_PK" PRIMARY KEY ("SIFRADELATNOSTI")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."DELATNOST" MODIFY ("SIFRADELATNOSTI" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table POSLOVNIPARTNER
--------------------------------------------------------
ALTER TABLE "STEFAN"."POSLOVNIPARTNER" ADD CONSTRAINT "PP_PK" PRIMARY KEY ("SIFRAPP")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."POSLOVNIPARTNER" MODIFY ("SIFRAPP" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table ZEMLJA
--------------------------------------------------------
ALTER TABLE "STEFAN"."ZEMLJA" ADD CONSTRAINT "ZEMLJA_PK" PRIMARY KEY ("SIFRAZEMLJE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."ZEMLJA" MODIFY ("SIFRAZEMLJE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table ULICA
--------------------------------------------------------
ALTER TABLE "STEFAN"."ULICA" ADD CONSTRAINT "ULICA_PK" PRIMARY KEY ("SIFRAULICE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."ULICA" MODIFY ("SIFRAULICE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table ROBA
--------------------------------------------------------
ALTER TABLE "STEFAN"."ROBA" ADD CONSTRAINT "ROBA_PK" PRIMARY KEY ("SIFRAROBE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."ROBA" MODIFY ("SIFRAROBE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table FAKTURA
--------------------------------------------------------
ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_PK" PRIMARY KEY ("BROJFAKTURE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."FAKTURA" MODIFY ("BROJFAKTURE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table STAVKEFAKTURE
--------------------------------------------------------
ALTER TABLE "STEFAN"."STAVKEFAKTURE" ADD CONSTRAINT "STFAKTURA_PK" PRIMARY KEY ("BROJFAKTURE", "RBSTAVKEFAKTURE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."STAVKEFAKTURE" MODIFY ("BROJFAKTURE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table JEDINSTVENACARINSKAISPRAVA
--------------------------------------------------------
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_PK" PRIMARY KEY ("REFERENTNIBROJ")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" MODIFY ("REFERENTNIBROJ" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table RADNIK
--------------------------------------------------------
ALTER TABLE "STEFAN"."RADNIK" ADD CONSTRAINT "RADNIK_PK" PRIMARY KEY ("SIFRARADNIKA")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."RADNIK" MODIFY ("SIFRARADNIKA" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table NARUDZBENICA
--------------------------------------------------------
ALTER TABLE "STEFAN"."NARUDZBENICA" ADD CONSTRAINT "NARUDZBENICA_PK" PRIMARY KEY ("BROJNARUDZBENICE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."NARUDZBENICA" MODIFY ("BROJNARUDZBENICE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CARINARNICA
--------------------------------------------------------
ALTER TABLE "STEFAN"."CARINARNICA" ADD CONSTRAINT "CARINARNICA_PK" PRIMARY KEY ("SIFRACARINARNICE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."CARINARNICA" MODIFY ("SIFRACARINARNICE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table ADRESA
--------------------------------------------------------
ALTER TABLE "STEFAN"."ADRESA" ADD CONSTRAINT "ADRESA_PK" PRIMARY KEY ("SIFRAMESTA", "SIFRAULICE", "BROJ", "SPRAT")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."ADRESA" MODIFY ("SIFRAMESTA" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table STAVKAJCI
--------------------------------------------------------
ALTER TABLE "STEFAN"."STAVKAJCI" ADD CONSTRAINT "STAVKAJCI_PK" PRIMARY KEY ("REFERENTNIBROJ", "RBSTAVKEJCI")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."STAVKAJCI" MODIFY ("REFERENTNIBROJ" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CENAROBE
--------------------------------------------------------
ALTER TABLE "STEFAN"."CENAROBE" ADD CONSTRAINT "CENAROBA_PK" PRIMARY KEY ("SIFRAROBE", "DATUMOD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."CENAROBE" MODIFY ("SIFRAROBE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table OBRACUNCARINSKOGDUGA
--------------------------------------------------------
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_PK" PRIMARY KEY ("BROJOBRACUNA")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" MODIFY ("BROJOBRACUNA" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table VALUTA
--------------------------------------------------------
ALTER TABLE "STEFAN"."VALUTA" ADD CONSTRAINT "VALUTA_PK" PRIMARY KEY ("SIFRAVALUTE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."VALUTA" MODIFY ("SIFRAVALUTE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table IZJAVADOVOZENJAVOZILA
--------------------------------------------------------
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_PK" PRIMARY KEY ("SIFRAIZJAVE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" MODIFY ("SIFRAIZJAVE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table TRANSPORTNOSREDSTVO
--------------------------------------------------------
ALTER TABLE "STEFAN"."TRANSPORTNOSREDSTVO" ADD CONSTRAINT "TS_PK" PRIMARY KEY ("SIFRATS")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."TRANSPORTNOSREDSTVO" MODIFY ("SIFRATS" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table STAVKAOCD
--------------------------------------------------------
ALTER TABLE "STEFAN"."STAVKAOCD" ADD CONSTRAINT "OCD_PK" PRIMARY KEY ("BROJOBRACUNA", "RBSTAVKEOCD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."STAVKAOCD" MODIFY ("BROJOBRACUNA" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table STAVKANARUDZBENICE
--------------------------------------------------------
ALTER TABLE "STEFAN"."STAVKANARUDZBENICE" ADD CONSTRAINT "STNARUDZBENICE_PK" PRIMARY KEY ("BROJNARUDZBENICE", "RB")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."STAVKANARUDZBENICE" MODIFY ("BROJNARUDZBENICE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table JEDINICAMERE
--------------------------------------------------------
ALTER TABLE "STEFAN"."JEDINICAMERE" ADD CONSTRAINT "JM_PK" PRIMARY KEY ("SIFRAJM")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."JEDINICAMERE" MODIFY ("SIFRAJM" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table MESTO
--------------------------------------------------------
ALTER TABLE "STEFAN"."MESTO" ADD CONSTRAINT "MESTO_PK" PRIMARY KEY ("SIFRAMESTA")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."MESTO" MODIFY ("SIFRAMESTA" NOT NULL ENABLE);
--------------------------------------------------------
-- Ref Constraints for Table ADRESA
--------------------------------------------------------
ALTER TABLE "STEFAN"."ADRESA" ADD CONSTRAINT "ADRESA_FK1" FOREIGN KEY ("SIFRAMESTA")
REFERENCES "STEFAN"."MESTO" ("SIFRAMESTA") ENABLE;
ALTER TABLE "STEFAN"."ADRESA" ADD CONSTRAINT "ADRESA_FK2" FOREIGN KEY ("SIFRAULICE")
REFERENCES "STEFAN"."ULICA" ("SIFRAULICE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CENAROBE
--------------------------------------------------------
ALTER TABLE "STEFAN"."CENAROBE" ADD CONSTRAINT "CENAROBA_FK" FOREIGN KEY ("SIFRAROBE")
REFERENCES "STEFAN"."ROBA" ("SIFRAROBE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table FAKTURA
--------------------------------------------------------
ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_FK1" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_FK2" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_FK3" FOREIGN KEY ("SIFRAVALUTE")
REFERENCES "STEFAN"."VALUTA" ("SIFRAVALUTE") ENABLE;
ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_FK4" FOREIGN KEY ("BROJNARUDZBENICE")
REFERENCES "STEFAN"."NARUDZBENICA" ("BROJNARUDZBENICE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table IZJAVADOVOZENJAVOZILA
--------------------------------------------------------
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_FK1" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_FK2" FOREIGN KEY ("SIFRATS")
REFERENCES "STEFAN"."TRANSPORTNOSREDSTVO" ("SIFRATS") ENABLE;
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_FK3" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_FK4" FOREIGN KEY ("BROJFAKTURE")
REFERENCES "STEFAN"."FAKTURA" ("BROJFAKTURE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table JEDINSTVENACARINSKAISPRAVA
--------------------------------------------------------
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK1" FOREIGN KEY ("BROJFAKTURE")
REFERENCES "STEFAN"."FAKTURA" ("BROJFAKTURE") ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK2" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK3" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK4" FOREIGN KEY ("SIFRAVALUTE")
REFERENCES "STEFAN"."VALUTA" ("SIFRAVALUTE") ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK5" FOREIGN KEY ("SIFRACARINARNICE")
REFERENCES "STEFAN"."CARINARNICA" ("SIFRACARINARNICE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table NARUDZBENICA
--------------------------------------------------------
ALTER TABLE "STEFAN"."NARUDZBENICA" ADD CONSTRAINT "NARUDZBENICA_FK1" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."NARUDZBENICA" ADD CONSTRAINT "NARUDZBENICA_FK2" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table OBRACUNCARINSKOGDUGA
--------------------------------------------------------
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_FK1" FOREIGN KEY ("REFERENTNIBROJ")
REFERENCES "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ("REFERENTNIBROJ") ENABLE;
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_FK2" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_FK3" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_FK4" FOREIGN KEY ("SIFRACARINARNICE")
REFERENCES "STEFAN"."CARINARNICA" ("SIFRACARINARNICE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table POSLOVNIPARTNER
--------------------------------------------------------
ALTER TABLE "STEFAN"."POSLOVNIPARTNER" ADD CONSTRAINT "PP_FK1" FOREIGN KEY ("SIFRAZEMLJE")
REFERENCES "STEFAN"."ZEMLJA" ("SIFRAZEMLJE") ENABLE;
ALTER TABLE "STEFAN"."POSLOVNIPARTNER" ADD CONSTRAINT "PP_FK2" FOREIGN KEY ("SIFRADELATNOSTI")
REFERENCES "STEFAN"."DELATNOST" ("SIFRADELATNOSTI") ENABLE;
ALTER TABLE "STEFAN"."POSLOVNIPARTNER" ADD CONSTRAINT "PP_FK3" FOREIGN KEY ("SIFRAMESTA", "SIFRAULICE", "BROJ", "SPRAT")
REFERENCES "STEFAN"."ADRESA" ("SIFRAMESTA", "SIFRAULICE", "BROJ", "SPRAT") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table ROBA
--------------------------------------------------------
ALTER TABLE "STEFAN"."ROBA" ADD CONSTRAINT "ROBA_FK" FOREIGN KEY ("SIFRAJM")
REFERENCES "STEFAN"."JEDINICAMERE" ("SIFRAJM") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table STAVKAJCI
--------------------------------------------------------
ALTER TABLE "STEFAN"."STAVKAJCI" ADD CONSTRAINT "STAVKEJCI_FK1" FOREIGN KEY ("BROJFAKTURE", "RBSTAVKEFAKTURE")
REFERENCES "STEFAN"."STAVKEFAKTURE" ("BROJFAKTURE", "RBSTAVKEFAKTURE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table STAVKANARUDZBENICE
--------------------------------------------------------
ALTER TABLE "STEFAN"."STAVKANARUDZBENICE" ADD CONSTRAINT "STNARUDZBENICE_FK1" FOREIGN KEY ("SIFRAROBE")
REFERENCES "STEFAN"."ROBA" ("SIFRAROBE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table STAVKAOCD
--------------------------------------------------------
ALTER TABLE "STEFAN"."STAVKAOCD" ADD CONSTRAINT "OCD_FK1" FOREIGN KEY ("BROJOBRACUNA")
REFERENCES "STEFAN"."OBRACUNCARINSKOGDUGA" ("BROJOBRACUNA") ENABLE;
ALTER TABLE "STEFAN"."STAVKAOCD" ADD CONSTRAINT "OCD_FK2" FOREIGN KEY ("REFERENTNIBROJ", "RBSTAVKEJCI")
REFERENCES "STEFAN"."STAVKAJCI" ("REFERENTNIBROJ", "RBSTAVKEJCI") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table STAVKEFAKTURE
--------------------------------------------------------
ALTER TABLE "STEFAN"."STAVKEFAKTURE" ADD CONSTRAINT "STFAKTURA_FK1" FOREIGN KEY ("BROJNARUDZBENICE", "RB")
REFERENCES "STEFAN"."STAVKANARUDZBENICE" ("BROJNARUDZBENICE", "RB") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table TRANSPORTNOSREDSTVO
--------------------------------------------------------
ALTER TABLE "STEFAN"."TRANSPORTNOSREDSTVO" ADD CONSTRAINT "TS_FK1" FOREIGN KEY ("SIFRAVTS")
REFERENCES "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" ("SIFRAVTS") ENABLE;