I have a use case to relate a note to the procedure it was written to document. Some examples: pathology reports and imaging exam reports. I don't want to resort to fact_relationship. Anybody else think this is a good idea? My ideas is to add procedure_occurrence_id to the note table.