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