위치
구성incrementalUpdateConfig를 적용할 수 있습니다(https://msfprojects.atlassian.net/wiki/spaces/BAH/pages/329679036/Incremental+Update 참조). 기존 OpenMRS 테이블
{
"name": "Location",
"type": "location",
"chunkSizeToRead": "500"
}평면화된 Mart 테이블
a) location_default - 이 테이블은 위치와 위치의 모든 상세 정보를 제공합니다.
사용하는 OpenMRS 테이블: location
| Column Name | Description |
|---|---|
| location_id | Unique column id from location table from openmrs |
| name | Name of the location |
| description | Description for that particular location |
| address1 - address15 | Represents different fields in address (Configurable) |
| city_village | City/Village of the patient |
| state_province | State/Province of the patient |
| postal_code | Postal code of the patient’s residential area |
| country | Country of patient’s residence |
| county_district | District of the patient’s residence |
| latitude | Latitude of the area of residence |
| longitude | Longitude of the area of residence |
| start_date | Date when the patient started living in that area |
| end_date | Date when the patient stopped being in that area |
| parent_location | parent locations id |
b) location_tag_map_default - 이 테이블은 위치 태그 매핑 상세 정보를 제공합니다.
사용하는 OpenMRS 테이블: location, location_tag_name, location_tag_map
| Column Name | Description |
|---|---|
| location_id | Unique column id from location table in openmrs |
| location_tag_id | Unique column id from location_tag table in openmrs |
| location_tag_name | Name of location from location_tag table in openmrs |
| location_tag_description | Location Tag description from location_tag table in openmrs |
c) location_attribute_details_default -
사용하는 OpenMRS 테이블: location, location_attribute, location_attribute_type
| Column Name | Description |
|---|---|
| location_attribute_id | Unique column id from location_attribute table in openmrs |
| attribute_type_id | location attribute type id from location_attribute table in openmrs |
| value_reference | value_reference from location_attribute table in openmrs |
| location_attribute_type_name | value_reference from location_attribute table in openmrs |
| location_attribute_type_description | location_attribute_type description from location_attribute table in openmrs |
| location_attribute_type_datatype | location_attribute_type_datatype from location_attribute table in openmrs |
| location_attribute_type_datatype_config | location_attribute_type_datatype_config from location_attribute table in openmrs |
| location_attribute_type_preferred_handler | location_attribute_type_preferred_handler from location_attribute table in openmrs |
| location_attribute_type_handler_config | location_attribute_type_handler_config from location_attribute table in openmrs |
| location_attribute_type_min_occurs | location_attribute_type_min_occurs from location_attribute table in openmrs |
| location_attribute_type_min_occurs | location_attribute_type_min_occurs from location_attribute table in openmrs |
원문 정보
원문 보기 ↗Bahmni Wiki · CC BY-SA 4.0