ㅁ
Tables (7)
countries
- country_id — CHAR(2) — Primary key — NOT NULL
- region_id (region_id2) — NUMBER — Foreign key → regions.region_id — NOT NULL
- country_name — VARCHAR2(40)
- region_id — NUMBER
departments
- department_id — NUMBER — Primary key — NOT NULL
- department_name — VARCHAR2(30) — NOT NULL
- manager_id — NUMBER
- location_id — NUMBER
employees
- employee_id — NUMBER — Primary key — NOT NULL
- first_name — VARCHAR2(20)
- last_name — VARCHAR2(25) — NOT NULL
- email — VARCHAR2(100) — NOT NULL
- phone_number — VARCHAR2(20)
- hire_date — DATE — NOT NULL
- job_id — VARCHAR2(10) — NOT NULL
- salary — NUMBER
- commission_pct — NUMBER
- manager_id — NUMBER
- department_id — NUMBER
job_history
- employee_id — NUMBER — Primary key — NOT NULL
- start_date — DATE — Primary key — NOT NULL
- end_date — DATE — NOT NULL
- job_id — VARCHAR2(10) — NOT NULL
- department_id — NUMBER — NOT NULL
jobs
- job_id — VARCHAR2(10) — Primary key — NOT NULL
- job_title — VARCHAR2(35) — NOT NULL
- min_salary — NUMBER
- max_salary — NUMBER
locations
- location_id — NUMBER — Primary key — NOT NULL
- country_id (country_id2) — CHAR(2) — Foreign key → countries.country_id — NOT NULL
- region_id (region_id2) — NUMBER — Foreign key → countries.region_id — NOT NULL
- street_address — VARCHAR2(40)
- postal_code — VARCHAR2(12)
- city — VARCHAR2(30) — NOT NULL
- state_province — VARCHAR2(25)
- country_id — CHAR(2)
regions
- region_id — NUMBER — Primary key — NOT NULL
- region_name — VARCHAR2(25)