<?xml version="1.0" encoding="UTF-8"?>
<project name='Human Resources'>
   <table name='Employee'>
      <column ColumnName='OID' Primary='YES'    DataType='int'       Length='4'     Precision='10'
         Identity='NO' IdentitySeed='' IdentityIncrement=''/>
      <!-- LOCKCOUNTER will not be used -->
      <!-- Stored Procedures will not be used -->
	    <column ColumnName='Social Insurance Number' Primary='NO' DataType='char' Length='9' Precision='0'
         Identity='NO' IdentitySeed='' IdentityIncrement=''/>
      <column ColumnName='Current Salary' Primary='NO' DataType='money' Length='19' Precision='19'
         Identity='NO' IdentitySeed='' IdentityIncrement=''/>
      <column ColumnName='Hire Date' Primary='NO' DataType='datetime' Length='8' Precision='0'
         Identity='NO' IdentitySeed='' IdentityIncrement=''/>
      <column ColumnName='OID Personal Info' Primary='NO' DataType='int' Length='4' Precision='10'
         Identity='NO' IdentitySeed='' IdentityIncrement=''/>
   </table>
   <table name='Personal Info'>
      <column ColumnName='OID' Primary='YES' DataType='int' Length='4' Precision='10'
         Identity='NO' IdentitySeed='' IdentityIncrement=''/>
      <column ColumnName='Name' Primary='NO' DataType='varchar' Length='60' Precision='0'
         Identity='NO' IdentitySeed='' IdentityIncrement=''>
         <feature feature-name='Business Key Column'/>
      </column>
      <column ColumnName='Address' Primary='NO' DataType='varchar' Length='200' Precision='0'
         Identity='NO' IdentitySeed='' IdentityIncrement=''/>
   </table>
   <relationship PrimaryKeyTable='Personal Info' ForeignKeyTable='Employee'>
      <match PrimaryKey='OID' ForeignKey='OID Personal Info'/>
   </relationship>
</project>