Re: [Gnumed-devel] Concurrent connections on the same patient

[Karsten Hilbert]

On Thu, Jun 28, 2012 at 02:18:39PM +0200, Slappinjohn wrote:

> so which tables actually do need replication?
> 
> 
>                               List of relations
>        Schema       |                Name
> --------------------+-------------------------------------

>  bill               | bill_item

>  blobs              | doc_desc
>  blobs              | doc_med
>  blobs              | doc_obj
>  blobs              | doc_type
>  blobs              | lnk_doc2hospital_stay
>  blobs              | lnk_doc_med2episode
>  blobs              | reviewed_doc_objs

>  cfg                | cfg_data
>  cfg                | cfg_item
>  cfg                | cfg_numeric
>  cfg                | cfg_str_array
>  cfg                | cfg_string
>  cfg                | cfg_template
>  cfg                | cfg_type_enum
>  cfg                | config
>  cfg                | db_logon_banner
>  cfg                | report_query

>  clin               | _enum_allergy_type
>  clin               | active_substance
>  clin               | allergy
>  clin               | allergy_state
>  clin               | clin_aux_note
>  clin               | clin_diag
>  clin               | clin_item_type
>  clin               | clin_narrative
>  clin               | clin_root_item
>  clin               | encounter
>  clin               | encounter_type
>  clin               | episode
>  clin               | family_history
>  clin               | fhx_relation_type
>  clin               | form_data
>  clin               | form_instances
>  clin               | health_issue
>  clin               | hospital_stay
>  clin               | incoming_data_unmatchable
>  clin               | incoming_data_unmatched
>  clin               | keyword_expansion
>  clin               | lab_request
>  clin               | lnk_code2aoe
>  clin               | lnk_code2episode
>  clin               | lnk_code2fhx
>  clin               | lnk_code2h_issue
>  clin               | lnk_code2item_root
>  clin               | lnk_code2narrative
>  clin               | lnk_code2procedure
>  clin               | lnk_code2rfe
>  clin               | lnk_constraint2vacc_course
>  clin               | lnk_pat2vaccination_course
>  clin               | lnk_substance2episode
>  clin               | lnk_tst2norm
>  clin               | lnk_ttype2unified_type
>  clin               | lnk_type2item
>  clin               | lnk_vaccination_course2schedule
>  clin               | lnk_vaccine2inds
>  clin               | meta_test_type
>  clin               | procedure
>  clin               | review_root
>  clin               | reviewed_test_results
>  clin               | soap_cat_ranks
>  clin               | substance_intake
>  clin               | test_org
>  clin               | test_result
>  clin               | test_type
>  clin               | vacc_indication
>  clin               | vacc_route
>  clin               | vaccination
>  clin               | vaccination_course
>  clin               | vaccination_course_constraint
>  clin               | vaccination_definition
>  clin               | vaccination_schedule
>  clin               | vaccine
>  clin               | vaccine_batches
>  clin               | waiting_list

>  dem                | address
>  dem                | address_type
>  dem                | country
>  dem                | enum_comm_types
>  dem                | enum_ext_id_types
>  dem                | gender_label
>  dem                | identity
>  dem                | identity_tag
>  dem                | inbox_item_category
>  dem                | inbox_item_type
>  dem                | lnk_identity2comm
>  dem                | lnk_identity2ext_id
>  dem                | lnk_job2person
>  dem                | lnk_org_unit2comm
>  dem                | lnk_org_unit2ext_id
>  dem                | lnk_person2relative
>  dem                | lnk_person_org_address
>  dem                | marital_status
>  dem                | message_inbox
>  dem                | name_gender_map
>  dem                | names
>  dem                | occupation
>  dem                | org
>  dem                | org_category
>  dem                | org_unit
>  dem                | relation_types
>  dem                | staff
>  dem                | staff_role
>  dem                | state
>  dem                | street
>  dem                | urb

>  gm                 | access_log
>  gm                 | notifying_tables
>  gm                 | schema_revision

>  i18n               | curr_lang
>  i18n               | keys
>  i18n               | translations

>  ref                | atc

>  ref                | branded_drug
>  ref                | code_thesaurus_root
>  ref                | coding_system_root
>  ref                | consumable_substance
>  ref                | data_source
>  ref                | document_type
>  ref                | form_types
>  ref                | icd10
>  ref                | icd9
>  ref                | icpc
>  ref                | icpc_chapter
>  ref                | icpc_component
>  ref                | icpc_thesaurus
>  ref                | lnk_substance2brand
>  ref                | loinc

>  ref                | ops
>  ref                | other_code
>  ref                | papersizes
>  ref                | paperwork_templates
>  ref                | tag_image

That should be it.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346