Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- tablica racuni
- DROP TABLE stavke;
- DROP TABLE racuni;
- CREATE TABLE racuni (
- id NUMBER(11, 0) PRIMARY KEY,
- broj_racuna VARCHAR(10) UNIQUE NOT NULL,
- datum_dospijeca DATE DEFAULT SYSDATE, -- danasnji dan
- osnovica NUMBER(10, 2) DEFAULT 0,
- pdv_vrijednost NUMBER(10, 2) DEFAULT 0,
- pdv NUMBER(3, 2) DEFAULT 0,
- ukupno NUMBER(10, 2) DEFAULT 0
- );
- -- tablica racuni 'ima vise' stavki
- CREATE TABLE stavke(
- id NUMBER(11, 0) PRIMARY KEY,
- racun_id NUMBER(11, 0),
- osnovica NUMBER(11, 0) DEFAULT 0,
- pdv_vrijednost NUMBER(10, 2) DEFAULT 0,
- pdv NUMBER(3, 2) DEFAULT 0,
- ukupno NUMBER(10, 2) DEFAULT 0,
- CONSTRAINT fk_racuni_stavke
- FOREIGN KEY (racun_id)
- REFERENCES racuni(id)
- );
- INSERT INTO racuni
- (id, broj_racuna, datum_dospijeca)
- VALUES
- (1, '1/1/1', SYSDATE);
- INSERT INTO stavke
- (id, racun_id, osnovica)
- VALUES
- (1, 1, 100);
- ALTER TABLE stavke ADD opis VARCHAR(255) DEFAULT 'nema opisa';
- ALTER TABLE stavke DROP COLUMN opis;
- DROP TABLE autori_knjige;
- DROP TABLE autori;
- DROP TABLE knjige;
- DROP TABLE knjige;
- CREATE TABLE knjige (
- id NUMBER(11, 0) PRIMARY KEY,
- naziv VARCHAR(255) UNIQUE
- );
- DROP TABLE autori;
- CREATE TABLE autori (
- id NUMBER(11, 0) PRIMARY KEY,
- ime VARCHAR(255)
- );
- -- many to many tablica
- CREATE TABLE autori_knjige (
- id NUMBER(11, 0) PRIMARY KEY,
- knjiga_id NUMBER(11, 0),
- autor_id NUMBER(11, 0),
- CONSTRAINT fk_autori_knjige_1
- FOREIGN KEY (knjiga_id)
- REFERENCES knjige(id),
- CONSTRAINT fk_autori_knjige_2
- FOREIGN KEY (autor_id)
- REFERENCES autori(id)
- );
- DROP TABLE studenti;
- CREATE TABLE studenti(
- id NUMBER (11,0) PRIMARY KEY ,
- jmbag NUMBER (9,0) UNIQUE,
- ime VARCHAR(50),
- prezime VARCHAR (50)
- );
- DROP TABLE predmeti;
- CREATE TABLE predmeti(
- id NUMBER(11,0) PRIMARY KEY,
- naziv VARCHAR(255) UNIQUE
- );
- DROP TABLE upisano;
- CREATE TABLE upisano(
- id NUMBER(11,0) PRIMARY KEY,
- student_id NUMBER(11,0),
- predmet_id NUMBER(11,0),
- CONSTRAINT fk_upisano_1
- FOREIGN KEY (predmet_id)
- REFERENCES predmeti(id),
- CONSTRAINT fk_upisano_2
- FOREIGN KEY (student_id)
- REFERENCES studenti(id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement