CREATE DATABASE rib;

CREATE TABLE kater (
id int PRIMARY KEY,
type varchar(70) ,
data date
);

CREATE TABLE rabotniki (
id int PRIMARY KEY,
name varchar(50),
adres varchar(100)
);

CREATE TABLE doljnost (
id int PRIMARY KEY,
name varchar(50)
);

CREATE TABLE ulov (
id int PRIMARY KEY,
id_kater int,
data_v date,
data_p date,
ves varchar(40),
FOREIGN KEY (id_kater) REFERENCES kater(id)
);

CREATE TABLE banka (
id int PRIMARY KEY ,
id_ulov int,
data_p int,
data_o int,
kachestvo varchar(20),
FOREIGN KEY (id_ulov) REFERENCES ulov(id)
);

CREATE TABLE comand (
id int PRIMARY KEY,
id_comand_ulov int,
id_rabotnik int,
id_doljnost int,
FOREIGN KEY (id_rabotnik) REFERENCES rabotniki(id),
FOREIGN KEY(id_doljnost) REFERENCES doljnost(id),
FOREIGN KEY(id_comand_ulov) REFERENCES ulov(id)
);