planets_postgre_initialize.sql

DROP TABLE IF EXISTS public."Typy_hvezd" CASCADE;
DROP TABLE IF EXISTS public."Typy_planet" CASCADE;
DROP TABLE IF EXISTS public."Typ_telesa" CASCADE;
DROP TABLE IF EXISTS public."Teleso" CASCADE;
DROP TABLE IF EXISTS public."Vzdalenost" CASCADE;
DROP TABLE IF EXISTS public."Objevitel" CASCADE;
DROP TABLE IF EXISTS public."Objev" CASCADE;
DROP TABLE IF EXISTS public."Prvky" CASCADE;
DROP TABLE IF EXISTS public."Slouceniny" CASCADE;
DROP TABLE IF EXISTS public."Slozeni" CASCADE;

CREATE TABLE IF NOT EXISTS public."Typy_hvezd"(
    id_hve integer NOT NULL,
    typ character varying(30) COLLATE pg_catalog."default" NOT NULL,
    spektralni_trida character(1) COLLATE pg_catalog."default" NOT NULL,
    barva character varying(12) COLLATE pg_catalog."default" NOT NULL,
    "teplota_(K)" integer NOT NULL,
    "zastoupeni_(%)" double precision,
    "zivotnost_(mil._let)" integer,
    CONSTRAINT "Typy_hvezd_pkey" PRIMARY KEY (id_hve)
);

CREATE TABLE IF NOT EXISTS public."Typy_planet"(
    id_pla integer NOT NULL,
    typ character varying(30) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT "Typy_planet_pkey" PRIMARY KEY (id_pla)
);

CREATE TABLE IF NOT EXISTS public."Typ_telesa"(
    id_typ integer NOT NULL,
    nazev character varying(20) COLLATE pg_catalog."default" NOT NULL,
    id_hve integer,
    id_pla integer,
    CONSTRAINT "Typ_telesa_pkey" PRIMARY KEY (id_typ),
    CONSTRAINT fk_typ_hve FOREIGN KEY (id_hve)
        REFERENCES public."Typy_hvezd" (id_hve) MATCH SIMPLE
        ON DELETE CASCADE,
    CONSTRAINT fk_typ_pla FOREIGN KEY (id_pla)
        REFERENCES public."Typy_planet" (id_pla) MATCH SIMPLE
        ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS public."Teleso"(
    id_tel integer NOT NULL,
    nazev character varying(25) COLLATE pg_catalog."default" UNIQUE NOT NULL,
    symbol character varying(5) COLLATE pg_catalog."default",
    id_typ_tel integer NOT NULL,
    "prumer_(km)" real NOT NULL,
    "hmotnost_(kg)" real NOT NULL,
    "hustota_(g/cm^(3))" real,
    "gravitace_(m/s^(2))" real NOT NULL,
    "min_teplota_(K)" integer,
    "prum_teplota_(K)" integer,
    "max_teplota_(K)" integer,
    "rychlost_rotace_(km/h)" real,
    "perioda_(d)" real NOT NULL,
    id_mat_hve integer,
    id_pla integer,
    CONSTRAINT "Teleso_pkey" PRIMARY KEY (id_tel),
    CONSTRAINT fk_mat_hve FOREIGN KEY (id_mat_hve)
        REFERENCES public."Teleso" (id_tel) MATCH SIMPLE
        ON DELETE CASCADE,
    CONSTRAINT fk_mesic FOREIGN KEY (id_pla)
        REFERENCES public."Teleso" (id_tel) MATCH SIMPLE
        ON DELETE CASCADE,
    CONSTRAINT fk_typ_tel FOREIGN KEY (id_typ_tel)
        REFERENCES public."Typ_telesa" (id_typ) MATCH SIMPLE
        ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS public."Vzdalenost"(
    id_vzd integer NOT NULL,
    "vzd_od_zeme_(AU)" real,
    "vzd_od_slunce_min_(AU)" real,
    "vzd_od_slunce_max_(AU)" real,
    id_tel integer NOT NULL,
    CONSTRAINT "Vzdalenost_pkey" PRIMARY KEY (id_vzd),
    CONSTRAINT fk_id_pla FOREIGN KEY (id_tel)
        REFERENCES public."Teleso" (id_tel) MATCH SIMPLE
        ON DELETE CASCADE
);


DROP SEQUENCE IF EXISTS vzdalenost_id_vzd_seq;
CREATE SEQUENCE vzdalenost_id_vzd_seq;
ALTER TABLE "Vzdalenost"
ALTER COLUMN id_vzd SET DEFAULT nextval('vzdalenost_id_vzd_seq');

CREATE TABLE IF NOT EXISTS public."Objevitel"(
    id_jme integer NOT NULL,
    jmeno character varying(15) COLLATE pg_catalog."default" NOT NULL,
    prijmeni character varying(15) COLLATE pg_catalog."default" NOT NULL,
    datum_narozeni date NOT NULL,
    zeme_narozeni character varying(20) COLLATE pg_catalog."default" NOT NULL,
    misto_narozeni character varying(20) COLLATE pg_catalog."default" NOT NULL,
    puvod character varying(20) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT "Objevitel_pkey" PRIMARY KEY (id_jme),
    CONSTRAINT date_check CHECK (datum_narozeni > '1400-01-01'::date)
);

CREATE TABLE IF NOT EXISTS public."Objev"(
    id_obj integer NOT NULL,
    datum_objevu date,
    objevitel character varying(30) COLLATE pg_catalog."default" NOT NULL,
    id_pla integer NOT NULL,
    id_jme integer,
    CONSTRAINT "Objev_pkey" PRIMARY KEY (id_obj, objevitel, id_pla),
    CONSTRAINT fk_jmeno FOREIGN KEY (id_jme)
        REFERENCES public."Objevitel" (id_jme) MATCH SIMPLE
        ON DELETE CASCADE,
    CONSTRAINT fk_planeta FOREIGN KEY (id_pla)
        REFERENCES public."Teleso" (id_tel) MATCH SIMPLE
        ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS public."Prvky"(
    id_prv integer NOT NULL,
    nazev character varying(20) COLLATE pg_catalog."default" NOT NULL,
    zkratka character varying(2) COLLATE pg_catalog."default" NOT NULL,
    protonove_cislo integer NOT NULL,
    relativni_atomova_hmotnost real NOT NULL,
    elektronegativita real,
    skupina character varying(3) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT "Prvky_pkey" PRIMARY KEY (id_prv)
);

CREATE TABLE IF NOT EXISTS public."Slouceniny"(
    id_slouc integer NOT NULL,
    nazev character varying(25) COLLATE pg_catalog."default" NOT NULL,
    zkratka character varying(6) COLLATE pg_catalog."default" NOT NULL,
    id_prv1 integer NOT NULL,
    pocet_molekul_1 smallint NOT NULL,
    id_prv2 integer NOT NULL,
    pocet_molekul_2 smallint NOT NULL,
    CONSTRAINT "Slouceniny_pkey" PRIMARY KEY (id_slouc),
    CONSTRAINT fk_prv1 FOREIGN KEY (id_prv1)
        REFERENCES public."Prvky" (id_prv) MATCH SIMPLE
        ON DELETE CASCADE,
    CONSTRAINT fk_prv2 FOREIGN KEY (id_prv2)
        REFERENCES public."Prvky" (id_prv) MATCH SIMPLE
        ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS public."Slozeni"(
    id_pla integer NOT NULL,
    id_prv integer,
    id_slouc integer,
    "vyskyt_(%)" real NOT null,
    CONSTRAINT fk_prvek FOREIGN KEY (id_prv)
        REFERENCES public."Prvky" (id_prv) MATCH SIMPLE
        ON DELETE CASCADE,
    CONSTRAINT fk_sloucenina FOREIGN KEY (id_slouc)
        REFERENCES public."Slouceniny" (id_slouc) MATCH SIMPLE
        ON DELETE CASCADE,
    CONSTRAINT id_pla_sloz FOREIGN KEY (id_pla)
        REFERENCES public."Teleso" (id_tel) MATCH SIMPLE
        ON DELETE CASCADE
);

INSERT INTO "Typy_hvezd" VALUES
(1,'Červená hvězda','M','červená',3200,80,200000),
(2,'Oranžová hvězda','K','oranžová',4500,8,50000),
(3,'Žlutá hvězda','G','žlutá',5700,3.5,10000),
(4,'Bílá hvězda','F','žlutobílá',6500,2,3000),
(5,'Bílomodrá hvězda','A','bílomodrá',8500,0.7,1000),
(6,'Modrobílá hvězda','B','modrobílá',20000,0.1,100),
(7,'Modrý veleobr','O','modrá',40000,0.00001,10);

INSERT INTO "Typy_planet" VALUES (1,'kamenná planeta'),(2,'plynný obr'),(3,'trpasličí planeta'),(4,'kamenný měsíc'),
(5,'asteroid'),(6,'kometa');

INSERT INTO "Typ_telesa" VALUES (1,'hvězda',1,NULL),(2,'hvězda',2,NULL),(3,'hvězda',3,NULL),(4,'hvězda',4,NULL),
(5,'hvězda',5,NULL),(6,'hvězda',6,NULL),(7,'hvězda',7,NULL),(8,'červený trpaslík',1,NULL),
(9,'planeta',NULL,1),(10,'planeta',NULL,2),(11,'planeta',NULL,3),(12,'měsíc',NULL,4),(13,'planetka',NULL,5),(14,'planetka',NULL,6);

INSERT INTO "Teleso" VALUES
(1 ,'Slunce', '☉', 3, 1392020, 1.9891*POWER(10,30), 1.408, 273.95, NULL, NULL,5780,7174,25.3800,NULL,NULL),
(2,'Merkur', '☿', 9, 4879.4, 3.302*POWER(10,23) , 5.427, 3.701, 90, 440, 700, 10.892, 58.6462, 1, NULL),
(3, 'Venuše', '♀', 9, 12103.7, 4.8685*POWER(10,24), 5.204, 8.87, NULL, 737, 773, 6.52, 243.0185,1,NULL),
(4, 'Země', '🜨', 9, 12756.270, 5.9736*POWER(10,24), 5.515, 9.81, 184, 287, 329, 1674.4, 1, 1, NULL),
(5, 'Měsíc', '☽', 12, 3476.2, 7.347673*POWER(10,22), 3.344, 1.622, 33,250,396, 16.657, 30, 1, 4),
(6, 'Mars', '♂', 9, 6792.4, 6.4185*POWER(10,23), 3.933, 3.69, 130, 210, 308, 868.22, 1.026, 1, NULL),
(7, 'Phobos', NULL, 12, 11.08, 1.070*POWER(10,16), 1.876, 0.0084, NULL, 233, NULL, 2.138, 0.319, 1, 6),
(8, 'Deimos', NULL, 12, 12.4, 2.244*POWER(10,15), 2.247, 0.0039, NULL, 233, NULL, 1.3513, 1.263, 1, 6),
(9, 'Jupiter', '♃', 10, 142984, 1.899*POWER(10,27), 1.326, 23.12, 112, 152, NULL,45262, 4332.59,1,NULL),
(10, 'Io',NULL,12, 3643, 8.9*POWER(10,22), 3.528, 1.79, 90, 110, 130, 271, 1.769, 1, 9),
(11, 'Europa',NULL,12, 3122, 4.8*POWER(10,22), 3.01, 1.314, 50, 103, 125, 115.67, 3.55, 1, 9),
(12, 'Ganymed',NULL,12, 5262, 14.8*POWER(10,22), 1.936, 1.428, 70, 110, 152, 271, 7.154, 1, 9),
(13, 'Callisto',NULL,12, 4821, 10.8*POWER(10,22), 1.834, 1.235, 80, 134, 165, 8.204, 16.689, 1, 9),
(14, 'Saturn', '♄',10, 120536, 5.6846*POWER(10,26), 0.6873, 8.96, 93, NULL, NULL, 35532, 10757.7, 1, NULL),
(15, 'Mimas', NULL, 12, 400,0.4*POWER(10,20), 1.1501, 0.064, NULL, 64, NULL, 14.28, 0.942,1, 14),
(16, 'Enceladus', NULL, 12, 504, 1.080*POWER(10,20), 1.6097, 0.113, 33, 75, 145,null, 1.3702, 1, 14),
(17, 'Tethys', NULL, 12, 1062, 6.1749*POWER(10,20), 0.984, 0.146, NULL, 86, NULL, 11.35, 1.8878, 1, 14),
(18, 'Dione', NULL, 12, 1123, 1.1*POWER(10,21), 1.4781, 0.232, NULL, 87, NULL, NULL, 2.7369, 1, 14),
(19, 'Rhea', NULL, 12, 1527, 2.3*POWER(10,21), 1.2372, 0.262, 53, NULL, 99, 8.48, 4.518, 1, 14),
(20, 'Titan', NULL, 12, 5149, 1.35*POWER(10,23), 1.8798, 1.352, NULL, 94, null, 5.57, 15.945, 1, 14),
(21, 'Lapetus', NULL, 12, 1470, 1.8*POWER(10,21), 1.0887, 0.223, 90,NULL,130, 3.26, 79.3215, 1, 14),
(22, 'Uran', '♅', 10,   51118, 8.6832*POWER(10,25), 1.270, 8.69, 55, 68, NULL, 9315.08, 30708.16, 1, NULL),
(23, 'Miranda', NULL, 12, 235.8, 6.293*POWER(10,19), 1.148, 0.076, null, 60, 84, 6.66, 1.413, 1, 22),
(24, 'Ariel', null, 12, 578.9, 1.2331*POWER(10,21),1.517, 0.246, null, 60, 84, 5.51, 2.520, 1, 22),
(25, 'Umbriel',null,12,584.7, 1.2885*POWER(10,21), 1.539, 0.252, null, 75, 85, 4.67, 4.144, 1, 22),
(26, 'Titania', null,12,788.4,3.4550*POWER(10,21), 1.683, 0.371, 60, 70, 89, 3.64, 8.706, 1, 22),
(27, 'Oberon', null, 12, 761.4, 3.1104*POWER(10,21), 1.682, 0.358, 70, null, 80, 3.15, 12.4632, 1, 22),
(28, 'Neptun', '♆', 10, 49528, 1.0243*POWER(10,26), 1.638, 11.15, 50,53,null, 9660, 60190, 1, null),
(29, 'Triton', null, 12, 2706.8, 2.14*POWER(10,22), 2.061, 0.0779, null, 38, null, 115.67, 5.877,1,28),
(30, 'Pluto', '♇', 11, 2370, 1.305*POWER(10,22), 1.87, 0.620, 33, 44, 55, 4.666, 90306.8, 1, null),
(31, 'Charon','⚷', 12, 1212, 1.586*POWER(10,21), 1.702, 0.288, null, 53, null, 0.21, 6.3872,1,30),
(32, 'Ceres', '⚳', 13, 952, 9.5*POWER(10,20), 2.077, 0.27, null, null, null, 17.9, 1680,1,null),
(33, 'Eris',null, 11, 2326, 1.6466*POWER(10,22), 2.43, 0.082, 30, 42, 56, 3.434, 2041999, 1, null),
(34, 'Proxima Centauri',null,8, 0.104*POWER(10,6)*2, 0.24*POWER(10,30), 56.8, 5.20, null, null, 2992, 22.204, 89.8,null,null),
(35, 'Halleyova kometa',null,14, 11, 2.2*POWER(10,14),0.6,0,null,null,null,null,27283,1,null);

INSERT INTO "Vzdalenost" ("vzd_od_zeme_(AU)","vzd_od_slunce_min_(AU)","vzd_od_slunce_max_(AU)",id_tel) VALUES
(1,null,null,1),(null,0.3075,0.4667,2),(null,0.7184,0.7282,3),(0,0.9833,1.0167,4),(null,1.3813,1.665,6),(null,4.9516,5.4552,9),
(null,9.0206,10.0535,14),(null,18.286,20.096,22),(null,29.766,30.441,28),(null,29.657,49.119,30),(null,2.5447,2.9873,32),
(null,38.271,67.864,33),(268521613.32, null, null, 34),(null,0.59278,35.14,35);

INSERT INTO "Objevitel" VALUES
(1,'Mikuláš','Koperník','1473-02-19','Polsko','Toruň','Polsko-německý'),
(2,'Galileo','Galilej','1564-02-15','Itálie','Pisa','Italský'),
(3,'Johannes','Kepler','1571-12-27','Německo','Weil der Stadt','Německý'),
(4, 'Asaph', 'Hall', '1829-10-15','USA', 'Conecticut','Americký'),
(5, 'William','Herschel', '1738-11-15', 'Svatá říše římská', 'Hanover', 'Německý'),
(6, 'Giovanni', 'Cassini', '1625-06-08','Janovská republika', 'Paříž', 'Francie'),
(7, 'Gerard','Kuiper', '1905-12-07','Nizozemsko','Tuitjenhorn','Nizozemsko-americký'),
(8, 'William','Lassell','1799-01-18','Anglický','Bolton','Anglický'),
(9, 'Clyde','Tombaugh','1906-02-04','Illinois','Streator','Americký'),
(10, 'James','Christy','1938-09-15','Wisconsin','Milwaukee','Americký'),
(11, 'Giuseppe','Piazzi','1746-07-07','Sicílie','Neapol','Římskokatolický'),
(12,'Christian','Huygens','1629-04-14','Nizozemsko','The Hague','Nizozemský'),
(13, 'Michael','E. Brown', '1965-01-05','Alabama','Huntsville','Americký');

INSERT INTO "Objev" VALUES
(1,null,'lidstvo',1,null),
(2,null,'Starověké civilizace',2,null),
(3,null,'Starověké civilizace',3,null),
(4,null,'lidstvo',4,null),
(5,null,'lidstvo',5,null),
(6,null,'Starověké civilizace',6,null),
(7,'1877-08-17','člověk',7,4),
(8,'1877-08-11','člověk',8,4),
(9,null,'Starověké civilizace',9,null),
(10,'1610-01-07','člověk',10,2),
(11,'1610-01-07','člověk',11,2),
(12,'1610-01-13','člověk',12,2),
(13,'1610-01-07','člověk',13,2),
(14,null,'Starověké civilizace',14,null),
(15,'1789-09-17','člověk',15,5),
(16,'1789-08-28','člověk',16,5),
(17,'1684-03-11','člověk',17,6),
(18,'1684-03-30','člověk',18,6),
(19,'1672-12-23','člověk',19,6),
(20,'1655-03-25','člověk',20,12),
(21,'1671-10-25','člověk',21,6),
(22,null,'Starověké civilizace',22,null),
(23,'1948-02-16','člověk',23,7),
(24,'1851-10-24','člověk',24,8),
(25,'1851-10-24','člověk',25,8),
(26,'1787-01-11','člověk',26,5),
(27,'1787-01-11','člověk',27,5),
(28,null,'Starověké civilizace',28,null),
(29,'1846-10-10','člověk',29,8),
(30,'1930-02-18','člověk',30,9),
(31,'1978-06-22','člověk',31,10),
(32,'1801-01-01','člověk',32,11),
(33, '2005-01-05','člověk',33,13),
(34, null, 'Starověké civilizace',34,null),
(35,null, 'Starověká čína',35,null);

INSERT INTO "Prvky" VALUES 
(1, 'Vodík', 'H', 1, 1.008, 2.20, '1.'),
(2, 'Helium', 'He', 2, 4.006, NULL, '18.'),
(3, 'Lithium', 'Li', 3, 6.97, 0.97, '1.'),
(4, 'Beryllium', 'Be', 4, 9.0122, 1.47, '2.'),
(5, 'Bor', 'B', 5, 10.81, 2.01, '13.'),
(6, 'Uhlík', 'C', 6, 12.011, 2.50, '14.'),
(7, 'Dusík','N', 7, 14.007, 3.07, '15.'),
(8, 'Kyslík', 'O', 8, 15.999, 3.50, '16.'),
(9, 'Fluor', 'F', 9, 18.998, 4.10, '17.'),
(10, 'Neon', 'Ne', 10, 20.180, NULL, '18.'),
(11, 'Sodík', 'Na', 11, 22.990, 1.01, '1.'),
(12, 'Hořčík', 'Mg', 12, 24.305, 1.23, '2.'),
(13, 'Hliník', 'Al', 13, 26.982, 1.47, '13.'),
(14, 'Křemík', 'Si', 14, 28.085, 1.74, '14.'),
(15, 'Fosfor', 'P', 15, 30.974, 2.06, '15.'),
(16, 'Síra', 'S', 16, 32.06, 2.44, '16.'),
(17, 'Chlor', 'Cl',17, 35.45, 2.83, '17.'),
(18, 'Argon', 'Ar',18,39.948, null, '18.'),
(19, 'Draslík', 'K', 19, 39.098, 0.91, '1.'),
(20, 'Vápník', 'Ca',20, 40.08, 1.04, '2.'),
(21, 'Skandium', 'Sc',21, 44.956, 1.20, '3.'),
(22, 'Titan', 'Ti',22, 47.867, 1.32, '4.'),
(24, 'Chrom', 'Cr', 24, 51.996, 1.56, '6.'),
(25, 'Mangan', 'Mn', 25, 54.938, 1.60, '7.'),
(26, 'Železo', 'Fe',26, 55.845, 1.64, '8.'),
(27, 'Kobalt', 'Co', 27, 58.933, 1.70, '9.'),
(28, 'Nikl', 'Ni', 28, 58.693, 1.75, '10.'),
(29, 'Měď', 'Cu', 29, 63.546, 1.75, '11.'),
(30, 'Zinek', 'Zn', 30, 65.38, 1.66, '12.'),
(31, 'Gallium','Ga',31,69.723,1.82,'13.'),
(32, 'Germanium', 'Ge', 32, 72.630, 2.02, '14.'),
(33,'Arsen','Ar',33, 74.922,2.20, '15.'),
(34,'Selen','Se',34, 78.97, 2.48, '16.'),
(35,'Brom','Br',35,79.904, 2.74, '17.'),
(36,'Krypton', 'Kr', 36, 83.798, null, '18.'),
(37, 'Rubidium','Rb',37, 85.468,0.89,'1.'),
(38, 'Stroncium', 'Sr', 38, 87.62, 0.99, '2.'),
(39, 'Yttrium', 'Y',39, 88.906, 1.11, '3.'),
(40, 'Zirkonium','Zr',40,91.224,1.22,'4.'),
(41, 'Niob', 'Nb', 41, 92.906, 1.23, '5.'),
(42, 'Molybden','Mo',42,95.95,1.30,'6.'),
(43,'Technecium','Tc',43,97,1.36,'7.'),
(44,'Ruthenium', 'Ru', 44,101.07, 1.42, '8.'),
(45, 'Rhodium','Rh',45,102.91,1.45,'9.'),
(46,'Palladium','Pd',46,106.42,1.35,'10.'),
(47,'Stříbro','Ag',47,107.87,1.42,'11.'),
(48,'Kadmium','Cd',48,112.41,1.46,'12.'),
(49,'Indium','In',49,114.82,1.49,'13.'),
(50,'Cín','Sn',50,118.71,1.72,'14.'),
(51,'Antimon','Sb',51, 121.76,1.82,'15.'),
(52,'Tellur','Te',52,127.60,2.01,'16.'),
(53,'Jod','I',53,126.90,2.21,'17.'),
(54,'Xenon','Xe',54,131.29,null,'18.'),
(55,'Cesium','Cs',55,132.91,0.86,'1.'),
(56,'Baryum','Ba',56,137.33,0.97,'2.'),
(57,'Lanthan','La',57,138.91,1.08,'3.'),
(72,'Hafnium','Hf',72,178.49,1.23,'4.'),
(74,'Wolfram','W',74,183.84,1.40,'6.'),
(78,'Platina','Pt',78,195.08,1.44,'10.'),
(79,'Zlato','Au',79,196.97,1.42,'11.'),
(80,'Rtuť','Hg',80,200.59,1.44,'12.'),
(81,'Thallium','Tl',81, 204.38, 1.44, '13.'),
(82,'Olovo','Pb',82, 207.2, 1.55, '14.');

INSERT INTO "Slouceniny" VALUES
(1, 'Oxid Uhličitý', 'CO₂',6, 1, 8, 2),
(2, 'Metan','CH₄',6, 1, 1, 4),
(3, 'Ethan','C₂H₆',6,2,1,6),
(4, 'Voda', 'H₂O', 1, 2, 8, 1),
(5, 'Oxid siřičitý','SO₂',16, 1, 8, 2),
(6, 'Oxid dusnatý', 'NO', 7, 1, 8, 1),
(7, 'Oxid uhelnatý','CO',6 ,1 ,8 ,1),
(8, 'Amoniak', 'NH3', 7, 1, 1, 3),
(9, 'Acetylen', 'C₂H₂',6 ,2 ,1, 2),
(10,'Ethen','C₂H₄',6, 2, 1, 4);

INSERT INTO "Slozeni" VALUES
(1,1,null,73.46),(1,2,null,24.85),(1,8,null,0.77),(1,6,null,0.29),(1,26,null,0.16),(1,10,null,0.12),(1,7,null,0.09),(1,14,null,0.07),(1,12,null,0.5),(1,16,null,0.04),
(2,19,null,31.7),(2,11,null,24.9),(2,8,null,15.1),(2,18,null,7),(2,2,null,5.9),(2,7,null,5.2),(2,null,1,3.6),(2,null,4,3.4),(2,1,null,3.2),
(3,null,1,96.5),(3,7,null,3),(3,null,5,0.015),(3,null,7,0.007),(3,18,null,0.007),(3,2,null,0.0012),(3,10,null,0.0007),
(4,7,null,78.08),(4,8,null,20.95),(4,18,null,0.93),(4,null,1,0.038),(4,null,5,0.033),
(5,8,null,43),(5,14,null,21),(5,13,null,10),(5,20,null,9),(5,26,null,9),(5,12,null,5),(5,22,null,2),(5,28,null,0.6),(5,11,null,0.3),(5,24,null,0.2),(5,19,null,0.1),(5,25,null,0.1),(5,16,null,0.1),
(6,null,1,95.32),(6,7,null,2.7),(6,18,null,1.16),(6,8,null,0.13),(6,null,7,0.07),(6,null,6,0.01),
(9,1,null,86),(9,2,null,14),(9,null,2,0.1),(9,null,8,0.02),
(10,null,5,90),
(14,1,null,96),(14,2,null,3),(14,null,2,0.4),(14,null,8,0.01),(14,null,3,0.0007),
(16,null,4,100),
(20,7,null,98.4),(20,null,2,1.4),(20,1,null,0.2),
(22,1,null,83),(22,2,null,15),(22,null,2,1.99),(22,null,8,0.01),(22,null,3,0.00025),(22,null,9,0.00001),
(28,1,null,80),(28,2,null,19),(28,null,2,1.5),(28,null,3,0.00015),
(30,7,null,99),(30,null,2,0.25),(30,null,7,0.0515),(30,null,9,0.0003),(30,null,10,0.0001);