test

Tables (6)

COUNTRY (Untitled5)

  • COUNTRY_ID (Key) — CHAR(2) — Primary key — NOT NULL
  • COUNTRY_NAME (Field2) — VARCHAR2(30)

DEPARTMENT (Untitled2)

  • DEPT_ID (Key) — CHAR(2) — Primary key — NOT NULL
  • DEPT_NAME (Field) — VARCHAR2(30)
  • LOC_ID (Field2) — CHAR(2)
  • LOCATION_ID (Key2) — CHAR(2) — Foreign key → LOCATION.LOCATION_ID — NOT NULL

EMPLOYEE (Untitled6)

  • EMP_ID (Key) — CHAR(3) — Primary key — NOT NULL
  • EMP_NAME (Field) — VARCHAR2(20)
  • EMP_NO (Field2) — CHAR(14)
  • EMAIL (Field3) — VARCHAR2(25)
  • PHONE (Field4) — VARCHAR2(15)
  • HIRE_DATE (Field5) — DATE
  • JOB_ID (Field6) — CHAR2(2)
  • SALARY (Field7) — NUMBER
  • BONUS_PCT (Field8) — NUMBER
  • MARRIAGE (Field9) — CHAR(1)
  • MRG_ID (Field10) — CHAR(3)
  • DEPT_ID (Field11) — CHAR(2)
  • JOB_ID (Key2) — CHAR2(2) — Foreign key → JOB.JOB_ID — NOT NULL
  • DEPT_ID (Key3) — CHAR(2) — Foreign key → DEPARTMENT.DEPT_ID — NOT NULL

JOB (Untitled3)

  • JOB_ID (Key) — CHAR2(2) — Primary key — NOT NULL
  • JOB_TITLE (Field) — VARCHAR2(35)
  • MIN_SAL (Field2) — NUMBER
  • MAX_SAL (Field3) — NUMBER

LOCATION (Untitled4)

  • LOCATION_ID (Key) — CHAR(2) — Primary key — NOT NULL
  • COUNTRY_ID (Field) — CHAR(2)
  • LOC_DESCRIBE (Field2) — VARCHAR2(40)
  • COUNTRY_ID (Key2) — CHAR(2) — Foreign key → COUNTRY.COUNTRY_ID — NOT NULL

SALARY (Untitled)

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