592 lines
35 KiB
XML
592 lines
35 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>
|
|
<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:{C12C82B6-A428-4E6B-A1EC-6C34421172BB}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblClinicInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblCommunes:{BBC55129-9EFF-443A-8B02-6B4A2CD94165}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblDistricts:districtid" FkField="Default:tblCommunes:districtid" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblDistricts:{3FD19CC6-14B1-4CA3-9CAC-55EA6D420496}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblProvinces:provinceid" FkField="Default:tblDistricts:provinceid" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblExaminationInfo:{E5713591-9022-487C-90FC-C9B46819F5F8}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblExaminationInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblPreClinicsInfo:{599D34A0-56DA-43FE-82F0-7EDD20D466D8}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblTests:Testid" FkField="Default:tblPreClinicsInfo:Testid" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblPreClinicsInfo:{FE3287BB-383F-4EA2-B9E3-7BA96E558900}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblPreClinicsInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblPregnanceInfo:{10E1B523-9602-47DA-A308-5844760A38D6}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblPregnanceInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblReferralsTo:{17452331-8457-4C8D-9AB2-89948C748EF9}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblAgency:AgencyTypeID" FkField="Default:tblReferralsTo:AgencyTypeID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblReferralsTo:{9543AE5E-D3F7-4C5F-938D-6B2F695F6BEB}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblServices:ServiceID" FkField="Default:tblReferralsTo:ServiceID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblReferralsTo:{CC108173-ECBC-47FB-8553-1DBE16E59DF2}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblReferralsTo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblTreatmentInfo:{2A3E0E2E-3FB8-4C59-9FBB-13B010A078D6}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblRegimens:Regimenid" FkField="Default:tblTreatmentInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblTreatmentInfo:{C9AAA80C-A7F6-4C91-B85B-2E1A8E59F699}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblRegimenStopReasons:ReasonID" FkField="Default:tblTreatmentInfo:ReasonID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblTreatmentInfo:{F9DDBADE-B3CA-4BB9-BD62-A2C0A3CBC3A2}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblTreatments:TreatmentID" FkField="Default:tblTreatmentInfo:TreatmentID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
<ForeignKeyConstraint Name="Default:tblTreatmentInfo:{FD5F4BCC-B921-42BC-A19A-C77836D7945B}">
|
|
<FieldPairs>
|
|
<FieldPair PkField="Default:tblPatients:PatientID" FkField="Default:tblTreatmentInfo:PatientID" />
|
|
</FieldPairs>
|
|
</ForeignKeyConstraint>
|
|
</ForeignKeyConstraints>
|
|
</Catalog>
|
|
</Catalogs>
|
|
</TargetDatabase>
|
|
</TargetDatabases>
|
|
<MappingStores>
|
|
<MappingStore Type="4F77DEE6-918E-4a53-8B3B-A076B00A3E0D">
|
|
<EntityMappings />
|
|
<TypedViewMappings />
|
|
<SPCallMappings />
|
|
<TypeConversionDefinitions />
|
|
</MappingStore>
|
|
</MappingStores>
|
|
<ModelViews />
|
|
</Project> |