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) — Primary key — NOT NULL
- 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)
loc
- loc_id — number(2)
- address — varchar2(50)
- city — varchar2(20)
- zip_code — varchar2(8))
- dept_name — varchar2(20)
- mgr_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))
- low_pay — number(4)
- high_pay — number(4)
pay_grade
- pay_level — char(3)
- low_pay — number(4)
- high_pay — number(4)