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