Last active
December 28, 2015 14:29
-
-
Save OndrejSlamecka/7514938 to your computer and use it in GitHub Desktop.
PB154 datasets
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE druh ( | |
"ID_druhu" int NOT NULL, | |
"Nazev_cesky" character varying, | |
"Nazev_latinsky" character varying, | |
"Vyskyt" character varying, | |
"Stupen_ohrozeni" character varying | |
); | |
INSERT INTO "druh" ("ID_druhu", "Nazev_cesky", "Nazev_latinsky", "Vyskyt", "Stupen_ohrozeni") VALUES | |
(1,'Medvěd lední','Ursus maritimus','pobřeží a zamrzlá moře polárních oblastí Evropy Asie a Ameriky','VU'), | |
(2,'Surikata','Suricata suricatta','polopouště suché stepi a otevřené okraje lesů jižní Afriky','LC'), | |
(3,'Bobr kanadský','Castor canadensis','rybníky jezera a pomalé řeky Severní Ameriky','LC'); | |
-- | |
CREATE TYPE pohlavi AS ENUM ('F', 'M'); | |
CREATE TABLE zvire ( | |
"ID_zvirete" int NOT NULL, | |
"Jmeno" character varying, | |
"ID_druhu" int, | |
"Rok_narozeni" int, | |
"Pohlavi" pohlavi, | |
"ID_matky" int, | |
"ID_otce" int | |
); | |
INSERT INTO zvire ("ID_zvirete", "Jmeno", "ID_druhu", "Rok_narozeni", "Pohlavi", "ID_matky", "ID_otce") VALUES | |
(1,'Cora','1','1998','F',NULL,NULL), | |
(2,'Umca','1','1998','M',NULL,NULL), | |
(3,'Nanuk','1','2012','M',1,2), | |
(4,'Kometa','1','2012','F',1,2), | |
(5,'Lenka','2','2008','F',NULL,NULL), | |
(6,'Fráňa','2','2005','M',NULL,NULL), | |
(7,'Thomas','3','2005','M',NULL,NULL), | |
(8,'James','3','2000','M',NULL,NULL); | |
-- | |
CREATE TABLE ohrozeni ( | |
"Stupen_ohrozeni" character varying, | |
"Popis" character varying | |
); | |
INSERT INTO ohrozeni ("Stupen_ohrozeni", "Popis") VALUES | |
('LC', 'málo dotčený druh-Least Concern'), | |
('VU', 'zranitelný druh-Vulnerable'), | |
('EN', 'ohrožený druh-Endangered'), | |
('CR', 'kriticky ohrožený druh-Critically Endangered'); | |
-- | |
CREATE TABLE sponzor ( | |
"Jmeno" character varying, | |
"Prijmeni" character varying, | |
"ID_zvirete" int, | |
"Rok" int, | |
"Castka" int | |
); | |
INSERT INTO sponzor ("Jmeno", "Prijmeni", "ID_zvirete", "Rok", "Castka") VALUES | |
('Karolína', 'Nováková', 2, 2013, 10000), | |
('Jan', 'Kohoutek', 8, 2010, 2010), | |
('Marek', 'Suchý', 5, 2008, 999), | |
('Lenka', 'Topolová', 6, 2008, 1500); | |
-- | |
CREATE TABLE "DMS" ( | |
"Datum" timestamp, | |
"ID_druhu" int | |
); | |
INSERT INTO "DMS" ("Datum", "ID_druhu") VALUES | |
('2013-09-11 11:45:03.000',1), | |
('2013-09-15 09:16:07.400',3), | |
('2013-10-29 17:36:03.780',2), | |
('2013-10-29 14:25:03.920',1); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment