test - 2020-07-13 07:11:10

Tables (6)

COUNTRY (Untitled6)

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

DEPARTMENT (Untitled4)

  • DEPT_ID (Key) — Primary key — NOT NULL
  • DEPT_NAME (Field)
  • LOCATION_ID (Key2) — Foreign key — NOT NULL

EMPLOYEE (Untitled3)

  • EMP_ID (Key) — Primary key — NOT NULL
  • EMP_NAME (Field)
  • EMP_NO (Field2)
  • EMAIL (Field3)
  • PHONE (Field4)
  • HIRE_DATE (Field5)
  • JOB_ID (Key2) — Foreign key — NOT NULL
  • SALARY (Field6)
  • BONUS_PCT (Field7)
  • MARRIAGE (Field8)
  • MGR_ID (FK)
  • DEPT_ID (Key3) — Foreign key — NOT NULL

JOB (Untitled2)

  • JOB_ID (Key) — Primary key — NOT NULL
  • JOB_TITLE (Field)
  • MIN_SAL (Field2)
  • MAX_SAL (Field3)

LOCATION (CopyOfUntitled5)

  • LOCATION_ID (Key) — Primary key — NOT NULL
  • COUNTRY_ID (Key2) — Foreign key — NOT NULL
  • LOC_DESCRIBE (Field)

SAL_GRADE (Untitled)

  • SLEVEL (Key) — Primary key — NOT NULL
  • LOWEST (Field)
  • HIGHEST (Field2)