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)