i have this new model that inherit the project.project model:
class RealEstateProject(models.Model):
_name = 'real.estate.project.classical'
_inherit = 'project.project'
_description = 'Real Estate Projects'
after running it appears this problem of many2many fields :
TypeError: Many2many fields real.estate.project.classical.favorite_user_ids and project.project.favorite_user_ids use the same table and columns
i added this field to my new model
favorite_user_ids = fields.Many2many(
'res.users',
'real_estate_project_favorite_user_rel',
'project_id',
'user_id',
string='Favorite Users'
)
then i have another field
TypeError: Many2many fields real.estate.project.classical.type_ids and project.project.type_ids use the same table and columns
so i add it
type_ids = fields.Many2many(
'project.task.type',
'real_estate_type_rel',
'project_id',
'type_id',
string='Types'
)
now after running i have this problem of foreign key:
psycopg2.errors.UndefinedColumn: column "real_estate_project_classical_id" referenced in foreign key constraint does not exist
How can i solve this please !!