Insa ERD
Tables (4)
dept
- 부서번호 (dept_id) — NUMBER(4) — Primary key — NOT NULL
- dept_name — varchar2(20)
- mgr_id — number(6)
- 위치번호 (loc_id) — number(2) — Foreign key → loc.위치번호 — NOT NULL
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)
- 부서번호 (dept_id) — NUMBER(4) — Foreign key → dept.부서번호 — NOT NULL
loc
- 위치번호 (loc_id) — number(2) — Primary key — NOT NULL
- 주소 (address) — varchar2(50)
- city — varchar2(20)
- zip_code — varchar2(8)
pay_grade
- pay_level — char(3)
- low_pay — number(4)
- high_pay — number(4)