Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table gatunek
- (
- id serial not null,
- nazwa_gatunku varchar(40) not null,
- constraint gatunek_pkey primary key (id)
- );
- create table autorzy
- (
- id serial not null,
- imie_autora varchar(30) not null,
- nazwisko_autora varchar(35) not null,
- constraint autorzy_pkey primary key (id)
- );
- create table ksiazka
- (
- id serial not null,
- tytul_ksiazki varchar(30) not null,
- isbn_ksiazki varchar(50) not null,
- gatunek_ksiazki integer not null,
- autor_ksiazki integer not null,
- autor_ksiazki_drugi varchar(20) null,
- cena_ksiazki decimal null,
- data_wydania_ksiazki date not null,
- constraint fk_ksiazka_gatunek foreign key (gatunek_ksiazki)
- references gatunek(id) match full
- ON UPDATE NO ACTION ON DELETE NO ACTION,
- constraint fk_ksiazka_autorzy foreign key (autor_ksiazki)
- references autorzy (id) match full
- ON UPDATE NO ACTION ON DELETE NO ACTION
- );
- drop table ksiazka;
- drop table gatunek;
- drop table autorzy;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement