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)