Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Pobocky
- (
- id_pobocky NUMBER (5) ,
- nazev VARCHAR2 (30) ,
- adresa VARCHAR2 (50) ,
- mesto VARCHAR2 (20) ,
- telefon CHAR (12),
- kod_zeme varchar2(10),
- CONSTRAINT pk_pobocka PRIMARY KEY ( id_pobocky )
- ) ;
- CREATE TABLE Pracovnici
- (
- id NUMBER(5) ,
- jmeno VARCHAR2 (15) ,
- prijmeni VARCHAR2 (20) ,
- plat NUMBER (5),
- id_pobocky NUMBER (5),
- CONSTRAINT pk_pracovnici PRIMARY KEY ( id )
- );
- CREATE TABLE Prodeje
- (
- datum_prodeje DATE ,
- datum_kurzu DATE ,
- mnozstvi NUMBER (3) ,
- cena_za_ks NUMBER (8) ,
- id_pobocky NUMBER (5),
- kod_meny VARCHAR2 (10),
- id_zbozi NUMBER (4)
- ) ;
- CREATE TABLE Zbozi
- (
- id_zbozi NUMBER (4) ,
- kategorie VARCHAR2 (20) ,
- nazev VARCHAR2 (20) ,
- typ VARCHAR2 (20) ,
- popis VARCHAR2 (30) ,
- cena NUMBER (8),
- kod_meny varchar2(10),
- CONSTRAINT pk_zbozi PRIMARY KEY ( id_zbozi )
- ) ;
- CREATE TABLE meny (
- kod varchar2(10),
- nazev varchar2(50),
- CONSTRAINT pk_meny PRIMARY KEY (kod)
- );
- CREATE TABLE kurzy (
- id NUMBER,
- platnost_od DATE,
- kurz NUMBER,
- kod_meny_z varchar2(10),
- kod_meny_do varchar2(10),
- CONSTRAINT pk_kurzy PRIMARY KEY (id)
- );
- CREATE TABLE zeme (
- kod varchar2(10),
- nazev varchar2(50),
- kod_meny varchar2(10),
- CONSTRAINT pk_zeme PRIMARY KEY (kod)
- );
- ALTER TABLE Pracovnici ADD CONSTRAINT fk_Pracovnici_Pobocky FOREIGN KEY (id_pobocky) REFERENCES
- Pobocky (id_pobocky);
- ALTER TABLE Prodeje ADD CONSTRAINT fk_Prodeje_Pobocky FOREIGN KEY (id_pobocky) REFERENCES
- Pobocky (id_pobocky);
- ALTER TABLE Prodeje ADD CONSTRAINT fk_Pracovnici_Zbozi FOREIGN KEY (id_zbozi) REFERENCES
- Zbozi (id_zbozi);
- ALTER TABLE Prodeje ADD CONSTRAINT fk_Pracovnici_Meny FOREIGN KEY (kod_meny) REFERENCES
- Meny (kod);
- ALTER TABLE Kurzy ADD CONSTRAINT fk_kurzy_meny_do FOREIGN KEY (kod_meny_do) REFERENCES
- Meny (kod);
- ALTER TABLE Kurzy ADD CONSTRAINT fk_kurzy_meny_z FOREIGN KEY (kod_meny_z) REFERENCES
- Meny (kod);
- ALTER TABLE Pobocky ADD CONSTRAINT fk_Zeme_Pobocky FOREIGN KEY (kod_zeme) REFERENCES
- Zeme (kod);
- ALTER TABLE Zbozi ADD CONSTRAINT fk_Zbozi_Meny FOREIGN KEY (kod_meny) REFERENCES Meny (kod);
- ALTER TABLE Zeme ADD CONSTRAINT fk_Zeme_mena FOREIGN KEY (kod_meny) REFERENCES
- Meny (kod);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement