TriplesMapCOUNTRIES
type: TriplesMap
logical table:
  table schema: Oracle
  table owner: HR
  table name: COUNTRIES
subject map:
  termtype: IRI
  template: http://demo.openlinksw.com/Oracle/countries/COUNTRY_ID={COUNTRY_ID}
  class: COUNTRIES
  graph: Oracle#
predicate object map:
  predicate map:
    constant: country id
  object map:
    column: COUNTRY_ID
predicate object map:
  predicate map:
    constant: country name
  object map:
    column: COUNTRY_NAME
predicate object map:
  predicate map:
    constant: countries has regions
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/regions/REGION_ID={REGION_ID}
predicate object map:
  predicate map:
    constant: countries of locations
  object map:
    parent triples map: TriplesMapLOCATIONS
    join condition:
      child: COUNTRY_ID
      parent: COUNTRY_ID

TriplesMapDEPARTMENTS
type: TriplesMap
logical table:
  table schema: Oracle
  table owner: HR
  table name: DEPARTMENTS
subject map:
  termtype: IRI
  template: http://demo.openlinksw.com/Oracle/departments/DEPARTMENT_ID={DEPARTMENT_ID}
  class: DEPARTMENTS
  graph: Oracle#
predicate object map:
  predicate map:
    constant: department id
  object map:
    column: DEPARTMENT_ID
predicate object map:
  predicate map:
    constant: department name
  object map:
    column: DEPARTMENT_NAME
predicate object map:
  predicate map:
    constant: departments has employees
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/employees/MANAGER_ID={MANAGER_ID}
predicate object map:
  predicate map:
    constant: departments has locations
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/locations/LOCATION_ID={LOCATION_ID}
predicate object map:
  predicate map:
    constant: departments of employees
  object map:
    parent triples map: TriplesMapEMPLOYEES
    join condition:
      child: DEPARTMENT_ID
      parent: DEPARTMENT_ID
predicate object map:
  predicate map:
    constant: departments of job history
  object map:
    parent triples map: TriplesMapJOB HISTORY
    join condition:
      child: DEPARTMENT_ID
      parent: DEPARTMENT_ID

TriplesMapEMPLOYEES
type: TriplesMap
logical table:
  table schema: Oracle
  table owner: HR
  table name: EMPLOYEES
subject map:
  termtype: IRI
  template: http://demo.openlinksw.com/Oracle/employees/EMPLOYEE_ID={EMPLOYEE_ID}
  class: EMPLOYEES
  graph: Oracle#
predicate object map:
  predicate map:
    constant: employee id
  object map:
    column: EMPLOYEE_ID
predicate object map:
  predicate map:
    constant: first name
  object map:
    column: FIRST_NAME
predicate object map:
  predicate map:
    constant: last name
  object map:
    column: LAST_NAME
predicate object map:
  predicate map:
    constant: email
  object map:
    column: EMAIL
predicate object map:
  predicate map:
    constant: phone number
  object map:
    column: PHONE_NUMBER
predicate object map:
  predicate map:
    constant: hire date
  object map:
    column: HIRE_DATE
predicate object map:
  predicate map:
    constant: salary
  object map:
    column: SALARY
predicate object map:
  predicate map:
    constant: commission pct
  object map:
    column: COMMISSION_PCT
predicate object map:
  predicate map:
    constant: employees has departments
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/departments/DEPARTMENT_ID={DEPARTMENT_ID}
predicate object map:
  predicate map:
    constant: employees has jobs
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/jobs/JOB_ID={JOB_ID}
predicate object map:
  predicate map:
    constant: employees of departments
  object map:
    parent triples map: TriplesMapDEPARTMENTS
    join condition:
      child: EMPLOYEE_ID
      parent: MANAGER_ID
predicate object map:
  predicate map:
    constant: employees has employees
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/employees/MANAGER_ID={MANAGER_ID}
predicate object map:
  predicate map:
    constant: employees of job history
  object map:
    parent triples map: TriplesMapJOB HISTORY
    join condition:
      child: EMPLOYEE_ID
      parent: EMPLOYEE_ID

TriplesMapJOBS
type: TriplesMap
logical table:
  table schema: Oracle
  table owner: HR
  table name: JOBS
subject map:
  termtype: IRI
  template: http://demo.openlinksw.com/Oracle/jobs/JOB_ID={JOB_ID}
  class: JOBS
  graph: Oracle#
predicate object map:
  predicate map:
    constant: job id
  object map:
    column: JOB_ID
predicate object map:
  predicate map:
    constant: job title
  object map:
    column: JOB_TITLE
predicate object map:
  predicate map:
    constant: min salary
  object map:
    column: MIN_SALARY
predicate object map:
  predicate map:
    constant: max salary
  object map:
    column: MAX_SALARY
predicate object map:
  predicate map:
    constant: jobs of employees
  object map:
    parent triples map: TriplesMapEMPLOYEES
    join condition:
      child: JOB_ID
      parent: JOB_ID
predicate object map:
  predicate map:
    constant: jobs of job history
  object map:
    parent triples map: TriplesMapJOB HISTORY
    join condition:
      child: JOB_ID
      parent: JOB_ID

TriplesMapJOB HISTORY
type: TriplesMap
logical table:
  table schema: Oracle
  table owner: HR
  table name: JOB_HISTORY
subject map:
  termtype: IRI
  template: http://demo.openlinksw.com/Oracle/job_history/EMPLOYEE_ID={EMPLOYEE_ID}/START_DATE={START_DATE}
  class: JOB HISTORY
  graph: Oracle#
predicate object map:
  predicate map:
    constant: start date
  object map:
    column: START_DATE
predicate object map:
  predicate map:
    constant: end date
  object map:
    column: END_DATE
predicate object map:
  predicate map:
    constant: job history has departments
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/departments/DEPARTMENT_ID={DEPARTMENT_ID}
predicate object map:
  predicate map:
    constant: job history has employees
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/employees/EMPLOYEE_ID={EMPLOYEE_ID}
predicate object map:
  predicate map:
    constant: job history has jobs
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/jobs/JOB_ID={JOB_ID}

TriplesMapLOCATIONS
type: TriplesMap
logical table:
  table schema: Oracle
  table owner: HR
  table name: LOCATIONS
subject map:
  termtype: IRI
  template: http://demo.openlinksw.com/Oracle/locations/LOCATION_ID={LOCATION_ID}
  class: LOCATIONS
  graph: Oracle#
predicate object map:
  predicate map:
    constant: location id
  object map:
    column: LOCATION_ID
predicate object map:
  predicate map:
    constant: street address
  object map:
    column: STREET_ADDRESS
predicate object map:
  predicate map:
    constant: postal code
  object map:
    column: POSTAL_CODE
predicate object map:
  predicate map:
    constant: city
  object map:
    column: CITY
predicate object map:
  predicate map:
    constant: state province
  object map:
    column: STATE_PROVINCE
predicate object map:
  predicate map:
    constant: locations has countries
  object map:
    termtype: IRI
    template: http://demo.openlinksw.com/Oracle/countries/COUNTRY_ID={COUNTRY_ID}
predicate object map:
  predicate map:
    constant: locations of departments
  object map:
    parent triples map: TriplesMapDEPARTMENTS
    join condition:
      child: LOCATION_ID
      parent: LOCATION_ID

TriplesMapREGIONS
type: TriplesMap
logical table:
  table schema: Oracle
  table owner: HR
  table name: REGIONS
subject map:
  termtype: IRI
  template: http://demo.openlinksw.com/Oracle/regions/REGION_ID={REGION_ID}
  class: REGIONS
  graph: Oracle#
predicate object map:
  predicate map:
    constant: region id
  object map:
    column: REGION_ID
predicate object map:
  predicate map:
    constant: region name
  object map:
    column: REGION_NAME
predicate object map:
  predicate map:
    constant: regions of countries
  object map:
    parent triples map: TriplesMapCOUNTRIES
    join condition:
      child: REGION_ID
      parent: REGION_ID