Advertisement
Guest User

For Krulji

a guest
Dec 11th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.66 KB | None | 0 0
  1. CREATE TABLE "JEDINICA_MJERE"
  2. ( "ID_JEDINICE_MJERE" NUMBER(3,0),
  3. "NAZIV_JEDINICE_MJERE" VARCHAR2(20),
  4. CONSTRAINT "JEDINICA_MJERE_PK" PRIMARY KEY ("ID_JEDINICE_MJERE")
  5. USING INDEX ENABLE
  6. )
  7. /
  8. CREATE TABLE "ARTIKL"
  9. ( "ID_ARTIKLA" NUMBER,
  10. "NAZIV" VARCHAR2(20),
  11. "VRSTA_ARTIKLA" CHAR(1),
  12. "JEDINICNA_CIJENA" NUMBER(10,2),
  13. "ID_JEDINICE_MJERE" NUMBER(3,0),
  14. CONSTRAINT "ARTIKL_PK" PRIMARY KEY ("ID_ARTIKLA")
  15. USING INDEX ENABLE,
  16. CONSTRAINT "CHECK" CHECK (VRSTA_ARTIKLA IN ('P', 'U', 'M')) ENABLE
  17. )
  18. /
  19. CREATE TABLE "POSLOVNI_PARTNER"
  20. ( "ID_POSLOVNOG_PARTNERA" NUMBER,
  21. "NAZIV" VARCHAR2(20),
  22. "KONTAKT_ADRESA" VARCHAR2(20),
  23. "BROJ_TELEFONA" VARCHAR2(20),
  24. "BROJ_ZIRO_RACUNA" VARCHAR2(20),
  25. CONSTRAINT "POSLOVNI_PARTNER_PK" PRIMARY KEY ("ID_POSLOVNOG_PARTNERA")
  26. USING INDEX ENABLE
  27. )
  28. /
  29. CREATE TABLE "ZAPOSLENIK"
  30. ( "ID_ZAPOSLENIK" NUMBER,
  31. "IME_I_PREZIME" VARCHAR2(20),
  32. "KONTAKT_TELEFON" VARCHAR2(20),
  33. CONSTRAINT "ZAPOSLENIK_PK" PRIMARY KEY ("ID_ZAPOSLENIK")
  34. USING INDEX ENABLE
  35. )
  36. /
  37. CREATE TABLE "RACUN"
  38. ( "ID_RACUNA" NUMBER,
  39. "DATUM_DOSPIJECA" DATE,
  40. "ID_POSLOVNOG_PARTNERA" NUMBER,
  41. "ID_ZAPOSLENIKA" NUMBER,
  42. CONSTRAINT "RACUN_PK" PRIMARY KEY ("ID_RACUNA")
  43. USING INDEX ENABLE
  44. )
  45. /
  46. CREATE TABLE "STAVKA_RACUNA_IVUK"
  47. ( "KOLICINA" NUMBER,
  48. "ID_RACUNA" NUMBER,
  49. "ID_ARTIKLA" NUMBER,
  50. CONSTRAINT "STAVKA_RACUNA_IVUK_PK" PRIMARY KEY ("ID_RACUNA", "ID_ARTIKLA")
  51. USING INDEX ENABLE
  52. )
  53. /
  54. ALTER TABLE "RACUN" ADD CONSTRAINT "RACUN_FK1" FOREIGN KEY ("ID_POSLOVNOG_PARTNERA")
  55. REFERENCES "POSLOVNI_PARTNER" ("ID_POSLOVNOG_PARTNERA") ENABLE
  56. /
  57. ALTER TABLE "RACUN" ADD CONSTRAINT "RACUN_FK2" FOREIGN KEY ("ID_ZAPOSLENIKA")
  58. REFERENCES "ZAPOSLENIK" ("ID_ZAPOSLENIK") ENABLE
  59. /
  60. ALTER TABLE "STAVKA_RACUNA_IVUK" ADD CONSTRAINT "STAVKA_RACUNA_FK1" FOREIGN KEY ("ID_RACUNA")
  61. REFERENCES "RACUN" ("ID_RACUNA") ENABLE
  62. /
  63. ALTER TABLE "STAVKA_RACUNA_IVUK" ADD CONSTRAINT "STAVKA_RACUNA_FK2" FOREIGN KEY ("ID_ARTIKLA")
  64. REFERENCES "ARTIKL" ("ID_ARTIKLA") ENABLE
  65. /
  66. ALTER TABLE "ARTIKL" ADD FOREIGN KEY ("ID_JEDINICE_MJERE")
  67. REFERENCES "JEDINICA_MJERE" ("ID_JEDINICE_MJERE") ENABLE
  68. /
  69. CREATE UNIQUE INDEX "ARTIKL_PK" ON "ARTIKL" ("ID_ARTIKLA")
  70. /
  71. CREATE UNIQUE INDEX "JEDINICA_MJERE_PK" ON "JEDINICA_MJERE" ("ID_JEDINICE_MJERE")
  72. /
  73. CREATE UNIQUE INDEX "POSLOVNI_PARTNER_PK" ON "POSLOVNI_PARTNER" ("ID_POSLOVNOG_PARTNERA")
  74. /
  75. CREATE UNIQUE INDEX "RACUN_PK" ON "RACUN" ("ID_RACUNA")
  76. /
  77. CREATE UNIQUE INDEX "STAVKA_RACUNA_IVUK_PK" ON "STAVKA_RACUNA_IVUK" ("ID_RACUNA", "ID_ARTIKLA")
  78. /
  79. CREATE UNIQUE INDEX "ZAPOSLENIK_PK" ON "ZAPOSLENIK" ("ID_ZAPOSLENIK")
  80. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement