Notes

Notes - notes.io

CREATE TABLE ZVIRE(
ID_ZVIRE INT PRIMARY KEY,
JMENO VARCHAR(30) NULL,
DATUM NAROZENI DATE NOT NULL,
ZEME_PUVODU VARCHAR(30));

INSERT INTO ZVIRE VALUES ('ZVIRE_ID NEXTVALUE','ADELA','3.4.2012','AFRIKA')
INSERT INTO ZVIRE VALUES ('ZVIRE_ID NEXTVALUE','NORBERT','4.20.2011','JAPONSKO')
INSERT INTO ZVIRE VALUES ('ZVIRE_ID NEXTVALUE','DENIS','8.28.2014','AFRIKA')
INSERT INTO ZVIRE VALUES ('ZVIRE_ID NEXTVALUE','PAVLA','5.17.2016','AMERIKA')
INSERT INTO ZVIRE VALUES ('ZVIRE_ID NEXTVALUE','PETR','7.6.2010','RUSKO')

CREATE TABLE VYBEH(
ID_VYBEH INT PRIMARY KEY,
ADRESA VARCHAR(30) NULL,
PLOCHA INT,
CLENITOST_TERENU VARCHAR(30));

INSERT INTO VYBEH VALUES ('ID_VYBEH NEXTVALUE','BLOCK_7','100','8')
INSERT INTO VYBEH VALUES ('ID_VYBEH NEXTVALUE','BLOCK_1','150','3')
INSERT INTO VYBEH VALUES ('ID_VYBEH NEXTVALUE','BLOCK_8','200','4')
INSERT INTO VYBEH VALUES ('ID_VYBEH NEXTVALUE','BLOCK_4','100','12')
INSERT INTO VYBEH VALUES ('ID_VYBEH NEXTVALUE','BLOCK_3','110','15')

CREATE TABLE DRUH(
ID_DRUH INT PRIMARY KEY,
POPIS VARCHAR (60);

INSERT INTO DRUH VALUES ('ID_DRUH NEXTVALUE','BAREVNÝ')
INSERT INTO DRUH VALUES ('ID_DRUH NEXTVALUE','CHLUPATÝ')
INSERT INTO DRUH VALUES ('ID_DRUH NEXTVALUE','MALÝ')
INSERT INTO DRUH VALUES ('ID_DRUH NEXTVALUE','VELKÝ')
INSERT INTO DRUH VALUES ('ID_DRUH NEXTVALUE','HNĚDÝ')

CREATE TABLE KLEC(
ID_KLEC INT PRIMARY KEY,
JMENO VARCHAR(30) NULL,
OBJEM INT NOT NULL,
VYBAVENI VARCHAR(50);

INSERT INTO KLEC VALUES ('ID_KLEC NEXTVALUE','KLEC_1','200','OBUŠEK')
INSERT INTO KLEC VALUES ('ID_KLEC NEXTVALUE','KLEC_2','300','HRUŠKA')
INSERT INTO KLEC VALUES ('ID_KLEC NEXTVALUE','KLEC_3','300','POMERANČ')
INSERT INTO KLEC VALUES ('ID_KLEC NEXTVALUE','KLEC_4','350','JABLKO')
INSERT INTO KLEC VALUES ('ID_KLEC NEXTVALUE','KLEC_5','400','MELOUN')

CREATE TABLE KRMIC(
ID_KRMIC INT PRIMARY KEY,
JMENO VARCHAR(30) NULL,
ADRESA VARCHAR (30) NULL;

INSERT INTO KRMIC VALUES ('ID_KRMIC NEXTVALUE','PETR','ZTRACENA_11')
INSERT INTO KRMIC VALUES ('ID_KRMIC NEXTVALUE','PAVEL','NA_ROHU_32')
INSERT INTO KRMIC VALUES ('ID_KRMIC NEXTVALUE','DAVID','TRÁVNÍČKOVA_214')
INSERT INTO KRMIC VALUES ('ID_KRMIC NEXTVALUE','MARTIN','PLZEŇSKÁ_358')
INSERT INTO KRMIC VALUES ('ID_KRMIC NEXTVALUE','JIRKA','MORAVOVÁ_111')

CREATE TABLE LEKAR(
ID_LEKAR INT PRIMARY KEY,
JMENO VARCHAR(30) NULL,
DATUM_PROHLIDKY INT NOT NULL;

INSERT INTO LEKAR VALUES ('ID_LEKAR NEXTVALUE','VAŠEK','17.2.2015')
INSERT INTO LEKAR VALUES ('ID_LEKAR NEXTVALUE','ADAM','3.9.2010')
INSERT INTO LEKAR VALUES ('ID_LEKAR NEXTVALUE','MATĚJ','9.7.2014')
INSERT INTO LEKAR VALUES ('ID_LEKAR NEXTVALUE','NORBERT','1.1.2011')
INSERT INTO LEKAR VALUES ('ID_LEKAR NEXTVALUE','KAREL','6.12.2012)

CREATE TABLE ZVIRE_DRUH(
ID_ZVIRE INT REFERENCES ZVIRE (ID_ZVIRE),
ID_DRUH INT REFERENCES DRUH (ID_DRUH),
PRIMARY KEY (ID_ZVIRE, ID_DRUH));

INSERT INTO ZVIRE_DRUH VALUES ('1','1'),
INSERT INTO ZVIRE_DRUH VALUES ('1','2'),
INSERT INTO ZVIRE_DRUH VALUES ('1','3'),
INSERT INTO ZVIRE_DRUH VALUES ('1','4'),
INSERT INTO ZVIRE_DRUH VALUES ('1','5'),
INSERT INTO ZVIRE_DRUH VALUES ('2','1'),
INSERT INTO ZVIRE_DRUH VALUES ('2','2'),
INSERT INTO ZVIRE_DRUH VALUES ('2','3'),
INSERT INTO ZVIRE_DRUH VALUES ('2','4'),
INSERT INTO ZVIRE_DRUH VALUES ('2','5'),
INSERT INTO ZVIRE_DRUH VALUES ('3','1'),
INSERT INTO ZVIRE_DRUH VALUES ('3','2'),
INSERT INTO ZVIRE_DRUH VALUES ('3','3'),
INSERT INTO ZVIRE_DRUH VALUES ('3','4'),
INSERT INTO ZVIRE_DRUH VALUES ('3','5'),
INSERT INTO ZVIRE_DRUH VALUES ('4','1'),
INSERT INTO ZVIRE_DRUH VALUES ('4','2'),
INSERT INTO ZVIRE_DRUH VALUES ('4','3'),
INSERT INTO ZVIRE_DRUH VALUES ('4','4'),
INSERT INTO ZVIRE_DRUH VALUES ('4','5'),
INSERT INTO ZVIRE_DRUH VALUES ('5','1'),
INSERT INTO ZVIRE_DRUH VALUES ('5','2'),
INSERT INTO ZVIRE_DRUH VALUES ('5','3'),
INSERT INTO ZVIRE_DRUH VALUES ('5','4'),
INSERT INTO ZVIRE_DRUH VALUES ('5','5'),

CREATE TABLE ZVIRE_VYBEH(
ID_ZVIRE INT REFERENCES ZVIRE (ID_ZVIRE),
ID_VYBEH INT REFERENCES VYBEH (ID_VYBEH),
PRIMARY KEY (ID_ZVIRE, ID_VYBEH));

INSERT INTO ZVIRE_VYBEH VALUES ('1','1'),
INSERT INTO ZVIRE_VYBEH VALUES ('1','2'),
INSERT INTO ZVIRE_VYBEH VALUES ('1','3'),
INSERT INTO ZVIRE_VYBEH VALUES ('1','4'),
INSERT INTO ZVIRE_VYBEH VALUES ('1','5'),
INSERT INTO ZVIRE_VYBEH VALUES ('2','1'),
INSERT INTO ZVIRE_VYBEH VALUES ('2','2'),
INSERT INTO ZVIRE_VYBEH VALUES ('2','3'),
INSERT INTO ZVIRE_VYBEH VALUES ('2','4'),
INSERT INTO ZVIRE_VYBEH VALUES ('2','5'),
INSERT INTO ZVIRE_VYBEH VALUES ('3','1'),
INSERT INTO ZVIRE_VYBEH VALUES ('3','2'),
INSERT INTO ZVIRE_VYBEH VALUES ('3','3'),
INSERT INTO ZVIRE_VYBEH VALUES ('3','4'),
INSERT INTO ZVIRE_VYBEH VALUES ('3','5'),
INSERT INTO ZVIRE_VYBEH VALUES ('4','1'),
INSERT INTO ZVIRE_VYBEH VALUES ('4','2'),
INSERT INTO ZVIRE_VYBEH VALUES ('4','3'),
INSERT INTO ZVIRE_VYBEH VALUES ('4','4'),
INSERT INTO ZVIRE_VYBEH VALUES ('4','5'),
INSERT INTO ZVIRE_VYBEH VALUES ('5','1'),
INSERT INTO ZVIRE_VYBEH VALUES ('5','2'),
INSERT INTO ZVIRE_VYBEH VALUES ('5','3'),
INSERT INTO ZVIRE_VYBEH VALUES ('5','4'),
INSERT INTO ZVIRE_VYBEH VALUES ('5','5'),

CREATE TABLE VYBEH_KRMIC(
ID_VYBEH INT REFERENCES VYBEH (ID_VYBEH),
ID_KRMIC INT REFERENCES KRMIC (ID_KRMIC),
PRIMARY KEY (ID_VYBEH, ID_KRMIC));

INSERT INTO VYBEH_KRMIC VALUES ('1','1'),
INSERT INTO VYBEH_KRMIC VALUES ('1','2'),
INSERT INTO VYBEH_KRMIC VALUES ('1','3'),
INSERT INTO VYBEH_KRMIC VALUES ('1','4'),
INSERT INTO VYBEH_KRMIC VALUES ('1','5'),
INSERT INTO VYBEH_KRMIC VALUES ('2','1'),
INSERT INTO VYBEH_KRMIC VALUES ('2','2'),
INSERT INTO VYBEH_KRMIC VALUES ('2','3'),
INSERT INTO VYBEH_KRMIC VALUES ('2','4'),
INSERT INTO VYBEH_KRMIC VALUES ('2','5'),
INSERT INTO VYBEH_KRMIC VALUES ('3','1'),
INSERT INTO VYBEH_KRMIC VALUES ('3','2'),
INSERT INTO VYBEH_KRMIC VALUES ('3','3'),
INSERT INTO VYBEH_KRMIC VALUES ('3','4'),
INSERT INTO VYBEH_KRMIC VALUES ('3','5'),
INSERT INTO VYBEH_KRMIC VALUES ('4','1'),
INSERT INTO VYBEH_KRMIC VALUES ('4','2'),
INSERT INTO VYBEH_KRMIC VALUES ('4','3'),
INSERT INTO VYBEH_KRMIC VALUES ('4','4'),
INSERT INTO VYBEH_KRMIC VALUES ('4','5'),
INSERT INTO VYBEH_KRMIC VALUES ('5','1'),
INSERT INTO VYBEH_KRMIC VALUES ('5','2'),
INSERT INTO VYBEH_KRMIC VALUES ('5','3'),
INSERT INTO VYBEH_KRMIC VALUES ('5','4'),
INSERT INTO VYBEH_KRMIC VALUES ('5','5'),

CREATE TABLE VYBEH_KLEC(
ID_VYBEH INT REFERENCES VYBEH (ID_VYBEH),
ID_KLEC INT REFERENCES KLEC (ID_KLEC),
PRIMARY KEY (ID_VYBEH, ID_KLEC));

INSERT INTO VYBEH_KLEC VALUES ('1','1'),
INSERT INTO VYBEH_KLEC VALUES ('1','2'),
INSERT INTO VYBEH_KLEC VALUES ('1','3'),
INSERT INTO VYBEH_KLEC VALUES ('1','4'),
INSERT INTO VYBEH_KLEC VALUES ('1','5'),
INSERT INTO VYBEH_KLEC VALUES ('2','1'),
INSERT INTO VYBEH_KLEC VALUES ('2','2'),
INSERT INTO VYBEH_KLEC VALUES ('2','3'),
INSERT INTO VYBEH_KLEC VALUES ('2','4'),
INSERT INTO VYBEH_KLEC VALUES ('2','5'),
INSERT INTO VYBEH_KLEC VALUES ('3','1'),
INSERT INTO VYBEH_KLEC VALUES ('3','2'),
INSERT INTO VYBEH_KLEC VALUES ('3','3'),
INSERT INTO VYBEH_KLEC VALUES ('3','4'),
INSERT INTO VYBEH_KLEC VALUES ('3','5'),
INSERT INTO VYBEH_KLEC VALUES ('4','1'),
INSERT INTO VYBEH_KLEC VALUES ('4','2'),
INSERT INTO VYBEH_KLEC VALUES ('4','3'),
INSERT INTO VYBEH_KLEC VALUES ('4','4'),
INSERT INTO VYBEH_KLEC VALUES ('4','5'),
INSERT INTO VYBEH_KLEC VALUES ('5','1'),
INSERT INTO VYBEH_KLEC VALUES ('5','2'),
INSERT INTO VYBEH_KLEC VALUES ('5','3'),
INSERT INTO VYBEH_KLEC VALUES ('5','4'),
INSERT INTO VYBEH_KLEC VALUES ('5','5'),

CREATE TABLE VYBEH_LEKAR(
ID_VYBEH INT REFERENCES VYBEH (ID_VYBEH),
ID_LEKAR INT REFERENCES LEKAR (ID_LEKAR),
PRIMARY KEY (ID_VYBEH, ID_LEKAR));

INSERT INTO VYBEH_LEKAR VALUES ('1','1'),
INSERT INTO VYBEH_LEKAR VALUES ('1','2'),
INSERT INTO VYBEH_LEKAR VALUES ('1','3'),
INSERT INTO VYBEH_LEKAR VALUES ('1','4'),
INSERT INTO VYBEH_LEKAR VALUES ('1','5'),
INSERT INTO VYBEH_LEKAR VALUES ('2','1'),
INSERT INTO VYBEH_LEKAR VALUES ('2','2'),
INSERT INTO VYBEH_LEKAR VALUES ('2','3'),
INSERT INTO VYBEH_LEKAR VALUES ('2','4'),
INSERT INTO VYBEH_LEKAR VALUES ('2','5'),
INSERT INTO VYBEH_LEKAR VALUES ('3','1'),
INSERT INTO VYBEH_LEKAR VALUES ('3','2'),
INSERT INTO VYBEH_LEKAR VALUES ('3','3'),
INSERT INTO VYBEH_LEKAR VALUES ('3','4'),
INSERT INTO VYBEH_LEKAR VALUES ('3','5'),
INSERT INTO VYBEH_LEKAR VALUES ('4','1'),
INSERT INTO VYBEH_LEKAR VALUES ('4','2'),
INSERT INTO VYBEH_LEKAR VALUES ('4','3'),
INSERT INTO VYBEH_LEKAR VALUES ('4','4'),
INSERT INTO VYBEH_LEKAR VALUES ('4','5'),
INSERT INTO VYBEH_LEKAR VALUES ('5','1'),
INSERT INTO VYBEH_LEKAR VALUES ('5','2'),
INSERT INTO VYBEH_LEKAR VALUES ('5','3'),
INSERT INTO VYBEH_LEKAR VALUES ('5','4'),
INSERT INTO VYBEH_LEKAR VALUES ('5','5'),

Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...

With notes.io;

* You can take a note from anywhere and any device with internet connection.
* You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
* You can quickly share your contents without website, blog and e-mail.
* You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
* Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.

Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.

Easy: Notes.io doesn’t require installation. Just write and share note!

Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )

Free: Notes.io works for 12 years and has been free since the day it was started.

You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;

Email: [email protected]

Twitter: http://twitter.com/notesio

Instagram: http://instagram.com/notes.io

Facebook: http://facebook.com/notesio

Regards;
Notes.io Team

Notes

Notes - notes.io

Shortened Note Link

Long File

Notes