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
I mean, when I want to know the name of the opportunity of a lead, I have two values that can be different:
opportunity_namefield 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?