sugar-notes-attachment

To attach Notes to a custom SugarCRM module without a join table, use the special 1:M relationship pattern via parent_id and parent_type fields instead of creating an intermediate join table.

SugarCRM uses parent_id and parent_type for Notes relationships as an exception to the typical M:M-with-join-table rule, enabling a direct 1:M relationship between Notes and custom modules without requiring a join table.

relationship_role_column and relationship_role_column_value are manual parameters required in SugarCRM relationship definitions to properly configure the special 1:M Notes attachment pattern using parent_id and parent_type fields.

Yes, you can create a one-to-many Notes relationship for a custom SugarCRM module by leveraging the parent_id and parent_type fields, which requires manual setup of relationship_role_column and relationship_role_column_value in the relationship definitions.

No, you do not need a join table for SugarCRM Notes attachments on custom modules. The Notes module is an exception to the join table rule, using parent_id and parent_type to establish a direct 1:M relationship.