-- =============================================
-- GNUmed - tracking of reviewed status of incoming data
-- =============================================
-- $Source: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmSchemaRevision.sql,v $
-- $Id: gmSchemaRevision.sql,v 1.15 2005/09/19 16:22:12 ncq Exp $
-- license: GPL
-- author: address@hidden

-- =============================================
-- force terminate + exit(3) on errors if non-interactive
\set ON_ERROR_STOP 1

-- ---------------------------------------------
create table reviewed_status (
	pk serial primary key,
	table_oid oid
		not null,
	fk_reviewed_pk integer
		not null,
	fk_reviewer integer
		not null
		references public.xlnk_identity(xfk_identity),
	is_technically_abnormal boolean
		not null,
	clinically_relevant boolean
		not null
) inherits (audit_fields);

-- =============================================
-- do simple schema revision tracking
select log_script_insertion('$RCSfile: gmWaitingList.sql,v $', '$Revision: 1.1 $');

-- =============================================
-- $Log: gmWaitingList.sql,v $
--