<?xml version='1.0' encoding='windows-1252' ?>
<!DOCTYPE Entity SYSTEM "jbo_03_01.dtd">

<Entity
   Name="Departments"
   DBObjectType="table"
   DBObjectName="DEPARTMENTS"
   AliasName="Departments"
   BindingStyle="Oracle"
   UseGlueCode="false"
   RowClass="model.DepartmentsImpl" >
   <DesignTime>
      <Attr Name="_isCodegen" Value="true" />
      <Attr Name="_version" Value="9.0.5.15.88" />
      <Attr Name="_codeGenFlag2" Value="Access" />
      <AttrArray Name="_publishEvents">
      </AttrArray>
   </DesignTime>
   <Attribute
      Name="DepartmentId"
      IsNotNull="true"
      Precision="4"
      Scale="0"
      ColumnName="DEPARTMENT_ID"
      Type="oracle.jbo.domain.Number"
      ColumnType="NUMBER"
      SQLType="NUMERIC"
      TableName="DEPARTMENTS"
      PrimaryKey="true" >
      <DesignTime>
         <Attr Name="_DisplaySize" Value="22" />
      </DesignTime>
   </Attribute>
   <Attribute
      Name="DepartmentName"
      IsNotNull="true"
      Precision="30"
      ColumnName="DEPARTMENT_NAME"
      Type="java.lang.String"
      ColumnType="VARCHAR2"
      SQLType="VARCHAR"
      TableName="DEPARTMENTS" >
      <DesignTime>
         <Attr Name="_DisplaySize" Value="30" />
      </DesignTime>
   </Attribute>
   <Attribute
      Name="ManagerId"
      Precision="6"
      Scale="0"
      ColumnName="MANAGER_ID"
      Type="oracle.jbo.domain.Number"
      ColumnType="NUMBER"
      SQLType="NUMERIC"
      TableName="DEPARTMENTS" >
      <DesignTime>
         <Attr Name="_DisplaySize" Value="22" />
      </DesignTime>
   </Attribute>
   <Attribute
      Name="LocationId"
      Precision="4"
      Scale="0"
      ColumnName="LOCATION_ID"
      Type="oracle.jbo.domain.Number"
      ColumnType="NUMBER"
      SQLType="NUMERIC"
      TableName="DEPARTMENTS" >
      <DesignTime>
         <Attr Name="_DisplaySize" Value="22" />
      </DesignTime>
   </Attribute>
   <AccessorAttribute
      Name="Employees"
      Association="model.DeptMgrFkAssoc"
      AssociationEnd="model.DeptMgrFkAssoc.Employees"
      AssociationOtherEnd="model.DeptMgrFkAssoc.Departments"
      Type="model.EmployeesImpl" >
   </AccessorAttribute>
   <AccessorAttribute
      Name="Employees1"
      Association="model.EmpDeptFkAssoc"
      AssociationEnd="model.EmpDeptFkAssoc.Employees1"
      AssociationOtherEnd="model.EmpDeptFkAssoc.Departments1"
      Type="oracle.jbo.RowIterator"
      IsUpdateable="false" >
   </AccessorAttribute>
   <Key
      Name="DeptIdPk" >
      <AttrArray Name="Attributes">
         <Item Value="model.Departments.DepartmentId" />
      </AttrArray>
      <DesignTime>
         <Attr Name="_DBObjectName" Value="DEPT_ID_PK" />
         <Attr Name="_isPrimary" Value="true" />
      </DesignTime>
   </Key>
   <Key
      Name="DeptNameNn" >
      <AttrArray Name="Attributes">
         <Item Value="model.Departments.DepartmentName" />
      </AttrArray>
      <DesignTime>
         <Attr Name="_DBObjectName" Value="DEPT_NAME_NN" />
         <Attr Name="_checkCondition" Value="&#34;DEPARTMENT_NAME&#34; IS NOT NULL" />
         <Attr Name="_isCheck" Value="true" />
      </DesignTime>
   </Key>
   <Key
      Name="DeptLocFk" >
      <AttrArray Name="Attributes">
         <Item Value="model.Departments.LocationId" />
      </AttrArray>
      <DesignTime>
         <Attr Name="_DBObjectName" Value="DEPT_LOC_FK" />
         <Attr Name="_referencedKey" Value="LOC_ID_PK" />
         <Attr Name="_isForeign" Value="true" />
      </DesignTime>
   </Key>
   <Key
      Name="DeptMgrFk" >
      <AttrArray Name="Attributes">
         <Item Value="model.Departments.ManagerId" />
      </AttrArray>
      <DesignTime>
         <Attr Name="_DBObjectName" Value="DEPT_MGR_FK" />
         <Attr Name="_referencedKey" Value="EMP_EMP_ID_PK" />
         <Attr Name="_isForeign" Value="true" />
      </DesignTime>
   </Key>
</Entity>
