new
Tables (7)
countries (나라)
- country_id — CHAR(2) — Primary key — NOT NULL
- country_name — VARCHAR(40)
- region_id — INT — Foreign key → regions.region_id — NOT NULL
departments (부서)
- department_id — INT — Primary key — NOT NULL
- department_name — VARCHAR(30) — NOT NULL
- manager_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(20)
- last_name — VARCHAR(25) — NOT NULL
- email — VARCHAR(25) — NOT NULL
- phone_number — VARCHAR(20)
- hire_date — DATE — NOT NULL
- job_id — VARCHAR(10) — Foreign key → jobs.job_id — NOT NULL
- salary — DECIMAL(8, 2) — NOT NULL
- commission_pct — DECIMAL(2, 2)
- manager_id (employee_id2) — INT — Foreign key → employees.employee_id — NOT NULL
- department_id — INT — Foreign key → departments.department_id — NOT NULL
job_history
- employee_id — INT — Foreign key → employees.employee_id — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- job_id — VARCHAR(10) — Foreign key → jobs.job_id — NOT NULL
- department_id — INT — Foreign key → departments.department_id — NOT NULL
jobs (직업)
- job_id — VARCHAR(10) — Primary key — NOT NULL
- job_title — VARCHAR(35) — NOT NULL
- min_salary — DECIMAL(8, 0)
- max_salary — DECIMAL(8, 0)
locations (장소)
- location_id — INT — Primary key — NOT NULL
- street_address — VARCHAR(40)
- postal_code — VARCHAR(12)
- city — VARCHAR(30) — NOT NULL
- state_province — VARCHAR(25)
- country_id — CHAR(2) — Foreign key → countries.country_id — NOT NULL
regions (지역)
- region_id — INT — Primary key — NOT NULL
- region_name — VARCHAR(25)