Events and Sales Opportunities
Goals Create a platform to capture and manage person-to-person, person-to-business, business-to-person, and business-to-business activities.

Events are generic may link to another table, such as a sales quote or 'opportunity' for information specific to certain kinds of events.
Guides The event table contains a 'type_id' and a 'data_id' that connects it to a table like salesop.  The 'type_id' determines the table and the 'data_id' determines the record in the table.

The fields user, user_org, target, and target_org are repeated in the salesop table for quick access and mild redundancy.

It is the intent that other tables like salesop will be added by the system designer and it will be up to the system designer to include or not include the redundant fields for their particular application.
Notes The user 'owns' the Sales Opportunity.
new02.htm