InsaERD
Tables (4)
dept
- 부서번호 (dept_id) — number(4) — Primary key — NOT NULL
- dept_name — varchar2(20)
- mgr_id — number(6)
emp
- emp_id — number(6)
- emp_name — varchar2(15)
- email — varchar2(15)
- gender — varchar2(1)
- birthdate — date
- phone — varchar2(15)
- hiredate — date
- position — varchar2(10)
- salary — number(4)
- comm — number(2,2)
- mgr_id — number(6)
- 부서번호 (dept_id) — number(4) — Foreign key → dept.부서번호 — NOT NULL
- 부서번호 (dept_id2) — number(4) — Foreign key → dept.부서번호 — NOT NULL
loc
- loc_id — number(2)
- address — varchar2(50)
- city — varchar2(20)
- zip_code — varchar2(8)
pay_grade
- pay_level — char(3)
- low_pay — number(4)
- high_pay — number(4)