insa ERD
Tables (4)
dept
- loc_id — number(2) — Primary key — NOT NULL
- dept_id — number(4)
- dept_name — varchar2(20)
- mgr_id — number(6)
- Field — VARCHAR(255)
- dept_id2 — NUMBER(4) — NOT NULL
emp
- emp_id — NUMBER(6) — Primary key — NOT NULL
- 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)
- loc_id — number(2) — NOT NULL
loc
- dept_id — NUMBER(4) — Primary key — NOT NULL
- 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)