test

Tables (6)

COUNTRY (country)

  • COUNTRY_ID (PK_CTRID) — CHAR(2 BYTE) — Primary key — NOT NULL
  • COUNTRY_NAME (SYS_C007382) — VARCHAR2(30 BYTE)

DEPARTMENT (departement)

  • DEPT_ID (PK_DEPTID) — CHAR(2 BYTE) — Primary key — NOT NULL
  • DEPT_NAME (Field) — VARCHAR2(30 BYTE)
  • LOCATION_ID (FK_LOCID) — CHAR(2 BYTE) — Foreign key → LOCATION.LOCATION_ID — NOT NULL

EMPLOYEE (employee)

  • EMP_ID (PK_EMPID) — CHAR(3 BYTE) — Primary key — NOT NULL
  • EMP_NAME (NN_ENAME) — VARCHAR2(20 BYTE)
  • EMP_NO (UNI_EMPNO) — CHAR(14 BYTE)
  • EMAIL (Field3) — VARCHAR2(25 BYTE)
  • PHONE (Field4) — VARCHAR2(12 BYTE)
  • HIRE_DATE (Field5) — HIRE_DATE
  • JOB_ID (FK_JOBID) — CHAR(2 BYTE) — Foreign key → JOB.JOB_ID — NOT NULL
  • SALARY (Field6) — NUMBER
  • BONUS_PCT (Field7) — NUMBER
  • MARRIAGE (CHK_MRIG) — CHAR(1 BYTE)
  • MGR_ID (FK_MGRID) — CHAR(3 BYTE) — Foreign key → EMPLOYEE.EMP_ID — NOT NULL
  • DEPT_ID (PK_DEPTID) — CHAR(2 BYTE) — Foreign key → DEPARTMENT.DEPT_ID — NOT NULL

JOB (job)

  • JOB_ID (PK_JOBID) — CHAR(2 BYTE) — Primary key — NOT NULL
  • JOB_TITLE (Field) — VARCHAR2(35 BYTE)
  • MIN_SAL (Field2) — NUMBER
  • MAX_SAL (Field3) — NUMBER

LOCATION (location)

  • LOCATION_ID (PK_LOCID) — CHAR(2 BYTE) — Primary key — NOT NULL
  • COUNTRY_ID (FK_CTRID) — CHAR(2 BYTE) — Foreign key → COUNTRY.COUNTRY_ID — NOT NULL
  • LOC_DESCRIBE (Field) — VARCHAR2(40 BYTE)

SAL_GRADE (sal_grade)

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