<Databases>
  <Database>
    <Tables>
      <Table Name="T_CDA_SECTION_MEDICAL_REPORT_LINKDOCS" Schema="AKUZ">
        <AddColumns>
          <Column Name="CdaTicket" Type="guid" IsNullable="1" />
        </AddColumns>
        <ForeignKeys>
          <ForeignKey Name="FK_T_CDA_DOCUMENT_T_CDA_SECTION_MEDICAL_REPORT_LINKDOCS_CdaTicket" ShortName="FK_T_CDA_DOCUMENT_T_CDA_SECTION_MEDICAL_REPORT_LINKDOC_8903508A" Column="CdaTicket" Table="T_CDA_DOCUMENT" TableSchema="AKUZ" TableColumn="CdaDocumentID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
        <UniqueConstraints>
          <UniqueConstraint Name="UQ_T_CDA_SECTION_MEDICAL_REPORT_LINKDOCS_CdaTicket" KeyColumn="CdaSectionMedicalReportLinkdocsID" IsColumnNullable="1">
            <Column Name="CdaTicket" />
          </UniqueConstraint>
        </UniqueConstraints>
      </Table>
      <Table Name="T_CDA_SECTION_DGN_SEMD" Schema="AKUZ">
        <AlterColumns>
          <Column Name="CdaRefHospReahabExamCons" Type="guid" IsNullable="1" />
        </AlterColumns>
      </Table>
      <Table Name="T_CDA_DGN_TICKET" Schema="AKUZ">
        <Columns>
          <Column Name="CdaDgnTicketID" Type="guid" IsNullable="0" />
          <Column Name="type_" Type="int" IsNullable="0" />
        </Columns>
        <PrimaryKey Name="PK_T_CDA_DGN_TICKET" Clustered="1">
          <Column Name="CdaDgnTicketID" />
        </PrimaryKey>
        <ForeignKeys>
          <ForeignKey Name="FK_T_ENTITIES_T_CDA_DGN_TICKET_type_" Column="type_" Table="T_ENTITIES" TableSchema="VCLib" TableColumn="EntityID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
      </Table>
      <Table Name="T_CDA_SECTION_DGN_TICKET" Schema="AKUZ">
        <Columns>
          <Column Name="CdaDgnTicketID" Type="guid" IsNullable="0" />
          <Column Name="CdaTicket" Type="guid" IsNullable="1" />
        </Columns>
        <PrimaryKey Name="PK_T_CDA_SECTION_DGN_TICKET" Clustered="1">
          <Column Name="CdaDgnTicketID" />
        </PrimaryKey>
        <ForeignKeys>
          <ForeignKey Name="FK_T_CDA_DGN_TICKET_T_CDA_SECTION_DGN_TICKET_CdaDgnTicketID" Column="CdaDgnTicketID" Table="T_CDA_DGN_TICKET" TableSchema="AKUZ" TableColumn="CdaDgnTicketID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_CDA_DOCUMENT_T_CDA_SECTION_DGN_TICKET_CdaTicket" Column="CdaTicket" Table="T_CDA_DOCUMENT" TableSchema="AKUZ" TableColumn="CdaDocumentID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
        <UniqueConstraints>
          <UniqueConstraint Name="UQ_T_CDA_SECTION_DGN_TICKET_CdaTicket" KeyColumn="CdaDgnTicketID" IsColumnNullable="1">
            <Column Name="CdaTicket" />
          </UniqueConstraint>
        </UniqueConstraints>
      </Table>
      <Table Name="T_CDA_SECTION_DOCINFO_TICKET" Schema="AKUZ">
        <Columns>
          <Column Name="CdaSectionDocinfoTicketID" Type="guid" IsNullable="0" />
          <Column Name="MestoOkazSkorojMedicPomosch" Type="int" IsNullable="1" />
          <Column Name="DataVizovSkorojMedicPomosch" Type="date" IsNullable="0" />
          <Column Name="VremyaVizovSkorojMedicPomosch" Type="datetime" IsNullable="0" />
          <Column Name="DataNeschastnSlucha" Type="date" IsNullable="0" />
          <Column Name="VremyaNeschastnSlucha" Type="datetime" IsNullable="0" />
          <Column Name="ObstoNeschastnSlucha" Type="int" IsNullable="1" />
          <Column Name="OkazMedicPomoschj" Type="string" Length="255" IsNullable="0" />
          <Column Name="SposobTransport" Type="int" IsNullable="0" />
          <Column Name="Division" Type="guid" IsNullable="0" />
          <Column Name="Diagnoz" Type="text" IsNullable="0" />
          <Column Name="RoljMedicRabotnUstanDiagn" Type="int" IsNullable="0" />
          <Column Name="PoliklNeotlPomoschSkorojMedicP" Type="int" IsNullable="1" />
          <Column Name="ProdolzhGospit" Type="float" Precision="6" Scale="2" IsNullable="1" />
          <Column Name="EhrRusS0JLHGTLBJ" Type="int" IsNullable="1" />
          <Column Name="OkazPomoschjAmbul" Type="bool" IsNullable="0" />
          <Column Name="RezuljtObrasch" Type="int" IsNullable="0" />
          <Column Name="DataVipiskIzStaci" Type="date" IsNullable="1" />
          <Column Name="ZamechMedicOrganRabotBrigadSko" Type="string" Length="255" IsNullable="1" />
          <Column Name="CdaTicket" Type="guid" IsNullable="1" />
          <Column Name="PlaceEmergencyCare" Type="text" IsNullable="1" />
          <Column Name="CircumstancesAccident" Type="text" IsNullable="1" />
        </Columns>
        <PrimaryKey Name="PK_T_CDA_SECTION_DOCINFO_TICKET" Clustered="1">
          <Column Name="CdaSectionDocinfoTicketID" />
        </PrimaryKey>
        <ForeignKeys>
          <ForeignKey Name="FK_T_EHR_RUS_6SNJAKF644_T_CDA_SECTION_DOCINFO_TICKET_MestoOkazSkorojMedicPomosch" ShortName="FK_T_EHR_RUS_6SNJAKF644_T_CDA_SECTION_DOCINFO_TICKET_M_7F4958FD" Column="MestoOkazSkorojMedicPomosch" Table="T_EHR_RUS_6SNJAKF644" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_EHR_RUS_48UV93VDJ8_T_CDA_SECTION_DOCINFO_TICKET_ObstoNeschastnSlucha" ShortName="FK_T_EHR_RUS_48UV93VDJ8_T_CDA_SECTION_DOCINFO_TICKET_O_C6F11115" Column="ObstoNeschastnSlucha" Table="T_EHR_RUS_48UV93VDJ8" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_EHR_RUS_BDVR724SDH_T_CDA_SECTION_DOCINFO_TICKET_SposobTransport" ShortName="FK_T_EHR_RUS_BDVR724SDH_T_CDA_SECTION_DOCINFO_TICKET_S_6B4EFEB8" Column="SposobTransport" Table="T_EHR_RUS_BDVR724SDH" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_DIVISION_T_CDA_SECTION_DOCINFO_TICKET_Division" Column="Division" Table="T_DIVISION" TableSchema="AKUZ" TableColumn="DivisionID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_EHR_RUS_RL682_T_CDA_SECTION_DOCINFO_TICKET_RoljMedicRabotnUstanDiagn" ShortName="FK_T_EHR_RUS_RL682_T_CDA_SECTION_DOCINFO_TICKET_RoljMe_0542DEE6" Column="RoljMedicRabotnUstanDiagn" Table="T_EHR_RUS_RL682" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_EHR_RUS_OOVP672A8N_T_CDA_SECTION_DOCINFO_TICKET_PoliklNeotlPomoschSkorojMedicP" ShortName="FK_T_EHR_RUS_OOVP672A8N_T_CDA_SECTION_DOCINFO_TICKET_P_84E3BC72" Column="PoliklNeotlPomoschSkorojMedicP" Table="T_EHR_RUS_OOVP672A8N" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_EHR_RUS_S0JLHGTLBJ_T_CDA_SECTION_DOCINFO_TICKET_EhrRusS0JLHGTLBJ" ShortName="FK_T_EHR_RUS_S0JLHGTLBJ_T_CDA_SECTION_DOCINFO_TICKET_E_76A2B5AE" Column="EhrRusS0JLHGTLBJ" Table="T_EHR_RUS_S0JLHGTLBJ" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_EHR_RUS_VRS365_T_CDA_SECTION_DOCINFO_TICKET_RezuljtObrasch" Column="RezuljtObrasch" Table="T_EHR_RUS_VRS365" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_CDA_DOCUMENT_T_CDA_SECTION_DOCINFO_TICKET_CdaTicket" Column="CdaTicket" Table="T_CDA_DOCUMENT" TableSchema="AKUZ" TableColumn="CdaDocumentID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
        <UniqueConstraints>
          <UniqueConstraint Name="UQ_T_CDA_SECTION_DOCINFO_TICKET_CdaTicket" KeyColumn="CdaSectionDocinfoTicketID" IsColumnNullable="1">
            <Column Name="CdaTicket" />
          </UniqueConstraint>
        </UniqueConstraints>
      </Table>
      <Table Name="T_CDA_SECTION_ERDGN_TICKET" Schema="AKUZ">
        <Columns>
          <Column Name="CdaDgnTicketID" Type="guid" IsNullable="0" />
          <Column Name="CdaTicket" Type="guid" IsNullable="1" />
        </Columns>
        <PrimaryKey Name="PK_T_CDA_SECTION_ERDGN_TICKET" Clustered="1">
          <Column Name="CdaDgnTicketID" />
        </PrimaryKey>
        <ForeignKeys>
          <ForeignKey Name="FK_T_CDA_DGN_TICKET_T_CDA_SECTION_ERDGN_TICKET_CdaDgnTicketID" Column="CdaDgnTicketID" Table="T_CDA_DGN_TICKET" TableSchema="AKUZ" TableColumn="CdaDgnTicketID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_CDA_DOCUMENT_T_CDA_SECTION_ERDGN_TICKET_CdaTicket" Column="CdaTicket" Table="T_CDA_DOCUMENT" TableSchema="AKUZ" TableColumn="CdaDocumentID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
        <UniqueConstraints>
          <UniqueConstraint Name="UQ_T_CDA_SECTION_ERDGN_TICKET_CdaTicket" KeyColumn="CdaDgnTicketID" IsColumnNullable="1">
            <Column Name="CdaTicket" />
          </UniqueConstraint>
        </UniqueConstraints>
      </Table>
      <Table Name="T_CDA_SECTION_SUR_TICKET" Schema="AKUZ">
        <Columns>
          <Column Name="CdaSectionSurTicketID" Type="guid" IsNullable="0" />
          <Column Name="CdaTicket" Type="guid" IsNullable="1" />
        </Columns>
        <PrimaryKey Name="PK_T_CDA_SECTION_SUR_TICKET" Clustered="1">
          <Column Name="CdaSectionSurTicketID" />
        </PrimaryKey>
        <ForeignKeys>
          <ForeignKey Name="FK_T_CDA_DOCUMENT_T_CDA_SECTION_SUR_TICKET_CdaTicket" Column="CdaTicket" Table="T_CDA_DOCUMENT" TableSchema="AKUZ" TableColumn="CdaDocumentID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
        <UniqueConstraints>
          <UniqueConstraint Name="UQ_T_CDA_SECTION_SUR_TICKET_CdaTicket" KeyColumn="CdaSectionSurTicketID" IsColumnNullable="1">
            <Column Name="CdaTicket" />
          </UniqueConstraint>
        </UniqueConstraints>
      </Table>
      <Table Name="T_CDA_SVEDEN_REZU_TICKET" Schema="AKUZ">
        <Columns>
          <Column Name="CdaSvedenRezuTicketID" Type="guid" IsNullable="0" />
          <Column Name="KodOperVmeshat" Type="int" IsNullable="1" />
          <Column Name="Primechanie" Type="text" IsNullable="1" />
          <Column Name="DataProvedOperVmeshat" Type="date" IsNullable="0" />
          <Column Name="VremyaProvedOperVmeshat" Type="datetime" IsNullable="0" />
          <Column Name="DataOkonchOperVmeshat" Type="date" IsNullable="1" />
          <Column Name="VremyaOkonchOperVmeshat" Type="datetime" IsNullable="1" />
          <Column Name="RezuljtOperVmeshat" Type="string" Length="255" IsNullable="1" />
          <Column Name="CdaSectionSurTicket" Type="guid" IsNullable="1" />
        </Columns>
        <PrimaryKey Name="PK_T_CDA_SVEDEN_REZU_TICKET" Clustered="1">
          <Column Name="CdaSvedenRezuTicketID" />
        </PrimaryKey>
        <ForeignKeys>
          <ForeignKey Name="FK_T_EHR_RUS_5P7QT9V2NB_T_CDA_SVEDEN_REZU_TICKET_KodOperVmeshat" Column="KodOperVmeshat" Table="T_EHR_RUS_5P7QT9V2NB" TableSchema="EHR" TableColumn="EhrRusID" CascadeDelete="0" CascadeUpdate="0" />
          <ForeignKey Name="FK_T_CDA_SECTION_SUR_TICKET_T_CDA_SVEDEN_REZU_TICKET_CdaSectionSurTicket" ShortName="FK_T_CDA_SECTION_SUR_TICKET_T_CDA_SVEDEN_REZU_TICKET_C_C7D9E9C6" Column="CdaSectionSurTicket" Table="T_CDA_SECTION_SUR_TICKET" TableSchema="AKUZ" TableColumn="CdaSectionSurTicketID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
      </Table>
      <Table Name="T_CDA_DGN_PROTOCOLEXTRACT" Schema="AKUZ">
        <AddColumns>
          <Column Name="CdaDgnTicket" Type="guid" IsNullable="1" />
        </AddColumns>
        <ForeignKeys>
          <ForeignKey Name="FK_T_CDA_DGN_TICKET_T_CDA_DGN_PROTOCOLEXTRACT_CdaDgnTicket" Column="CdaDgnTicket" Table="T_CDA_DGN_TICKET" TableSchema="AKUZ" TableColumn="CdaDgnTicketID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
      </Table>
    </Tables>
  </Database>
</Databases>