161a162,176
> 
> create table generic_result (
> 	id serial primary key,
> 	reviewed_by_clinician boolean 
> 		not null
> 		default false,
> 	fk_reviewer integer
> 		default null
> 		references xlnk_identity(xfk_identity)
> 		check(((reviewed_by_clinician is false) and (fk_reviewer is null)) or (fk_reviewer is not null)),
> 	clinically_relevant boolean
> 		default null
> 		check (((reviewed_by_clinician=false) and (clinically_relevant is null)) or (clinically_relevant is not null))
> ) inherits (clin_root_item);
> 
164d178
< 	fk_doc integer, -- references gmBlobs.med_doc.id
194,205c208,209
< 	material_detail text,
< 	reviewed_by_clinician boolean   -- IMHO this should move to gmBlobs.doc_med, as all documents need this 
< 		not null
< 		default false,
< 	fk_reviewer integer
< 		default null
< 		references xlnk_identity(xfk_identity)
< 		check(((reviewed_by_clinician is false) and (fk_reviewer is null)) or (fk_reviewer is not null)),
< 	clinically_relevant boolean
< 		default null
< 		check (((reviewed_by_clinician=false) and (clinically_relevant is null)) or (clinically_relevant is not null))
< ) inherits (clin_root_item);
---
> 	material_detail text
> ) inherits (generic_result);
223,224d226
< comment on column test_result.fk_doc is
< 	'the document used to generate these results';
282a285,289
> create table report_result (
> 	id serial primary key,
> 	ufk_doc integer -- references gmBlobs.med_doc.id
> ) inherits (generic_result);
> 
284c291,292
< create table lab_request (
---
> 
> create table generic_request (
286,288d293
< 	fk_test_org integer
< 		not null
< 		references test_org(pk),
298,301d302
< 	lab_request_id text
< 		default null,
< 	lab_rxd_when timestamp with time zone
< 		default null,
313a315,326
> 	ufk_form integer -- the form used to generate this request
> ) inherits (clin_root_item);
> 
> create table lab_request (
> 	pk serial primary key,
> 	fk_test_org integer
> 		not null
> 		references test_org(pk),
> 	lab_request_id text
> 		default null,
> 	lab_rxd_when timestamp with time zone
> 		default null,