HR
Tables (44)
tb_announcement
- announcement_id — varchar(36) — Primary key — NOT NULL
- priority — int — NOT NULL
- status — int
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- title — varchar(200)
- content — text
tb_approval_request
- approval_request_id — varchar(36) — Primary key — NOT NULL
- current_step — smallint — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- request_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- request_type — enum('ATTENDANCE_EDIT', 'CANCELLATION', 'FLEXIBLE_WORK_REQUEST', 'HOLIDAY_WORK', 'LEAVE', 'OVERTIME', 'WORK_REQUEST') — NOT NULL
- status — enum('APPROVED', 'CANCELLED', 'PENDING', 'PROCESSING', 'REJECTED') — NOT NULL
tb_approval_request_step
- approval_request_step_id — varchar(36) — Primary key — NOT NULL
- step_order — smallint — NOT NULL
- approved_at — datetime(6)
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- approver_id — varchar(36) — NOT NULL
- delegate_approver_id — varchar(36)
- request_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- reason — varchar(250)
- status — enum('APPROVED', 'CANCELLED', 'PENDING', 'PROCESSING', 'REJECTED') — NOT NULL
tb_attachments
- request_attachment_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- file_size — bigint — NOT NULL
- last_modified_at — timestamp — NOT NULL
- entity_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- file_type — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- file_path — varchar(200) — NOT NULL
- file_name — varchar(255) — NOT NULL
- attachment_type — enum('ANNOUNCEMENT', 'FAQ', 'REQUEST', 'SUPPORT_CASE', 'SUPPORT_MESSAGE') — NOT NULL
- request_type — enum('ATTENDANCE_EDIT', 'CANCELLATION', 'FLEXIBLE_WORK_REQUEST', 'HOLIDAY_WORK', 'LEAVE', 'OVERTIME', 'WORK_REQUEST')
tb_attendance
- attendance_id — varchar(36) — Primary key — NOT NULL
- actual_working_hours — decimal(4, 2)
- check_in_lat — decimal(8, 5)
- check_in_lng — decimal(8, 5)
- check_out_lat — decimal(8, 5)
- check_out_lng — decimal(8, 5)
- date — date — NOT NULL
- check_in_time — datetime(6) — NOT NULL
- check_out_time — datetime(6)
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- employee_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- work_arrangement — varchar(120)
- workplace_check_out — varchar(250)
- workplace_name — varchar(250)
- attendance_place — enum('BRANCH', 'COMPANY', 'FLEXIBLE_WORK', 'HOME', 'OUTSIDE', 'UNMAPPED')
- check_in_status — enum('LATE', 'VALID')
- check_out_status — enum('EARLY', 'VALID')
tb_attendance_activity_log
- attendance_activity_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- activity_date — date — NOT NULL
- activity_name — varchar(120)
- activity_type — enum('BUSINESS_TRIP', 'OUTSIDE', 'REMOTE', 'SECONDMENT') — NOT NULL
- actual_end_time — datetime(6)
- actual_start_time — datetime(6)
- attendance_id — varchar(36)
- attendance_place_snapshot — enum('BRANCH', 'COMPANY', 'FLEXIBLE_WORK', 'HOME', 'OUTSIDE', 'UNMAPPED')
- check_in_status_snapshot — enum('LATE', 'VALID')
- context_snapshot — varchar(1000)
- employee_id — varchar(36) — NOT NULL
- end_lat — decimal(10, 7)
- end_lng — decimal(10, 7)
- from_status_code — varchar(50) — NOT NULL
- from_status_name — varchar(100)
- location_name — varchar(250)
- memo — varchar(500)
- planned_end_time — datetime(6)
- planned_start_time — datetime(6)
- review_status — enum('APPROVED', 'CANCELLED', 'PENDING_REVIEW', 'RECORDED', 'REJECTED') — NOT NULL
- reviewed_at — datetime(6)
- reviewed_by — varchar(50)
- source — enum('HOME_MATCH', 'SYSTEM', 'USER') — NOT NULL
- start_lat — decimal(10, 7)
- start_lng — decimal(10, 7)
- teams_message_id — varchar(120)
- teams_sync_message — varchar(500)
- teams_sync_status — enum('FAILED', 'NONE', 'PENDING', 'SKIPPED', 'SUCCESS') — NOT NULL
- to_status_code — varchar(50) — NOT NULL
- to_status_name — varchar(100)
- transitioned_at — datetime(6) — NOT NULL
tb_attendance_edit_request
- attendance_edit_request_id — varchar(36) — Primary key — NOT NULL
- actual_working_hours — decimal(4, 2)
- attendance_date — date — NOT NULL
- change_check_in_time — time(6) — NOT NULL
- change_check_out_time — time(6) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- code — varchar(15) — NOT NULL
- employee_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- work_arrangement — varchar(120)
- reason — varchar(250) — NOT NULL
- workplace_name — varchar(250)
- attendance_place — enum('BRANCH', 'COMPANY', 'FLEXIBLE_WORK', 'HOME', 'OUTSIDE', 'UNMAPPED')
- check_in_status — enum('LATE', 'VALID')
- check_out_status — enum('EARLY', 'VALID')
- status — enum('APPROVED', 'CANCELLED', 'PENDING', 'PROCESSING', 'REJECTED') — NOT NULL
tb_business_trip_companions
- business_trip_companion_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- employee_id — varchar(36) — NOT NULL
- work_request_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- note — varchar(250)
tb_cancellation_requests
- cancellation_request_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- code — varchar(30) — NOT NULL
- employee_id — varchar(36) — NOT NULL
- request_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- reason — varchar(250)
- request_type — enum('ANNUAL', 'ATTENDANCE_EDIT', 'ATTENDANCE_RECORD', 'BUSINESS_TRIP', 'CANCELLATION', 'COMPENSATORY', 'FAMILY_CARE', 'FAMILY_EVENT', 'FLEXIBLE_WORK_REQUEST', 'HALF_DAY', 'HOLIDAY_WORK', 'HOURS', 'MATERNITY', 'MENSTRUAL', 'OFFICIAL', 'OTHER', 'OUTSIDE', 'OVERTIME', 'PARENTAL', 'SECONDMENT', 'SICK', 'SUBSTITUTE')
- status — enum('APPROVED', 'CANCELLED', 'PENDING', 'PROCESSING', 'REJECTED') — NOT NULL
tb_cm_alarm
- cm_alarm_id — varchar(36) — Primary key — NOT NULL
- is_read — tinyint(1) — NOT NULL
- priority — int — NOT NULL
- target_date — date
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- code — varchar(15)
- alert_recipient_id — varchar(36) — NOT NULL
- request_id — varchar(36)
- system_alarm_uid — varchar(36)
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- title — varchar(200)
- content — text
- action — enum('RECEIVE', 'SEND')
- alarm_type — enum('ADMIN', 'REMIND_CHECKIN', 'REMIND_CHECKIN_LATE', 'REMIND_CHECKOUT', 'REMIND_CHECKOUT_EARLY', 'SYSTEM') — NOT NULL
- cancel_type — enum('ANNUAL', 'ATTENDANCE_EDIT', 'ATTENDANCE_RECORD', 'BUSINESS_TRIP', 'CANCELLATION', 'COMPENSATORY', 'FAMILY_CARE', 'FAMILY_EVENT', 'FLEXIBLE_WORK_REQUEST', 'HALF_DAY', 'HOLIDAY_WORK', 'HOURS', 'MATERNITY', 'MENSTRUAL', 'OFFICIAL', 'OTHER', 'OUTSIDE', 'OVERTIME', 'PARENTAL', 'SECONDMENT', 'SICK', 'SUBSTITUTE')
- request_status — enum('APPROVED', 'PENDING', 'PENDING_REMINDER', 'PROCESSING', 'REJECTED')
- request_type — enum('ANNUAL', 'ATTENDANCE_EDIT', 'ATTENDANCE_RECORD', 'BUSINESS_TRIP', 'CANCELLATION', 'COMPENSATORY', 'FAMILY_CARE', 'FAMILY_EVENT', 'FLEXIBLE_WORK_REQUEST', 'HALF_DAY', 'HOLIDAY_WORK', 'HOURS', 'MATERNITY', 'MENSTRUAL', 'OFFICIAL', 'OTHER', 'OUTSIDE', 'OVERTIME', 'PARENTAL', 'SECONDMENT', 'SICK', 'SUBSTITUTE')
tb_employee_menstrual_leave
- employee_menstrual_leave_id — varchar(36) — Primary key — NOT NULL
- menstrual_leave_days — int — NOT NULL
- used_days — int — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- employee_id — varchar(36) — NOT NULL
tb_employees
- employee_id — varchar(36) — Primary key — NOT NULL
- birth_date — date
- is_skip_attendance_check — tinyint(1)
- join_date — date
- resign_date — date
- status — smallint
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- phone — varchar(15)
- parent_employee_id — varchar(36)
- permission_id — varchar(36)
- position_id — varchar(36)
- workplace_id — varchar(36)
- org_code — varchar(40) — NOT NULL
- created_by — varchar(50) — NOT NULL
- employee_type — varchar(50)
- identity_id — varchar(50)
- last_modified_by — varchar(50) — NOT NULL
- role — varchar(50) — NOT NULL
- username — varchar(50) — NOT NULL
- email — varchar(100) — NOT NULL
- employee_code — varchar(100) — NOT NULL
- full_name — varchar(100)
- password — varchar(100) — NOT NULL
- profile_image — varchar(200)
- address — varchar(255)
- gender — enum('FEMALE', 'MALE')
- full_eng_name — varchar(100)
- address_latitude — decimal(10, 7)
- address_longitude — decimal(10, 7)
tb_event_inbox
- event_id — varchar(36) — NOT NULL — 이벤트 ID' primary ke
- created_date_time — datetime(6) — NOT NULL — 이벤트 수신 시각
- error_code — varchar(50) — 비즈니스/시스템 오류 코드
- error_detail — text — 상세 오류 정보 (stacktrace / context)
- error_message — varchar(255) — 요약 오류 메시지
- event_type — enum('ATTENDANCE_DELETE', 'ATTENDANCE_INSERT', 'CHECK_IN', 'CHECK_OUT', 'HOLIDAY_DELETE', 'HOLIDAY_INSERT', 'HOLIDAY_UPDATE') — NOT NULL — 이벤트 종류
- event_version — int — NOT NULL — payload 스키마 버전 (파싱 분기용)
- hr_workplace_id — varchar(50) — HR 기준 근무지 ID
- payload — longtext — NOT NULL — 수신 이벤트 데이터(JSON)
- process_status — enum('FAILED', 'RECEIVED', 'SKIPPED', 'SUCCESS') — NOT NULL — RECEIVED / SUCCESS / FAILED / SKIPPED
- processed_date_time — datetime(6) — 처리 완료 시각
- so_floor_id — int — SO 기준 층 ID
- user_id — varchar(50) — 사용자 ID
- event_date_time — datetime(6) — NOT NULL — 이벤트 발생 시각
tb_event_outbox
- event_id — varchar(36) — NOT NULL — 이벤트 ID' primary ke
- created_date_time — datetime(6) — NOT NULL — 이벤트 생성 시각
- error_code — varchar(50) — 에러 코드 (HTTP 상태 등)
- error_message — varchar(255) — 간단한 에러 메시지
- event_type — enum('ATTENDANCE_DELETE', 'ATTENDANCE_INSERT', 'CHECK_IN', 'CHECK_OUT', 'HOLIDAY_DELETE', 'HOLIDAY_INSERT', 'HOLIDAY_UPDATE') — NOT NULL — 이벤트 종류
- event_version — int — NOT NULL — 이벤트 payload 스키마 버전
- hr_workplace_id — varchar(50) — 근무지 ID
- last_attempt_date_time — datetime(6) — 마지막 전송 시도 시각
- last_modified_date_time — datetime(6) — NOT NULL — 마지막 상태 변경 시각
- next_attempt_date_time — datetime(6) — 다음 전송 시도 가능 시각
- payload — longtext — NOT NULL — 이벤트 상세 데이터(JSON)
- retry_count — int — NOT NULL — 재시도 횟수
- so_floor_id — int — 층 ID
- status — enum('FAIL', 'PENDING', 'SKIPPED', 'SUCCESS') — NOT NULL — 전송 상태 (PENDING / SUCCESS / FAILED / SKIPPED)
- user_id — varchar(50) — 사용자 ID (빠른 조회용)
tb_faq
- faq_id — varchar(36) — Primary key — NOT NULL
- use_yn — smallint
- lang_code — varchar(10)
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- answer — text
- question — text
- created_at — datetime
tb_flexible_work_requests
- flexible_work_request_id — varchar(36) — Primary key — NOT NULL
- end_date — date — NOT NULL
- end_time — time(6)
- latitude — decimal(8, 5)
- longitude — decimal(8, 5)
- start_date — date — NOT NULL
- start_time — time(6)
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- code — varchar(30) — NOT NULL
- employee_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- type — varchar(120) — NOT NULL
- location — varchar(250)
- reason — varchar(250)
- period_type — enum('FULL_DAY', 'HOURLY') — NOT NULL
- status — enum('APPROVED', 'CANCELLED', 'PENDING', 'PROCESSING', 'REJECTED') — NOT NULL
tb_general_setting
- general_setting_id — varchar(36) — Primary key — NOT NULL
- radius_meters — int
- send_mail — tinyint(1) — NOT NULL
- send_teams — tinyint(1) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- address — varchar(255)
- company_name — varchar(255)
- phone_number — varchar(255)
- profile_image — varchar(255)
- type — enum('SYSTEM') — NOT NULL
- calendar_week_start — varchar(10)
tb_holiday_work_requests
- holiday_work_request_id — varchar(36) — Primary key — NOT NULL
- allocated_days — tinyint
- allocated_hours — decimal(5, 2)
- days — tinyint
- end_date — date — NOT NULL
- end_time — time(6) — NOT NULL
- expire_date — date — NOT NULL
- hours — decimal(5, 2)
- start_date — date — NOT NULL
- start_time — time(6) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- code — varchar(20)
- employee_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- holiday_name — varchar(100) — NOT NULL
- reason — varchar(250)
- holiday_type — enum('HOLIDAY', 'WEEKEND') — NOT NULL
- status — enum('APPROVED', 'CANCELLED', 'PENDING', 'PROCESSING', 'REJECTED') — NOT NULL
tb_job_executions
- job_execution_id — varchar(36) — Primary key — NOT NULL
- execution_date — date — NOT NULL
- status — tinyint(1) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- job_code — varchar(50) — NOT NULL
- message — varchar(500)
tb_leave_balance
- leave_balance_id — varchar(36) — Primary key — NOT NULL
- allocated_days — decimal(5, 2) — NOT NULL
- used_days — decimal(5, 2) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- valid_from — datetime(6) — NOT NULL
- valid_to — datetime(6) — NOT NULL
- employee_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- accrual_type — enum('MONTHLY', 'YEARLY') — NOT NULL
tb_leave_requests
- leave_request_id — varchar(36) — Primary key — NOT NULL
- allocated_days_before — decimal(5, 2)
- days_request — decimal(5, 2)
- end_date — date — NOT NULL
- end_time — time(6)
- event_date — date
- is_miscarriage — tinyint(1)
- is_multiple_birth — tinyint(1)
- is_paid — tinyint(1)
- period_end_date — date
- period_start_date — date
- start_date — date — NOT NULL
- start_time — time(6)
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- contact — varchar(15)
- code — varchar(20)
- employee_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- reason — varchar(250)
- dependent_info — varchar(255)
- duration_type — enum('FULL_DAY', 'HALF_DAY', 'HOURLY')
- half_leave_type — enum('POST', 'PRE')
- leave_accrual_type — enum('HOLIDAY_WORK', 'OT_WORK')
- leave_type — enum('ANNUAL', 'COMPENSATORY', 'SPECIAL', 'TEMPORARY') — NOT NULL
- request_type — enum('ANNUAL', 'COMPENSATORY', 'FAMILY_CARE', 'FAMILY_EVENT', 'HALF_DAY', 'HOURS', 'MATERNITY', 'MENSTRUAL', 'OFFICIAL', 'OTHER', 'PARENTAL', 'SICK', 'SUBSTITUTE') — NOT NULL
- status — enum('APPROVED', 'CANCELLED', 'PENDING', 'PROCESSING', 'REJECTED') — NOT NULL
tb_leave_rule
- leave_rule_id — varchar(36) — Primary key — NOT NULL
- leave_days — decimal(3)
- seniority — int
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- family_event — enum('FUNERAL', 'WEDDING')
- family_relation — enum('CHILD', 'GRANDPARENT', 'PARENT', 'SELF', 'SIBLING', 'SPOUSE')
- type — enum('ANNUAL', 'FAMILY_CARE', 'FAMILY_EVENT', 'PARENTAL') — NOT NULL
tb_login_failed_attempt
- login_failed_attempt_id — varchar(36) — Primary key — NOT NULL
- fail_count — int
- is_locked — tinyint(1)
- created_at — timestamp — NOT NULL
- expire_time — datetime(6)
- last_modified_at — timestamp — NOT NULL
- username — varchar(255)
tb_menu
- menu_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- eng_name — varchar(64) — NOT NULL
- ko_name — varchar(64) — NOT NULL
- menu_code — varchar(255) — NOT NULL
- site — enum('ADMIN', 'USER') — NOT NULL
tb_org
- org_code — varchar(40) — Primary key — NOT NULL
- order_no — smallint — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- load_date_time — datetime(6) — NOT NULL
- org_tel_no — varchar(20)
- company_code — varchar(40) — NOT NULL
- up_org_code — varchar(40)
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- eng_name — varchar(64) — NOT NULL
- org_name — varchar(100) — NOT NULL
- reg_type — varchar(20) — NOT NULL
- use_yn — char — NOT NULL
- org_type — enum('DEPARTMENT', 'TEAM')
tb_org_position
- org_position_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- org_code — varchar(255)
- position_id — varchar(255)
tb_otp_verification
- otp_verification_id — varchar(36) — Primary key — NOT NULL
- otp_code — varchar(6) — NOT NULL
- created_at — timestamp — NOT NULL
- expiry_time — datetime(6)
- last_modified_at — timestamp — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- employee_id — varchar(255)
- phone_number — varchar(255)
- type — enum('CHANGE_PHONE') — NOT NULL
tb_overtime_requests
- over_time_request_id — varchar(36) — Primary key — NOT NULL
- allocated_hours — decimal(5, 2) — NOT NULL
- date — date — NOT NULL
- end_time — time(6) — NOT NULL
- expire_date — date — NOT NULL
- hours — decimal(5, 2) — NOT NULL
- start_time — time(6) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- code — varchar(20)
- employee_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- reason — varchar(250) — NOT NULL
- over_time_type — enum('POST', 'PRE') — NOT NULL
- status — enum('APPROVED', 'CANCELLED', 'PENDING', 'PROCESSING', 'REJECTED') — NOT NULL
tb_password_reset_token
- password_reset_token_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- username — varchar(50) — NOT NULL
- new_password — varchar(100) — NOT NULL
- token — varchar(255) — NOT NULL
tb_permission
- permission_id — varchar(36) — Primary key — NOT NULL
- is_default — tinyint(1) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- name — varchar(64) — NOT NULL
- role — enum('ADMIN', 'MANAGER', 'USER') — NOT NULL
tb_permission_menu
- permission_menu_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- menu_id — varchar(36) — NOT NULL
- permission_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
tb_position
- position_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- en_name — varchar(255)
- ko_name — varchar(255)
- position_code — varchar(255) — NOT NULL
- order_no — smallint
tb_reminder_logs
- reminder_logs_id — varchar(36) — Primary key — NOT NULL
- target_date — date
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- employee_id — varchar(36) — NOT NULL
- request_id — varchar(36)
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- type — enum('REMIND_CHECKIN', 'REMIND_CHECKIN_LATE', 'REMIND_CHECKOUT', 'REMIND_CHECKOUT_EARLY', 'REQUEST_REMINDER') — NOT NULL
tb_settings
- setting_id — varchar(36) — Primary key — NOT NULL
- allow_notifications — tinyint(1) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- employee_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
tb_support_case
- support_case_id — varchar(36) — Primary key — NOT NULL
- admin_read — smallint
- employee_read — smallint
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- code — varchar(20) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- description — text
- employee_id — varchar(255)
- title — varchar(255)
- status — enum('CLOSED', 'OPEN')
tb_support_case_message
- support_case_message_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- sender_id — varchar(36) — NOT NULL
- support_case_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- content — text
tb_sync_setting
- sync_setting_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- process_interval — varchar(255) — NOT NULL
- remove_interval — varchar(255) — NOT NULL
- send_interval — varchar(255) — NOT NULL
- sync_url — varchar(100) — NOT NULL
- use_yn — smallint
- holiday_priority_source — varchar(50)
- event_retention_days — int — NOT NULL
- holiday_gov_cron — varchar(50) — NOT NULL
- holiday_gov_months_ahead — int — NOT NULL
- holiday_gov_use_yn — smallint
tb_sync_workplace
- sync_workplace_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- so_floor_id — int — NOT NULL
- so_floor_name — varchar(100) — NOT NULL
- workplace_id — varchar(36) — NOT NULL
tb_user_token
- id — int — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- username — varchar(50) — NOT NULL
- token — varchar(500) — NOT NULL
tb_work_calendar
- work_calendar_id — varchar(36) — Primary key — NOT NULL
- end_date — date — NOT NULL
- is_leave — tinyint(1) — NOT NULL
- start_date — date — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- calendar_name — varchar(100)
- calendar_type — enum('HOLIDAY', 'SPECIAL_WORKING_DAY')
- calendar_source — enum('GOV', 'HR', 'SO')
- is_primary — tinyint(1) — NOT NULL
- so_holiday_id — int
tb_work_policy
- work_policy_id — varchar(36) — Primary key — NOT NULL
- allow_checkin_late — int
- allow_checkout_early — int
- allowed_check_in_from — time(6) — NOT NULL
- allowed_check_out_from — time(6) — NOT NULL
- base_work_hours — smallint — NOT NULL
- break_end_time — time(6)
- break_start_time — time(6)
- core_time_end — time(6) — NOT NULL
- core_time_start — time(6) — NOT NULL
- is_default — int — NOT NULL
- max_ot_hours — decimal(38, 2)
- min_ot_hours — decimal(38, 2)
- reminder_after — int
- work_end_time — time(6) — NOT NULL
- work_start_time — time(6) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- policy_type — varchar(20) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- eng_name — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- use_yn — char — NOT NULL
tb_work_policy_assignment
- work_policy_assignment_id — varchar(36) — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- employee_id — varchar(36) — NOT NULL
- work_policy_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
tb_work_requests
- work_request_id — varchar(36) — Primary key — NOT NULL
- cost — decimal(15)
- end_date — date — NOT NULL
- end_time — time(6)
- latitude — decimal(8, 5)
- longitude — decimal(8, 5)
- start_date — date — NOT NULL
- start_time — time(6)
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- code — varchar(20)
- contact_info — varchar(20)
- employee_id — varchar(36) — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- person_in_charge — varchar(100)
- transport — varchar(100)
- location — varchar(250)
- reason — varchar(250)
- visited_client — varchar(500)
- work_description — varchar(500)
- status — enum('APPROVED', 'CANCELLED', 'PENDING', 'PROCESSING', 'REJECTED') — NOT NULL
- work_type — enum('BUSINESS_TRIP', 'OUTSIDE', 'SECONDMENT') — NOT NULL
tb_workplace
- workplace_id — varchar(36) — Primary key — NOT NULL
- latitude — decimal(8, 5) — NOT NULL
- longitude — decimal(8, 5) — NOT NULL
- created_at — timestamp — NOT NULL
- last_modified_at — timestamp — NOT NULL
- created_by — varchar(50) — NOT NULL
- last_modified_by — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- address — varchar(250) — NOT NULL
- description — varchar(250)
- type — enum('BRANCH', 'COMPANY') — NOT NULL