It sounds like the primary key constraints and foreign key references have been dropped from your Odoo database. This could be due to a number of reasons, such as a manual mistake, a bug in the software, or a problem with the database itself.

One way to solve this issue would be to restore a backup of your database that was taken before the primary key constraints and foreign key references were dropped. If you do not have a backup, you will need to manually recreate the primary key constraints and foreign key references.

To recreate the primary key constraints, you will need to run the following SQL command for each table:

ALTER TABLE ADD PRIMARY KEY ();

To recreate the foreign key references, you will need to run the following SQL command for each foreign key:

ALTER TABLE ADD FOREIGN KEY () REFERENCES ();

It is also important to check if there are any data integrity issues and fix them before recreating the foreign keys, as well as to validate that the data still makes sense after recreating the constraints.

It is highly recommended to create a backup of your database before making any changes and test it in a non-production environment first.