[Gnumed-update] - curr_medication -> clin_medication + propagate [...]

[ihaywood]

Commit from ncq (2004-09-17 16:14 EDT)
---------------

- curr_medication -> clin_medication + propagate
- partial index on clin_episode.fk_health_issue where fk_health_issue not null
- index on clin_medication.discontinued where discontinued not null
- rework v_pat_episodes since episode can now have fk_health_issue = null
- add val_target_* to v_test_results
- fix grants
- improve clin_health_issue datatypes + comments
- clin_episode: add fk_patient, fk_health_issue nullable
- but constrain: if fk_health_issue null then fk_patient NOT none or vice versa
- form_instances are soaP
- start rework of clin_medication (was curr_medication)

  gnumed  gnumed/server/sql/gmclinical.sql       1.122
  gnumed  gnumed/server/sql/gmClinicalViews.sql  1.97


Commit from ncq (2004-09-17 16:15 EDT)
---------------

- add val_target_* to test_result

  gnumed  gnumed/server/sql/gmMeasurements.sql  1.29


Commit from ncq (2004-09-17 16:16 EDT)
---------------

- cleanup, improve comments
- tighten identity constraints

  gnumed  gnumed/server/sql/gmDemographics.sql  1.35


Commit from ncq (2004-09-17 16:18 EDT)
---------------

- clin_episode_id_seq -> *_pk_seq

  gnumed  gnumed/server/sql/test-data/test_data-James_Kirk.sql      1.34
  gnumed  gnumed/server/sql/test-data/test_data-lab_regression.sql  1.7


Commit from ncq (2004-09-17 16:28 EDT)
---------------

- PG 7.4 is helpful: fix UNION

  gnumed  gnumed/server/sql/gmClinicalViews.sql  1.98


Commit from ncq (2004-09-17 16:32 EDT)
---------------

- IF there is a health issue it MUST have a label, there is no default

  gnumed  gnumed/server/sql/test-data/test_data-James_Kirk.sql  1.35


Commit from ncq (2004-09-17 16:57 EDT)
---------------

- use lowercase since things will be lowercase anyways

  gnumed  gnumed/server/bootstrap/gmNotificationSchemaGenerator.py  1.9


Commit from ncq (2004-09-17 16:59 EDT)
---------------

- remove cruft
- in v_pat_episodes UNION pull data from correct places ...

  gnumed  gnumed/server/sql/gmClinicalViews.sql  1.99


Commit from ncq (2004-09-17 17:00 EDT)
---------------

- IF health issue then MUST have description

  gnumed  gnumed/server/sql/test-data/test_data-lab_regression.sql  1.8


Commit from ncq (2004-09-17 17:02 EDT)
---------------

- further tighten clin_episode

  gnumed  gnumed/server/sql/gmclinical.sql  1.123


Commit from ncq (2004-09-17 20:19 EDT)
---------------

- add v_compl_narrative
- add v_problem_list
- include is_significant in v_pat_episodes

  gnumed  gnumed/server/sql/gmClinicalViews.sql  1.100


Commit from ncq (2004-09-17 20:20 EDT)
---------------

- add active/significant fields to episode/issue table
- improve comments
- tighten constraints on clin_episode

  gnumed  gnumed/server/sql/gmclinical.sql  1.124