qwer

Tables (5)

alembic_version

  • version_num — varchar(32) — Primary key — NOT NULL

allowance_policies

  • id — int — Primary key — NOT NULL
  • branch_id — int — NOT NULL
  • comprehensive_overtime — tinyint(1)
  • annual_leave — tinyint(1)
  • holiday_work — tinyint(1)
  • job_duty — tinyint(1)
  • meal — tinyint(1)
  • doctor_holiday_work_pay — int — NOT NULL
  • common_holiday_work_pay — int — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_yn — varchar(1)

auto_annual_leave_approval

  • id — int — Primary key — NOT NULL
  • branch_id — int — NOT NULL
  • top_auto_approval — tinyint(1)
  • total_auto_approval — tinyint(1)
  • part_auto_approval — tinyint(1)
  • created_at — datetime
  • updated_at — datetime
  • deleted_yn — varchar(1)

auto_annual_leave_grant

  • id — int — Primary key — NOT NULL
  • branch_id — int — NOT NULL
  • account_based_january_1st — enum('초기화', '다음해로 이월') — NOT NULL — 매 년 1월 1일기준
  • account_based_less_than_year — enum('당해년도 일괄 부여', '매 월 1개씩 부여') — NOT NULL — 근속년수 1년 미만
  • account_based_decimal_point — enum('0.5 기준 올림', '절삭', '올림', '반올림') — NOT NULL — 소수점처리
  • entry_date_based_remaining_leave — enum('초기화', '다음해로 이월') — NOT NULL — 매 년 입사일 기준
  • condition_based_month — int — NOT NULL
  • condition_based_cnt — int — NOT NULL
  • condition_based_type — enum('월', '일') — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_yn — varchar(1)

auto_overtime_policies

  • id — int — Primary key — NOT NULL
  • branch_id — int — NOT NULL
  • top_auto_applied — tinyint(1)
  • total_auto_applied — tinyint(1)
  • part_auto_applied — tinyint(1)
  • created_at — datetime
  • updated_at — datetime
  • deleted_yn — varchar(1)