HR
Tables (8)
COUNTRIES (Untitled2)
- COUNTRY_ID (Key) — CHAR2 — Primary key — NOT NULL
- REGION_ID (REGION_NAME) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
- COUNTRY_NAME (Field) — VARCHAR2
DEPARTMENTS (Untitled3)
- DEPARTMENT_ID (Key) — NUMBER — Primary key — NOT NULL
- LOCATION_ID (Key2) — NUMBER — Foreign key → LOCATIONS.LOCATION_ID — NOT NULL
- DEPARTMENT_NAME (Field) — VARCHAR2
- MANAGER_ID (Field2) — NUMBER
EMPLOYEES (Untitled7)
- EMPLOYEE_ID (Key) — NUMBER — Primary key — NOT NULL
- DEPARTMENT_ID (Key2) — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
- FIRST_NAME (Field) — VARCHAR2
- LAST_NAME (Field2) — VARCHAR2
- EMAIL (Field3) — VARCHAR2
- PHONE_NUMBER (Field4) — VARCHAR2
- HIRE_DATE (Field5) — DATE
- JOB_ID (Field6) — VARCHAR2
- SALARY (Field7) — NUMBER
- COMMISSION_PCT (Field8) — NUMBER
- MANAGER_ID (Field9) — NUMBER
JOBS (Untitled5)
- JOB_ID (Key) — VARCHAR2 — Primary key — NOT NULL
- JOB_TITLE (Field) — VARCHAR2
- MIN_SALARY (Field2) — NUMBER
- MAX_SALARY (Field3) — NUMBER
JOB_HISTORY (Untitled4)
- EMPLOYEE_ID (Key) — NUMBER — Primary key — NOT NULL
- DEPARTMENT_ID (Key2) — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
- START_DATE (Field) — DATE
- END_DATE (Field2) — DATE
- JOB_ID (Field3) — VARCHAR2
LOCATIONS (Untitled6)
- LOCATION_ID (Key) — NUMBER — Primary key — NOT NULL
- COUNTRY_ID (Key2) — CHAR — Foreign key → COUNTRIES.COUNTRY_ID — NOT NULL
- STREET_ADDRESS (Field) — VARCHAR2
- POSTAL_CODE (Field2) — VARCHAR2
- CITY (Field3) — VARCHAR2
- STATE_PROVINCE (Field4) — VARCHAR2
REGIONFILES (Untitled8)
- Key (FILENUM) — NUMBER — Primary key — NOT NULL
- Key (REGION_ID) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
- Field (FILENAME) — VARCHAR2(300)
- Field (ORINAME) — VARCHAR2(300)
REGIONS (Untitled)
- REGION_ID (KEY) — NUMBER — Primary key — NOT NULL
- REGION_NAME (Field) — VARCHAR2