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