ex

테이블 (6)

AttendanceHistory (ATTENDANCE_HISTORY)

  • Key (id) — 기본 키 — NOT NULL
  • Field (ATTENDANCE_DATE) — DATE
  • Field (ATTENDANCE_START_TIME)
  • Field (ATTENDANCE_END_TIME)
  • Field (IS_HOLIDAY)
  • Field (IS_LATE)
  • Field (NIGHT_HOURS)
  • Field (OVERTIME_HOURS)
  • Field2 (TARGET_EMP_NUMBER)
  • Field (ORG_ID)
  • Field (ORG_NAME)

Untitled (OVERTIME_APPLY)

  • Key (ID) — 기본 키 — NOT NULL
  • Field (OVERTIME_START_TIME)
  • Field (OVERTIME_END_TIME)
  • Field (OVERTIME_TYPE)
  • Field (BREAK_HOURS)
  • Field (EMP_NUMBER)
  • Field (ORG_ID)

Untitled (EMPLOYEE)

  • Key (ID) — 기본 키 — NOT NULL
  • Field (EMP_NUMBER)
  • Field (EMPLOY_DATE)
  • Field (EMPLOY_STATUS)
  • Field (EMPLOYMENT_TYPE)
  • Field (GENDER)
  • Field (GROUP_ENTER_DATE)
  • Field

Untitled (PERSONAL_ATTENDANCE_TYPE)

  • Key (ID) — 기본 키 — NOT NULL
  • Field (TARGET_EMP_NUMBER)
  • Field (ATTENDANCE_TYPE_ID)
  • Field (START_DATE)
  • Field (END_DATE)

Untitled (ATTENDANCE_CODE)

  • Key (ID) — 기본 키 — NOT NULL
  • Field (ATTENDANCE_CODE)
  • Field (ATTENDANCE_NAME)
  • Field (DIVISION)
  • Field (UNITDIVISION)
  • Field (MANAGEMENT_UNIT)
  • Field (DEDUCTION)
  • Field (PAID_VACATION)
  • Field (RECOGNIZED_PAID_DAYS)
  • Field (WORK_DAY_INCLUDE)
  • Field (NORMAL_WORK)
  • Field (PAYMENT)
  • Field (HOLIDAY_INCLUDE)
  • Field (USE_STATUS)
  • Field (DISCRIPTION)

기간근태등록 (ATTENDACNE_APPLY)

  • Key (ID) — 기본 키 — NOT NULL
  • Field (ATTENDANCE_START_TIME)
  • Field2 (ATTENDANCE_END_TIME)
  • Field3 (ATTENDANCE_TYPE)
  • Field (REASON)
  • Field (TARGET_EMP_NUMBER)
  • Field (ORG_ID)
  • Field (ORG_NAME)
  • Field (STATUS)