<Databases>
  <Database>
    <Tables>
      <Table Name="T_LMSZ" Schema="RDS">
        <Columns>
          <Column Name="LmszID" Type="guid" IsNullable="0" />
          <Column Name="Code" Type="string" Length="10" IsNullable="0" />
          <Column Name="Name" Type="string" Length="100" IsNullable="0" />
        </Columns>
        <PrimaryKey Name="PK_T_LMSZ" Clustered="1">
          <Column Name="LmszID" />
        </PrimaryKey>
      </Table>
      <Table Name="T_BENEFITS_CATEGORY" Schema="RDS">
        <Columns>
          <Column Name="BenefitsCategoryID" Type="guid" IsNullable="0" />
          <Column Name="Lmsz" Type="guid" IsNullable="0" />
          <Column Name="LocalCategoryCode" Type="string" Length="10" IsNullable="0" />
          <Column Name="Name" Type="string" Length="100" IsNullable="0" />
          <Column Name="BeginDate" Type="date" IsNullable="0" />
          <Column Name="DateEnd" Type="date" IsNullable="1" />
        </Columns>
        <PrimaryKey Name="PK_T_BENEFITS_CATEGORY" Clustered="1">
          <Column Name="BenefitsCategoryID" />
        </PrimaryKey>
        <ForeignKeys>
          <ForeignKey Name="FK_T_LMSZ_T_BENEFITS_CATEGORY_Lmsz" Column="Lmsz" Table="T_LMSZ" TableSchema="RDS" TableColumn="LmszID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
      </Table>
      <Table Name="T_BENEFITS" Schema="RDS">
        <AddColumns>
          <Column Name="BenefitsCategory" Type="guid" IsNullable="1" />
        </AddColumns>
        <ForeignKeys>
          <ForeignKey Name="FK_T_BENEFITS_CATEGORY_T_BENEFITS_BenefitsCategory" Column="BenefitsCategory" Table="T_BENEFITS_CATEGORY" TableSchema="RDS" TableColumn="BenefitsCategoryID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
      </Table>
    </Tables>
  </Database>
</Databases>