recreate table dict_devices(id int, id_dev_total int);
recreate table devices(id_device int not null, info varchar( 20 ));
alter table devices add constraint pk_device primary key(id_device);
alter table dict_devices add constraint fk_dict_devices_1
foreign key (id_dev_total) references devices(id_device)
on delete CASCADE on update CASCADE;

insert into devices values( 1 , 'abc');
insert into devices values( 2 , 'def');
insert into devices values( 3 , 'was');

insert into dict_devices values( 1 , 1 );
insert into dict_devices values( 2 , 1 );
insert into dict_devices values( 3 , 1 );
insert into dict_devices values( 4 , 1 );
insert into dict_devices values( 5 , 2 );
insert into dict_devices values( 6 , 2 );
insert into dict_devices values( 7 , 3 );
insert into dict_devices values( 8 , 3 );
insert into dict_devices values( 9 , 1 );
commit;