일근태

테이블 (8)

T_COMMUTE (출퇴근 시각 마스터)

  • ID (PK) — INT(10) — 기본 키 — NOT NULL
  • stamp (PK.) — INT(11) — 기본 키 — NOT NULL
  • back_id (Field2) — INT(11)
  • back_stamp (Field3) — INT(11)
  • division (Field4) — VARCHAR(2)
  • type (Field5) — ENUM('1','2')
  • platform (Field6) — VARCHAR(2)
  • remark (Field7) — VARCHAR(1000)
  • status (Field8) — VARCHAR(1)
  • ip (Field9) — INT(11)
  • location (Field10) — POINT
  • gps_range (Field11) — INT(11)
  • address (Field12) — VARCHAR(300)

htm_flexible_person_time_history (개인별 근무시간이력)

  • FLEXIBLE_WORK_PERSON_TIME_ID (PK) — 기본 키 — NOT NULL
  • FLEXIBLE_WORK_ORGANIZATION_ID (Field)
  • EMPLOYEE_ID (IDX1)
  • WORK_DAY (IDX1.)
  • TOTAL_TIME (Field4) — DECIMAL(10,1)
  • WORK_TIME (Field5) — DECIMAL(10,1)
  • OVER_TIME (Field6) — DECIMAL(10,1)
  • NIGHT_TIME (Field7) — DECIMAL(10,1)
  • HOLIDAY_TIME (Field8) — DECIMAL(10,1)

htm_flexible_work_organization (부서별유연근무제)

  • FLEXIBLE_WORK_ORGANIZATION_ID (PK) — 기본 키 — NOT NULL
  • COMPANY_ORIGINAL_ID (Field) — INT(11)
  • ORGANIZATION_ID (IDX1.) — INT(11)
  • FLEXIBLE_WORK_GUBUN (Field3) — INT(11)
  • FLEXIBLE_WORK_CODE (Field4) — INT(11)
  • WEEK_BASELINE (Field5) — INT(11)
  • WORK_START_DAY (IDX1) — DATE
  • WORK_END_DAY (Field7) — DATE
  • TOTAL_WORK_TIME (Field8) — INT(11)
  • MONTH_WORK_TIME (Field9) — INT(11)
  • WEEK_WORK_TIME (Field10) — INT(11)
  • OVERTIME_TIME (Field11) — INT(11)
  • ASSIGNMENT_TRANSFER_YN (Field12) — CHAR(1)
  • OVERTIME_YN (Field13) — CHAR(1)
  • WORK_NOT_YN (Field14) — CHAR(1)
  • MIN_WORK_TIME_YN (Field15) — CHAR(1)
  • MIN_WORK_TIME (Field16) — INT(11)
  • MAX_WORK_TIME_YN (Field17) — CHAR(1)
  • MAX_WORK_TIME (Field18) — INT(11)
  • COWORK_TIME_YN (Field19) — CHAR(1)
  • COWORK_START_TIME (Field20) — VARCHAR(10)
  • COWORK_END_TIME (Field21) — VARCHAR(10)
  • PERSONAL_TIME_YN (Field22) — CHAR(1)
  • WORK_START_TIME (Field23) — VARCHAR(10)
  • WORK_START_TIME_ALLOW (Field24) — INT(11)
  • WORK_END_TIME (Field25) — VARCHAR(10)
  • WORK_END_TIME_ALLOW (Field26) — INT(11)
  • PERSONAL_MEAL_YN (Field27) — CHAR(1)
  • LUNCH_START_TIME (Field28) — INT(11)
  • LUNCH_END_TIME (Field29) — INT(11)
  • DINNER_START_TIME (Field30) — INT(11)
  • DINNER_END_TIME (Field31) — INT(11)
  • GPS_REQUIRED_YN (Field32) — VARCHAR(1)
  • MODIFY_TODAY_YN (Field33) — VARCHAR(1)
  • NOTE (Field34)
  • ATTRIBUTE_CATEGORY (Field35)
  • ATTRIBUTE01 (Field36)
  • ATTRIBUTE02 (Field37)
  • ATTRIBUTE03 (Field38)
  • ATTRIBUTE04 (Field39)
  • ATTRIBUTE05 (Field40)
  • ATTRIBUTE06 (Field41)
  • ATTRIBUTE07 (Field42)
  • ATTRIBUTE08 (Field43)
  • ATTRIBUTE09 (Field44)
  • ATTRIBUTE10 (Field45)
  • CREATION_DATE (Field46)
  • CREATED_BY (Field47)
  • LAST_UPDATE_DATE (Field48)
  • LAST_UPDATED_BY (Field49)
  • LAST_UPDATE_LOGIN (Field50)
  • MOBILE_USE_FLAG (Field51) — CHAR(1)
  • EXTENDED_WORK_DRAFT_USE_FLAG (Field52) — CHAR(1)
  • EXTENDED_WORK_START_TIME_USE_FLAG (Field53) — CHAR(1)
  • EXTENDED_WORK_START_TIME (Field54) — VARCHAR(10)
  • NIGHT_TAXI_USE_YN (Field55) — VARCHAR(1)
  • allow_chat_bot (Field56) — VARCHAR(1)

htm_flexible_work_person (개인별유연근무제)

  • FLEXIBLE_WORK_EMPLOYEE_ID (PK) — INT(11) — 기본 키 — NOT NULL
  • COMPANY_ORIGINAL_ID (Field) — INT(11)
  • EMPLOYEE_ID (Field2) — INT(11)
  • FLEXIBLE_WORK_CODE (Field3) — INT(11)
  • WEEK_BASELINE (Field4) — INT(11)
  • WORK_START_DAY (Field5) — DATE
  • WORK_END_DAY (Field6) — DATE
  • COWORK_START_TIME (Field7) — VARCHAR(10)
  • COWORK_END_TIME (Field8) — VARCHAR(10)
  • WORK_START_TIME (Field9) — VARCHAR(10)
  • WORK_START_TIME_ALLOW (Field10) — INT(11)
  • WORK_END_TIME (Field11) — VARCHAR(10)
  • WORK_END_TIME_ALLOW (Field12) — INT(11)
  • LUNCH_START_TIME (Field13) — INT(11)
  • LUNCH_END_TIME (Field14) — INT(11)
  • DINNER_START_TIME (Field15) — INT(11)
  • DINNER_END_TIME (Field16) — INT(11)
  • WRITE_EMPLOYEE_ID (Field17) — INT(11)
  • APPLICATION_YMD (Field18) — DATE
  • DRAFT_ID (Field19) — INT(11)
  • REASON (Field20) — VARCHAR(1000)
  • REQUEST_STATUS_CODE (Field21) — INT(11)
  • CANCEL_DRAFT_ID (Field22) — INT(11)
  • CANCEL_REQ_YMD (Field23) — DATE
  • CANCEL_NOTE (Field24) — VARCHAR(200)
  • CANCEL_EMPLOYEE_ID (Field25) — INT(11)
  • ATTACH_GROUP_ID (Field26) — INT(11)
  • NOTE (Field27)
  • ATTRIBUTE_CATEGORY (Field28)
  • ATTRIBUTE01. (Field29)
  • ATTRIBUTE02 (Field30)
  • ATTRIBUTE03 (Field31)
  • ATTRIBUTE04 (Field32)
  • ATTRIBUTE05 (Field33)
  • ATTRIBUTE06 (Field34)
  • ATTRIBUTE07 (Field35)
  • ATTRIBUTE08 (Field36)
  • ATTRIBUTE09 (Field37)
  • ATTRIBUTE10 (Field38)

t_commute_ip_white_list (출퇴근 IP 허용 정보)

  • COMPANY_ID (Field)
  • IP (Field2)

t_commute_master (Untitled)

  • ID (PK) — INT(10) — 기본 키 — NOT NULL
  • PID (Field) — INT(10)
  • draft_id (Field2) — INT(11)
  • draft_type (Field3) — VARCHAR(1)
  • ymd (Field4) — DATE
  • employee_id (Field5) — INT(11)
  • status (Field6) — VARCHAR(1)

t_commute_reports (Untitled2)

  • report_id (PK) — INT(11) — 기본 키 — NOT NULL
  • user_id (Field) — INT(11)
  • created_at (Field2) — DATETIME
  • current_lat (Field3) — DOUBLE(9,7)
  • current_lon (Field4) — DOUBLE(9,7)
  • target_lat (Field5) — DOUBLE(9,7)
  • target_lon (Field6) — DOUBLE(9,7)
  • radius (Field7) — VARCHAR(20)
  • distance (Field8) — VARCHAR(20)

t_commute_standard (출퇴근 유형 (법정휴게 기준시간, 휴게시간, 절상/절사 단위).)

  • type (PK) — CHAR(1) — 기본 키 — NOT NULL
  • stamp (Field2) — INT(11)
  • remark (Field3) — VARCHAR(100)