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)