Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE "JEDINICA_MJERE"
- ( "ID_JEDINICE_MJERE" NUMBER(3,0),
- "NAZIV_JEDINICE_MJERE" VARCHAR2(20),
- CONSTRAINT "JEDINICA_MJERE_PK" PRIMARY KEY ("ID_JEDINICE_MJERE")
- USING INDEX ENABLE
- )
- /
- CREATE TABLE "ARTIKL"
- ( "ID_ARTIKLA" NUMBER,
- "NAZIV" VARCHAR2(20),
- "VRSTA_ARTIKLA" CHAR(1),
- "JEDINICNA_CIJENA" NUMBER(10,2),
- "ID_JEDINICE_MJERE" NUMBER(3,0),
- CONSTRAINT "ARTIKL_PK" PRIMARY KEY ("ID_ARTIKLA")
- USING INDEX ENABLE,
- CONSTRAINT "CHECK" CHECK (VRSTA_ARTIKLA IN ('P', 'U', 'M')) ENABLE
- )
- /
- CREATE TABLE "POSLOVNI_PARTNER"
- ( "ID_POSLOVNOG_PARTNERA" NUMBER,
- "NAZIV" VARCHAR2(20),
- "KONTAKT_ADRESA" VARCHAR2(20),
- "BROJ_TELEFONA" VARCHAR2(20),
- "BROJ_ZIRO_RACUNA" VARCHAR2(20),
- CONSTRAINT "POSLOVNI_PARTNER_PK" PRIMARY KEY ("ID_POSLOVNOG_PARTNERA")
- USING INDEX ENABLE
- )
- /
- CREATE TABLE "ZAPOSLENIK"
- ( "ID_ZAPOSLENIK" NUMBER,
- "IME_I_PREZIME" VARCHAR2(20),
- "KONTAKT_TELEFON" VARCHAR2(20),
- CONSTRAINT "ZAPOSLENIK_PK" PRIMARY KEY ("ID_ZAPOSLENIK")
- USING INDEX ENABLE
- )
- /
- CREATE TABLE "RACUN"
- ( "ID_RACUNA" NUMBER,
- "DATUM_DOSPIJECA" DATE,
- "ID_POSLOVNOG_PARTNERA" NUMBER,
- "ID_ZAPOSLENIKA" NUMBER,
- CONSTRAINT "RACUN_PK" PRIMARY KEY ("ID_RACUNA")
- USING INDEX ENABLE
- )
- /
- CREATE TABLE "STAVKA_RACUNA_IVUK"
- ( "KOLICINA" NUMBER,
- "ID_RACUNA" NUMBER,
- "ID_ARTIKLA" NUMBER,
- CONSTRAINT "STAVKA_RACUNA_IVUK_PK" PRIMARY KEY ("ID_RACUNA", "ID_ARTIKLA")
- USING INDEX ENABLE
- )
- /
- ALTER TABLE "RACUN" ADD CONSTRAINT "RACUN_FK1" FOREIGN KEY ("ID_POSLOVNOG_PARTNERA")
- REFERENCES "POSLOVNI_PARTNER" ("ID_POSLOVNOG_PARTNERA") ENABLE
- /
- ALTER TABLE "RACUN" ADD CONSTRAINT "RACUN_FK2" FOREIGN KEY ("ID_ZAPOSLENIKA")
- REFERENCES "ZAPOSLENIK" ("ID_ZAPOSLENIK") ENABLE
- /
- ALTER TABLE "STAVKA_RACUNA_IVUK" ADD CONSTRAINT "STAVKA_RACUNA_FK1" FOREIGN KEY ("ID_RACUNA")
- REFERENCES "RACUN" ("ID_RACUNA") ENABLE
- /
- ALTER TABLE "STAVKA_RACUNA_IVUK" ADD CONSTRAINT "STAVKA_RACUNA_FK2" FOREIGN KEY ("ID_ARTIKLA")
- REFERENCES "ARTIKL" ("ID_ARTIKLA") ENABLE
- /
- ALTER TABLE "ARTIKL" ADD FOREIGN KEY ("ID_JEDINICE_MJERE")
- REFERENCES "JEDINICA_MJERE" ("ID_JEDINICE_MJERE") ENABLE
- /
- CREATE UNIQUE INDEX "ARTIKL_PK" ON "ARTIKL" ("ID_ARTIKLA")
- /
- CREATE UNIQUE INDEX "JEDINICA_MJERE_PK" ON "JEDINICA_MJERE" ("ID_JEDINICE_MJERE")
- /
- CREATE UNIQUE INDEX "POSLOVNI_PARTNER_PK" ON "POSLOVNI_PARTNER" ("ID_POSLOVNOG_PARTNERA")
- /
- CREATE UNIQUE INDEX "RACUN_PK" ON "RACUN" ("ID_RACUNA")
- /
- CREATE UNIQUE INDEX "STAVKA_RACUNA_IVUK_PK" ON "STAVKA_RACUNA_IVUK" ("ID_RACUNA", "ID_ARTIKLA")
- /
- CREATE UNIQUE INDEX "ZAPOSLENIK_PK" ON "ZAPOSLENIK" ("ID_ZAPOSLENIK")
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement