Hello. There was a question about CRM-systems with a monthly fee (a la bitriks24, amocrm). How is the database implemented, if each project has transactions, leads, tasks, etc., where all entities are tied to the project? Is this done simply by adding the project_id field to each record in the database?
The question is abstract though, but I want to understand the possible ways.