hr
Tables (7)
COUNTRIES (Untitled)
- COUNTRY_ID (Key) — VARCHAR(2) — Primary key — NOT NULL
- COUNTRY_NAME (Field) — VARCHAR2(40)
- REGION_ID — NUMBER(22) — Foreign key → REGIONS.REGION_ID — NOT NULL
DEPARTMENTS (-)
- DEPARTMENT_ID (Key) — NUMBER(22) — Primary key — NOT NULL
- DEPARTMENT_NAME (Field) — VARCHAR2(40)
- LOCATION_ID (Field3) — NUMBER(22)
- MANAGER_ID (LOCATION_ID) — NUMBER(22) — Foreign key → LOCATIONS.LOCATION_ID — NOT NULL
- LOCATION_ID (EMPLOYEE_ID) — NUMBER(22) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
EMPLOYEES (Untitled4)
- EMPLOYEE_ID (Key) — NUMBER(6,0) — Primary key — NOT NULL
- FIRST_NAME (Field) — VARCHAR2(20 BYTE)
- LAST_NAME (Field2) — VARCHAR2(30)
- EMAIL (Field3) — VARCHAR2(30)
- PHONE_NUMBER (Field4) — VARCHAR2(20 BYTE)
- HIRE_DATE (Field5) — VARCHAR2(30)
- JOB_ID — VARCHAR2(10 BYTE) — Foreign key → JOBS.JOB_ID — NOT NULL
- SALARY (Field7) — VARCHAR2(30)
- COMMISSION_PCT (Field8) — NUMBER(2,2)
- MANAGER_ID (EMPLOYEE_ID) — NUMBER(6,0) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
- DEPARTMENT_ID — NUMBER(4,0) — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
JOBS (Untitled3)
- JOB_ID (Key) — VARCHAR(2) — Primary key — NOT NULL
- JOB_TITLE (Field) — VARCHAR2(30)
- MIN_SALARY (Field2) — NUMBER(6,0)
- MAX_SALARY (Field3) — NUMBER(6,0)
- Field4
JOB_HISTORY (Untitled6)
- START_DATE (Key2) — DATE — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(6) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
- END_DATE (Field) — DATE
- JOB_ID — VARCHAR2(10) — Foreign key → JOBS.JOB_ID — NOT NULL
- DEPARTMENT_ID — NUMBER(4) — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
LOCATIONS (Untitled2)
- LOCATION_ID (Key) — VARCHAR(2) — Primary key — NOT NULL
- STREET_ADDRESS (Field) — VARCHAR2(40)
- POSTAL_CODE (Field2) — VARCHAR2(12)
- CITY (Field3) — VARCHAR2(30)
- STATE_PROVINCE (Field4) — VARCHAR2(25)
- COUNTRY_ID — CHAR(2)(22) — Foreign key → COUNTRIES.COUNTRY_ID — NOT NULL
REGIONS (Untitled5)
- REGION_ID (Key) — VARCHAR(2) — Primary key — NOT NULL
- REGION_NAME (Field) — VARCHAR2(25)