[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Concurrent connections on the same patient
From: |
Slappinjohn |
Subject: |
Re: [Gnumed-devel] Concurrent connections on the same patient |
Date: |
Thu, 28 Jun 2012 14:18:39 +0200 |
User-agent: |
Mozilla/5.0 (X11; Linux x86_64; rv:10.0.4) Gecko/20120510 Icedove/10.0.4 |
Hi,
so which tables actually do need replication?
List of relations
Schema | Name
--------------------+-------------------------------------
au | referral
audit | audit_fields no
audit | audit_trail no
audit | audited_tables no
audit | log_access_log no
audit | log_active_substance no
audit | log_address no
audit | log_allergy no
audit | log_allergy_state no
audit | log_beh_fall_typ no
audit | log_behandlungsfall no
audit | log_branded_drug no
audit | log_clin_aux_note no
audit | log_clin_diag no
audit | log_clin_item_type no
audit | log_clin_narrative no
audit | log_consumable_substance no
audit | log_consumed_substance no
audit | log_data_source no
audit | log_doc_desc no
audit | log_doc_med no
audit | log_encounter no
audit | log_episode no
audit | log_family_history no
audit | log_fhx_relation_type no
audit | log_form_data no
audit | log_form_instances no
audit | log_gender_label no
audit | log_health_issue no
audit | log_hospital_stay no
audit | log_hx_family_item no
audit | log_identity no
audit | log_identity_tag no
audit | log_inbox_item_category no
audit | log_inbox_item_type no
audit | log_incoming_data_unmatchable no
audit | log_incoming_data_unmatched no
audit | log_lab_request no
audit | log_lab_test_gnr no
audit | log_lnk_code2aoe no
audit | log_lnk_code2episode no
audit | log_lnk_code2fhx no
audit | log_lnk_code2h_issue no
audit | log_lnk_code2narrative no
audit | log_lnk_code2procedure no
audit | log_lnk_code2rfe no
audit | log_lnk_constraint2vacc_course no
audit | log_lnk_identity2ext_id no
audit | log_lnk_identity2primary_doc no
audit | log_lnk_job2person no
audit | log_lnk_org_unit2comm no
audit | log_lnk_org_unit2ext_id no
audit | log_lnk_pat2vaccination_course no
audit | log_lnk_person2relative no
audit | log_lnk_substance2brand no
audit | log_lnk_tst2norm no
audit | log_lnk_type2item no
audit | log_lnk_vaccination_course2schedule no
audit | log_lnk_vaccine2inds no
audit | log_message_inbox no
audit | log_occupation no
audit | log_operation no
audit | log_org no
audit | log_org_unit no
audit | log_paperwork_templates no
audit | log_prax_geb_paid no
audit | log_procedure no
audit | log_referral no
audit | log_relation_types no
audit | log_report_query no
audit | log_staff no
audit | log_staff_role no
audit | log_state no
audit | log_street no
audit | log_substance_in_brand no
audit | log_substance_intake no
audit | log_tag_image no
audit | log_test_org no
audit | log_test_result no
audit | log_test_type no
audit | log_urb no
audit | log_vacc_indication no
audit | log_vacc_route no
audit | log_vaccination no
audit | log_vaccination_course no
audit | log_vaccination_course_constraint no
audit | log_vaccination_definition no
audit | log_vaccination_schedule no
audit | log_vaccine no
audit | log_vaccine_batches no
audit | log_waiting_list no
audit | log_xlnk_identity no
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
de_de | beh_fall_typ
de_de | behandlungsfall
de_de | kvk
de_de | lab_test_gnr
de_de | payment_method
de_de | prax_geb_paid
de_de | zuzahlungsbefreiung
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
information_schema | sql_features no
information_schema | sql_implementation_info no
information_schema | sql_languages no
information_schema | sql_packages no
information_schema | sql_parts no
information_schema | sql_sizing no
information_schema | sql_sizing_profiles no
pg_catalog | pg_aggregate no
pg_catalog | pg_am no
pg_catalog | pg_amop no
pg_catalog | pg_amproc no
pg_catalog | pg_attrdef no
pg_catalog | pg_attribute no
pg_catalog | pg_auth_members no
pg_catalog | pg_authid no
pg_catalog | pg_cast no
pg_catalog | pg_class no
pg_catalog | pg_collation no
pg_catalog | pg_constraint no
pg_catalog | pg_conversion no
pg_catalog | pg_database no
pg_catalog | pg_db_role_setting no
pg_catalog | pg_default_acl no
pg_catalog | pg_depend no
pg_catalog | pg_description no
pg_catalog | pg_enum no
pg_catalog | pg_extension no
pg_catalog | pg_foreign_data_wrapper no
pg_catalog | pg_foreign_server no
pg_catalog | pg_foreign_table no
pg_catalog | pg_index no
pg_catalog | pg_inherits no
pg_catalog | pg_language no
pg_catalog | pg_largeobject no
pg_catalog | pg_largeobject_metadata no
pg_catalog | pg_namespace no
pg_catalog | pg_opclass no
pg_catalog | pg_operator no
pg_catalog | pg_opfamily no
pg_catalog | pg_pltemplate no
pg_catalog | pg_proc no
pg_catalog | pg_rewrite no
pg_catalog | pg_seclabel no
pg_catalog | pg_shdepend no
pg_catalog | pg_shdescription no
pg_catalog | pg_statistic no
pg_catalog | pg_tablespace no
pg_catalog | pg_trigger no
pg_catalog | pg_ts_config no
pg_catalog | pg_ts_config_map no
pg_catalog | pg_ts_dict no
pg_catalog | pg_ts_parser no
pg_catalog | pg_ts_template no
pg_catalog | pg_type no
pg_catalog | pg_user_mapping no
public | basic_unit
public | form_field_types
public | form_fields
public | form_job_queue
public | form_job_targets
public | form_print_defs
public | gm_client_db_match
public | housekeeping_todo
public | test_norm
public | unit
ref | atc
ref | atc_staging
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 | loinc_staging
ref | ops
ref | other_code
ref | papersizes
ref | paperwork_templates
ref | tag_image
staging | lab_request no
staging | test_result no
(301 rows)
???
Marc
- Re: [Gnumed-devel] database replication with bucardo, (continued)
- Re: [Gnumed-devel] database replication with bucardo, Slappinjohn, 2012/06/27
- Re: [Gnumed-devel] database replication with bucardo, Karsten Hilbert, 2012/06/27
- Re: [Gnumed-devel] database replication with bucardo, Slappinjohn, 2012/06/27
- Re: [Gnumed-devel] database replication with bucardo, Karsten Hilbert, 2012/06/27
- Re: [Gnumed-devel] database replication with bucardo, Slappinjohn, 2012/06/27
- Re: [Gnumed-devel] database replication with bucardo, Karsten Hilbert, 2012/06/27
- Re: [Gnumed-devel] database replication with bucardo, Busser, Jim, 2012/06/27
- Re: [Gnumed-devel] database replication with bucardo, Karsten Hilbert, 2012/06/27
- [Gnumed-devel] Concurrent connections on the same patient, Busser, Jim, 2012/06/27
- Re: [Gnumed-devel] Concurrent connections on the same patient, Karsten Hilbert, 2012/06/28
- Re: [Gnumed-devel] Concurrent connections on the same patient,
Slappinjohn <=
- Re: [Gnumed-devel] Concurrent connections on the same patient, Karsten Hilbert, 2012/06/28
- Re: [Gnumed-devel] Concurrent connections on the same patient, Busser, Jim, 2012/06/28
- Re: [Gnumed-devel] Concurrent connections on the same patient, Karsten Hilbert, 2012/06/28
- Re: [Gnumed-devel] Concurrent connections on the same patient, Slappinjohn, 2012/06/28
- Re: [Gnumed-devel] Concurrent connections on the same patient, Karsten Hilbert, 2012/06/28
- Re: [Gnumed-devel] Concurrent connections on the same patient, Karsten Hilbert, 2012/06/28
- Re: [Gnumed-devel] Concurrent connections on the same patient, Slappinjohn, 2012/06/29
- Re: [Gnumed-devel] Concurrent connections on the same patient, Karsten Hilbert, 2012/06/29
- Re: [Gnumed-devel] Concurrent connections on the same patient, Slappinjohn, 2012/06/29
- Re: [Gnumed-devel] Concurrent connections on the same patient, Karsten Hilbert, 2012/06/29