By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Company (
idCompany SMALLINT NOT NULL,
name_company VARCHAR(45) NOT NULL,
abbr_company VARCHAR(3) NOT NULL,
PRIMARY KEY (idCompany)
);
select * FRom Company;
CREATE TABLE Employee (
idEmployee TINYINT NOT NULL,
name_Employee VARCHAR(45) NOT NULL,
abbr_Employee VARCHAR(3) NOT NULL,
PRIMARY KEY (idEmployee)
);
select * FRom Employee;
CREATE TABLE Automate (
idAutomate SMALLINT NOT NULL,
type_Automate VARCHAR(45) NOT NULL,
idCompany SMALLINT NULL,
PRIMARY KEY (idAutomate),
FOREIGN KEY (idCompany)
REFERENCES Company (idCompany)
);
select * FROM Automate;
CREATE TABLE Profit (
idCodeTurnover INT NOT NULL,
| companyname1 | companyname2 | ddate | turnover | name_Employee | idCodeTurnover | row_num |
|---|---|---|---|---|---|---|
| CE | Coffeeshop de Engel | 2011-04-11 | 2018 | Johan Bakker | 4 | 1 |
| 2011-02-11 | 1653 | Klaas Jansen | 2 | 2 | ||
| 2011-01-11 | 1542 | Jan Hein | 1 | 3 | ||
| 2011-05-11 | 1503 | Klaas Jansen | 5 | 4 | ||
| 2011-03-11 | 1482 | Jan Hein | 3 | 5 | ||
| SV | Snackbar Vork | 2011-05-12 | 2035 | Klaas Jansen | 6 | 1 |
| WSE | Kantine BV WSE | 2011-06-02 | 912 | Klaas Jansen | 8 | 1 |
| 2011-03-01 | 837 | Klaas Jansen | 7 | 2 | ||
| 2011-09-01 | 799 | Jan Hein | 9 | 3 | ||
| ZS | Zwembad de Snip | 2011-04-11 | 1387 | Johan Bakker | 10 | 1 |