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