create database fakulta;

drop table predmet;
drop table aktivity;
drop table ucitel;
drop table zkouska;
drop table informace;
drop table teriminzk;
drop table varianty;
drop table student;
drop table zapocet;

drop sequence id_predmet;
drop sequence id_aktivity;
drop sequence id_ucitel;
drop sequence id_zkouska;
drop sequence id_informace;
drop sequence id_terimin_zk;
drop sequence id_varianty;
drop sequence id_student;
drop sequence id_zapocet;

Create table predmet(
id_predmet int auto_increment primary key,
zkratka
nazev
ak_rok
kredity
prednasky
cviceni
zakonceni
);



Create table aktivity(
id_aktivity int auto_increment primary key,
popis
datum
interval
body

);



Create table ucitel(
id_ucitel int auto_increment primary key,
cislo
jmeno
);

Create table zkouska(
id_zkouska int auto_increment primary key,
popis
minbody
maxbody
datum
trvani
prihlasovani
);

Create table informace(
id_informace int auto_increment primary key,
znamka
pocet
zapis
);

Create table termin_zk(
id_termin_zk int auto_increment primary key,
datum
trvani
popis
interval
zpusob);

Create table varianty(
id_varianty int auto_increment primary key,
);

Create table student(
id_student int auto_increment primary key,
identifikator
jmeno
student
);

Create table zapocet(
id_zapocet int auto_increment primary key,
);