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.
