<Databases>
  <Database>
    <Tables>
      <Table Name="T_CDA_SECTION_PATIENT_ROUTTODIAG" Schema="AKUZ">
        <Columns>
          <Column Name="CdaSectionPatientRouttodiagID" Type="guid" IsNullable="0" />
          <Column Name="Name" Type="string" Length="255" IsNullable="0" />
          <Column Name="Surname" Type="string" Length="255" IsNullable="0" />
          <Column Name="MiddleName" Type="string" Length="255" IsNullable="1" />
          <Column Name="Sex" Type="int" IsNullable="0" />
          <Column Name="Birthday" Type="date" IsNullable="0" />
          <Column Name="AddressLiving" Type="guid" IsNullable="1" />
          <Column Name="AddressRegistry" Type="guid" IsNullable="1" />
          <Column Name="CdaRouttodiag" Type="guid" IsNullable="1" />
        </Columns>
        <PrimaryKey Name="PK_T_CDA_SECTION_PATIENT_ROUTTODIAG" Clustered="1">
          <Column Name="CdaSectionPatientRouttodiagID" />
        </PrimaryKey>
        <ForeignKeys>
          <ForeignKey Name="FK_T_ENUMS_T_CDA_SECTION_PATIENT_ROUTTODIAG_Sex" Column="Sex" Table="T_ENUMS" TableSchema="VCLib" TableColumn="EnumID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_PATIENT_ADDRESS_T_CDA_SECTION_PATIENT_ROUTTODIAG_AddressLiving" ShortName="FK_T_PATIENT_ADDRESS_T_CDA_SECTION_PATIENT_ROUTTODIAG__1265675C" Column="AddressLiving" Table="T_PATIENT_ADDRESS" TableSchema="AKUZ" TableColumn="AddressID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_PATIENT_ADDRESS_T_CDA_SECTION_PATIENT_ROUTTODIAG_AddressRegistry" ShortName="FK_T_PATIENT_ADDRESS_T_CDA_SECTION_PATIENT_ROUTTODIAG__6AD93EED" Column="AddressRegistry" Table="T_PATIENT_ADDRESS" TableSchema="AKUZ" TableColumn="AddressID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_CDA_DOCUMENT_T_CDA_SECTION_PATIENT_ROUTTODIAG_CdaRouttodiag" ShortName="FK_T_CDA_DOCUMENT_T_CDA_SECTION_PATIENT_ROUTTODIAG_Cda_922BFF6C" Column="CdaRouttodiag" Table="T_CDA_DOCUMENT" TableSchema="AKUZ" TableColumn="CdaDocumentID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
        <UniqueConstraints>
          <UniqueConstraint Name="UQ_T_CDA_SECTION_PATIENT_ROUTTODIAG_CdaRouttodiag" KeyColumn="CdaSectionPatientRouttodiagID" IsColumnNullable="1">
            <Column Name="CdaRouttodiag" />
          </UniqueConstraint>
        </UniqueConstraints>
      </Table>
		<Table Name="T_CDA_REPRESENTATIVE_ROUTTODIAG" Schema="AKUZ">
			<Columns>
				<Column Name="CdaRepresentativeRouttodiagID" Type="guid" IsNullable="0" />
				<Column Name="Name" Type="string" Length="255" IsNullable="0" />
				<Column Name="Surname" Type="string" Length="255" IsNullable="0" />
				<Column Name="MiddleName" Type="string" Length="255" IsNullable="1" />
				<Column Name="Snils" Type="string" Length="255" IsNullable="1" />
				<Column Name="Birthday" Type="datetime" IsNullable="1" />
				<Column Name="OMSPolicy" Type="string" Length="255" IsNullable="1" />
				<Column Name="EhrRus7c1skgluah" Type="int" IsNullable="1" />
				<Column Name="AddressLiving" Type="guid" IsNullable="1" />
				<Column Name="AddressRegistry" Type="guid" IsNullable="1" />
				<Column Name="LpuMain" Type="guid" IsNullable="1" />
				<Column Name="CdaSectionPatientRouttodiag" Type="guid" IsNullable="1" />
			</Columns>
			<PrimaryKey Name="PK_T_CDA_REPRESENTATIVE_ROUTTODIAG" Clustered="1">
				<Column Name="CdaRepresentativeRouttodiagID" />
			</PrimaryKey>
			<ForeignKeys>
				<ForeignKey Name="FK_T_EHR_RUS_7C1SKGLUAH_T_CDA_REPRESENTATIVE_ROUTTODIAG_EhrRus7c1skgluah" ShortName="FK_T_EHR_RUS_7C1SKGLUAH_T_CDA_REPRESENTATIVE_ROUTTODIA_3383D6D0" Column="EhrRus7c1skgluah" Table="T_EHR_RUS_7C1SKGLUAH" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
				<ForeignKey Name="FK_T_PATIENT_ADDRESS_T_CDA_REPRESENTATIVE_ROUTTODIAG_AddressLiving" ShortName="FK_T_PATIENT_ADDRESS_T_CDA_REPRESENTATIVE_ROUTTODIAG_A_CB69569B" Column="AddressLiving" Table="T_PATIENT_ADDRESS" TableSchema="AKUZ" TableColumn="AddressID" CascadeDelete="0" CascadeUpdate="0" />
				<ForeignKey Name="FK_T_PATIENT_ADDRESS_T_CDA_REPRESENTATIVE_ROUTTODIAG_AddressRegistry" ShortName="FK_T_PATIENT_ADDRESS_T_CDA_REPRESENTATIVE_ROUTTODIAG_A_BFBCA652" Column="AddressRegistry" Table="T_PATIENT_ADDRESS" TableSchema="AKUZ" TableColumn="AddressID" CascadeDelete="0" CascadeUpdate="0" />
				<ForeignKey Name="FK_T_LPU_MAIN_T_CDA_REPRESENTATIVE_ROUTTODIAG_LpuMain" Column="LpuMain" Table="T_LPU_MAIN" TableSchema="AKUZ" TableColumn="LpuID" CascadeDelete="0" CascadeUpdate="0" />
				<ForeignKey Name="FK_T_CDA_SECTION_PATIENT_ROUTTODIAG_T_CDA_REPRESENTATIVE_ROUTTODIAG_CdaSectionPatientRouttodiag" ShortName="FK_T_CDA_SECTION_PATIENT_ROUTTODIAG_T_CDA_REPRESENTATI_DC417CF7" Column="CdaSectionPatientRouttodiag" Table="T_CDA_SECTION_PATIENT_ROUTTODIAG" TableSchema="AKUZ" TableColumn="CdaSectionPatientRouttodiagID" CascadeDelete="0" CascadeUpdate="0" />
			</ForeignKeys>
			<UniqueConstraints>
				<UniqueConstraint Name="UQ_T_CDA_REPRESENTATIVE_ROUTTODIAG_CdaSectionPatientRouttodiag" KeyColumn="CdaRepresentativeRouttodiagID" IsColumnNullable="1">
					<Column Name="CdaSectionPatientRouttodiag" />
				</UniqueConstraint>
			</UniqueConstraints>
		</Table>
		<Table Name="T_CDA_CONTACT_ROUTTODIAG" Schema="AKUZ">
			<Columns>
				<Column Name="CdaContactRouttodiagID" Type="guid" IsNullable="0" />
				<Column Name="Contact" Type="string" Length="255" IsNullable="0" />
				<Column Name="CdaRepresentativeRouttodiag" Type="guid" IsNullable="1" />
			</Columns>
			<PrimaryKey Name="PK_T_CDA_CONTACT_ROUTTODIAG" Clustered="1">
				<Column Name="CdaContactRouttodiagID" />
			</PrimaryKey>
			<ForeignKeys>
				<ForeignKey Name="FK_T_CDA_REPRESENTATIVE_ROUTTODIAG_T_CDA_CONTACT_ROUTTODIAG_CdaRepresentativeRouttodiag" ShortName="FK_T_CDA_REPRESENTATIVE_ROUTTODIAG_T_CDA_CONTACT_ROUTT_FF0684F4" Column="CdaRepresentativeRouttodiag" Table="T_CDA_REPRESENTATIVE_ROUTTODIAG" TableSchema="AKUZ" TableColumn="CdaRepresentativeRouttodiagID" CascadeDelete="0" CascadeUpdate="0" />
			</ForeignKeys>
		</Table>
		<Table Name="T_CDA_IDENTIFICATION_DOCUMENT_ROUTTODIAG" Schema="AKUZ">
			<Columns>
				<Column Name="CdaIdentificationDocumentRouttodiagID" Type="guid" IsNullable="0" />
				<Column Name="EhrRusNn5meatu5t" Type="int" IsNullable="0" />
				<Column Name="Series" Type="string" Length="255" IsNullable="0" />
				<Column Name="Number" Type="string" Length="255" IsNullable="0" />
				<Column Name="IssueDate" Type="datetime" IsNullable="0" />
				<Column Name="IssueOrgName" Type="string" Length="512" IsNullable="0" />
				<Column Name="IssueOrgCode" Type="int" IsNullable="0" />
				<Column Name="CdaRepresentativeRouttodiag" Type="guid" IsNullable="1" />
			</Columns>
			<PrimaryKey Name="PK_T_CDA_IDENTIFICATION_DOCUMENT_ROUTTODIAG" Clustered="1">
				<Column Name="CdaIdentificationDocumentRouttodiagID" />
			</PrimaryKey>
			<ForeignKeys>
				<ForeignKey Name="FK_T_EHR_RUS_NN5MEATU5T_T_CDA_IDENTIFICATION_DOCUMENT_ROUTTODIAG_EhrRusNn5meatu5t" ShortName="FK_T_EHR_RUS_NN5MEATU5T_T_CDA_IDENTIFICATION_DOCUMENT__F739714D" Column="EhrRusNn5meatu5t" Table="T_EHR_RUS_NN5MEATU5T" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
				<ForeignKey Name="FK_T_CDA_REPRESENTATIVE_ROUTTODIAG_T_CDA_IDENTIFICATION_DOCUMENT_ROUTTODIAG_CdaRepresentativeRouttodiag" ShortName="FK_T_CDA_REPRESENTATIVE_ROUTTODIAG_T_CDA_IDENTIFICATIO_0A0C5C46" Column="CdaRepresentativeRouttodiag" Table="T_CDA_REPRESENTATIVE_ROUTTODIAG" TableSchema="AKUZ" TableColumn="CdaRepresentativeRouttodiagID" CascadeDelete="0" CascadeUpdate="0" />
			</ForeignKeys>
			<UniqueConstraints>
				<UniqueConstraint Name="UQ_T_CDA_IDENTIFICATION_DOCUMENT_ROUTTODIAG_CdaRepresentativeRouttodiag" KeyColumn="CdaIdentificationDocumentRouttodiagID" IsColumnNullable="1">
					<Column Name="CdaRepresentativeRouttodiag" />
				</UniqueConstraint>
			</UniqueConstraints>
		</Table>
		<Table Name="T_CDA_AUTHORITY_DOC_ROUTTODIAG" Schema="AKUZ">
			<Columns>
				<Column Name="CdaAuthorityDocRouttodiagID" Type="guid" IsNullable="0" />
				<Column Name="IdentityCardTypeId" Type="int" IsNullable="0" />
				<Column Name="Series" Type="string" Length="16" IsNullable="0" />
				<Column Name="Number" Type="string" Length="16" IsNullable="0" />
				<Column Name="IssueOrgName" Type="string" Length="256" IsNullable="0" />
				<Column Name="IssueDate" Type="date" IsNullable="0" />
				<Column Name="CdaRepresentativeRouttodiag" Type="guid" IsNullable="1" />
			</Columns>
			<PrimaryKey Name="PK_T_CDA_AUTHORITY_DOC_ROUTTODIAG" Clustered="1">
				<Column Name="CdaAuthorityDocRouttodiagID" />
			</PrimaryKey>
			<ForeignKeys>
				<ForeignKey Name="FK_T_EHR_RUS_4C7NGF83DD_T_CDA_AUTHORITY_DOC_ROUTTODIAG_IdentityCardTypeId" ShortName="FK_T_EHR_RUS_4C7NGF83DD_T_CDA_AUTHORITY_DOC_ROUTTODIAG_B33C8C14" Column="IdentityCardTypeId" Table="T_EHR_RUS_4C7NGF83DD" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
				<ForeignKey Name="FK_T_CDA_REPRESENTATIVE_ROUTTODIAG_T_CDA_AUTHORITY_DOC_ROUTTODIAG_CdaRepresentativeRouttodiag" ShortName="FK_T_CDA_REPRESENTATIVE_ROUTTODIAG_T_CDA_AUTHORITY_DOC_31690C9A" Column="CdaRepresentativeRouttodiag" Table="T_CDA_REPRESENTATIVE_ROUTTODIAG" TableSchema="AKUZ" TableColumn="CdaRepresentativeRouttodiagID" CascadeDelete="0" CascadeUpdate="0" />
			</ForeignKeys>
			<UniqueConstraints>
				<UniqueConstraint Name="UQ_T_CDA_AUTHORITY_DOC_ROUTTODIAG_CdaRepresentativeRouttodiag" KeyColumn="CdaAuthorityDocRouttodiagID" IsColumnNullable="1">
					<Column Name="CdaRepresentativeRouttodiag" />
				</UniqueConstraint>
			</UniqueConstraints>
		</Table>
    </Tables>
  </Database>
</Databases>