test - 2020-07-13 07:49:20
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 — 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 — NOT NULL
- SALARY (Field6) — NUMBER
- BONUS_PCT (Field7) — NUMBER
- MARRIAGE (CHK_MRIG) — CHAR(1 BYTE)
- MGR_ID (FK_MGRID) — CHAR(3 BYTE) — Foreign key — NOT NULL
- DEPT_ID (PK_DEPTID) — CHAR(2 BYTE) — Foreign key — 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 — 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