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.

  • I will reformulate your question: is there any other way to join tables, other than a key from one table to another, or a separate table - bundles. Do you understand correctly? Well then no. - Total Pusher

0