-- TVORBA TABULEK
CREATE TABLE IF NOT EXISTS Budova (
id_budovy TINYINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
nazev_budovy VARCHAR(10) NOT NULL
);
CREATE TABLE IF NOT EXISTS Oddeleni (
id_oddeleni TINYINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
nazev_oddeleni VARCHAR(75) NOT NULL,
id_budovy TINYINT UNSIGNED NOT NULL,
kontakt_telefon VARCHAR(15) NOT NULL,
luzkova_cast ENUM("Ano","Ne"),
pocet_luzek MEDIUMINT
);
CREATE TABLE IF NOT EXISTS Personal (
id_personal MEDIUMINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
jmeno VARCHAR(50),
prijmeni VARCHAR(50),
id_pozice TINYINT NOT NULL,
id_specializace TINYINT
);
CREATE TABLE IF NOT EXISTS OddPers (
id_personal MEDIUMINT UNSIGNED NOT NULL,
id_oddeleni TINYINT UNSIGNED NOT NULL,
primar ENUM("Ano","Ne"),
kontakt_primar VARCHAR(15),
vrchni_sestra ENUM("Ano","Ne"),
kontakt_sestra VARCHAR(15)
);
CREATE TABLE IF NOT EXISTS Pozice (
id_pozice TINYINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
nazev_pozice VARCHAR(50),
plat DECIMAL(15,2)
);
CREATE TABLE IF NOT EXISTS Specializace (
id_specializace TINYINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
nazev_specializace VARCHAR(50)
);
-- VKLÁDÁNÍ DAT
INSERT INTO Budova(nazev_budovy) VALUES
("Pavilon A"),
("Pavilon B"),
("Pavilon B1"),
("Pavilon C"),
("Pavilon D"),
("Pavilon E"),
("Pavilon G"),
("Pavilon H"),
("Pavilon CH"),
("Pavilon I"),
("Pavilon J"),
("Pavilon K1"),
("Pavilon K2"),
("Pavilon L"),
("Pavilon M"),
("Pavilon N"),
("Pavilon O"),
("Pavilon S");
INSERT INTO Oddeleni(nazev_oddeleni,id_budovy,kontakt_telefon,luzkova_cast,pocet_luzek) VALUES
("Interní oddělení, interní ambulance",1,"577772569","Ne",NULL),
("Jednotka intenzivní péče interních oborů",1,"577689851","Ne",NULL),
("Neurologická ambulance",1,"577747679","Ne",NULL),
("Lékárna, prodejna zdravotnického materiálu",2,"577362826","Ne",NULL),
("Hematologicko-transfuzní oddělení",3,"577867240","Ano",127),
("Domácí péče",13,"577795456","Ne",NULL),
("Onkologická ambulance",13,"577203015","Ne",NULL),
("RDG",4,"577791023","Ano",378),
("CT",4,"577773637","Ne",NULL),
("Ultrazvuk",4,"577476065","Ne",NULL),
("DIP – Dlouhodobá intenzivní péče",4,"577190681","Ano",60),
("Chirurgická ambulance",5,"577141501","Ano",410),
("Traumatologická ambulance",5,"577205627","Ano",121),
("Lékařská pohotovostní služba pro dospělé",5,"577585411","Ne",NULL),
("ARO",5,"577942527","Ano",163),
("Urologické oddělení",6,"577856396","Ano",79),
("Ortopedické oddělení",6,"577234558","Ne",NULL),
("Traumatologické oddělení",6,"577428646","Ne",NULL),
("Chirurgické oddělení",6,"577952730","Ano",491),
("Neurologické oddělení",6,"577415448","Ne",NULL),
("Ortopedická, urologická a ORL ambulance",6,"577714949","Ano",236),
("Oční oddělení",7,"577752484","Ne",NULL),
("Centrální operační sály a centrální sterilizace",7,"577953895","Ne",NULL),
("Chirurgická JIP",7,"577205742","Ne",NULL),
("Ředitelství",8,"577304033","Ano",70),
("Přednáškový sál",8,"577219505","Ano",213),
("Kuchyň",8,"577608766","Ano",275),
("Jídelna",8,"577628600","Ne",NULL),
("Nutriční poradna",8,"577604146","Ano",48),
("Garáže",8,"577224734","Ne",NULL),
("Porodní",9,"577408043","Ano",188),
("Gynekologie",9,"577646244","Ne",NULL),
("Dětské oddělení",9,"577442536","Ano",67),
("Dětská lékařská pohotovostní služba, Dětská ambulance",9,"577185320","Ne",NULL),
("Nukleární medicína",10,"577150317","Ano",167),
("Hematologická ambulance",12,"577418104","Ano",345),
("Občerstvení",14,"577527772","Ne",NULL),
("LDN",15,"577642962","Ano",381),
("Hemodialýza",15,"577436066","Ne",NULL),
("Rehabilitace",15,"577563279","Ne",NULL),
("Kožní ambulance",15,"577424758","Ano",335),
("Praktický lékař",15,"577353588","Ano",190),
("Dětská neurologie",15,"577264802","Ano",357),
("Anesteziologická ambulance",15,"577880262","Ano",15),
("Ambulance chronické bolesti",15,"577244588","Ne",NULL),
("Biochemická laboratoř",16,"577836492","Ano",226),
("Ambulance pro infekční choroby",16,"577436213","Ne",NULL),
("MW DIAS",11,"577415135","Ne",NULL),
("Krajská hygienická stanice",17,"577544108","Ano",229),
("Magnetická rezonance",18,"577254669","Ne",NULL);
INSERT INTO Personal(jmeno,prijmeni,id_pozice,id_specializace) VALUES
("Miroslav","Topor",1,14),
("Michaela","Vohradníková",1,10),
("Libuše","Maříková",1,8),
("Bohumil","Čech",1,6),
("Stanislav","Reimann",1,11),
("Jakub","Skotnica",1,12),
("Michal","Havlis",1,15),
("Jiří","Staněk",1,7),
("René","Jureček",1,7),
("Roman","Šedivý",1,1),
("Irena","Ryšavá",1,3),
("Klára","Bieligová",1,5),
("Jozef","Marek",1,10),
("Jaroslav","Kobosil",1,10),
("Josef","Hasil",1,3),
("Lenka","Lvová",1,7),
("Petr","Kučeravý",1,9),
("František","Novák",1,15),
("Ondřej","Michalko",1,3),
("David","Kadlec",1,4),
("Emilie","Honsnejmanová",1,12),
("Aleš","Weiss",1,15),
("Hana","Juřenová",1,7),
("Radim","Štrunc",1,14),
("Martin","Cipín",1,12),
("Tereza","Novotná",1,3),
("Jana","Chrudinová",1,2),
("Marie","Pokrývková",1,14),
("Anna","Pařízková",1,12),
("Soňa","Rozsypalová",1,7),
("Václav","Houda",1,10),
("Andrea","Vaverková",1,15),
("Mária","Babková",1,9),
("Věra","Davidová",1,15),
("Jan","Brázda",1,2),
("Libor","Kelnar",1,14),
("Pavel","Petržela",1,4),
("Zbyněk","Marinčák",1,11),
("Božena","Jiránková",1,13),
("Iveta","Dvořáková",1,1),
("Ivana","Friedbergerová",1,14),
("Helena","Vaniová",1,8),
("Veronika","Mezerová",1,5),
("Pavlína","Provazníková",1,11),
("Kristýna","Žižková",1,9),
("Radka","Staňová",1,7),
("Lukáš","Stránský",1,8),
("Denisa","Kolářová",1,1),
("Miluše","Brázdová",1,3),
("Jiřina","Hamerníková",1,9),
("Markéta","Kudličková",1,4),
("Milena","Hodboďová",1,6),
("Karel","Rataj",1,11),
("Tomáš","Švácha",1,12),
("Petra","Cíchová",1,1),
("Eva","Rášová",1,13),
("Olga","Paterová",1,15),
("Daniela","Pichrtová",1,7),
("Zdeněk","Hrdina",1,5),
("Eduard","Raba",1,1),
("Dagmar","Poláková",1,12),
("Alena","Válková",1,6),
("Ludmila","Izáková",1,3),
("Tarik","Buch",1,6),
("Milan","Turek",1,1),
("Martina","Ježdíková",1,2),
("Marija","Kuncová",1,7),
("Nikolas","Dokoupil",1,5),
("Miloslava","Tichavská",1,5),
("Bohumír","Orator",1,11),
("Nela","Andrlová",2,18),
("Simona","Šrámková",2,20),
("Eva","Kalinová",2,19),
("Marie","Baníková",2,17),
("Kateřina","Jedličková",2,19),
("Renata","Mosazná",2,20),
("Šárka","Baráková",2,19),
("Jana","Čechová",2,20),
("Zdenka","Trávníčková",2,16),
("Michaela","Křupková",2,19),
("Pavla","Ryšánková",2,20),
("Aloisie","Kratochvílová",2,17),
("Hana","Fišarová",2,16),
("Martina","Křížková",2,17),
("Marcela","Tučková",2,19),
("Lucie","Kulišanová",2,16),
("Marta","Hejníková",2,17),
("Anna","Brožková",2,20),
("Věra","Rusnak",2,19),
("Pavlína","Hocková",2,19),
("Jarmila","Peschtová",2,16),
("Ludmila","Hodačová",2,20),
("Miroslava","Pustějovská",2,16),
("Alena","Böhmová",2,17),
("Lenka","Kučerová",2,16),
("Dana","Jandová",2,18),
("Karolína","Šormová",2,18),
("Yveta","Hanousková",2,16),
("Edita","Vaňharová",2,20),
("Helena","Jelínková",2,16),
("Petra","Moravská",2,20),
("Jitka","Šaržíková",2,18),
("Monika","Chaloupková",2,17),
("Jiřina","Hájková",2,20),
("Růžena","Havlová",2,20),
("Vlasta","Urbánková",2,18),
("Lada","Vácová",2,20),
("Markéta","Rychnovská",2,16),
("Zdeňka","Tioková",2,16),
("Iveta","Bubeníková",2,19),
("Jaroslava","Černá",2,17),
("Iva","Hrbková",2,17),
("Tereza","Blažková",2,16),
("Dagmar","Melichová",2,18),
("Zuzana","Rudišová",2,18),
("Štefánia","Bobková",2,18),
("Ivana","Brejchová",2,18),
("Veronika","Fajmonová",2,18),
("Irena","Kozderová",2,17),
("Barbora","Stará",2,17),
("Gabriela","Štenclová",2,18),
("Greta","Konečná",2,16),
("Milena","Vymazalová",2,17),
("Gertruda","Burianová",2,19),
("Renáta","Matasová",2,16),
("Milada","Škábová",2,17),
("Jindra","Bártíková",2,17),
("Lyudmyla","Šrajerová",2,17),
("Božena","Krátká",2,16),
("Libuše","Králová",2,20),
("Miluška","Krejčová",2,18),
("Justina","Pešková",2,19),
("Žaneta","Plachá",2,17),
("Ivona","Dvořáková",2,19),
("Maria","Oračková",2,16),
("Kristýna","Gígelová",2,20),
("Naděžda","Mysíková",2,19),
("Eliška","Řepová",2,17),
("Anežka","Flekačová",2,16),
("Danuše","Hamroziová",2,20),
("Jindřiška","Kubíková",2,20),
("Sabina","Helekalová",2,19),
("Stanislava","Křížová",2,17),
("Květoslava","Lorencová",2,17),
("Nikola","Frýbová",2,19),
("Andrea","Piačková",2,17),
("Viera","Braunová",2,19),
("Blanka","Opršalová",2,19),
("Julie","Temňáková",2,20),
("Olga","Štebelová",2,19);
INSERT INTO Pozice(nazev_pozice,plat) VALUES
("lékař",32000),
("sestra",28000);
INSERT INTO Specializace(nazev_specializace) VALUES
("anesteziologie a intenzivní medicína"),
("dermatovenerologie"),
("endokrinologie a diabetologie"),
("gastroenterologie"),
("gynekologie a porodnictví"),
("hematologie a transfuzní lékařství"),
("chirurgie"),
("kardiologie"),
("klinická onkologie"),
("neurologie"),
("ortopedie a traumatologie pohybového ústrojí"),
("otorinolaryngologie a chirurgie hlavy a krku"),
("radiologie a zobrazovací metody"),
("urologie"),
("všeobecné praktické lékařství"),
("všeobecná sestra"),
("dětská sestra"),
("porodní asistentka"),
("zdravotní laborant"),
("praktická sestra");
INSERT INTO OddPers(id_personal,id_oddeleni,primar,kontakt_primar,vrchni_sestra,kontakt_sestra) VALUES
(1,17,NULL,NULL,NULL,NULL),
(2,46,"Ano",577390915,NULL,NULL),
(3,17,NULL,NULL,NULL,NULL),
(4,29,"Ano",577931610,NULL,NULL),
(5,15,"Ano",577314472,NULL,NULL),
(6,7,NULL,NULL,NULL,NULL),
(7,33,NULL,NULL,NULL,NULL),
(8,37,"Ano",577226769,NULL,NULL),
(9,50,NULL,NULL,NULL,NULL),
(10,44,NULL,NULL,NULL,NULL),
(11,31,"Ano",577634722,NULL,NULL),
(12,34,NULL,NULL,NULL,NULL),
(13,5,"Ano",577567446,NULL,NULL),
(14,2,NULL,NULL,NULL,NULL),
(15,7,"Ano",577615184,NULL,NULL),
(16,13,"Ano",577577141,NULL,NULL),
(17,25,NULL,NULL,NULL,NULL),
(18,24,"Ano",577572699,NULL,NULL),
(19,20,NULL,NULL,NULL,NULL),
(20,14,NULL,NULL,NULL,NULL),
(21,40,"Ano",577980181,NULL,NULL),
(22,1,NULL,NULL,NULL,NULL),
(23,42,NULL,NULL,NULL,NULL),
(24,38,"Ano",577337626,NULL,NULL),
(25,18,"Ano",577633708,NULL,NULL),
(26,29,NULL,NULL,NULL,NULL),
(27,48,NULL,NULL,NULL,NULL),
(28,9,NULL,NULL,NULL,NULL),
(29,36,"Ano",577337517,NULL,NULL),
(30,48,"Ano",577639154,NULL,NULL),
(31,14,"Ano",577765109,NULL,NULL),
(32,36,"Ano",577440345,NULL,NULL),
(33,19,NULL,NULL,NULL,NULL),
(34,33,"Ano",577539579,NULL,NULL),
(35,39,"Ano",577622402,NULL,NULL),
(36,36,NULL,NULL,NULL,NULL),
(37,45,"Ano",577445989,NULL,NULL),
(38,27,NULL,NULL,NULL,NULL),
(39,15,"Ano",577670695,NULL,NULL),
(40,29,"Ano",577703672,NULL,NULL),
(41,39,"Ano",577426135,NULL,NULL),
(42,24,"Ano",577117939,NULL,NULL),
(43,11,NULL,NULL,NULL,NULL),
(44,7,"Ano",577369976,NULL,NULL),
(45,5,NULL,NULL,NULL,NULL),
(46,42,NULL,NULL,NULL,NULL),
(47,21,"Ano",577653887,NULL,NULL),
(48,1,"Ano",577160557,NULL,NULL),
(49,42,"Ano",577232639,NULL,NULL),
(50,13,NULL,NULL,NULL,NULL),
(51,24,"Ano",577522616,NULL,NULL),
(52,14,"Ano",577482998,NULL,NULL),
(53,7,"Ano",577695439,NULL,NULL),
(54,3,NULL,NULL,NULL,NULL),
(55,15,"Ano",577556083,NULL,NULL),
(56,33,NULL,NULL,NULL,NULL),
(57,46,"Ano",577401978,NULL,NULL),
(58,13,NULL,NULL,NULL,NULL),
(59,16,"Ano",577182901,NULL,NULL),
(60,3,"Ano",577638509,NULL,NULL),
(61,24,"Ano",577584849,NULL,NULL),
(62,23,NULL,NULL,NULL,NULL),
(63,25,NULL,NULL,NULL,NULL),
(64,15,"Ano",577405251,NULL,NULL),
(65,22,NULL,NULL,NULL,NULL),
(66,14,"Ano",577179373,NULL,NULL),
(67,41,NULL,NULL,NULL,NULL),
(68,38,"Ano",577626017,NULL,NULL),
(69,15,NULL,NULL,NULL,NULL),
(70,47,NULL,NULL,NULL,NULL),
(71,29,NULL,NULL,NULL,NULL),
(72,50,NULL,NULL,NULL,NULL),
(73,22,NULL,NULL,NULL,NULL),
(74,2,NULL,NULL,NULL,NULL),
(75,37,NULL,NULL,"Ano",577336212),
(76,22,NULL,NULL,"Ano",577528263),
(77,25,NULL,NULL,"Ano",577722596),
(78,21,NULL,NULL,NULL,NULL),
(79,17,NULL,NULL,"Ano",577932325),
(80,31,NULL,NULL,NULL,NULL),
(81,21,NULL,NULL,"Ano",577799344),
(82,12,NULL,NULL,NULL,NULL),
(83,16,NULL,NULL,NULL,NULL),
(84,35,NULL,NULL,"Ano",577893763),
(85,33,NULL,NULL,NULL,NULL),
(86,26,NULL,NULL,"Ano",577701959),
(87,16,NULL,NULL,NULL,NULL),
(88,5,NULL,NULL,NULL,NULL),
(89,10,NULL,NULL,NULL,NULL),
(90,49,NULL,NULL,NULL,NULL),
(91,14,NULL,NULL,"Ano",577609025),
(92,35,NULL,NULL,NULL,NULL),
(93,48,NULL,NULL,"Ano",577999648),
(94,50,NULL,NULL,"Ano",577162770),
(95,40,NULL,NULL,NULL,NULL),
(96,43,NULL,NULL,"Ano",577221269),
(97,28,NULL,NULL,NULL,NULL),
(98,37,NULL,NULL,"Ano",577871247),
(99,13,NULL,NULL,"Ano",577907932),
(100,15,NULL,NULL,NULL,NULL),
(101,29,NULL,NULL,NULL,NULL),
(102,14,NULL,NULL,"Ano",577743245),
(103,10,NULL,NULL,"Ano",577270344),
(104,27,NULL,NULL,"Ano",577758930),
(105,20,NULL,NULL,NULL,NULL),
(106,5,NULL,NULL,NULL,NULL),
(107,18,NULL,NULL,"Ano",577235131),
(108,5,NULL,NULL,NULL,NULL),
(109,32,NULL,NULL,NULL,NULL),
(110,8,NULL,NULL,NULL,NULL),
(111,29,NULL,NULL,NULL,NULL),
(112,5,NULL,NULL,NULL,NULL),
(113,29,NULL,NULL,NULL,NULL),
(114,32,NULL,NULL,NULL,NULL),
(115,44,NULL,NULL,"Ano",577378345),
(116,31,NULL,NULL,NULL,NULL),
(117,40,NULL,NULL,"Ano",577248566),
(118,45,NULL,NULL,NULL,NULL),
(119,19,NULL,NULL,NULL,NULL),
(120,18,NULL,NULL,NULL,NULL),
(121,7,NULL,NULL,"Ano",577927860),
(122,48,NULL,NULL,"Ano",577720938),
(123,29,NULL,NULL,"Ano",577301434),
(124,42,NULL,NULL,"Ano",577833304),
(125,50,NULL,NULL,"Ano",577421996),
(126,50,NULL,NULL,NULL,NULL),
(127,19,NULL,NULL,"Ano",577761477),
(128,31,NULL,NULL,"Ano",577416309),
(129,34,NULL,NULL,NULL,NULL),
(130,43,NULL,NULL,NULL,NULL),
(131,11,NULL,NULL,NULL,NULL),
(132,5,NULL,NULL,NULL,NULL),
(133,30,NULL,NULL,NULL,NULL),
(134,34,NULL,NULL,NULL,NULL),
(135,25,NULL,NULL,"Ano",577550969),
(136,9,NULL,NULL,"Ano",577640829),
(137,42,NULL,NULL,"Ano",577177284),
(138,29,NULL,NULL,NULL,NULL),
(139,36,NULL,NULL,"Ano",577293393),
(140,50,NULL,NULL,NULL,NULL),
(141,46,NULL,NULL,NULL,NULL),
(142,40,NULL,NULL,"Ano",577479196),
(143,43,NULL,NULL,NULL,NULL),
(144,17,NULL,NULL,NULL,NULL),
(145,10,NULL,NULL,"Ano",577334270),
(146,49,NULL,NULL,"Ano",577888514),
(147,28,NULL,NULL,NULL,NULL),
(148,15,NULL,NULL,"Ano",577174081),
(149,26,NULL,NULL,"Ano",577566529),
(150,17,NULL,NULL,"Ano",577534116),
(52,27,NULL,NULL,NULL,NULL),
(15,28,"Ano",577146736,NULL,NULL),
(12,18,NULL,NULL,NULL,NULL),
(143,40,NULL,NULL,NULL,NULL),
(32,22,NULL,NULL,NULL,NULL),
(27,28,NULL,NULL,NULL,NULL),
(135,47,NULL,NULL,NULL,NULL),
(4,18,"Ano",577371015,NULL,NULL),
(60,31,NULL,NULL,NULL,NULL),
(99,5,NULL,NULL,"Ano",577367626),
(50,7,NULL,NULL,NULL,NULL),
(84,50,NULL,NULL,NULL,NULL),
(135,26,NULL,NULL,NULL,NULL),
(77,45,NULL,NULL,NULL,NULL),
(87,37,NULL,NULL,NULL,NULL),
(139,8,NULL,NULL,"Ano",577611202),
(5,47,"Ano",577806076,NULL,NULL),
(78,41,NULL,NULL,"Ano",577915480),
(46,48,"Ano",577910721,NULL,NULL),
(43,33,NULL,NULL,NULL,NULL),
(4,15,"Ano",577869395,NULL,NULL),
(24,35,"Ano",577856620,NULL,NULL),
(96,16,NULL,NULL,"Ano",577433105),
(17,28,"Ano",577561659,NULL,NULL),
(19,3,"Ano",577112062,NULL,NULL),
(66,28,NULL,NULL,NULL,NULL),
(124,36,NULL,NULL,NULL,NULL),
(102,26,NULL,NULL,NULL,NULL),
(53,46,"Ano",577345180,NULL,NULL),
(53,7,"Ano",577598427,NULL,NULL),
(146,46,NULL,NULL,"Ano",577817190),
(117,42,NULL,NULL,NULL,NULL),
(147,36,NULL,NULL,NULL,NULL),
(44,2,"Ano",577187298,NULL,NULL),
(64,20,"Ano",577427918,NULL,NULL),
(140,34,NULL,NULL,NULL,NULL),
(35,33,NULL,NULL,NULL,NULL),
(144,28,NULL,NULL,NULL,NULL),
(110,23,NULL,NULL,"Ano",577435674),
(115,50,NULL,NULL,NULL,NULL),
(53,30,NULL,NULL,NULL,NULL),
(81,49,NULL,NULL,NULL,NULL),
(28,13,NULL,NULL,NULL,NULL),
(44,36,NULL,NULL,NULL,NULL),
(31,44,"Ano",577637782,NULL,NULL),
(34,28,"Ano",577301775,NULL,NULL),
(91,9,NULL,NULL,"Ano",577837799),
(118,9,NULL,NULL,"Ano",577430246),
(86,11,NULL,NULL,"Ano",577235485),
(143,35,NULL,NULL,"Ano",577141205),
(48,16,NULL,NULL,NULL,NULL),
(27,28,"Ano",577637624,NULL,NULL),
(16,42,"Ano",577428756,NULL,NULL),
(76,30,NULL,NULL,NULL,NULL),
(104,38,NULL,NULL,"Ano",577765733),
(71,22,NULL,NULL,"Ano",577506189),
(5,33,"Ano",577452439,NULL,NULL),
(41,27,NULL,NULL,NULL,NULL),
(106,43,NULL,NULL,"Ano",577457288),
(57,20,NULL,NULL,NULL,NULL),
(145,20,NULL,NULL,NULL,NULL),
(23,15,"Ano",577470081,NULL,NULL),
(116,45,NULL,NULL,NULL,NULL),
(23,9,"Ano",577602920,NULL,NULL),
(20,16,NULL,NULL,NULL,NULL),
(69,43,NULL,NULL,NULL,NULL),
(142,7,NULL,NULL,NULL,NULL),
(78,21,NULL,NULL,"Ano",577350824),
(127,40,NULL,NULL,NULL,NULL),
(76,34,NULL,NULL,"Ano",577941716),
(19,38,"Ano",577283238,NULL,NULL),
(36,46,"Ano",577501300,NULL,NULL),
(69,42,NULL,NULL,NULL,NULL),
(1,3,NULL,NULL,NULL,NULL),
(67,21,"Ano",577586046,NULL,NULL),
(126,9,NULL,NULL,"Ano",577773622),
(4,19,NULL,NULL,NULL,NULL),
(115,25,NULL,NULL,NULL,NULL),
(29,42,NULL,NULL,NULL,NULL),
(56,43,"Ano",577840306,NULL,NULL),
(115,48,NULL,NULL,"Ano",577799314),
(33,27,NULL,NULL,NULL,NULL),
(44,42,"Ano",577786935,NULL,NULL),
(146,15,NULL,NULL,"Ano",577414337),
(140,35,NULL,NULL,"Ano",577651883),
(76,46,NULL,NULL,NULL,NULL),
(44,27,NULL,NULL,NULL,NULL),
(34,45,"Ano",577689542,NULL,NULL),
(60,20,NULL,NULL,NULL,NULL),
(131,47,NULL,NULL,NULL,NULL),
(34,32,"Ano",577929063,NULL,NULL),
(109,42,NULL,NULL,"Ano",577807039),
(133,31,NULL,NULL,"Ano",577223539),
(113,46,NULL,NULL,"Ano",577432593),
(10,9,"Ano",577279217,NULL,NULL),
(6,6,"Ano",577595860,NULL,NULL),
(88,49,NULL,NULL,NULL,NULL),
(145,38,NULL,NULL,NULL,NULL),
(51,8,NULL,NULL,NULL,NULL),
(135,13,NULL,NULL,"Ano",577265084),
(30,9,"Ano",577114029,NULL,NULL),
(148,35,NULL,NULL,NULL,NULL),
(124,35,NULL,NULL,NULL,NULL),
(17,13,"Ano",577784084,NULL,NULL),
(24,28,NULL,NULL,NULL,NULL),
(137,4,NULL,NULL,"Ano",577369925),
(74,37,NULL,NULL,"Ano",577540372),
(111,33,NULL,NULL,"Ano",577415504),
(98,47,NULL,NULL,"Ano",577383769),
(43,34,NULL,NULL,NULL,NULL),
(49,10,"Ano",577782625,NULL,NULL),
(97,49,NULL,NULL,"Ano",577129633),
(149,50,NULL,NULL,"Ano",577266693),
(1,45,NULL,NULL,NULL,NULL),
(131,19,NULL,NULL,"Ano",577517928),
(72,31,NULL,NULL,"Ano",577129002),
(122,2,NULL,NULL,"Ano",577775079),
(18,39,"Ano",577430197,NULL,NULL),
(144,4,NULL,NULL,"Ano",577566092),
(88,37,NULL,NULL,"Ano",577446591),
(68,41,"Ano",577176853,NULL,NULL),
(14,43,"Ano",577198938,NULL,NULL),
(46,32,NULL,NULL,NULL,NULL),
(121,26,NULL,NULL,"Ano",577613375),
(139,8,NULL,NULL,"Ano",577341499),
(61,22,"Ano",577716086,NULL,NULL),
(63,33,NULL,NULL,NULL,NULL),
(147,35,NULL,NULL,NULL,NULL),
(57,20,NULL,NULL,NULL,NULL),
(138,21,NULL,NULL,"Ano",577605990),
(23,1,NULL,NULL,NULL,NULL),
(124,3,NULL,NULL,"Ano",577287522),
(44,9,"Ano",577421464,NULL,NULL),
(54,2,NULL,NULL,NULL,NULL),
(149,37,NULL,NULL,"Ano",577769990),
(46,3,NULL,NULL,NULL,NULL),
(87,10,NULL,NULL,"Ano",577284359),
(131,16,NULL,NULL,NULL,NULL),
(20,1,"Ano",577309252,NULL,NULL),
(36,36,"Ano",577471204,NULL,NULL),
(125,25,NULL,NULL,"Ano",577884858),
(42,34,NULL,NULL,NULL,NULL),
(88,48,NULL,NULL,NULL,NULL),
(6,26,"Ano",577237640,NULL,NULL),
(44,15,NULL,NULL,NULL,NULL),
(114,2,NULL,NULL,"Ano",577602858),
(137,30,NULL,NULL,"Ano",577690356),
(12,20,"Ano",577238152,NULL,NULL),
(149,28,NULL,NULL,NULL,NULL),
(109,35,NULL,NULL,"Ano",577912178),
(72,30,NULL,NULL,NULL,NULL),
(3,7,"Ano",577757494,NULL,NULL),
(114,50,NULL,NULL,"Ano",577889836),
(38,22,NULL,NULL,NULL,NULL),
(11,14,"Ano",577317992,NULL,NULL),
(100,42,NULL,NULL,NULL,NULL),
(122,28,NULL,NULL,NULL,NULL),
(55,11,NULL,NULL,NULL,NULL),
(114,4,NULL,NULL,NULL,NULL),
(72,19,NULL,NULL,NULL,NULL),
(109,46,NULL,NULL,"Ano",577889945),
(150,17,NULL,NULL,"Ano",577422201),
(55,36,"Ano",577113909,NULL,NULL),
(132,7,NULL,NULL,NULL,NULL),
(16,42,NULL,NULL,NULL,NULL),
(121,7,NULL,NULL,NULL,NULL),
(1,46,NULL,NULL,NULL,NULL),
(3,46,NULL,NULL,NULL,NULL),
(82,23,NULL,NULL,"Ano",577491973),
(89,30,NULL,NULL,"Ano",577924441),
(146,37,NULL,NULL,NULL,NULL),
(141,28,NULL,NULL,"Ano",577681267),
(19,26,NULL,NULL,NULL,NULL),
(128,41,NULL,NULL,NULL,NULL),
(119,36,NULL,NULL,NULL,NULL),
(36,34,"Ano",577168450,NULL,NULL),
(90,28,NULL,NULL,"Ano",577858853),
(66,20,"Ano",577309434,NULL,NULL),
(66,38,"Ano",577227953,NULL,NULL),
(65,1,"Ano",577617657,NULL,NULL),
(106,41,NULL,NULL,"Ano",577507877),
(112,19,NULL,NULL,"Ano",577669415),
(62,13,"Ano",577561754,NULL,NULL),
(76,9,NULL,NULL,NULL,NULL),
(59,6,"Ano",577867669,NULL,NULL),
(47,25,"Ano",577268927,NULL,NULL),
(33,14,"Ano",577434285,NULL,NULL),
(5,32,"Ano",577334404,NULL,NULL),
(85,43,NULL,NULL,NULL,NULL),
(135,9,NULL,NULL,NULL,NULL),
(21,8,NULL,NULL,NULL,NULL),
(3,9,"Ano",577312032,NULL,NULL),
(135,17,NULL,NULL,"Ano",577661113),
(95,30,NULL,NULL,"Ano",577262525),
(146,4,NULL,NULL,"Ano",577719745),
(103,11,NULL,NULL,"Ano",577917690),
(132,15,NULL,NULL,NULL,NULL),
(125,19,NULL,NULL,NULL,NULL),
(143,34,NULL,NULL,"Ano",577382166),
(21,13,NULL,NULL,NULL,NULL);
-- VÝPIS
SELECT nazev_budovy,nazev_oddeleni,kontakt_telefon,luzkova_cast,pocet_luzek,primar,kontakt_primar,vrchni_sestra,kontakt_sestra,jmeno,prijmeni,nazev_pozice,plat,nazev_specializace FROM Budova
INNER JOIN Oddeleni USING (id_budovy)
INNER JOIN OddPers USING (id_oddeleni)
INNER JOIN Personal USING (id_personal)
INNER JOIN Pozice USING (id_pozice)
INNER JOIN Specializace USING (id_specializace)
ORDER BY nazev_budovy ASC; Write, Run & Share MariaDB queries online using OneCompiler's MariaDB online editor and compiler for free. It's one of the robust, feature-rich online editor and compiler for MariaDB. Getting started with the OneCompiler's MariaDB editor is really simple and pretty fast. The editor shows sample boilerplate code when you choose database as 'MariaDB' and start writing queries to learn and test online without worrying about tedious process of installation.
MariaDB is a community developed, open source relational database management system.
CREATE command is used to create a table, schema or an index.
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
....);
ALTER command is used to add, modify or delete columns or constraints from the database table.
ALTER TABLE Table_name ADD column_name datatype;
TRUNCATE command is used to delete the data present in the table but this will not delete the table.
TRUNCATE table table_name;
DROP command is used to delete the table along with its data.
DROP TABLE table_name;
RENAME command is used to rename the table name.
ALTER TABLE table_name1 RENAME to new_table_name1;
INSERT Statement is used to insert new records into the database table.
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
Select statement is used to select data from database tables.
SELECT column1, column2, ...
FROM table_name;
UPDATE statement is used to modify the existing values of records present in the database table.
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
DELETE statement is used to delete the existing records present in the database table.
DELETE FROM table_name where condition;