hexagon
Tables (25)
ATTENDANCE_RECORD
- ATTENDANCE_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- ATTENDANCE_TYPE_ID — NUMBER(10) — Foreign key → ATTENDANCE_TYPE.ATTENDANCE_TYPE_ID — NOT NULL
- START_DATE — DATE — NOT NULL
- END_DATE — DATE — NOT NULL
- START_TIME — VARCHAR2(5)
- END_TIME — VARCHAR2(5)
- DAY_COUNT — NUMBER(9,2)
- HOUR_COUNT — NUMBER(9,2)
- DESCRIPTION — VARCHAR2(500)
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
ATTENDANCE_TYPE
- ATTENDANCE_TYPE_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
- ATTENDANCE_CODE — VARCHAR2(30) — NOT NULL
- ATTENDANCE_NAME — VARCHAR2(100) — NOT NULL
- UNIT_CODE — VARCHAR2(20) — NOT NULL
- ATTENDANCE_GROUP_CODE — VARCHAR2(20) — NOT NULL
- LEAVE_TYPE_ID — NUMBER(10) — Foreign key → LEAVE_TYPE.LEAVE_TYPE_ID
- DISPLAY_ORDER — NUMBER(3) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
CERTIFICATE_ISSUE
- CERTIFICATE_ISSUE_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- CERTIFICATE_TYPE_CODE — VARCHAR2(30) — NOT NULL
- ISSUE_YEAR — CHAR(4) — NOT NULL
- ISSUE_SEQUENCE — NUMBER(6) — NOT NULL
- ISSUE_NO — VARCHAR2(30) — NOT NULL
- ISSUE_DATE — DATE — NOT NULL
- PURPOSE — VARCHAR2(200) — NOT NULL
- SUBMISSION_TARGET — VARCHAR2(200)
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
COMPANY_INFO
- COMPANY_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_NAME — VARCHAR2(100) — NOT NULL
- BUSINESS_NO — VARCHAR2(20) — NOT NULL
- CEO_TITLE — VARCHAR2(20) — NOT NULL
- CEO_NAME — VARCHAR2(50) — NOT NULL
- CORP_NO — VARCHAR2(20)
- EST_DATE — DATE — NOT NULL
- WEB_SITE — VARCHAR2(100)
- ADDRESS — VARCHAR2(300)
- TEL_NO — VARCHAR2(50)
- FAX_NO — VARCHAR2(50)
- BUSINESS_TYPE — VARCHAR2(50)
- BUSINESS_ITEM — VARCHAR2(50)
- PAY_DAY — NUMBER(2) — NOT NULL
- PAY_PERIOD_START_DAY — NUMBER(2) — NOT NULL
- PAY_PERIOD_END_DAY — NUMBER(2) — NOT NULL
- BANK_NAME — VARCHAR2(100)
- ACCOUNT_HOLDER — VARCHAR2(50)
- BANK_ACCOUNT — VARCHAR2(100)
- LOGO_PATH — VARCHAR2(300)
- SEAL_PATH — VARCHAR2(300)
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
DAILY_WORK_RECORD
- DAILY_WORK_RECORD_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- PAYROLL_EMPLOYEE_ID — NUMBER(10) — Foreign key → PAYROLL_EMPLOYEE.PAYROLL_EMPLOYEE_ID
- WORK_SITE_NAME — VARCHAR2(100) — NOT NULL
- WORK_DATE — DATE — NOT NULL
- DAILY_WAGE — NUMBER(15,0) — NOT NULL
- PAY_RATE — NUMBER(5,2) — NOT NULL
- PAY_AMOUNT — NUMBER(15,0) — NOT NULL
- INCOME_TAX_AMOUNT — NUMBER(15,0) — NOT NULL
- LOCAL_INCOME_TAX_AMOUNT — NUMBER(15,0) — NOT NULL
- NET_PAY_AMOUNT — NUMBER(15,0) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
DEDUCTION_ITEM
- DEDUCTION_ITEM_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
- DEDUCTION_ITEM_NAME — VARCHAR2(100) — NOT NULL
- CALCULATION_METHOD — VARCHAR2(500)
- TRUNCATION_UNIT — NUMBER(10) — NOT NULL
- REMARK — VARCHAR2(500)
- USE_YN — CHAR(1) — NOT NULL
- DISPLAY_ORDER — NUMBER(3) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
EMPLOYEE
- EMPLOYEE_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
- EMPLOYEE_NO — VARCHAR2(30) — NOT NULL
- EMPLOYMENT_TYPE — VARCHAR2(20) — NOT NULL
- INCOME_TYPE — VARCHAR2(20) — NOT NULL
- EMPLOYEE_NAME — VARCHAR2(50) — NOT NULL
- EMPLOYEE_NAME_EN — VARCHAR2(50)
- HIRE_DATE — DATE — NOT NULL
- RESIGN_DATE — DATE
- DEPARTMENT — VARCHAR2(100) — NOT NULL
- POSITION — VARCHAR2(100)
- DOM_FOR_YN — CHAR(1)
- RESIDENT_REG_NO — VARCHAR2(100)
- PHONE — VARCHAR2(20)
- MOBILE — VARCHAR2(20)
- EMAIL — VARCHAR2(100)
- NATIONAL_PENSION — VARCHAR2(20) — NOT NULL
- HEALTH_INSURANCE — VARCHAR2(20) — NOT NULL
- LONG_TERM_CARE_INSURANCE — VARCHAR2(20) — NOT NULL
- EMPLOYMENT_INSURANCE — VARCHAR2(20) — NOT NULL
- EMP_INCOME_TAX_RATE — NUMBER(5,2) — NOT NULL
- TAX_REDUCTION_SME_YOUTH — VARCHAR2(50) — NOT NULL
- BUS_INCOME_EARNER — VARCHAR2(50) — NOT NULL
- DAILY_WORKER — VARCHAR2(50) — NOT NULL
- OTHER_INCOME_EARNER — VARCHAR2(50) — NOT NULL
- EMP_BUS_INCOME_EARNER — VARCHAR2(50) — NOT NULL
- TAX_EXEMPTION — VARCHAR2(50) — NOT NULL
- DURUNURI_N_A — VARCHAR2(50) — NOT NULL
- DURUNURI_NEW_80 — VARCHAR2(50) — NOT NULL
- DURUNURI_NEW_90 — VARCHAR2(50) — NOT NULL
- BASE_WAGE_AMOUNT — NUMBER(15,0) — NOT NULL
- NATIONAL_PENSION_BASE_AMOUNT — NUMBER(15,0)
- HEALTH_INSURANCE_BASE_AMOUNT — NUMBER(15,0)
- EMPLOYMENT_INSURANCE_BASE_AMOUNT — NUMBER(15,0)
- BANK_NAME — VARCHAR2(100)
- BANK_ACCOUNT — VARCHAR2(100)
- ACCOUNT_HOLDER — VARCHAR2(50)
- NATIONAL_PENSION_NO — VARCHAR2(50)
- NATIONAL_PENSION_ACQ_DATE — DATE
- NATIONAL_PENSION_LOSS_DATE — DATE
- HEALTH_INSURANCE_NO — VARCHAR2(50)
- HEALTH_INSURANCE_ACQ_DATE — DATE
- HEALTH_INSURANCE_LOSS_DATE — DATE
- EMPLOYMENT_INSURANCE_NO — VARCHAR2(50)
- EMPLOYMENT_INSURANCE_ACQ_DATE — DATE
- EMPLOYMENT_INSURANCE_LOSS_DATE — DATE
- INDUSTRIAL_ACCIDENT_NO — VARCHAR2(50)
- INDUSTRIAL_ACCIDENT_ACQ_DATE — DATE
- INDUSTRIAL_ACCIDENT_LOSS_DATE — DATE
- MILITARY_STATUS_CODE — VARCHAR2(20)
- MILITARY_BRANCH_CODE — VARCHAR2(20)
- MILITARY_SERVICE_START_DATE — DATE
- MILITARY_SERVICE_END_DATE — DATE
- MILITARY_SPECIALTY — VARCHAR2(100)
- MILITARY_EXEMPT_REASON — VARCHAR2(300)
- RECOMMENDER_NAME — VARCHAR2(50)
- RECOMMENDER_RELATION — VARCHAR2(50)
- RECOMMENDER_COMPANY_NAME — VARCHAR2(100)
- RECOMMENDER_POSITION — VARCHAR2(100)
- RECOMMENDER_PHONE — VARCHAR2(20)
- … +22
EMPLOYEE_APPOINTMENT
- APPOINTMENT_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- APPOINTMENT_TYPE_CODE — VARCHAR2(20) — NOT NULL
- APPOINTMENT_DATE — DATE — NOT NULL
- DEPARTMENT — VARCHAR2(100)
- POSITION — VARCHAR2(100)
- DUTY_TITLE — VARCHAR2(100)
- MEMO — VARCHAR2(500)
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
EMPLOYEE_CAREER
- CAREER_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- COMPANY_NAME — VARCHAR2(100) — NOT NULL
- DEPARTMENT — VARCHAR2(100)
- POSITION — VARCHAR2(100)
- START_DATE — DATE — NOT NULL
- END_DATE — DATE
- DUTY_YY — NUMBER(2)
- DUTY_MM — NUMBER(2)
- RESIGN_REASON — VARCHAR2(300)
- CAREER_DESCRIPTION — VARCHAR2(500)
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
EMPLOYEE_DEPENDENT
- DEPENDENT_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- DEPENDENT_NAME — VARCHAR2(50) — NOT NULL
- RELATION_CODE — VARCHAR2(20) — NOT NULL
- DOM_FOR_YN — CHAR(1)
- BIRTH_DATE — DATE
- DISABLED_YN — CHAR(1) — NOT NULL
- PERSONAL_DEDUCTION_YN — CHAR(1) — NOT NULL
- HEALTH_INSURANCE_YN — CHAR(1) — NOT NULL
- COHABITATION_YN — CHAR(1) — NOT NULL
- WAGE_INCOME_TAX_YN — CHAR(1) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
EMPLOYEE_EDUCATION
- EDUCATION_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- SCHOOL_NAME — VARCHAR2(100) — NOT NULL
- MAJOR_NAME — VARCHAR2(100)
- START_DATE — DATE
- END_DATE — DATE
- GRADUATION_STATUS — VARCHAR2(20)
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
EMPLOYEE_LANGUAGE
- LANGUAGE_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- LANGUAGE_NAME — VARCHAR2(50) — NOT NULL
- TEST_NAME — VARCHAR2(100)
- OFFICIAL_SCORE — VARCHAR2(30)
- ACQUISITION_DATE — DATE
- READING_LEVEL_CODE — VARCHAR2(20)
- WRITING_LEVEL_CODE — VARCHAR2(20)
- SPEAKING_LEVEL_CODE — VARCHAR2(20)
- DISPLAY_ORDER — NUMBER(3) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
EMPLOYEE_LEAVE
- EMPLOYEE_LEAVE_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- LEAVE_TYPE_ID — NUMBER(10) — Foreign key → LEAVE_TYPE.LEAVE_TYPE_ID — NOT NULL
- GRANTED_DAYS — NUMBER(9,2) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
EMPLOYEE_QUALIFICATION
- QUALIFICATION_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- QUALIFICATION_NAME — VARCHAR2(100) — NOT NULL
- ACQUISITION_DATE — DATE
- ISSUING_ORGANIZATION — VARCHAR2(100)
- CERTIFICATE_NO — VARCHAR2(50)
- MEMO — VARCHAR2(500)
- DISPLAY_ORDER — NUMBER(3) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
EMPLOYEE_REWARD_PUNISHMENT
- REWARD_PUNISHMENT_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- REWARD_PUNISHMENT_TYPE_CODE — VARCHAR2(20) — NOT NULL
- REWARD_PUNISHMENT_NAME — VARCHAR2(100) — NOT NULL
- AUTHORITY_NAME — VARCHAR2(100)
- REWARD_PUNISHMENT_DATE — DATE
- REWARD_PUNISHMENT_CONTENT — VARCHAR2(1000)
- MEMO — VARCHAR2(500)
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
EMPLOYEE_TRAINING
- TRAINING_ID — NUMBER(10) — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- TRAINING_TYPE_CODE — VARCHAR2(20) — NOT NULL
- TRAINING_NAME — VARCHAR2(200) — NOT NULL
- TRAINING_START_DATE — DATE
- TRAINING_END_DATE — DATE
- TRAINING_INSTITUTION — VARCHAR2(100)
- TRAINING_COST — NUMBER(15,0) — NOT NULL
- REFUND_TRAINING_COST — NUMBER(15,0) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
LEAVE_TYPE
- LEAVE_TYPE_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
- LEAVE_CODE — VARCHAR2(30) — NOT NULL
- LEAVE_NAME — VARCHAR2(100) — NOT NULL
- EFFECTIVE_START_DATE — DATE — NOT NULL
- EFFECTIVE_END_DATE — DATE — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- DISPLAY_ORDER — NUMBER(3) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
PAYROLL
- PAYROLL_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
- PAY_YEAR_MONTH — CHAR(6) — NOT NULL
- PAY_SEQUENCE — NUMBER(3) — NOT NULL
- SETTLEMENT_START_DATE — DATE — NOT NULL
- SETTLEMENT_END_DATE — DATE — NOT NULL
- PAYMENT_DATE — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
PAYROLL_DEDUCTION_DETAIL
- PAYROLL_DEDUCTION_DETAIL_ID — NUMBER(10) — Primary key — NOT NULL
- PAYROLL_EMPLOYEE_ID — NUMBER(10) — Foreign key → PAYROLL_EMPLOYEE.PAYROLL_EMPLOYEE_ID — NOT NULL
- DEDUCTION_ITEM_ID — NUMBER(10) — Foreign key → DEDUCTION_ITEM.DEDUCTION_ITEM_ID — NOT NULL
- AMOUNT — NUMBER(15,0) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
PAYROLL_EMPLOYEE
- PAYROLL_EMPLOYEE_ID — NUMBER(10) — Primary key — NOT NULL
- PAYROLL_ID — NUMBER(10) — Foreign key → PAYROLL.PAYROLL_ID — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- EMPLOYMENT_TYPE — VARCHAR2(20) — NOT NULL
- INCOME_TYPE — VARCHAR2(20) — NOT NULL
- TOTAL_PAY_AMOUNT — NUMBER(15,0) — NOT NULL
- TOTAL_DEDUCTION_AMOUNT — NUMBER(15,0) — NOT NULL
- NET_PAY_AMOUNT — NUMBER(15,0) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
PAYROLL_PAY_DETAIL
- PAYROLL_PAY_DETAIL_ID — NUMBER(10) — Primary key — NOT NULL
- PAYROLL_EMPLOYEE_ID — NUMBER(10) — Foreign key → PAYROLL_EMPLOYEE.PAYROLL_EMPLOYEE_ID — NOT NULL
- PAY_ITEM_ID — NUMBER(10) — Foreign key → PAY_ITEM.PAY_ITEM_ID — NOT NULL
- AMOUNT — NUMBER(15,0) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
PAYROLL_TRANSFER_REQUEST
- TRANSFER_REQUEST_ID — NUMBER(10) — Primary key — NOT NULL
- PAYROLL_ID — NUMBER(10) — Foreign key → PAYROLL.PAYROLL_ID — NOT NULL
- REQUEST_YN — CHAR(1) — NOT NULL
- REQUEST_DATE — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
PAY_ITEM
- PAY_ITEM_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
- PAY_ITEM_NAME — VARCHAR2(100) — NOT NULL
- TAXABLE_YN — CHAR(1) — NOT NULL
- NON_TAX_NAME — VARCHAR2(100)
- NON_TAX_LIMIT_AMOUNT — NUMBER(15,0)
- CALCULATION_METHOD — VARCHAR2(500)
- TRUNCATION_UNIT — NUMBER(10) — NOT NULL
- ATTENDANCE_PAY_RULE — VARCHAR2(30)
- BULK_PAY_AMOUNT — NUMBER(15,0)
- USE_YN — CHAR(1) — NOT NULL
- DISPLAY_ORDER — NUMBER(3) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
RETIREMENT_PAY
- RETIREMENT_PAY_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID — NOT NULL
- CALC_START_DATE — DATE — NOT NULL
- CALC_END_DATE — DATE — NOT NULL
- SERVICE_DAYS — NUMBER(10) — NOT NULL
- TOTAL_WAGE_AMOUNT — NUMBER(15,0) — NOT NULL
- AVERAGE_DAILY_WAGE — NUMBER(15,0) — NOT NULL
- RETIREMENT_PAY_AMOUNT — NUMBER(15,0) — NOT NULL
- INCOME_TAX_AMOUNT — NUMBER(15,0) — NOT NULL
- LOCAL_INCOME_TAX_AMOUNT — NUMBER(15,0) — NOT NULL
- NET_PAY_AMOUNT — NUMBER(15,0) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL
USER_ACCOUNT
- USER_ID — NUMBER(10) — Primary key — NOT NULL
- COMPANY_ID — NUMBER(10) — Foreign key → COMPANY_INFO.COMPANY_ID — NOT NULL
- EMPLOYEE_ID — NUMBER(10) — Foreign key → EMPLOYEE.EMPLOYEE_ID
- LOGIN_ID — VARCHAR2(50) — NOT NULL
- PASSWORD_HASH — VARCHAR2(255) — NOT NULL
- USER_NAME — VARCHAR2(50) — NOT NULL
- EMAIL — VARCHAR2(100)
- PHONE — VARCHAR2(20)
- ROLE_CODE — VARCHAR2(20) — NOT NULL
- STATUS — VARCHAR2(20) — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MOD_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE — NOT NULL
- UPDATED_AT — DATE — NOT NULL