CREATE TABLE Entité_1(
   ident1 smallint generated by default as identity,
   PRIMARY KEY(ident1)
);
 
CREATE TABLE Entité_2(
   ident2 smallint generated by default as identity,
   PRIMARY KEY(ident2)
);
 
CREATE TABLE Entité_3(
   ident3 SMALLINT,
   PRIMARY KEY(ident3)
);
 
CREATE TABLE Entité_4(
   ident4 INT,
   PRIMARY KEY(ident4)
);
 
CREATE TABLE Asso_1(
   ident1 smallint generated by default as identity,
   ident2 smallint generated by default as identity,
   PRIMARY KEY(ident1, ident2),
   FOREIGN KEY(ident1) REFERENCES Entité_1(ident1),
   FOREIGN KEY(ident2) REFERENCES Entité_2(ident2)
);
 
CREATE TABLE Asso_2(
   ident3 SMALLINT,
   ident4 INT,
   PRIMARY KEY(ident3, ident4),
   FOREIGN KEY(ident3) REFERENCES Entité_3(ident3),
   FOREIGN KEY(ident4) REFERENCES Entité_4(ident4)
);

CREATE TABLE TRFITAUX(
   CTVAIDEN INT,
   CALDDATE DATE,
   REGNIDEN INT,
   TAUXTAUX DECIMAL(7,4) NOT NULL,
   PRIMARY KEY(CTVAIDEN, CALDDATE, REGNIDEN),
   FOREIGN KEY(CTVAIDEN) REFERENCES TRFICTVA(CTVAIDEN) ON DELETE CASCADE,
   FOREIGN KEY(CALDDATE) REFERENCES dummy(CALDDATE),
   FOREIGN KEY(REGNIDEN) REFERENCES TYGEREGN(REGNIDEN) ON DELETE CASCADE
);