12test
Tables (8)
Countries
- country_id — VARCHAR(10) — Primary key — NOT NULL
- country_name — VARCHAR(50)
- region_id — INT — Foreign key → Regions.region_id
Departments
- department_id — INT — Primary key — NOT NULL
- department_name — VARCHAR(20)
- employee_id — INT — Foreign key → Employees.employee_id
- location_id — INT — Foreign key → Locations.location_id — NOT NULL
Employees
- employee_id — INT — Primary key — NOT NULL
- first_name — VARCHAR(30)
- last_name — VARCHAR(30)
- email — VARCHAR(30)
- phone_number — VARCHAR(20)
- hire_date — DATE
- job_id — VARCHAR(10) — Foreign key → Jobs.job_id
- salary — INT
- commission_pct — INT
- manager_id — INT — Foreign key → Employees.employee_id
- department_id — INT — Foreign key → Departments.department_id
Job_grades
- grade_level — CHAR(1) — NOT NULL
- lowest_sal — INT — NOT NULL
- highest_sal — INT — NOT NULL
Job_history
- start_date — DATE — Primary key — NOT NULL — 직원의 업무 시작일
- job_id2 — VARCHAR(10) — Foreign key → Jobs.job_id — NOT NULL
- employee_id2 — INT — Foreign key → Employees.employee_id
- end_date — DATE — 직원 과거 직무 종료일
- department_id2 — INT — Foreign key → Departments.department_id
Jobs
- job_id — VARCHAR(10) — Primary key — NOT NULL
- job_title — VARCHAR(50) — 직무명
- min_salary — INT — NOT NULL — 최소 급여
- max_salary — INT — 최대 급여
Locations
- location_id — INT — Primary key — NOT NULL
- street_address — VARCHAR(50)
- postal_code — VARCHAR(20)
- city — VARCHAR(20)
- state_province — VARCHAR(20)
- country_id — VARCHAR(10) — Foreign key → Countries.country_id
Regions
- region_id — INT — Primary key — NOT NULL
- region_name — VARCHAR(30)