<?xml version="1.0" encoding="ISO-8859-15"?>
<!--
  generated by Jailer, Mon Dec 15 09:59:34 CET 2008 from wisser@desktop
  
  Extraction Model:  EMPLOYEE where T.NAME='SCOTT' (Demo.csv)
  Database URL:      jdbc:db2://localhost:50001/wisser
  Database User:     scott
  Exported Rows:     16
      DEPARTMENT                     2
      EMPLOYEE                       3
      PROJECT                        2
      PROJECT_PARTICIPATION          2
      ROLE                           2
      SALARYGRADE                    5
-->
<entities>
  <employee empno="7788">
    <!--columns of EMPLOYEE as T-->
    <name>SCOTT</name>
    <job>ANALYST</job>
    <hiredate>1982-12-09</hiredate>
    <comm/>
    <!--associated SALARYGRADE row-->
    <salary_grade grade="4">
      <!--columns of SALARYGRADE as T-->
      <losal>2001</losal>
      <hisal>3000</hisal>
    </salary_grade>
    <!--associated DEPARTMENT row-->
    <department deptno="20">
      <!--columns of DEPARTMENT as T-->
      <name>RESEARCH</name>
      <location>DALLAS</location>
    </department>
    <!--associated EMPLOYEE row-->
    <boss empno="7566">
      <!--columns of EMPLOYEE as T-->
      <name>JONES</name>
      <job>MANAGER</job>
      <hiredate>1981-04-02</hiredate>
      <comm/>
      <!--associated SALARYGRADE row-->
      <salary_grade grade="4">
        <!--columns of SALARYGRADE as T-->
        <losal>2001</losal>
        <hisal>3000</hisal>
      </salary_grade>
      <!--associated DEPARTMENT row-->
      <department deptno="20">
        <!--columns of DEPARTMENT as T-->
        <name>RESEARCH</name>
        <location>DALLAS</location>
      </department>
      <!--associated EMPLOYEE row-->
      <boss empno="7839">
        <!--columns of EMPLOYEE as T-->
        <name>KING</name>
        <job>PRESIDENT</job>
        <hiredate>1981-11-17</hiredate>
        <comm/>
        <!--associated SALARYGRADE row-->
        <salary_grade grade="5">
          <!--columns of SALARYGRADE as T-->
          <losal>3001</losal>
          <hisal>9999</hisal>
        </salary_grade>
        <!--associated DEPARTMENT row-->
        <department deptno="10">
          <!--columns of DEPARTMENT as T-->
          <name>ACCOUNTING</name>
          <location>NEW YORK</location>
        </department>
        <!--associated EMPLOYEE row-->
        <!--associated PROJECT_PARTICIPATION rows-->
        <participations/>
      </boss>
      <!--associated PROJECT_PARTICIPATION rows-->
      <participations>
        <project_participation>
          <!--columns of PROJECT_PARTICIPATION as T-->
          <start_date>2007-02-24</start_date>
          <end_date>2008-07-31</end_date>
          <!--associated ROLE row-->
          <!--columns of ROLE as T-->
          <role_description>Project manager</role_description>
          <!--associated PROJECT row-->
          <!--columns of PROJECT as T-->
          <project_description>Foundation of Quantum Technology</project_description>
          <project_start_date>2007-02-24</project_start_date>
          <project_end_date>2008-07-31</project_end_date>
        </project_participation>
      </participations>
    </boss>
    <!--associated PROJECT_PARTICIPATION rows-->
    <participations>
      <project_participation>
        <!--columns of PROJECT_PARTICIPATION as T-->
        <start_date>2006-05-15</start_date>
        <end_date>2006-11-01</end_date>
        <!--associated ROLE row-->
        <!--columns of ROLE as T-->
        <role_description>Developer</role_description>
        <!--associated PROJECT row-->
        <!--columns of PROJECT as T-->
        <project_description>Development of Novel Magnetic Suspension System</project_description>
        <project_start_date>2006-01-01</project_start_date>
        <project_end_date>2007-08-13</project_end_date>
      </project_participation>
    </participations>
  </employee>
  <salarygrade grade="1">
    <!--columns of SALARYGRADE as T-->
    <losal>700</losal>
    <hisal>1200</hisal>
  </salarygrade>
  <salarygrade grade="2">
    <!--columns of SALARYGRADE as T-->
    <losal>1201</losal>
    <hisal>1400</hisal>
  </salarygrade>
  <salarygrade grade="3">
    <!--columns of SALARYGRADE as T-->
    <losal>1401</losal>
    <hisal>2000</hisal>
  </salarygrade>
</entities>
