1041 lines
63 KiB
XML
1041 lines
63 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<!--LLBLGen Pro v3.1 project file. Do not manually edit this file. Incorrect references could lead to an unloadable project file.-->
|
|
<Project Version="3.1" TargetFrameworkName="LLBLGen Pro Runtime Framework">
|
|
<Properties>
|
|
<Abbreviations />
|
|
<Property Name="AdditionalTaskPerformerFolder" Value="" />
|
|
<Property Name="AdditionalTasksFolder" Value="" />
|
|
<Property Name="AdditionalTemplatesFolder" Value="" />
|
|
<Property Name="AdditionalTypeConverterFolder" Value="" />
|
|
<Property Name="AddNewElementsAfterRefresh" Value="0" />
|
|
<Property Name="AddNewFieldsAfterRefresh" Value="0" />
|
|
<Property Name="AddNewViewsAsEntitiesAfterRefresh" Value="0" />
|
|
<Property Name="AutoAddManyToManyRelationships" Value="false" />
|
|
<Property Name="AutoAssignSequencesToIntegerPks" Value="true" />
|
|
<Property Name="AutoAssignTypeConverterToFieldMapping" Value="false" />
|
|
<Property Name="CleanUpVsNetProjects" Value="true" />
|
|
<Property Name="ConnectionStringKeyNamePattern" Value="ConnectionString.{$ProviderName}" />
|
|
<Property Name="EncodingToUse" Value="0" />
|
|
<Property Name="EnforcePascalCasingAlways" Value="true" />
|
|
<Property Name="EntityFieldNameStripPattern" Value="{}{}" />
|
|
<Property Name="EntityNameStripPattern" Value="{tbl_}{}" />
|
|
<Property Name="ExcludableOrphanedElementDetectedAction" Value="3" />
|
|
<Property Name="FailCodeGenerationOnWriteError" Value="false" />
|
|
<Property Name="FieldMappedOntoRelatedFieldPattern" Value="{$RelatedFieldName}" />
|
|
<Property Name="FkFieldsAreNamedAfterTargetField" Value="true" />
|
|
<Property Name="ForeignKeyFieldPattern" Value="{$NavigatorName}{$RelatedFieldName}" />
|
|
<Property Name="GroupUsage" Value="0" />
|
|
<Property Name="IdentifyingFieldsFollowDBPrimaryKeyConstraints" Value="0" />
|
|
<Property Name="InsertUnderscoreAtWordBreakCaseSensitiveDBs" Value="false" />
|
|
<Property Name="LengthPrecisionScaleFollowDBLengthPrecisionScale" Value="0" />
|
|
<Property Name="MakeElementNamePascalCasing" Value="true" />
|
|
<Property Name="NavigatorMappedOntoManyToManyPattern" Value="{$EndEntityName}CollectionVia{$IntermediateEntityName$S}" />
|
|
<Property Name="NavigatorMappedOntoOneManyToOnePattern" Value="{$EndEntityName$S}" />
|
|
<Property Name="NavigatorMappedOntoOneToManyPattern" Value="{$EndEntityName$P}" />
|
|
<Property Name="NonExcludableOrphanedElementDetectedAction" Value="3" />
|
|
<Property Name="PreferDecimalOverCurrencyTypes" Value="true" />
|
|
<Property Name="PreferNaturalCharacterTypes" Value="true" />
|
|
<Property Name="PreferVariableLengthTypes" Value="true" />
|
|
<Property Name="ProjectCreator" Value="sdsds" />
|
|
<Property Name="ProjectName" Value="dsds" />
|
|
<Property Name="RelationalModelDataElementNameCasingCaseSensitiveDBs" Value="3" />
|
|
<Property Name="RelationshipsFollowDBForeignKeyConstraints" Value="0" />
|
|
<Property Name="RemoveUnderscoresFromElementName" Value="true" />
|
|
<Property Name="RemoveUnmappedElementsAfterRefresh" Value="0" />
|
|
<Property Name="ResetFieldOrderBasedOnTargetOrderAtRefresh" Value="false" />
|
|
<Property Name="RetrieveDBCustomProperties" Value="false" />
|
|
<Property Name="RootNamespace" Value="" />
|
|
<Property Name="SequencePattern" Value="SEQ_{$EntityName}" />
|
|
<Property Name="SetGroupNameAfterSchemaName" Value="true" />
|
|
<Property Name="SetSchemaNameAfterGroupName" Value="true" />
|
|
<Property Name="StoredProcNameStripPattern" Value="{pr_, sp_}{}" />
|
|
<Property Name="StoreTimeLastGeneratedIntoProject" Value="false" />
|
|
<Property Name="SyncMappedElementNamesAfterRefresh" Value="0" />
|
|
<Property Name="SyncRelationalModelDataElementNameAfterRename" Value="0" />
|
|
<Property Name="SyncRenamedMappedElementNamesAfterRefresh" Value="0" />
|
|
<Property Name="TargetPerEntityEdgesRequireBackingFkConstraint" Value="true" />
|
|
<Property Name="TypedViewFieldNameStripPattern" Value="{}{}" />
|
|
<Property Name="TypedViewNameStripPattern" Value="{vw_}{}" />
|
|
<Property Name="UniqueConstraintsFollowDBUniqueConstraints" Value="0" />
|
|
<Property Name="UpdateCustomPropertiesAfterRefresh" Value="0" />
|
|
<Property Name="UseCustomFieldOrderingOnNewElements" Value="false" />
|
|
</Properties>
|
|
<TypeShortcuts />
|
|
<CodeGenerationCyclePreferences>
|
|
<OutputType Value="3">
|
|
<LastUsedPreferences>
|
|
<DestinationRootFolder Value="D:\patientman\Datalib" />
|
|
<FrameworkName Value="LLBLGen Pro Runtime Framework" />
|
|
<LanguageName Value="C#" />
|
|
<PlatformName Value=".NET 4.0" />
|
|
<PresetName Value="SD.Presets.Adapter.General2010" />
|
|
<RootNamespace Value="Datalib" />
|
|
<TemplateGroup Value="Adapter" />
|
|
<TemplateBindings>
|
|
<Binding Name="SD.TemplateBindings.SharedTemplates.NET40" />
|
|
<Binding Name="SD.TemplateBindings.SharedTemplates.NET35" />
|
|
<Binding Name="SD.TemplateBindings.SharedTemplates.NET20" />
|
|
<Binding Name="SD.TemplateBindings.AccessSpecific.NET20" />
|
|
<Binding Name="SD.TemplateBindings.General" />
|
|
</TemplateBindings>
|
|
</LastUsedPreferences>
|
|
</OutputType>
|
|
<OutputType Value="2">
|
|
<LastUsedPreferences>
|
|
<DestinationRootFolder Value="" />
|
|
<FrameworkName Value="DDL SQL" />
|
|
<LanguageName Value="SQL" />
|
|
<PlatformName Value="RDBMS" />
|
|
<PresetName Value="" />
|
|
<RootNamespace Value="" />
|
|
<TemplateGroup Value="Update DDL SQL" />
|
|
<TemplateBindings />
|
|
</LastUsedPreferences>
|
|
</OutputType>
|
|
</CodeGenerationCyclePreferences>
|
|
<CodeGenerationMetaDataDefaults>
|
|
<TargetElement Type="256">
|
|
<Defaults>
|
|
<Attributes>
|
|
<Attribute Value="Browsable($false)" />
|
|
</Attributes>
|
|
</Defaults>
|
|
</TargetElement>
|
|
</CodeGenerationMetaDataDefaults>
|
|
<EntityModel>
|
|
<ValueTypeDefinitions />
|
|
<EntityDefinitions>
|
|
<EntityDefinition Name="TblAgency">
|
|
<Fields>
|
|
<Field Name="AgencyTypeId" Type="string" MaxLength="2" IsPrimaryKey="true" />
|
|
<Field Name="EAgencyTypeName" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="VAgencyTypeName" Type="string" IsOptional="true" MaxLength="255" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblClinicInfo">
|
|
<Fields>
|
|
<Field Name="Anemia" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Blackouts" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Burning" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="ClinicStage" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Colic" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Depression" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Diarrhea" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="FatDistributionChanges" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Headache" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Height" Type="double" IsOptional="true" Precision="15" />
|
|
<Field Name="Jaundice" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Motion" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Nausea" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="PatientId" Type="string" MaxLength="15" />
|
|
<Field Name="Poisoning" Type="int" IsOptional="true" Precision="10" />
|
|
<Field Name="ProgressTb" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="Rash" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="UniqueKey" Type="string" MaxLength="32" IsPrimaryKey="true" />
|
|
<Field Name="Weight" Type="double" IsOptional="true" Precision="15" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblCommune">
|
|
<Fields>
|
|
<Field Name="Communeid" Type="string" MaxLength="7" IsPrimaryKey="true" />
|
|
<Field Name="Communename" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="Districtid" Type="string" IsOptional="true" MaxLength="5" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblDistrict">
|
|
<Fields>
|
|
<Field Name="Districtid" Type="string" MaxLength="5" IsPrimaryKey="true" />
|
|
<Field Name="Districtname" Type="string" IsOptional="true" MaxLength="26" />
|
|
<Field Name="Provinceid" Type="string" IsOptional="true" MaxLength="3" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblExaminationInfo">
|
|
<Fields>
|
|
<Field Name="ExamDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="LateAppointmentReason" Type="string" IsOptional="true" MaxLength="536870911" />
|
|
<Field Name="OutPatientTreatment" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="PatientId" Type="string" MaxLength="15" />
|
|
<Field Name="ReExamDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="TbScreen" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="TreatmentFollow" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="UniqueKey" Type="string" MaxLength="32" IsPrimaryKey="true" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblPatient">
|
|
<Fields>
|
|
<Field Name="Address" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="AdherenceAssessmentDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="BirthYear" Type="int" IsOptional="true" Precision="10" />
|
|
<Field Name="CommuneId" Type="string" IsOptional="true" MaxLength="7" />
|
|
<Field Name="DateofArv" Type="datetime" IsOptional="true" />
|
|
<Field Name="DateofeligibletoArt" Type="datetime" IsOptional="true" />
|
|
<Field Name="DateofReceivingDrug" Type="datetime" IsOptional="true" />
|
|
<Field Name="Dateofreferral" Type="datetime" IsOptional="true" />
|
|
<Field Name="DateofRegistration" Type="datetime" IsOptional="true" />
|
|
<Field Name="DateSelectedtoArt" Type="datetime" IsOptional="true" />
|
|
<Field Name="DeathDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="DistrictId" Type="string" IsOptional="true" MaxLength="5" />
|
|
<Field Name="HivConfirmedDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="IdentityCardNo" Type="string" IsOptional="true" MaxLength="20" />
|
|
<Field Name="IsDeath" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="MissingDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="OldPatientId" Type="string" MaxLength="15" />
|
|
<Field Name="PatientId" Type="string" MaxLength="15" IsPrimaryKey="true" />
|
|
<Field Name="PatientName" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="ProvinceId" Type="string" IsOptional="true" MaxLength="3" />
|
|
<Field Name="ReferralId" Type="string" IsOptional="true" MaxLength="2" />
|
|
<Field Name="ReferralName" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="ReferralProvinceId" Type="string" IsOptional="true" MaxLength="3" />
|
|
<Field Name="Sex" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="SupporterInfo" Type="string" IsOptional="true" MaxLength="536870911" />
|
|
<Field Name="TelephoneNo" Type="string" IsOptional="true" MaxLength="20" />
|
|
</Fields>
|
|
<UniqueConstraints>
|
|
<UniqueConstraint Name="PatientId">
|
|
<Field Name="OldPatientId" />
|
|
</UniqueConstraint>
|
|
</UniqueConstraints>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblPreClinicsInfo">
|
|
<Fields>
|
|
<Field Name="PatientId" Type="string" MaxLength="15" />
|
|
<Field Name="QualitytResult" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="QuantityResult" Type="double" IsOptional="true" Precision="15" />
|
|
<Field Name="ReTestDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="Status" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="TestDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="Testid" Type="string" MaxLength="2" />
|
|
<Field Name="UniqueKey" Type="string" MaxLength="32" IsPrimaryKey="true" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblPregnanceInfo">
|
|
<Fields>
|
|
<Field Name="EstimatedDelivery" Type="datetime" IsOptional="true" />
|
|
<Field Name="Note" Type="string" IsOptional="true" MaxLength="536870911" />
|
|
<Field Name="PatientId" Type="string" IsOptional="true" MaxLength="15" />
|
|
<Field Name="PragnancyDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="UniqueKey" Type="string" MaxLength="32" IsPrimaryKey="true" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblProvince">
|
|
<Fields>
|
|
<Field Name="Provinceid" Type="string" MaxLength="3" IsPrimaryKey="true" />
|
|
<Field Name="Provincename" Type="string" IsOptional="true" MaxLength="30" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblReferralFromPlace">
|
|
<Fields>
|
|
<Field Name="EReferralName" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="ReferralId" Type="string" MaxLength="255" IsPrimaryKey="true" />
|
|
<Field Name="VReferralName" Type="string" IsOptional="true" MaxLength="255" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblReferralsTo">
|
|
<Fields>
|
|
<Field Name="AgencyTypeId" Type="string" IsOptional="true" MaxLength="2" />
|
|
<Field Name="Note" Type="string" IsOptional="true" MaxLength="536870911" />
|
|
<Field Name="PatientId" Type="string" IsOptional="true" MaxLength="15" />
|
|
<Field Name="ProvinceId" Type="string" IsOptional="true" MaxLength="3" />
|
|
<Field Name="ReceiveServiceDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="ReferralAgency" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="ReferralDate" Type="datetime" IsOptional="true" />
|
|
<Field Name="ServiceId" Type="string" IsOptional="true" MaxLength="2" />
|
|
<Field Name="Status" Type="short" IsOptional="true" Precision="5" />
|
|
<Field Name="UniqueKey" Type="string" MaxLength="15" IsPrimaryKey="true" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblRegimen">
|
|
<Fields>
|
|
<Field Name="ERegimenName" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="Regimenid" Type="string" MaxLength="2" IsPrimaryKey="true" />
|
|
<Field Name="VRegimenname" Type="string" IsOptional="true" MaxLength="255" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblRegimenStopReason">
|
|
<Fields>
|
|
<Field Name="EReasonDes" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="ReasonId" Type="string" MaxLength="2" IsPrimaryKey="true" />
|
|
<Field Name="VReasonDes" Type="string" IsOptional="true" MaxLength="255" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblService">
|
|
<Fields>
|
|
<Field Name="EServiceName" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="ServiceId" Type="string" MaxLength="2" IsPrimaryKey="true" />
|
|
<Field Name="VServiceName" Type="string" IsOptional="true" MaxLength="255" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblTest">
|
|
<Fields>
|
|
<Field Name="ETestName" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="Testid" Type="string" MaxLength="2" IsPrimaryKey="true" />
|
|
<Field Name="VTestName" Type="string" IsOptional="true" MaxLength="255" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblTreatment">
|
|
<Fields>
|
|
<Field Name="ETreatmentDes" Type="string" IsOptional="true" MaxLength="255" />
|
|
<Field Name="TreatmentId" Type="string" MaxLength="2" IsPrimaryKey="true" />
|
|
<Field Name="VTreatmentDes" Type="string" IsOptional="true" MaxLength="255" />
|
|
</Fields>
|
|
</EntityDefinition>
|
|
<EntityDefinition Name="TblTreatmentInfo">
|
|
<Fields>
|
|
<Field Name="PatientId" Type="string" MaxLength="2" />
|
|
<Field Name="ReasonId" Type="string" MaxLength="2" />
|
|
<Field Name="Regimenid" Type="string" MaxLength="2" />
|
|
<Field Name="TreatmentEdate" Type="datetime" IsOptional="true" />
|
|
<Field Name="TreatmentId" Type="string" IsOptional="true" MaxLength="2" />
|
|
<Field Name="TreatmentSdate" Type="datetime" IsOptional="true" />
|
|
<Field Name="UniqueKey" Type="string" MaxLength="15" IsPrimaryKey="true" />
|
|
</Fields>
|
|
<UniqueConstraints>
|
|
<UniqueConstraint Name="Regimenid">
|
|
<Field Name="Regimenid" />
|
|
</UniqueConstraint>
|
|
</UniqueConstraints>
|
|
</EntityDefinition>
|
|
</EntityDefinitions>
|
|
<Relationships>
|
|
<NormalRelationship Name="TblClinicInfo.TblPatient-TblPatient.TblClinicInfos" Start=":TblClinicInfo" End=":TblPatient" StartNavigator="TblPatient" EndNavigator="TblClinicInfos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="PatientId" PkField="PatientId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblCommune.TblDistrict-TblDistrict.TblCommunes" Start=":TblCommune" End=":TblDistrict" StartNavigator="TblDistrict" EndNavigator="TblCommunes" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="Districtid" PkField="Districtid" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblDistrict.TblProvince-TblProvince.TblDistricts" Start=":TblDistrict" End=":TblProvince" StartNavigator="TblProvince" EndNavigator="TblDistricts" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="Provinceid" PkField="Provinceid" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblExaminationInfo.TblPatient-TblPatient.TblExaminationInfos" Start=":TblExaminationInfo" End=":TblPatient" StartNavigator="TblPatient" EndNavigator="TblExaminationInfos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="PatientId" PkField="PatientId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblPreClinicsInfo.TblPatient-TblPatient.TblPreClinicsInfos" Start=":TblPreClinicsInfo" End=":TblPatient" StartNavigator="TblPatient" EndNavigator="TblPreClinicsInfos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="PatientId" PkField="PatientId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblPreClinicsInfo.TblTest-TblTest.TblPreClinicsInfos" Start=":TblPreClinicsInfo" End=":TblTest" StartNavigator="TblTest" EndNavigator="TblPreClinicsInfos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="Testid" PkField="Testid" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblPregnanceInfo.TblPatient-TblPatient.TblPregnanceInfos" Start=":TblPregnanceInfo" End=":TblPatient" StartNavigator="TblPatient" EndNavigator="TblPregnanceInfos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="PatientId" PkField="PatientId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblReferralsTo.TblAgency-TblAgency.TblReferralsTos" Start=":TblReferralsTo" End=":TblAgency" StartNavigator="TblAgency" EndNavigator="TblReferralsTos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="AgencyTypeId" PkField="AgencyTypeId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblReferralsTo.TblPatient-TblPatient.TblReferralsTos" Start=":TblReferralsTo" End=":TblPatient" StartNavigator="TblPatient" EndNavigator="TblReferralsTos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="PatientId" PkField="PatientId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblReferralsTo.TblService-TblService.TblReferralsTos" Start=":TblReferralsTo" End=":TblService" StartNavigator="TblService" EndNavigator="TblReferralsTos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="ServiceId" PkField="ServiceId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblTreatmentInfo.TblPatient-TblPatient.TblTreatmentInfo" Start=":TblTreatmentInfo" End=":TblPatient" StartNavigator="TblPatient" EndNavigator="TblTreatmentInfo" Type="1" StartIsOptional="true">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="UniqueKey" PkField="PatientId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblTreatmentInfo.TblRegiman-TblRegimen.TblTreatmentInfos" Start=":TblTreatmentInfo" End=":TblRegimen" StartNavigator="TblRegiman" EndNavigator="TblTreatmentInfos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="PatientId" PkField="Regimenid" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblTreatmentInfo.TblRegimenStopReason-TblRegimenStopReason.TblTreatmentInfo" Start=":TblTreatmentInfo" End=":TblRegimenStopReason" StartNavigator="TblRegimenStopReason" EndNavigator="TblTreatmentInfo" Type="1">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="ReasonId" PkField="ReasonId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
<NormalRelationship Name="TblTreatmentInfo.TblTreatment-TblTreatment.TblTreatmentInfos" Start=":TblTreatmentInfo" End=":TblTreatment" StartNavigator="TblTreatment" EndNavigator="TblTreatmentInfos" Type="4">
|
|
<FieldRelationships>
|
|
<FieldFieldRelationship FkField="TreatmentId" PkField="TreatmentId" />
|
|
</FieldRelationships>
|
|
</NormalRelationship>
|
|
</Relationships>
|
|
<InheritanceHierarchies />
|
|
</EntityModel>
|
|
<TargetDatabases>
|
|
<TargetDatabase Type="4F77DEE6-918E-4a53-8B3B-A076B00A3E0D">
|
|
<ConnectionElements>
|
|
<ConnectionElement Name="CatalogName" Value="FHI" />
|
|
<ConnectionElement Name="UserID" Value="admin" />
|
|
<ConnectionElement Name="Password" Value="" />
|
|
<ConnectionElement Name="DatabaseFile" Value="D:\patientman\database\FHI.mdb" />
|
|
<ConnectionElement Name="SecurityFile" Value="" />
|
|
<ConnectionElement Name="DatabasePassword" Value="" />
|
|
</ConnectionElements>
|
|
<SystemSequences>
|
|
<Sequence Name="@@IDENTITY" />
|
|
</SystemSequences>
|
|
<Catalogs>
|
|
<Catalog Name="FHI">
|
|
<Schemas>
|
|
<Schema Name="Default">
|
|
<Tables>
|
|
<Table Name="tblAgency">
|
|
<Fields>
|
|
<Field Name="AgencyTypeID" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="2" />
|
|
<Field Name="vAgencyTypeName" Ordinal="3" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="eAgencyTypeName" Ordinal="4" IsOptional="true" DbType="11" Length="255" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblClinicInfo">
|
|
<Fields>
|
|
<Field Name="UniqueKey" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="32">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Primary Key" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="PatientID" Ordinal="3" DbType="11" Length="15" />
|
|
<Field Name="Height" Ordinal="4" IsOptional="true" DefaultValue="0" DbType="4" Precision="15" />
|
|
<Field Name="Weight" Ordinal="5" IsOptional="true" DefaultValue="0" DbType="4" Precision="15" />
|
|
<Field Name="ClinicStage" Ordinal="6" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Motion" Ordinal="7" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Rash" Ordinal="8" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="jaundice" Ordinal="9" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Nausea" Ordinal="10" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Diarrhea" Ordinal="11" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Colic" Ordinal="12" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Headache" Ordinal="13" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Burning" Ordinal="14" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Anemia" Ordinal="15" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="FatDistributionChanges" Ordinal="16" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Blackouts" Ordinal="17" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Depression" Ordinal="18" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="Poisoning" Ordinal="19" IsOptional="true" DefaultValue="0" DbType="6" Precision="10" />
|
|
<Field Name="ProgressTB" Ordinal="20" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblCommunes">
|
|
<Fields>
|
|
<Field Name="communeid" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="7" />
|
|
<Field Name="communename" Ordinal="3" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="districtid" Ordinal="4" IsOptional="true" DbType="11" Length="5" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblDistricts">
|
|
<Fields>
|
|
<Field Name="districtname" Ordinal="2" IsOptional="true" DbType="11" Length="26">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="District Name" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="districtid" Ordinal="3" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="5">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="District Code" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="provinceid" Ordinal="4" IsOptional="true" DbType="11" Length="3">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Province Code" />
|
|
</CustomProperties>
|
|
</Field>
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblExaminationInfo">
|
|
<Fields>
|
|
<Field Name="UniqueKey" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="32">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Khóa chính" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="PatientID" Ordinal="3" DbType="11" Length="15">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value=" Patient ID" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="ReExamDate" Ordinal="4" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Ngày tái khám" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="ExamDate" Ordinal="5" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Supporter Name" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="TbScreen" Ordinal="6" IsOptional="true" DefaultValue="0" DbType="5" Precision="5">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Sàng lọc Lao" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="OutPatientTreatment" Ordinal="7" IsOptional="true" DefaultValue="0" DbType="5" Precision="5">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Điều trị ngoại trú" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="TreatmentFollow" Ordinal="8" IsOptional="true" DefaultValue="0" DbType="5" Precision="5">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Tuân thủ điều trị" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="LateAppointmentReason" Ordinal="9" IsOptional="true" DbType="7" Length="536870911">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Lý do lỡ hẹn" />
|
|
</CustomProperties>
|
|
</Field>
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblPatients">
|
|
<Fields>
|
|
<Field Name="PatientID" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="15">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Patient ID" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="PatientName" Ordinal="3" IsOptional="true" DbType="11" Length="255">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Patient Name" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="BirthYear" Ordinal="4" IsOptional="true" DefaultValue="0" DbType="6" Precision="10">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Year of Birth" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="Sex" Ordinal="5" IsOptional="true" DefaultValue="0" DbType="5" Precision="5">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Gender" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="IdentityCardNo" Ordinal="6" IsOptional="true" DbType="11" Length="20">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Number of Identity Card" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="TelephoneNo" Ordinal="7" IsOptional="true" DbType="11" Length="20">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Telephone Number" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="ProvinceID" Ordinal="8" IsOptional="true" DbType="11" Length="3">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Province Code" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="DistrictID" Ordinal="9" IsOptional="true" DbType="11" Length="5">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="District Code" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="Address" Ordinal="10" IsOptional="true" DbType="11" Length="255">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Address of Supporter" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="CommuneID" Ordinal="11" IsOptional="true" DbType="11" Length="7">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Commune Code" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="ReferralID" Ordinal="12" IsOptional="true" DbType="11" Length="2" />
|
|
<Field Name="Dateofreferral" Ordinal="13" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Date of referal" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="ReferralProvinceID" Ordinal="14" IsOptional="true" DbType="11" Length="3">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Province Code" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="OldPatientID" Ordinal="15" DbType="11" Length="15">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Patient ID" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="ReferralName" Ordinal="16" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="IsDeath" Ordinal="17" IsOptional="true" DefaultValue="0" DbType="5" Precision="5">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Death" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="DeathDate" Ordinal="18" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Date of Death" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="HivConfirmedDate" Ordinal="19" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Date confirmed HIV-positive" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="DateofRegistration" Ordinal="20" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Date of registration" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="SupporterInfo" Ordinal="21" IsOptional="true" DbType="7" Length="536870911">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Information abount Supporter" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="DateofeligibletoART" Ordinal="22" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Date of eligible to ART" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="DateSelectedtoART" Ordinal="23" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Selected to ART" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="AdherenceAssessmentDate" Ordinal="24" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Adherence assessment ready date" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="DateofARV" Ordinal="25" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Date of ART initiated" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="DateofReceivingDrug" Ordinal="26" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Date of first day receiving drug at this OPC" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="MissingDate" Ordinal="27" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Date of lossing" />
|
|
</CustomProperties>
|
|
</Field>
|
|
</Fields>
|
|
<UniqueConstraints>
|
|
<UniqueConstraint Name="PatientID">
|
|
<Field Name="OldPatientID" />
|
|
</UniqueConstraint>
|
|
</UniqueConstraints>
|
|
</Table>
|
|
<Table Name="tblPreClinicsInfo">
|
|
<Fields>
|
|
<Field Name="UniqueKey" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="32">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Khóa chính" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="PatientID" Ordinal="3" DbType="11" Length="15">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value=" Patient ID" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="Testid" Ordinal="4" DbType="11" Length="2" />
|
|
<Field Name="TestDate" Ordinal="5" IsOptional="true" DbType="2" />
|
|
<Field Name="QualitytResult" Ordinal="6" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="QuantityResult" Ordinal="7" IsOptional="true" DefaultValue="0" DbType="4" Precision="15" />
|
|
<Field Name="Status" Ordinal="8" IsOptional="true" DefaultValue="0" DbType="5" Precision="5" />
|
|
<Field Name="ReTestDate" Ordinal="9" IsOptional="true" DbType="2" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblPregnanceInfo">
|
|
<Fields>
|
|
<Field Name="UniqueKey" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="32">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Primary Key" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="PatientID" Ordinal="3" IsOptional="true" DbType="11" Length="15">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Patient ID" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="PragnancyDate" Ordinal="4" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Date of Pregnancy" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="EstimatedDelivery" Ordinal="5" IsOptional="true" DbType="2">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Estimated Date of Delivery" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="Note" Ordinal="6" IsOptional="true" DbType="7" Length="536870911">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Note" />
|
|
</CustomProperties>
|
|
</Field>
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblProvinces">
|
|
<Fields>
|
|
<Field Name="provincename" Ordinal="2" IsOptional="true" DbType="11" Length="30">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Province Name" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="provinceid" Ordinal="3" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="3">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Province Code" />
|
|
</CustomProperties>
|
|
</Field>
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblReferralFromPlaces">
|
|
<Fields>
|
|
<Field Name="ReferralID" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="255" />
|
|
<Field Name="eReferralName" Ordinal="3" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="vReferralName" Ordinal="4" IsOptional="true" DbType="11" Length="255" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblReferralsTo">
|
|
<Fields>
|
|
<Field Name="UniqueKey" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="15" />
|
|
<Field Name="PatientID" Ordinal="3" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="ServiceID" Ordinal="4" IsOptional="true" DbType="11" Length="2" />
|
|
<Field Name="ReferralDate" Ordinal="5" IsOptional="true" DbType="2" />
|
|
<Field Name="ProvinceID" Ordinal="6" IsOptional="true" DbType="11" Length="3" />
|
|
<Field Name="AgencyTypeID" Ordinal="7" IsOptional="true" DbType="11" Length="2" />
|
|
<Field Name="ReferralAgency" Ordinal="8" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="Status" Ordinal="9" IsOptional="true" DefaultValue="0" DbType="5" Precision="5">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Đến nhận dịch vụ" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="ReceiveServiceDate" Ordinal="10" IsOptional="true" DbType="2" />
|
|
<Field Name="Note" Ordinal="11" IsOptional="true" DbType="7" Length="536870911" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblRegimens">
|
|
<Fields>
|
|
<Field Name="Regimenid" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="2" />
|
|
<Field Name="vRegimenname" Ordinal="3" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="eRegimenName" Ordinal="4" IsOptional="true" DbType="11" Length="255" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblRegimenStopReasons">
|
|
<Fields>
|
|
<Field Name="ReasonID" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="2" />
|
|
<Field Name="vReasonDes" Ordinal="3" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="eReasonDes" Ordinal="4" IsOptional="true" DbType="11" Length="255" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblServices">
|
|
<Fields>
|
|
<Field Name="ServiceID" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="2" />
|
|
<Field Name="vServiceName" Ordinal="3" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="eServiceName" Ordinal="4" IsOptional="true" DbType="11" Length="255" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblTests">
|
|
<Fields>
|
|
<Field Name="Testid" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="2" />
|
|
<Field Name="vTestName" Ordinal="3" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="eTestName" Ordinal="4" IsOptional="true" DbType="11" Length="255" />
|
|
</Fields>
|
|
</Table>
|
|
<Table Name="tblTreatmentInfo">
|
|
<Fields>
|
|
<Field Name="UniqueKey" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="15">
|
|
<CustomProperties>
|
|
<CustomProperty Name="Description" Value="Primary Key" />
|
|
</CustomProperties>
|
|
</Field>
|
|
<Field Name="PatientID" Ordinal="3" DbType="11" Length="10" />
|
|
<Field Name="TreatmentID" Ordinal="4" IsOptional="true" DbType="11" Length="2" />
|
|
<Field Name="Regimenid" Ordinal="5" DbType="11" Length="2" />
|
|
<Field Name="TreatmentSdate" Ordinal="6" IsOptional="true" DbType="2" />
|
|
<Field Name="TreatmentEdate" Ordinal="7" IsOptional="true" DbType="2" />
|
|
<Field Name="ReasonID" Ordinal="8" DbType="11" Length="2" />
|
|
</Fields>
|
|
<UniqueConstraints>
|
|
<UniqueConstraint Name="ReasonID">
|
|
<Field Name="ReasonID" />
|
|
</UniqueConstraint>
|
|
<UniqueConstraint Name="Regimenid">
|
|
<Field Name="Regimenid" />
|
|
</UniqueConstraint>
|
|
</UniqueConstraints>
|
|
</Table>
|
|
<Table Name="tblTreatments">
|
|
<Fields>
|
|
<Field Name="TreatmentID" Ordinal="2" IsPrimaryKey="true" PkConstraintName="PrimaryKey" DbType="11" Length="2" />
|
|
<Field Name="vTreatmentDes" Ordinal="3" IsOptional="true" DbType="11" Length="255" />
|
|
<Field Name="eTreatmentDes" Ordinal="4" IsOptional="true" DbType="11" Length="255" />
|
|
</Fields>
|
|
</Table>
|
|
</Tables>
|
|
</Schema>
|
|
</Schemas>
|
|
<ForeignKeyConstraints>
|
|
<ForeignKeyConstraint Name="Default:tblClinicInfo:tblPatientstblClinicInfo">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblClinicInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblCommunes:{5660F530-8199-4A34-9FB6-203B9C0C8E20}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblDistricts:districtid" FkField="Default:tblCommunes:districtid" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblDistricts:{CEDE6A80-FEB8-4B37-AE3F-F4B86EBE961E}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblProvinces:provinceid" FkField="Default:tblDistricts:provinceid" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblExaminationInfo:tblPatientstblExaminationInfo">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblExaminationInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblPreClinicsInfo:tblPatientstblPreClinicsInfo">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblPreClinicsInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblPreClinicsInfo:tblTeststblPreClinicsInfo">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblTests:Testid" FkField="Default:tblPreClinicsInfo:Testid" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblPregnanceInfo:tblPatientstblPregnanceInfo">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblPregnanceInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblReferralsTo:tblAgencytblReferrals">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblAgency:AgencyTypeID" FkField="Default:tblReferralsTo:AgencyTypeID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblReferralsTo:tblPatientstblReferrals">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblReferralsTo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblReferralsTo:tblServicestblReferrals">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblServices:ServiceID" FkField="Default:tblReferralsTo:ServiceID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblTreatmentInfo:tblPatientstblTreatmentInfo">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblTreatmentInfo:UniqueKey" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblTreatmentInfo:tblRegimenstblTreatmentInfo">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblRegimens:Regimenid" FkField="Default:tblTreatmentInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblTreatmentInfo:tblRegimenStopReasonstblTreatmentInfo">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblRegimenStopReasons:ReasonID" FkField="Default:tblTreatmentInfo:ReasonID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblTreatmentInfo:tblTreatmentstblTreatmentInfo">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblTreatments:TreatmentID" FkField="Default:tblTreatmentInfo:TreatmentID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
</ForeignKeyConstraints>
|
|
</Catalog>
|
|
</Catalogs>
|
|
</TargetDatabase>
|
|
</TargetDatabases>
|
|
<MappingStores>
|
|
<MappingStore Type="4F77DEE6-918E-4a53-8B3B-A076B00A3E0D">
|
|
<EntityMappings>
|
|
<EntityMapping EntityName=":TblAgency" TargetName="FHI:Default:tblAgency">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="AgencyTypeId" TargetFieldName="AgencyTypeID" />
|
|
<FieldMapping FieldName="EAgencyTypeName" TargetFieldName="eAgencyTypeName" />
|
|
<FieldMapping FieldName="VAgencyTypeName" TargetFieldName="vAgencyTypeName" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblClinicInfo" TargetName="FHI:Default:tblClinicInfo">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="Anemia" TargetFieldName="Anemia" />
|
|
<FieldMapping FieldName="Blackouts" TargetFieldName="Blackouts" />
|
|
<FieldMapping FieldName="Burning" TargetFieldName="Burning" />
|
|
<FieldMapping FieldName="ClinicStage" TargetFieldName="ClinicStage" />
|
|
<FieldMapping FieldName="Colic" TargetFieldName="Colic" />
|
|
<FieldMapping FieldName="Depression" TargetFieldName="Depression" />
|
|
<FieldMapping FieldName="Diarrhea" TargetFieldName="Diarrhea" />
|
|
<FieldMapping FieldName="FatDistributionChanges" TargetFieldName="FatDistributionChanges" />
|
|
<FieldMapping FieldName="Headache" TargetFieldName="Headache" />
|
|
<FieldMapping FieldName="Height" TargetFieldName="Height" />
|
|
<FieldMapping FieldName="Jaundice" TargetFieldName="jaundice" />
|
|
<FieldMapping FieldName="Motion" TargetFieldName="Motion" />
|
|
<FieldMapping FieldName="Nausea" TargetFieldName="Nausea" />
|
|
<FieldMapping FieldName="PatientId" TargetFieldName="PatientID" />
|
|
<FieldMapping FieldName="Poisoning" TargetFieldName="Poisoning" />
|
|
<FieldMapping FieldName="ProgressTb" TargetFieldName="ProgressTB" />
|
|
<FieldMapping FieldName="Rash" TargetFieldName="Rash" />
|
|
<FieldMapping FieldName="UniqueKey" TargetFieldName="UniqueKey" />
|
|
<FieldMapping FieldName="Weight" TargetFieldName="Weight" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblCommune" TargetName="FHI:Default:tblCommunes">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="Communeid" TargetFieldName="communeid" />
|
|
<FieldMapping FieldName="Communename" TargetFieldName="communename" />
|
|
<FieldMapping FieldName="Districtid" TargetFieldName="districtid" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblDistrict" TargetName="FHI:Default:tblDistricts">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="Districtid" TargetFieldName="districtid" />
|
|
<FieldMapping FieldName="Districtname" TargetFieldName="districtname" />
|
|
<FieldMapping FieldName="Provinceid" TargetFieldName="provinceid" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblExaminationInfo" TargetName="FHI:Default:tblExaminationInfo">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="ExamDate" TargetFieldName="ExamDate" />
|
|
<FieldMapping FieldName="LateAppointmentReason" TargetFieldName="LateAppointmentReason" />
|
|
<FieldMapping FieldName="OutPatientTreatment" TargetFieldName="OutPatientTreatment" />
|
|
<FieldMapping FieldName="PatientId" TargetFieldName="PatientID" />
|
|
<FieldMapping FieldName="ReExamDate" TargetFieldName="ReExamDate" />
|
|
<FieldMapping FieldName="TbScreen" TargetFieldName="TbScreen" />
|
|
<FieldMapping FieldName="TreatmentFollow" TargetFieldName="TreatmentFollow" />
|
|
<FieldMapping FieldName="UniqueKey" TargetFieldName="UniqueKey" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblPatient" TargetName="FHI:Default:tblPatients">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="Address" TargetFieldName="Address" />
|
|
<FieldMapping FieldName="AdherenceAssessmentDate" TargetFieldName="AdherenceAssessmentDate" />
|
|
<FieldMapping FieldName="BirthYear" TargetFieldName="BirthYear" />
|
|
<FieldMapping FieldName="CommuneId" TargetFieldName="CommuneID" />
|
|
<FieldMapping FieldName="DateofArv" TargetFieldName="DateofARV" />
|
|
<FieldMapping FieldName="DateofeligibletoArt" TargetFieldName="DateofeligibletoART" />
|
|
<FieldMapping FieldName="DateofReceivingDrug" TargetFieldName="DateofReceivingDrug" />
|
|
<FieldMapping FieldName="Dateofreferral" TargetFieldName="Dateofreferral" />
|
|
<FieldMapping FieldName="DateofRegistration" TargetFieldName="DateofRegistration" />
|
|
<FieldMapping FieldName="DateSelectedtoArt" TargetFieldName="DateSelectedtoART" />
|
|
<FieldMapping FieldName="DeathDate" TargetFieldName="DeathDate" />
|
|
<FieldMapping FieldName="DistrictId" TargetFieldName="DistrictID" />
|
|
<FieldMapping FieldName="HivConfirmedDate" TargetFieldName="HivConfirmedDate" />
|
|
<FieldMapping FieldName="IdentityCardNo" TargetFieldName="IdentityCardNo" />
|
|
<FieldMapping FieldName="IsDeath" TargetFieldName="IsDeath" />
|
|
<FieldMapping FieldName="MissingDate" TargetFieldName="MissingDate" />
|
|
<FieldMapping FieldName="OldPatientId" TargetFieldName="OldPatientID" />
|
|
<FieldMapping FieldName="PatientId" TargetFieldName="PatientID" />
|
|
<FieldMapping FieldName="PatientName" TargetFieldName="PatientName" />
|
|
<FieldMapping FieldName="ProvinceId" TargetFieldName="ProvinceID" />
|
|
<FieldMapping FieldName="ReferralId" TargetFieldName="ReferralID" />
|
|
<FieldMapping FieldName="ReferralName" TargetFieldName="ReferralName" />
|
|
<FieldMapping FieldName="ReferralProvinceId" TargetFieldName="ReferralProvinceID" />
|
|
<FieldMapping FieldName="Sex" TargetFieldName="Sex" />
|
|
<FieldMapping FieldName="SupporterInfo" TargetFieldName="SupporterInfo" />
|
|
<FieldMapping FieldName="TelephoneNo" TargetFieldName="TelephoneNo" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblPreClinicsInfo" TargetName="FHI:Default:tblPreClinicsInfo">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="PatientId" TargetFieldName="PatientID" />
|
|
<FieldMapping FieldName="QualitytResult" TargetFieldName="QualitytResult" />
|
|
<FieldMapping FieldName="QuantityResult" TargetFieldName="QuantityResult" />
|
|
<FieldMapping FieldName="ReTestDate" TargetFieldName="ReTestDate" />
|
|
<FieldMapping FieldName="Status" TargetFieldName="Status" />
|
|
<FieldMapping FieldName="TestDate" TargetFieldName="TestDate" />
|
|
<FieldMapping FieldName="Testid" TargetFieldName="Testid" />
|
|
<FieldMapping FieldName="UniqueKey" TargetFieldName="UniqueKey" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblPregnanceInfo" TargetName="FHI:Default:tblPregnanceInfo">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="EstimatedDelivery" TargetFieldName="EstimatedDelivery" />
|
|
<FieldMapping FieldName="Note" TargetFieldName="Note" />
|
|
<FieldMapping FieldName="PatientId" TargetFieldName="PatientID" />
|
|
<FieldMapping FieldName="PragnancyDate" TargetFieldName="PragnancyDate" />
|
|
<FieldMapping FieldName="UniqueKey" TargetFieldName="UniqueKey" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblProvince" TargetName="FHI:Default:tblProvinces">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="Provinceid" TargetFieldName="provinceid" />
|
|
<FieldMapping FieldName="Provincename" TargetFieldName="provincename" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblReferralFromPlace" TargetName="FHI:Default:tblReferralFromPlaces">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="EReferralName" TargetFieldName="eReferralName" />
|
|
<FieldMapping FieldName="ReferralId" TargetFieldName="ReferralID" />
|
|
<FieldMapping FieldName="VReferralName" TargetFieldName="vReferralName" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblReferralsTo" TargetName="FHI:Default:tblReferralsTo">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="AgencyTypeId" TargetFieldName="AgencyTypeID" />
|
|
<FieldMapping FieldName="Note" TargetFieldName="Note" />
|
|
<FieldMapping FieldName="PatientId" TargetFieldName="PatientID" />
|
|
<FieldMapping FieldName="ProvinceId" TargetFieldName="ProvinceID" />
|
|
<FieldMapping FieldName="ReceiveServiceDate" TargetFieldName="ReceiveServiceDate" />
|
|
<FieldMapping FieldName="ReferralAgency" TargetFieldName="ReferralAgency" />
|
|
<FieldMapping FieldName="ReferralDate" TargetFieldName="ReferralDate" />
|
|
<FieldMapping FieldName="ServiceId" TargetFieldName="ServiceID" />
|
|
<FieldMapping FieldName="Status" TargetFieldName="Status" />
|
|
<FieldMapping FieldName="UniqueKey" TargetFieldName="UniqueKey" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblRegimen" TargetName="FHI:Default:tblRegimens">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="ERegimenName" TargetFieldName="eRegimenName" />
|
|
<FieldMapping FieldName="Regimenid" TargetFieldName="Regimenid" />
|
|
<FieldMapping FieldName="VRegimenname" TargetFieldName="vRegimenname" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblRegimenStopReason" TargetName="FHI:Default:tblRegimenStopReasons">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="EReasonDes" TargetFieldName="eReasonDes" />
|
|
<FieldMapping FieldName="ReasonId" TargetFieldName="ReasonID" />
|
|
<FieldMapping FieldName="VReasonDes" TargetFieldName="vReasonDes" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblService" TargetName="FHI:Default:tblServices">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="EServiceName" TargetFieldName="eServiceName" />
|
|
<FieldMapping FieldName="ServiceId" TargetFieldName="ServiceID" />
|
|
<FieldMapping FieldName="VServiceName" TargetFieldName="vServiceName" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblTest" TargetName="FHI:Default:tblTests">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="ETestName" TargetFieldName="eTestName" />
|
|
<FieldMapping FieldName="Testid" TargetFieldName="Testid" />
|
|
<FieldMapping FieldName="VTestName" TargetFieldName="vTestName" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblTreatment" TargetName="FHI:Default:tblTreatments">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="ETreatmentDes" TargetFieldName="eTreatmentDes" />
|
|
<FieldMapping FieldName="TreatmentId" TargetFieldName="TreatmentID" />
|
|
<FieldMapping FieldName="VTreatmentDes" TargetFieldName="vTreatmentDes" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
<EntityMapping EntityName=":TblTreatmentInfo" TargetName="FHI:Default:tblTreatmentInfo">
|
|
<FieldMappings>
|
|
<FieldMapping FieldName="PatientId" TargetFieldName="PatientID" />
|
|
<FieldMapping FieldName="ReasonId" TargetFieldName="ReasonID" />
|
|
<FieldMapping FieldName="Regimenid" TargetFieldName="Regimenid" />
|
|
<FieldMapping FieldName="TreatmentEdate" TargetFieldName="TreatmentEdate" />
|
|
<FieldMapping FieldName="TreatmentId" TargetFieldName="TreatmentID" />
|
|
<FieldMapping FieldName="TreatmentSdate" TargetFieldName="TreatmentSdate" />
|
|
<FieldMapping FieldName="UniqueKey" TargetFieldName="UniqueKey" />
|
|
</FieldMappings>
|
|
</EntityMapping>
|
|
</EntityMappings>
|
|
<TypedViewMappings />
|
|
<SPCallMappings />
|
|
<TypeConversionDefinitions />
|
|
</MappingStore>
|
|
</MappingStores>
|
|
<ModelViews />
|
|
</Project> |