hexagon_erd

Tables (27)

appointment

  • appointment_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • appointment_type — VARCHAR2(100)
  • appointment_date — DATE
  • department_id — NUMBER
  • position_id — NUMBER
  • position_type — VARCHAR2(100)
  • remarks3 — VARCHAR2(4000)

attendance

  • attendance_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • input_date — DATE
  • attendance_type_id — NUMBER — Foreign key → attendance_type.attendance_type_id
  • field_or_project_id — NUMBER — Foreign key → field_or_project.field_or_project_id
  • start_date — DATE
  • end_date — DATE
  • attendance_days — NUMBER
  • amount — NUMBER
  • summary — VARCHAR2(4000)

attendance_group

  • attendance_group_id — NUMBER — Primary key — NOT NULL
  • attendance_group_name — VARCHAR2(50)

attendance_type

  • attendance_type_id — NUMBER — Primary key — NOT NULL
  • attendance_type_name — VARCHAR2(50)
  • unit — VARCHAR2(50)
  • attendance_group_id — NUMBER — Foreign key → attendance_group.attendance_group_id
  • vacation_type_id — NUMBER — Foreign key → vacation_type.vacation_type_id
  • usage — CHAR(1)

career

  • career_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • company_name — VARCHAR2(200)
  • start_date — DATE
  • end_date — DATE
  • employment_period — VARCHAR2(100)
  • final_position — VARCHAR2(100)
  • responsibilities — VARCHAR2(4000)
  • reason_for_resignation — VARCHAR2(4000)

certification

  • certification_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • certification_name — VARCHAR2(200)
  • acquisition_date — DATE
  • issuing_organization — VARCHAR2(200)
  • certification_number — VARCHAR2(100)
  • remarks1 — VARCHAR2(4000)

company_info

  • company_id — NUMBER — Primary key — NOT NULL
  • company_name — VARCHAR2(100) — NOT NULL
  • representative_title — VARCHAR2(50)
  • representative_name — VARCHAR2(50)
  • business_number — VARCHAR2(50)
  • corporation_number — VARCHAR2(50)
  • establishment_date — DATE
  • website — VARCHAR2(100)
  • office_address — VARCHAR2(200)
  • phone_number — VARCHAR2(20)
  • fax_number — VARCHAR2(20)
  • business_type — VARCHAR2(50)
  • business_item — VARCHAR2(50)

contact_person_info

  • person_id — NUMBER — Primary key — NOT NULL
  • company_id — NUMBER — Foreign key → company_info.company_id
  • contact_name — VARCHAR2(50) — NOT NULL
  • department_id — NUMBER
  • position_id — NUMBER
  • con_phone_number — VARCHAR2(20)
  • mobile_number — VARCHAR2(20)
  • email — VARCHAR2(100)

degree

  • degree_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • graduate — VARCHAR2(100)
  • admission_date — DATE
  • graduation_date — DATE
  • school_name — VARCHAR2(200)
  • major — VARCHAR2(100)
  • completion — VARCHAR2(10)

department

  • department_id — NUMBER — Primary key — NOT NULL
  • department_name — VARCHAR2(100)

dependents

  • dependent_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • relationship — VARCHAR2(100)
  • parents_name — VARCHAR2(100)
  • foreign_or_domestic1 — VARCHAR2(20)
  • parents_number1 — VARCHAR2(20)
  • parents_number2 — VARCHAR2(20)

employee

  • employee_id — NUMBER — Primary key — NOT NULL
  • account_id — NUMBER
  • company_id — NUMBER
  • person_id — NUMBER
  • employment_type — VARCHAR2(100)
  • korean_name — VARCHAR2(100)
  • english_name — VARCHAR2(100)
  • hire_date — DATE
  • resignation_date — DATE
  • department_id — NUMBER — Foreign key → department.department_id
  • position_id — NUMBER — Foreign key → position.position_id
  • foreign_or_domestic — VARCHAR2(20)
  • resident_number1 — VARCHAR2(20)
  • resident_number2 — VARCHAR2(20)
  • address — VARCHAR2(200)
  • tel_phone — VARCHAR2(20)
  • mobile — VARCHAR2(20)
  • email — VARCHAR2(100)
  • sns — VARCHAR2(100)
  • other_details — VARCHAR2(4000)
  • status — VARCHAR2(20)

employee_salary_account

  • account_id — NUMBER — Primary key — NOT NULL
  • company_id — NUMBER
  • bank_name — VARCHAR2(100)
  • account_number — VARCHAR2(100)
  • deposit_stocks — VARCHAR2(100)
  • salary_calculation1 — DATE
  • salary_calculation2 — DATE
  • salary_payment_date — DATE

field_or_project

  • field_or_project_id — NUMBER — Primary key — NOT NULL
  • name — VARCHAR2(100)

guarantor

  • guarantor_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • guarantor_name — VARCHAR2(100)
  • guarantor_relationship — VARCHAR2(100)
  • guarantor_resident_number — VARCHAR2(20)
  • guarantee_amount — NUMBER
  • guarantee_date — DATE
  • guarantee_expiration_date — DATE
  • guarantor_phone_number — VARCHAR2(20)

insurance

  • insurance_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • insurance_agency — VARCHAR2(200)
  • insurance_number — VARCHAR2(100)
  • insurance_amount — NUMBER
  • insurance_start_date — DATE
  • insurance_end_date — DATE
  • remarks4 — VARCHAR2(4000)

language_ability

  • language_ability_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • language — VARCHAR2(100)
  • test_name — VARCHAR2(100)
  • official_score — NUMBER
  • acquisition_date1 — DATE
  • reading_ability — VARCHAR2(20)
  • writing_ability — VARCHAR2(20)
  • speaking_ability — VARCHAR2(20)

military_service

  • military_service_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • service_type — VARCHAR2(100)
  • branch — VARCHAR2(100)
  • service_period1 — DATE
  • service_period2 — DATE
  • final_rank — VARCHAR2(100)
  • department1 — VARCHAR2(100)
  • exemption_reason — VARCHAR2(4000)

position

  • position_id — NUMBER — Primary key — NOT NULL
  • position_name — VARCHAR2(100)

referrer

  • referrer_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • referrer_name — VARCHAR2(100)
  • referrer_relationship — VARCHAR2(100)
  • referrer_company_name — VARCHAR2(200)
  • referrer_position — VARCHAR2(100)
  • referrer_phone_number — VARCHAR2(20)

retirement

  • retirement_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • retirement_type — VARCHAR2(100)
  • retirement_date — DATE
  • retirement_reason — VARCHAR2(4000)
  • contact_after_retirement — VARCHAR2(20)
  • retirement_pay — NUMBER

reward_penalty

  • reward_penalty_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • reward_penalty_type — VARCHAR2(100)
  • reward_penalty_name — VARCHAR2(200)
  • reward_penalty_giver — VARCHAR2(200)
  • reward_penalty_date — DATE
  • reward_penalty_description — VARCHAR2(4000)
  • remarks2 — VARCHAR2(4000)

training

  • training_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • training_type — VARCHAR2(100)
  • training_name — VARCHAR2(200)
  • training_start_date — DATE
  • training_end_date — DATE
  • training_organization — VARCHAR2(200)
  • training_cost — NUMBER
  • refundable_training_cost — NUMBER

vacation_days

  • vacation_days_id — NUMBER — Primary key — NOT NULL
  • vacation_type_id — NUMBER — Foreign key → vacation_type.vacation_type_id
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • vacation_value — NUMBER

vacation_type

  • vacation_type_id — NUMBER — Primary key — NOT NULL
  • vacation_type_name — VARCHAR2(50)
  • apply_period1 — DATE
  • apply_period2 — DATE
  • usage — CHAR(1)

wage

  • wage_id — NUMBER — Primary key — NOT NULL
  • employee_id — NUMBER — Foreign key → employee.employee_id
  • wage_period — VARCHAR2(20)
  • wage_type_id — NUMBER — Foreign key → wage_type.wage_type_id
  • wage_value — NUMBER
  • settlement_period_start_date — DATE
  • settlement_period_end_date — DATE
  • wage_payment_date — DATE

wage_type

  • wage_type_id — NUMBER — Primary key — NOT NULL
  • wage_type_name — VARCHAR2(50)
  • number_cut — VARCHAR2(50)
  • attendance_or_lumpsum — VARCHAR2(50)
  • attendance_or_lumpsum_content — VARCHAR2(50)
  • usage — CHAR(1)