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)