test

Tables (6)

COUNTRY (Untitled5)

  • COUNRTY_ID (Key) — Primary key — NOT NULL

DEPARTMENT (Untitled2)

  • DEPT_ID (Key) — Primary key — NOT NULL
  • LOC_ID (Field)
  • LOCATION_ID (Key2) — Foreign key → LOCATION.LOCATION_ID — NOT NULL

EMPLOYEE (Untitled)

  • EMP_ID (Key) — Primary key — NOT NULL
  • JOB_ID (Key2) — Foreign key → JOB.JOB_ID — NOT NULL
  • DEPT_ID (Field)
  • DEPT_ID (Key3) — Foreign key → DEPARTMENT.DEPT_ID — NOT NULL
  • EMP_ID (Key4) — Foreign key → EMPLOYEE.EMP_ID — NOT NULL

JOB (Untitled3)

  • JOB_ID (Key) — Primary key — NOT NULL

LOCATION (Untitled4)

  • LOCATION_ID (Key) — Primary key — NOT NULL
  • COUNTRY_ID (Field)
  • COUNRTY_ID (Key2) — Foreign key → COUNTRY.COUNRTY_ID — NOT NULL

SAL_GRADE

  • SLEVEL (Key) — Primary key — NOT NULL