Re: [Gnumed-devel] examining current schemas

[Karsten Hilbert]

> gmclinical stores the basic table outline (SQL CREATE TABLE commands dominate 
> here)
> gmClinicalData contains INSERT commands to fill some tables that contain 
> fixed lists, usually lists of
>  types of things, such as types of consultation.
> gmClinicalViews defines various SQL  views on the basic tables in 
> gmclinical.sql
More specifically, *Views.sql always contain SQL statements
that can be run on a live database without affecting the data
inside, eg. view definitions, triggers, indices.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346