An opportunity represents any sort of energy reduction or equipment renewal project in a building that will reduce operating costs for the building it is applied to. Here is how the opportunity tables relate to one another:
The relationship between the opportunity impact table and tblOppor is maintained using triggers because of the multiple foreign keys on the table.