employees
Tables (4)
departments (Untitled4)
- 부서아이디 (department_id) — INT — Primary key — NOT NULL
- 부서이름 (department_name) — VARCHAR(30) — NOT NULL
- 매니저아이디 (manager_id) — INT
- Field
employees (Untitled)
- 사원번호 (employee_id) — INT — Primary key — NOT NULL
- 직업아이디 (job_id) — VARCHAR(10) — Foreign key → jobs.직업아이디 — NOT NULL
- 사수번호 (manager_id) — INT — Foreign key → employees.사원번호 — NOT NULL
- 부서아이디 (department_id) — INT — Foreign key → departments.부서아이디 — NOT NULL
- 이름 (first_name) — VARCHAR(20)
- 이름 (last_name) — VARCHAR(25) — NOT NULL
- 이메일 (email) — VARCHAR(25) — NOT NULL
- 번호 (phone_number) — VARCHAR(20)
- 급여 (salary) — DECIMAL(8,2)
- (commission_pct) — DECIMAL(2,2)
- 고용일 (hire_date) — DATE — NOT NULL
- Field
job_history (Untitled3)
- 시작일 (start_date) — DATE — Primary key — NOT NULL
- 사원번호 (employee_id) — INT — Foreign key → employees.사원번호 — NOT NULL
- 직업아이디 (job_id) — VARCHAR(10) — Foreign key → jobs.직업아이디 — NOT NULL
- 부서아이디 (department_id) — INT — Foreign key → departments.부서아이디 — NOT NULL
- 종료일 (end_date) — NOT NULL
jobs (Untitled2)
- 직업아이디 (job_id) — VARCHAR(10) — Primary key — NOT NULL
- 직업이름 (job_title) — VARCHAR(35) — NOT NULL
- 최소급여 (min_salary) — INT
- 최대급여 (max_salary) — INT