gnumed-server 19.6-1 / var / lib / gnumed / server / sql / gmDemographics-Person-data.sql

This file is indexed.

/var/lib/gnumed/server/sql/gmDemographics-Person-data.sql is in gnumed-server 19.6-1.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below. 

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
-- project: GNUMed
-- author: Karsten Hilbert
-- license: GPL v2 or later (details at http://gnu.org)
-- identity related data
-- ===================================================================
-- $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/sql/gmDemographics-Person-data.sql,v $
-- $Id: gmDemographics-Person-data.sql,v 1.11 2006-01-09 13:46:19 ncq Exp $
-- ===================================================================
-- force terminate + exit(3) on errors if non-interactive
\set ON_ERROR_STOP 1

-- ================================================
-- please do NOT alter the sequence !!

BEGIN;
insert into dem.relation_types(biological, description, inverse) values(true,  i18n.i18n('parent'), NULL);
insert into dem.relation_types(biological, description, inverse) values(true,  i18n.i18n('child'), 1);
update dem.relation_types set inverse=2 where id=1;
insert into dem.relation_types(biological, description, inverse) values(true,  i18n.i18n('sibling'), 3);
insert into dem.relation_types(biological, description, inverse) values(true,  i18n.i18n('halfsibling'), 4);
insert into dem.relation_types(biological, description, inverse) values(false, i18n.i18n('stepparent'), NULL);
insert into dem.relation_types(biological, description, inverse) values(false, i18n.i18n('stepchild'), 5);
update dem.relation_types set inverse=6 where id=5;
insert into dem.relation_types(biological, description, inverse) values(false, i18n.i18n('married'), 7);
insert into dem.relation_types(biological, description, inverse) values(false, i18n.i18n('de facto'), 8);
insert into dem.relation_types(biological, description, inverse) values(false, i18n.i18n('divorced'), 9);
insert into dem.relation_types(biological, description, inverse) values(false, i18n.i18n('separated'), 10);
insert into dem.relation_types(biological, description, inverse) values(false, i18n.i18n('legal guardian'), NULL);
insert into dem.relation_types(biological, description, inverse) values(false, i18n.i18n('ward'), 11);
update dem.relation_types set inverse=12 where id=11;
COMMIT;

insert into dem.marital_status(name) values (i18n.i18n ('single'));
insert into dem.marital_status(name) values (i18n.i18n ('de facto'));
insert into dem.marital_status(name) values (i18n.i18n ('married'));
insert into dem.marital_status(name) values (i18n.i18n ('divorced'));
insert into dem.marital_status(name) values (i18n.i18n ('separated'));
insert into dem.marital_status(name) values (i18n.i18n ('widowed'));


insert into dem.gender_label (tag, label, sort_weight, comment) values (
	i18n.i18n('m'), i18n.i18n('male'), 3, '(m)ale'
);
insert into dem.gender_label (tag, label, sort_weight, comment) values (
	i18n.i18n('f'), i18n.i18n('female'), 3, '(f)emale'
);
insert into dem.gender_label (tag, label, sort_weight, comment) values (
	i18n.i18n('tm'), i18n.i18n('transsexual phenotype male'), 2, 'tm - (t)ranssexual phenotype (m)ale'
);
insert into dem.gender_label (tag, label, sort_weight, comment) values (
	i18n.i18n('tf'), i18n.i18n('transsexual phenotype female'), 2, 'tf - (t)ranssexual phenotype (f)emale'
);
insert into dem.gender_label (tag, label, sort_weight, comment) values (
	i18n.i18n('h'), i18n.i18n('hermaphrodite'), 1, '(h)ermaphrodite: intersexual'
);

-- ===================================================================
-- staff roles
delete from dem.staff_role;

-- standard GP practice staff
insert into dem.staff_role (name) values (i18n.i18n('doctor'));
insert into dem.staff_role (name) values (i18n.i18n('nurse'));
insert into dem.staff_role (name) values (i18n.i18n('manager'));
insert into dem.staff_role (name) values (i18n.i18n('secretary'));
insert into dem.staff_role (name) values (i18n.i18n('X-ray assistant'));
insert into dem.staff_role (name) values (i18n.i18n('lab technician'));
insert into dem.staff_role (name) values (i18n.i18n('medical student'));
insert into dem.staff_role (name) values (i18n.i18n('student nurse'));
insert into dem.staff_role (name) values (i18n.i18n('trainee - secretary'));
insert into dem.staff_role (name) values (i18n.i18n('trainee - X-ray'));
insert into dem.staff_role (name) values (i18n.i18n('trainee - lab'));

-- =============================================
-- do simple schema revision tracking
INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmDemographics-Person-data.sql,v $', '$Revision: 1.11 $');

-- =============================================
-- $Log: gmDemographics-Person-data.sql,v $
-- Revision 1.11  2006-01-09 13:46:19  ncq
-- - adjust to schema "i18n" qualification
--
-- Revision 1.10  2006/01/06 10:12:02  ncq
-- - add missing grants
-- - add_table_for_audit() now in "audit" schema
-- - demographics now in "dem" schema
-- - add view v_inds4vaccine
-- - move staff_role from clinical into demographics
-- - put add_coded_term() into "clin" schema
-- - put German things into "de_de" schema
--
-- Revision 1.9  2005/09/19 16:38:51  ncq
-- - adjust to removed is_core from gm_schema_revision
--
-- Revision 1.8  2005/07/14 21:31:42  ncq
-- - partially use improved schema revision tracking
--
-- Revision 1.7  2005/04/14 17:45:21  ncq
-- - gender_label.sort_rank -> sort_weight
--
-- Revision 1.6  2005/04/14 16:57:50  ncq
-- - add gender_label data
--
-- Revision 1.5  2005/02/12 13:49:14  ncq
-- - identity.id -> identity.pk
-- - allow NULL for identity.fk_marital_status
-- - subsequent schema changes
--
-- Revision 1.4  2004/12/20 19:04:37  ncq
-- - fixes by Ian while overhauling the demographics API
--
-- Revision 1.3  2004/12/15 09:25:53  ncq
-- - don't hardcode primary key of marital status
--
-- Revision 1.2  2004/03/02 10:22:30  ihaywood
-- support for martial status and occupations
-- .conf files now use host autoprobing
--
-- Revision 1.1  2003/08/02 10:46:03  ncq
-- - rename schema files by service
--
-- Revision 1.3  2003/05/12 12:43:39  ncq
-- - gmI18N, gmServices and gmSchemaRevision are imported globally at the
--   database level now, don't include them in individual schema file anymore
--
-- Revision 1.2  2003/05/03 14:24:56  ncq
-- - updated comment
--
-- Revision 1.1  2003/02/14 10:36:37  ncq
-- - break out default and test data into their own files, needed for dump/restore of dbs
--

APT Browse - Built by Thomas Orozco.