CREATE TABLE Klienci(
	id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) NOT NULL PRIMARY KEY,
	imie varchar(255) NOT NULL,
	nazwisko varchar(255) NOT NULL
);

CREATE TABLE Firma (
	id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) NOT NULL PRIMARY KEY,
	nazwa varchar(255) NOT NULL
);

CREATE TABLE Obroty (
	id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) NOT NULL PRIMARY KEY,
	wartosc number(10) NOT NULL,
	kierunek varchar(255) NOT NULL,
	idKlienta number(10) NOT NULL,
	idFirmy number(10) NOT NULL,


	CONSTRAINT fkObrotyFirma
	 FOREIGN KEY (idFirmy)
	 REFERENCES Firma (id)
	 ON DELETE CASCADE,

	CONSTRAINT fkObrotyKlient
	 FOREIGN KEY (idKlienta)
	 REFERENCES Klienci (id)
	 ON DELETE CASCADE
);

CREATE TABLE ObrotyTowary (
	id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) NOT NULL PRIMARY KEY,
	idObroty number(10) NOT NULL,
	idTowary number(10) NOT NULL,

	CONSTRAINT fkObroty
	 FOREIGN KEY (idObroty)
	 REFERENCES Obroty (id)
	 ON DELETE CASCADE,

	CONSTRAINT fktowary
	 FOREIGN KEY (idTowary)
	 REFERENCES Towary (id)
	 ON DELETE CASCADE
);

CREATE TABLE Towary (
	id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) NOT NULL PRIMARY KEY,
	cena number(10) NOT NULL,
	jednostka varchar(255) NOT NULL
);