ex
Tables (6)
admin
- id — varchar2(10)
- pass — varchar2(10)
- role — varchar2(15)
- 부서 — 관리자'))
department
- departmentCode — varchar2(5)
- departmentname — varchar2(15)
departmentAdminAccount
- DepartmentId — varchar2(10)
- DepartmentPassword — varchar2(10)
employee
- employeeCode — varchar2(10)
- employeeName — varchar2(10)
- position — varchar2(10)
- salary — number(10, 2)
- departmentCode — varchar2(10)
- hireYear — number(4)
- email — varchar2(20)
- employmentStatus — varchar2(15)
integratedAdminAccount
- IntegratedId — varchar2(10)
- IntegratedPassword — varchar2(10)
specInfo
- Key — Primary key — NOT NULL
- employeeCode — varchar2(10)
- phoneNum — varchar2(20)
- residenceAddress — varchar2(50)
- certifications — varchar2(100)
- education — VARCHAR2(10)
- career — VARCHAR2(20)