일근태
테이블 (14)
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_daily_base (근태기준관리)
- DAILY_BASE_ID (PK) — INT(11) — 기본 키 — NOT NULL
- COMPANY_ORIGINAL_ID (Field) — INT(11)
- WORK_CODE (Field2) — INT(11)
- TYPE_CODE (Field3) — INT(11)
- START_YMD (Field4) — DATETIME
- END_YMD (Field5) — DATETIME
- LIMIT_TYPE (Field6) — INT(11)
- LIMIT_DAYS (Field7) — INT(11)
- LIMIT_DAYS_AFTER (Field8) — INT(11)
- HOLIDAY_APPLY_TYPE (Field9) — INT(11)
- YEAR_LIMIT_NUM (Field10) — DECIMAL
- PAY_YN (Field11) — CHAR(1)
- UNPAID_DAYS (Field12) — INT(11)
- OVERLAP_YN (Field13) — CHAR(1)
- ATTEND_YN (Field14) — CHAR(1)
- REQUEST_TYPE_ID (Field15) — INT(11)
- REQUEST_UNIT_ID (Field16) — INT(11)
- NOTE (Field17) — VARCHAR(200)
- YY_MINUS_YN (Field18) — CHAR(1)
- CHILDBIRTH_YN (Field19) — CHAR(1)
- HOLDAY_PLAN_YN (Field20) — CHAR(1)
- WORK_TIME_DISPLAY_YN (Field21) — CHAR(1)
- WORK_PERIOD_YN (Field22) — CHAR(1)
- HALF_USE_YN (Field23) — CHAR(1)
- WORK_TIME_NUM (Field24) — DECIMAL(7,3)
- MASKING (Field25) — VARCHAR(100)
- DISPLAY_YN (Field26) — CHAR(1)
- REQUEST_UNIT_TIME (Field27) — INT(4)
- MONTH_LIMIT_NUM (Field28) — DECIMAL(7,3)
- DAY_LIMIT_NUM (Field29) — DECIMAL(7,3)
- YEAR_NUM (Field30) — DECIMAL(7,3)
- YEAR_NUM_SATURDAY (Field31) — DECIMAL(7,3)
- ATTACH_FILE_YN (Field32) — CHAR(1)
- SUBSTITUDE_YN (Field33) — CHAR(1)
- ATTRIBUTE_CATEGORY (Field34)
- ATTRIBUTE01 ~ATTRIBUTE10 (Field35)
- CREATION_DATE (Field36)
- CREATED_BY (Field37)
- LAST_UPDATE_DATE (Field38)
- LAST_UPDATED_BY (Field39)
- LAST_UPDATE_LOGIN (Field40)
- default_start_time (Field41) — VARCHAR(5) — ..
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_time_emp (개인별 근무형태)
- FLEXIBLE_TIME_EMP_ID (PK) — INT(11) — 기본 키 — NOT NULL
- COMPANY_ORIGINAL_ID (Field) — INT(11)
- EMPLOYEE_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_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)
- Field2
- Field6
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)
htm_work_base (근무유형관리)
- WORK_BASE_ID (PK) — INT(11) — 기본 키 — NOT NULL
- COMPANY_ORIGINAL_ID (Field) — INT(11)
- Field2
- Field3 — VARCHAR(1)
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9
- Field10
- Field11
- Field12
- Field13
- Field14
- Field15
- Field16
- Field17
- Field18
- Field19
- Field20
- Field21
- Field22
- Field23
- Field24 — DATETIME
htm_work_day_detail (24시간 상세설정)
- WORK_DAY_DETAIL_ID (PK) — INT(11) — 기본 키 — NOT NULL
- WORK_TIME_TABLE_ID (PK2) — INT(11) — 외래 키 → htm_work_time_table.WORK_TIME_TABLE_ID — NOT NULL
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
- Field — DECIMAL(10,1)
htm_work_time_pattern (근무패턴)
- WORK_TIME_PATTERN_ID (PK) — INT(11) — 기본 키 — NOT NULL
- WORK_BASE_ID (PK2) — INT(11) — 외래 키 → htm_work_base.WORK_BASE_ID — NOT NULL
- Field — VARCHAR(100)
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9 — INT(11).
htm_work_time_table (근무시간표)
- WORK_TIME_TABLE_ID (PK) — INT(11) — 기본 키 — NOT NULL
- Field — VARCHAR(100)
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7 — VARCHAR(1)
- Field8 — VARCHAR(1)
- Field9 — VARCHAR(1)
- Field10 — VARCHAR(1)
- Field11
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 (출퇴근위치 히스토리)
- 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)