employer
Tables (5)
Employee (직원정보)
- emp_id (직원식별자) — VARCHAR2 — Primary key — NOT NULL
- emp_no (직원식별번호) — INT
- emp_nam (직원명) — VARCHAR2
- emp_birth (생년월일) — VARCHAR2
- emp_postal (우편번호) — VARCHAR2
- emp_addr (주소) — VARCHAR2
- emp_detail (상세주소) — VARCHAR2
- emp_phone (연락처) — VARCHAR2
- emp_dept (부서) — VARCHAR2
- emp_rule (직책) — VARCHAR2
- emp_hiredate (입사일) — DATE
- emp_position (권한등급) — INT
- emp_delstatus (삭제여부) — INT
Holidays (연휴정보)
- h_day (연휴일자) — DATE — Primary key — NOT NULL
- h_name (연휴명) — VARCHAR
- h_type (연휴유형) — VARCHAR2
LeaveManagement (연차관리)
- lm_no (연차식별번호) — INT — Primary key — NOT NULL
- emp_id (직원식별자) — VARCHAR2 — Foreign key → Employee.emp_id — NOT NULL
- lm_total (연차총일수) — INT
- lm_use (연차사용일수) — INT
Request (요청)
- r_no (요청식별번호) — INT — Primary key — NOT NULL
- emp_id (직원식별자) — VARCHAR2 — Foreign key → Employee.emp_id — NOT NULL
- r_day (신청일자) — DATE
- r_content (요청내용) — VARCHAR2
- r_detail (상세내용) — VARCHAR2
- r_status (처리상태) — VARCHAR2
Work (근무일지)
- w_no (근무식별번호) — INT — Primary key — NOT NULL
- emp_id (직원식별자) — VARCHAR2 — Foreign key → Employee.emp_id — NOT NULL
- w_status (근무상태) — VARCHAR
- w_day (근무일자) — DATE
- w_on (출근시간) — TIME
- w_off (퇴근시간) — TIME
- w_time (근무시간) — TIME