employee

Tables (6)

COUNTRY (Untitled5)

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

DEPARTMENT (Untitled4)

  • DEPT_ID (Key) — Primary key — NOT NULL
  • DEPT_NAME (Field)
  • LOC_ID (FK) — NOT NULL

EMPLOYEE (Untitled2)

  • EMP_ID (Key) — Primary key — NOT NULL
  • EMP_NAME (Field)
  • EMP_NO (Field2)
  • EMAIL (Field3)
  • HIRE_DATE (Field4)
  • JOB_ID (Field5)
  • Field6
  • Field7
  • Field8
  • Field9
  • Field10

JOB (Untitled3)

  • JOB_ID (Key) — Primary key — NOT NULL
  • EMP_ID (Key2) — Foreign key → EMPLOYEE.EMP_ID — NOT NULL
  • JOB_TITLE (Field)
  • MIN_SAL (Field2)
  • MAX_SAL (Field3)

LOCATION (Untitled6)

  • COUNTRY_ID (FK) — Primary key — NOT NULL
  • LOC_DESCRIBE (Field)

SAL_GRADE (Untitled)

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