HR system

Tables (12)

annual_leave

  • leave_no — number
  • emp_no — number
  • creation_date — date
  • leave_type — varchar2(30)
  • leave_start — date
  • leave_end — date
  • isapproval — number
  • contents — varchar2(500)
  • emp_no (emp_no2) — number — Foreign key → emp.emp_no — NOT NULL

certification_list

  • certi_id — varchar2(20)
  • certi_category — varchar2(20)
  • certi_user — varchar2(20)
  • certi_file — varchar2(20)
  • emp_no — number — Foreign key → emp.emp_no — NOT NULL

dateofsal

  • date_sal — number
  • sal_num — number — Foreign key → salary.sal_num — NOT NULL

deduction

  • ded_num — number(3)
  • ded_name — varchar2(20) — NOT NULL
  • ded_price — number(10)
  • ded_time — number(1)
  • candidate — varchar2(999)
  • isdelete — number(1)
  • sal_num — number — Foreign key → salary.sal_num — NOT NULL

dept

  • dept_no — number — Primary key — NOT NULL
  • dept_code — varchar2(10) — NOT NULL
  • dept_name — varchar2(30) — NOT NULL
  • manage_emp_no — number
  • dept_upper_no — number
  • dept_emp_num — number
  • emp_no (emp_no2) — number — Foreign key → emp.emp_no — NOT NULL

emp

  • emp_no — number — Primary key — NOT NULL
  • emp_id — varchar2(20) — NOT NULL
  • emp_pwd — varchar2(50)
  • emp_name — varchar2(50)
  • emp_personal_email — varchar2(50)
  • emp_email — varchar2(50)
  • emp_phonenum — varchar2(30)
  • emp_birthday — DATE
  • emp_ZIP_CODE — VARCHAR2(10)
  • emp_FIRST_ADDR — VARCHAR2(200)
  • emp_SECOND_ADDR — VARCHAR2(200)
  • emp_start_date — DATE
  • emp_image — varchar2(200)
  • emp_end_date — DATE
  • emp_job — varchar2(50)
  • position_no — number
  • emp_dept_no — number
  • emp_role — number
  • iswork — number
  • left_leave — number

notice

  • notice_title — varchar2(20)
  • notice_id — varchar2(20)
  • notice_user — varchar2(20)
  • notice_content — varchar2(1000)
  • notice_file — varchar2(20)
  • notice_date — date

position

  • position_no — number
  • position_code — varchar2(2) — NOT NULL
  • position_name — varchar2(30) — NOT NULL
  • dept_no — number — Foreign key → dept.dept_no — NOT NULL

project

  • project_name — varchar2(20)
  • project_id — varchar2(20)
  • iscomplete — number(1)
  • participant — varchar2(999)
  • // — 주석이.
  • result — varchar2(20)
  • emp_no — number — Foreign key → emp.emp_no — NOT NULL

salary

  • sal_num — number — Primary key — NOT NULL
  • name — varchar2(20)
  • dept — varchar2(20)
  • salary — number(10)
  • bonus — number(10)
  • overtime — number(10)
  • isdelete — number(1)
  • emp_no — number — Foreign key → emp.emp_no — NOT NULL

welfare

  • wel_num — number(3)
  • wel_name — varchar2(20) — NOT NULL
  • wel_price — number(10)
  • include_salary — varchar(20)
  • provide_way — number(1)
  • provide_time — number(1)
  • candidate — varchar2(999)
  • isdelete — number(1)
  • sal_num — number — Foreign key → salary.sal_num — NOT NULL

working_sys

  • working_sys_no — number
  • emp_no — number
  • work_date — date
  • inwork — date
  • outwork — date
  • lateness — number
  • early_leave — number
  • work_over — number
  • emp_no (emp_no2) — number — Foreign key → emp.emp_no — NOT NULL