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