일근태
테이블 (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)