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)