test

Tables (6)

COUNTRY

  • COUNTRY_ID — Primary key
  • COUNTRY_NAME — NOT NULL

DEPARTMENT

  • DEPT_ID — Primary key
  • DEPT_NAME
  • LOC_ID — NOT NULL, FK
  • LOCATION_ID — Foreign key → LOCATION.LOCATION_ID

EMPLOYEE

  • Field (EMP_ID) — Primary key
  • EMP_NO — NOT NULL
  • EMAIL
  • PHONE
  • HIRE_DATE
  • JOB_ID — FK
  • SALARY
  • BONUS_PCT
  • MARRIAGE — CHECK
  • MGR_ID — FK
  • DEPT_ID — FK
  • DEPT_ID (DEPT_ID2) — Foreign key → DEPARTMENT.DEPT_ID
  • JOB_ID (JOB_ID2) — Foreign key → JOB.JOB_ID
  • Field (Field2) — Foreign key → EMPLOYEE.Field

JOB

  • JOB_ID — Primary key
  • JOB_TITLE
  • MIN_SAL
  • MAX_SAL

LOCATION

  • LOCATION_ID — Primary key
  • COUNTRY_ID — FK
  • LOC_DESCRIBE
  • COUNTRY_ID (COUNTRY_ID2) — Foreign key → COUNTRY.COUNTRY_ID

SAL_GRADE

  • SLEVEL — Primary key
  • LOWEST
  • HIGHEST