One thing to point out: this implies that you are going to store a free-standing obs, and store a reference to that in the radiology report. E.g. you’ll end up with:
- an HTML file on the filesystem
- a row in the obs table, whose complex_value points to the HTML file
- a column in the radiology report table, whose value is a foreign key to the obs_id of the obs.
That may be what you want to do, but the alternative is to just use a mechanism similar to the complex obs one, but not_mechanism_, but not actually store an obs. E.g. instead you just have:
- an HTML file on the filesystem
- a column in the radiology report table that points to the HTML file
- (no obs)