Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE "ZAMESTNANEC" (
- id_zamestnanec uuid,
- kod text,
- jmeno text,
- prijmeni text,
- telefon text,
- datum_narozeni date,
- datum_nastupu date,
- plat int,
- odmeny int,
- id_oddeleni uuid,
- PRIMARY KEY (id_zamestnanec)
- );
- CREATE TABLE "ODDELENI" (
- id_oddeleni uuid,
- kod text,
- nazev text,
- PRIMARY KEY (id_oddeleni)
- );
- CREATE TABLE "PUBLIKACE" (
- id_publikace uuid,
- nazev text,
- typ text,
- datum_vydani date,
- zakladni_cena int,
- minimalni_cena int,
- autor uuid,
- korekce uuid,
- PRIMARY KEY (id_publikace)
- );
- CREATE INDEX ZAMESTNANCI_KOD ON "ZAMESTNANEC" (kod);
- CREATE INDEX ZAMESTNANCI_PRIJMENI ON "ZAMESTNANEC" (prijmeni);
- CREATE INDEX ZAMESTNANCI_DAT_NAST ON "ZAMESTNANEC" (datum_nastupu);
- CREATE INDEX ZAMESTNANCI_ODD ON "ZAMESTNANEC" (id_oddeleni);
- CREATE INDEX PUBLIKACE_NAZEV ON "PUBLIKACE" (nazev);
- CREATE INDEX PUBLIKACE_DAT_VYD ON "PUBLIKACE" (datum_vydani);
- CREATE INDEX PUBLIKACE_AUTOR ON "PUBLIKACE" (autor);
- CREATE INDEX PUBLIKACE_KOREKCE ON "PUBLIKACE" (korekce);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement