<?xml version="1.0" encoding="ISO-8859-15"?>
<!--
  generated by Jailer, Fri Jun 19 11:38:50 CEST 2009 from wisser@u19
  
  Extraction Model:  EMPLOYEE where NAME='JONES' (/data/workspace/trunk/src/test/pseudocolumns/restricted_export/extractionmodel.csv)
  Database URL:      jdbc:postgresql://localhost:5432/postgres
  Database User:     postgres
  Exported Rows:     11
      DEPARTMENT                     2
      EMPLOYEE                       4
      SALARYGRADE                    2
      PROJECT_PARTICIPATION          1
      ROLE                           1
      PROJECT                        1
-->
<entities>
  <employee>
    <!--columns of EMPLOYEE as T-->
    <empno>7566</empno>
    <name>JONES</name>
    <job>MANAGER</job>
    <boss>7839</boss>
    <hiredate>1981-04-02</hiredate>
    <salary>2975.00</salary>
    <comm/>
    <deptno>20</deptno>
    <!--associated PROJECT_PARTICIPATION rows-->
    <project_participation>
      <!--columns of PROJECT_PARTICIPATION as T-->
      <projectno>1003</projectno>
      <empno>7566</empno>
      <start_date>2007-02-24</start_date>
      <end_date>2008-07-31</end_date>
      <role_id>102</role_id>
    </project_participation>
  </employee>
  <employee>
    <!--columns of EMPLOYEE as T-->
    <empno>7788</empno>
    <name>SCOTT</name>
    <job>ANALYST</job>
    <boss>7566</boss>
    <hiredate>1982-12-09</hiredate>
    <salary>3000.00</salary>
    <comm/>
    <deptno>20</deptno>
    <!--associated PROJECT_PARTICIPATION rows-->
  </employee>
  <employee>
    <!--columns of EMPLOYEE as T-->
    <empno>7839</empno>
    <name>KING</name>
    <job>PRESIDENT</job>
    <boss/>
    <hiredate>1981-11-17</hiredate>
    <salary>5000.00</salary>
    <comm/>
    <deptno>10</deptno>
    <!--associated PROJECT_PARTICIPATION rows-->
  </employee>
  <employee>
    <!--columns of EMPLOYEE as T-->
    <empno>7902</empno>
    <name>FORD</name>
    <job>ANALYST</job>
    <boss>7566</boss>
    <hiredate>1981-12-03</hiredate>
    <salary>3000.00</salary>
    <comm/>
    <deptno>20</deptno>
    <!--associated PROJECT_PARTICIPATION rows-->
  </employee>
  <department>
    <!--columns of DEPARTMENT as T-->
    <deptno>10</deptno>
    <name>ACCOUNTING</name>
    <location>NEW YORK</location>
  </department>
  <department>
    <!--columns of DEPARTMENT as T-->
    <deptno>20</deptno>
    <name>RESEARCH</name>
    <location>DALLAS</location>
  </department>
  <project>
    <!--columns of PROJECT as T-->
    <projectno>1003</projectno>
    <description>Foundation of Quantum Technology</description>
    <start_date>2007-02-24</start_date>
    <end_date>2008-07-31</end_date>
  </project>
  <role>
    <!--columns of ROLE as T-->
    <role_id>102</role_id>
    <description>Project manager</description>
  </role>
  <salarygrade>
    <!--columns of SALARYGRADE as T-->
    <grade>4</grade>
    <losal>2001</losal>
    <hisal>3000</hisal>
  </salarygrade>
  <salarygrade>
    <!--columns of SALARYGRADE as T-->
    <grade>5</grade>
    <losal>3001</losal>
    <hisal>9999</hisal>
  </salarygrade>
</entities>
