ㅁㅎㅇ
Tables (18)
HRIMASTER
- EMP_CODE — VARCHAR(20) — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
- EMP_NAME — VARCHAR(30)
- SOCIAL_NUM — VARCHAR(200)
- GENDER — CHAR(1)
- ENTER_DATE — DATE
- POSITION_CODE — VARCHAR(10)
- POSITION_DATE — DATE
- DUTY_CODE — VARCHAR(3)
- DUTY_DATE — DATE
- EMP_STATE — VARCHAR(4)
- DEPT_CODE — VARCHAR(10)
- RETIRE_DATE — DATE
- RETIRE_REASON — VARCHAR(4)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTANNUALDETAIL
- YYYY — VARCHAR(4) — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
- EMP_CODE — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
- DEPT_CODE — VARCHAR(10)
- ANNUAL_START_DATE — DATE
- ANNUAL_END_DATE — DATE
- TOTAL_WORK_DAY — NUMERIC(19,5)
- REAL_WORK_DAY — NUMERIC(19,5)
- TOT_DAY — NUMERIC(19,5)
- USE_DAY — NUMERIC(19,5)
- BALANCE_DAY — NUMERIC(19,5)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTATTENDANCEREQUEST
- REQ_ID — VARCHAR(20) — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
- REQ_GROUP — VARCHAR(20)
- REQ_TYPE — VARCHAR(20)
- REQUESTER_EMP_CODE — VARCHAR(20)
- TARGET_EMP_CODE — VARCHAR(20)
- REQUESTER_DEPT_CODE — VARCHAR(10)
- TARGET_DEPT_CODE — VARCHAR(10)
- TARGET_DATE — DATE
- TARGET_DATE_TO — DATE
- REASON — VARCHAR(50)
- REASON_DETAIL — VARCHAR(300)
- STATUS — VARCHAR(20)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
- SUBMITTED_AT — DATETIME
- APPROVED_AT — DATETIME
- CANCELED_AT — DATETIME
HRTATTENDANCE_APPROVAL
- COMPANY — VARCHAR(3) — Foreign key → HRIMASTER.COMPANY — NOT NULL
- REQ_ID — VARCHAR(20) — Foreign key → HRTATTENDANCEREQUEST.REQ_ID — NOT NULL
- STEP_NO — INTEGER
- APPROVER_EMP_CODE — VARCHAR(20)
- STATUS — VARCHAR(20)
- DECISION_AT — DATETIME
- REJECT_REASON — VARCHAR(300)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTATTENDANCE_GENERAL
- COMPANY — VARCHAR(3) — Foreign key → HRTATTENDANCEREQUEST.COMPANY — NOT NULL
- REQ_ID — VARCHAR(20) — Foreign key → HRTATTENDANCEREQUEST.REQ_ID — NOT NULL
- START_TIME — TIME
- END_TIME — TIME
- WORK_MIN — INTEGER
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTATTENDANCE_OTHER
- COMPANY — VARCHAR(3) — Foreign key → HRTSHIFTMASTER.COMPANY — NOT NULL
- REQ_ID — VARCHAR(20) — Foreign key → HRTATTENDANCEREQUEST.REQ_ID — NOT NULL
- CHANGE_SHIFT_CODE — VARCHAR(10)
- START_DATE — DATE
- END_DATE — DATE
- APPLY_TYPE — VARCHAR(20)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTDAILYATTENDANCE
- YYYYMMDD — DATE — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → HRTSHIFTMASTER.COMPANY — NOT NULL
- EMP_CODE — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
- DEPT_CODE — VARCHAR(10)
- SHIFT_CODE — VARCHAR(10)
- ACTUAL_SHIFT_CODE — VARCHAR(10)
- CHECK_IN — TIME
- CHECK_OUT — TIME
- OVERNIGHT_YN — CHAR(1)
- WORK_MIN — INTEGER
- OVER_MIN — INTEGER
- NIGHT_MIN — INTEGER
- LATE_YN — CHAR(1)
- EARLY_LEAVE_YN — CHAR(1)
- ABSENT_YN — CHAR(1)
- WEEK_NUM — VARCHAR(6)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTDUTYINFO
- COMPANY — VARCHAR(3) — Primary key — NOT NULL
- DUTY_CODE — VARCHAR(3) — Primary key — NOT NULL
- DUTY_NAME — VARCHAR(10)
- USE_YN — CHAR(1)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTGRADEINFO
- COMPANY — VARCHAR(3) — Primary key — NOT NULL
- POSITION_CODE — VARCHAR(10) — Primary key — NOT NULL
- POSITION_NAME — NVARCHAR(30)
- USE_YN — CHAR(1)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTHOLIDAYMASTER
- HOLIDAY_DATE — DATE — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
- HOLIDAY_NAME — NVARCHAR(50)
- HOLIDAY_TYPE — VARCHAR(10)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTSHIFTMASTER
- SHIFT_CODE — VARCHAR(10) — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → HRTTIMEITEM.COMPANY — NOT NULL
- SHIFT_NAME — VARCHAR(50)
- NORMAL_TIME_ITEM_CODE — VARCHAR(10)
- WORK_ON_DAY_TYPE — VARCHAR(2)
- WORK_ON_TIME — TIME
- WORK_OFF_DAY_TYPE — VARCHAR(2)
- WORK_OFF_TIME — TIME
- BREAK1_START_DAY_TYPE — VARCHAR(2)
- BREAK1_START_TIME — TIME
- BREAK1_END_DAY_TYPE — VARCHAR(2)
- BREAK1_END_TIME — TIME
- BREAK2_START_DAY_TYPE — VARCHAR(2)
- BREAK2_START_TIME — TIME
- BREAK2_END_DAY_TYPE — VARCHAR(2)
- BREAK2_END_TIME — TIME
- OVER_START_DAY_TYPE — VARCHAR(2)
- OVER_START_TIME — TIME
- OVER_END_DAY_TYPE — VARCHAR(2)
- OVER_END_TIME — TIME
- OVER2_START_DAY_TYPE — VARCHAR(2)
- OVER2_START_TIME — TIME
- OVER2_END_DAY_TYPE — VARCHAR(2)
- OVER2_END_TIME — TIME
- MEMO — VARCHAR(300)
- USE_YN — CHAR(1)
- FIVE_WEEK_YN — CHAR(1)
- WORK_TYPE_CODE — VARCHAR(10)
- WORK_DAY_TYPE — VARCHAR(10)
- SORT_SEQ — INTEGER
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTTIMEITEM
- COMPANY — VARCHAR(3) — Primary key — NOT NULL
- TIME_ITEM_CODE — VARCHAR(10) — Primary key — NOT NULL
- TIME_ITEM_NAME — NVARCHAR(50)
- TIME_ITEM_ABBR_NAME — NVARCHAR(50)
- MEMO — NVARCHAR(300)
- USE_YN — CHAR(1)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTWEEKLYATTENDANCE
- WEEK_START_DATE — DATE — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
- DEPT_CODE — VARCHAR(10) — Foreign key → ORGDEPTMASTER.DEPT_CODE — NOT NULL
- EMP_CODE — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
- WORK_DAY_CNT — NUMERIC(19,5)
- TOTAL_WORK_MIN — INTEGER
- TOTAL_OVER_MIN — INTEGER
- TOTAL_NIGHT_MIN — INTEGER
- LATE_CNT — INTEGER
- ABSENT_CNT — INTEGER
- ANNUAL_USE_CNT — INTEGER
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTWORKEMPCALENDAR
- YYYYMMDD — DATE — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → HRTWORKPATTERNMASTER.COMPANY — NOT NULL
- EMP_CODE — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
- TXN_ID — INT
- SHIFT_CODE — VARCHAR(10)
- WORK_PATTERN_CODE — VARCHAR(10)
- DEPT_CODE — VARCHAR(10)
- SHIFT_CODE_ORIG — VARCHAR(10)
- HOLIDAY_YN — CHAR(1)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTWORKPATTERNDETAIL
- SEQ — INTEGER — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → HRTSHIFTMASTER.COMPANY — NOT NULL
- WORK_PATTERN_CODE — VARCHAR(10) — Foreign key → HRTWORKPATTERNMASTER.WORK_PATTERN_CODE — NOT NULL
- DAY_TYPE — VARCHAR(2)
- SHIFT_CODE — VARCHAR(10)
- WORK_TYPE_CODE — VARCHAR(10)
- WORK_DAY_TYPE — VARCHAR(10)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
HRTWORKPATTERNMASTER
- COMPANY — VARCHAR(3) — Primary key — NOT NULL
- WORK_PATTERN_CODE — VARCHAR(10) — Primary key — NOT NULL
- WORK_PATTERN_NAME — VARCHAR(50)
- PATTERN_TYPE — VARCHAR(10)
- CYCLE_UNIT — VARCHAR(2)
- CYCLE_COUNT — INTEGER
- START_DATE — DATE
- END_DATE — DATE
- USE_YN — CHAR(1)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
ORGDEPTMASTER
- DEPT_CODE — VARCHAR(10) — Primary key — NOT NULL
- COMPANY — VARCHAR(3) — Foreign key → HRTWORKPATTERNMASTER.COMPANY — NOT NULL
- DEPT_NAME — VARCHAR(50)
- PARENT_DEPT — VARCHAR(10)
- DEPT_LEADER — VARCHAR(20)
- DEPT_CATEGORY — VARCHAR(10)
- START_DATE — DATE
- END_DATE — DATE
- USE_YN — CHAR(1)
- OLD_DEPT_LEADER — VARCHAR(20)
- WORK_PATTERN_CODE — VARCHAR(10)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
USER_ACCOUNT
- COMPANY — VARCHAR(3) — Foreign key → HRIMASTER.COMPANY — NOT NULL
- USER_ID — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
- PASSWORD_HASH — VARCHAR(256)
- ROLE_CODE — VARCHAR(20)
- LAST_LOGIN_AT — DATETIME
- PWD_CHANGED_AT — DATETIME
- USE_YN — CHAR(1)
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME