Why do we need a lead.opportunity_name
field in lead table
, while there is a lead.opportunity_id
field and Opportunity table has a opportunity.name
field?
I mean, when I want to know the name of the opportunity of a lead, I have two values that can be different:
-
lead.opportunity_name
(theopportunity_name
field of the lead) -
lead.opportunity.name
(the name of the opportunity of the lead)
Since the relation is “opportunity => one to many” lead, so each lead can have 0 or 1 opportunity (the lead belongs to an opportunity), is that for storing the opportunity name before the actual opportunity is created?
Btw, can the ID of an opportunity be present if more that one record in the Lead table?