test

Tables (5)

Untitled (JOB)

  • Key (JOB_ID) — Primary key — NOT NULL
  • Field (TITLE)
  • Field2 (MINSAL)
  • Field3 (MAXSAL)

Untitled (DEPARTMENT)

  • Key (DEPT_ID) — Primary key — NOT NULL
  • Field (DEPT_NAME)
  • Key (LOCATION_ID) — Foreign key → Untitled.Key — NOT NULL

Untitled (LOCATION)

  • Key (LOCATION_ID) — Primary key — NOT NULL
  • Field (LOCDESCIREBE)
  • Key (COUNTRY_ID) — Foreign key → Untitled2.Key — NOT NULL

Untitled2 (EMPLOYEE)

  • Key (EMP_ID) — Primary key — NOT NULL
  • Field9 (MGR_ID)
  • Field (NAME)
  • Field2 (NO)
  • Field3 (EMAIL)
  • Field4 (PHONE)
  • Field5 (HIREDATE)
  • Field6 (SALARY)
  • Field7 (BONUS)
  • Field8 (MARRIAGE)
  • Key (JOB_ID) — Foreign key → Untitled.Key — NOT NULL
  • Key (DEPT_ID) — Foreign key → Untitled.Key — NOT NULL

Untitled2 (COUNTRY)

  • Key (COUNTRY_ID) — Primary key — NOT NULL
  • Field (NAME)