asd
Tables (66)
approval
- approval_id — uuid — Primary key — NOT NULL
- assignment_id — uuid — Foreign key → assignment.assignment_id — NOT NULL
- approval_title — varchar(200) — NOT NULL
- approval_content — text
- notes — text
- completion_date — timestamp(6)
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — VARCHAR(255)
- created_by — varchar(30)
- updated_by — varchar(30)
assignment
- assignment_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- department_id — uuid — Foreign key → department.department_id — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- assignment_type — varchar(30)
- assignment_content — text
- assignment_start_date — timestamp(6)
- assignment_end_date — timestamp(6)
- notes — text
- created_at — timestamp(6)
- updated_at — timestamp(6)
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
audit
- audit_id — uuid — Primary key — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- director_id — uuid — Foreign key → director.director_id — NOT NULL
- audit_meeting_number — text
- audit_name — varchar(50)
- is_audit_formation — timestamp(6) — NOT NULL
- audit_start_date — timestamp(6)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
award
- certificate_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- award_name — varchar(200)
- issuing_organization — varchar(200)
- grade — varchar(200)
- issue_date — timestamp(6)
- expiration_date — timestamp(6)
- is_nationally_certified — bool
- is_verified — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
board_director
- board_director_id — uuid — Primary key — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- director_id — uuid — Foreign key → director.director_id — NOT NULL
- board_meeting_number — text
- board_director_name — varchar(50)
- is_board_director — timestamp(6) — NOT NULL
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
business_certification
- business_certification_id — uuid — Primary key — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- business_name — varchar(200)
- business_organization — varchar(200)
- issuing_organization — varchar(200) — NOT NULL
- certification_number — varchar(100)
- business_start_date — timestamp(6)
- business_end_date — timestamp(6)
- is_active — bool — NOT NULL
- issue_date — timestamp(6) — NOT NULL
- suspension_date — timestamp(6)
- certification_type — varchar(100) — NOT NULL
- certification_name — varchar(200) — NOT NULL
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
career
- career_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- company_name — varchar(200)
- company_scale — varchar(30)
- revenue — BIGINT
- industry — varchar(30)
- department — varchar(30)
- job — varchar(100)
- position — varchar(100)
- employment_type — varchar(30)
- is_manager_experienced — bool
- responsibilities — text
- project — text
- is_currently_employed — bool
- hire_date — timestamp(6)
- termination_date — timestamp(6)
- termination_reason — text
- base_salary — BIGINT
- currency — varchar(30)
- is_verified — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
career_salary
- career_salary_id — uuid — Primary key — NOT NULL
- career_id — uuid — Foreign key → career.career_id — NOT NULL
- base_salary — BIGINT
- fixed_bonus — BIGINT
- variable_bonus — BIGINT
- is_comprehensive_wage — BIGINT
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
ceo
- ceo_id — uuid — Primary key — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- director_id — uuid — Foreign key → director.director_id — NOT NULL
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
certificate
- certificate_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- certificate_name — varchar(200)
- issuing_organization — varchar(200)
- grade — varchar(200)
- issue_date — timestamp(6)
- expiration_date — timestamp(6)
- is_nationally_certified — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
common_accident_type
- accident_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_approval_participant
- approval_participant_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_approval_status
- approval_status_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_approval_type
- approval_classification_id — uuid — Primary key — NOT NULL
- code — varchar(20) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_assignment_type
- assignment_type_id — uuid — Primary key — NOT NULL
- main_code — varchar(30)
- main_value — varchar(50)
- sub_code — varchar(30) — NOT NULL
- sub_value — varchar(50) — NOT NULL
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_company_scale
- company_scale_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_corporation_relation
- corporation_relationship_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_corporation_status
- corporation_status_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_corporation_type
- corporation_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_department_code
- department_code_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(50) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_department_status
- department_status_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_department_type
- department_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_director_type
- corporation_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_disability_grade
- disability_grade_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_disability_type
- disability_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_employee_status
- employee_status_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_employee_type
- employee_status_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_gender
- gender_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_injury_type
- accident_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_job
- job_id — uuid — Primary key — NOT NULL
- code — varchar(50)
- valude — varchar(50)
- created_at — timestamp(6)
- updated_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
common_leave_type
- leave_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_military_service_status
- military_service_status_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_military_service_type
- military_service_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_nationality_type
- nationality_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_position
- position_id — uuid — Primary key — NOT NULL
- code — varchar(50)
- valude — varchar(50)
- created_at — timestamp(6)
- updated_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
common_rank
- rank_id — uuid — Primary key — NOT NULL
- code — varchar(50)
- valude — varchar(50)
- created_at — timestamp(6)
- updated_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
common_veteran_type
- veteran_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
common_visa_type
- visa_type_id — uuid — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
confirmed_hire
- Key — uuid — Primary key — NOT NULL
- ... — ...
- notes — text
- created_at — timestamp(6)
- updated_at — timestamp(6)
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
corporation
- corporation_id — uuid — Primary key — NOT NULL
- parent_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- corporation_name — varchar(50)
- corporate_registration_number — varchar(50)
- business_registration_number — varchar(50)
- tax_office_code — varchar(50)
- business_code — varchar(50)
- confirm_date — timestamp(6)
- corporation_status — varchar(20)
- relationship_type — varchar(30)
- corporation_type — varchar(30)
- parent_corporation — varchar(30)
- corporation_prefix — varchar(30)
- industry_code — varchar(30)
- industry_type — varchar(50)
- business_type — varchar(50)
- business_items — varchar(200)
- dissolution_date — timestamp(6)
- establishment_date — timestamp(6)
- merger_date — timestamp(6)
- acquired_date — timestamp(6)
- inactive_date — timestamp(6)
- liquidation_date — timestamp(6)
- demerger_date — timestamp(6)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
corporation_agreement
- corporation_agreement_id — uuid — Primary key — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- agreement_number — varchar(150) — NOT NULL
- agreement_title — varchar(200) — NOT NULL
- agreement_content — text
- key_terms — text
- counterparty_corporation — varchar(200) — NOT NULL
- agreement_start_date — timestamp(6) — NOT NULL
- agreement_end_date — timestamp(6)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
corporation_certification
- corporation_certification_id — uuid — Primary key — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- issuing_organization — varchar(200) — NOT NULL
- awarding_institution — varchar(200)
- certification_number — varchar(100)
- certification_start_date — timestamp(6)
- certification_end_date — timestamp(6)
- is_active — bool — NOT NULL
- issue_date — timestamp(6) — NOT NULL
- suspension_date — timestamp(6)
- certification_type — varchar(100) — NOT NULL
- certification_name — varchar(200) — NOT NULL
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
department
- department_id — uuid — Primary key — NOT NULL
- parent_id — uuid — Foreign key → department.department_id — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- department_head_id — uuid — Foreign key → department_head.department_head_id — NOT NULL
- department_korean_name — varchar(200)
- department_english_name — varchar(200)
- department_status — varchar(30)
- department_type — varchar(30)
- department_code — varchar(30)
- establishment_date — timestamp(6)
- dissolution_date — timestamp(6)
- address — varchar(300)
- address_detail — varchar(300)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
department_head
- department_head_id — uuid — Primary key — NOT NULL
- employee_id — uuid
- notes — text
- created_at — timestamp(6)
- updated_at — timestamp(6)
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
director
- director_id — uuid — Primary key — NOT NULL
- director_type — varchar(30)
- employee_id — varchar(200)
- appointment_ceo_date — timestamp(6)
- appointment_director_date — timestamp(6)
- appointment_date — timestamp(6) — NOT NULL
- resignation_date — timestamp(6)
- term_end_date — timestamp(6)
- is_full_time — bool
- has_other_employment — bool
- director_name — varchar(50)
- is_director — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
disability_info
- disability_info_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- disability_type — varchar(30)
- disability_grade — varchar(30)
- disability_registration_number — varchar(200)
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
education
- education_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- education_type — varchar(30)
- enrollment_date — timestamp(6)
- graduation_date — timestamp(6)
- is_graduation — bool
- school_name — varchar(200)
- degree_name — varchar(200)
- degree_registration_number — varchar(200)
- campus_type — varchar(30)
- is_transfer — bool
- major — varchar(200)
- nationality — varchar(100)
- grade_point_average — double
- is_grade_point_average — bool
- is_verified — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
employee
- employee_id — uuid — Primary key — NOT NULL
- employee_number — varchar(100) — NOT NULL
- password — varchar(255)
- korean_name — varchar(50)
- english_name — varchar(100)
- employment_status — varchar(30) — NOT NULL
- employment_type — varchar(30)
- job — varchar(30)
- rank — varchar(30)
- position — varchar(30)
- gender — varchar(20)
- hire_date — timestamp(6)
- termination_date — timestamp(6)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
employee_approval
- employee_approval_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- approval_id — uuid — Foreign key → approval.approval_id — NOT NULL
- participant_role — varchar(20) — NOT NULL
- approval_status — varchar(20) — NOT NULL
- approval_type — varchar(20)
- approval_comment — text — ext
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
employee_contact
- employee_contact_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- personal_email — varchar(100)
- work_email — varchar(100)
- mobile_phone — varchar(100)
- work_phone — varchar(100)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
family_leave
- family_leave_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- leave_type — varchar(30)
- leave_start_date — timestamp(6)
- leave_end_date — timestamp(6)
- leave_return_date — timestamp(6)
- pay_percentage — double
- is_handover_completed — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
head_office_address
- head_office_address_id — uuid — Primary key — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- main_fax — varchar(50)
- main_phone — varchar(50)
- nationality — varchar(100)
- address — varchar(300)
- address_detail — varchar(300)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
language_certificate
- language_certificate_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- language — varchar(30)
- language_test_name — varchar(200)
- grade — varchar(200)
- issue_date — timestamp(6)
- issuing_organization — varchar(200)
- is_nationally_certified — bool
- is_verified — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
language_info
- language_info_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- nationality — varchar(100)
- speaking_level — varchar(30)
- writing_level — varchar(30)
- listening_level — varchar(30)
- is_native — bool
- is_verified — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
marital_info
- personal_info_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- is_marital — bool
- marriage_date — timestamp(6)
- is_children — bool
- number_of_children — int
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
menus
- menus_id — uuid — Primary key — NOT NULL
- parent_id — uuid — Foreign key → menus.menus_id — NOT NULL
- menu_name — varchar(100) — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- created_by — varchar(30)
- updated_by — varchar(30)
military_info
- military_info_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- military_service_status — varchar(30)
- military_service_start — timestamp(6)
- military_service_end — timestamp(6)
- military_service_type — varchar(30)
- military_rank — varchar(30)
- military_exemption_reason — text
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
minor
- minor_id — uuid — Primary key — NOT NULL
- education_id — uuid — Foreign key → education.education_id — NOT NULL
- minor_name — varchar(200)
- is_verified — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
nationality_info
- nationality_info_id — uuid — Primary key — NOT NULL
- corporation_id — uuid — Foreign key → corporation.corporation_id — NOT NULL
- local_representative_name — varchar(200)
- local_business_name — varchar(200)
- local_registration_number — varchar(200)
- address — varchar(200)
- address_detail — varchar(200)
- created_at — timestamp(6)
- updated_at — timestamp(6)
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
passport_info
- passport_info_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- passport_number — varchar(200)
- passport_issue_date — timestamp(6)
- passport_expiry_date — timestamp(6)
- passport_issuing_country — varchar(100)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
personal_info
- personal_info_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- national_id_number — varchar(100)
- nationality — varchar(100)
- religion — varchar(30)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
second_major
- second_major_id — uuid — Primary key — NOT NULL
- education_id — uuid — Foreign key → education.education_id — NOT NULL
- second_major_name — varchar(200)
- is_verified — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
unpaid_leave
- unpaid_leave_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- leave_type — varchar(30)
- leave_start_date — timestamp(6)
- leave_end_date — timestamp(6)
- leave_return_date — timestamp(6)
- pay_percentage — double
- is_handover_completed — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
veteran_info
- veteran_info_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- veteran_status — bool
- veteran_type — varchar(30)
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
visa_info
- visa_info_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- nationality — varchar(100)
- visa_type — varchar(100)
- visa_issue_date — timestamp(6)
- visa_expiry_date — timestamp(6)
- is_verified — bool
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)
work_accident
- work_accident_id — uuid — Primary key — NOT NULL
- employee_id — uuid — Foreign key → employee.employee_id — NOT NULL
- accident_date — timestamp(6)
- accident_location — varchar(200)
- accident_type — varchar(30)
- accident_description — text
- injury_type — varchar(30)
- body_part_injured — varchar(200)
- disability_rating — varchar(200)
- treatment_start_date — timestamp(6)
- treatment_end_date — timestamp(6)
- expected_recovery_date — timestamp(6)
- compensation_paid_date — timestamp(6)
- accident_report_date — timestamp(6)
- investigation_result — text
- notes — text
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
- created_by — varchar(30)
- updated_by — varchar(30)