1) A lead has multiple proposals (Proposal number will be different)
2) A proposal has revised versions
3) There will be a possibility to revise a revised proposal (sub version)

Find version

                                  select count(id) from proposal_versions where proposal_id={proposal_id}
                          

Find revised version

                                  select count(id) from proposal_versions where parent_version_id={version_id}