CREATE TABLE SEMESTR (
	semestr_id varchar(30) NOT NULL PRIMARY KEY,
	semestr_nazwa varchar(255),
	dataOd datetime null,
	dataDo datetime null,
);

CREATE TABLE STUDENT2 (
		nr_indeksu varchar(30) NOT NULL PRIMARY KEY,
        FirstName varchar(255),
        LastName varchar(255),
        Email varchar(255),
        Telefon varchar(255),
        Wydzial varchar(255),
        Obywatelstwo varchar(255),
        RokZap varchar(255),
        Pesel varchar(255),
        Miasto varchar(255),
);

CREATE TABLE SM (
	nr_indeksu varchar(30),
	semestr_id varchar(30),
	CONSTRAINT indeks_semestr_pk PRIMARY KEY (nr_indeksu, semestr_id),
	CONSTRAINT FK_indeks
		FOREIGN KEY (nr_indeksu) REFERENCES STUDENT2 (nr_indeksu),
	CONSTRAINT FK_semestr
		FOREIGN KEY (semestr_id) REFERENCES SEMESTR (semestr_id)
);