CREATE TABLE IF NOT EXISTS "hrm_employee" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(255) NOT NULL,
    "job_number" varchar(64) DEFAULT NULL,
    "user_id" bigint DEFAULT NULL,
    "mobile" varchar(255) DEFAULT NULL,
    "country" varchar(64) DEFAULT NULL,
    "nation" varchar(64) DEFAULT NULL,
    "id_type" tinyint DEFAULT NULL,
    "id_number" varchar(255) DEFAULT NULL,
    "sex" tinyint DEFAULT NULL,
    "email" varchar(255) DEFAULT NULL,
    "native_place" varchar(128) DEFAULT NULL,
    "birthday" timestamp DEFAULT NULL,
    "age" int DEFAULT NULL,
    "address" varchar(255) DEFAULT NULL,
    "highest_education" tinyint DEFAULT NULL,
    "dept_id" bigint DEFAULT NULL,
    "leader_employee_id" bigint DEFAULT NULL,
    "entry_status" tinyint DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "type" tinyint DEFAULT NULL,
    "entry_time" timestamp DEFAULT NULL,
    "probation" int DEFAULT NULL,
    "regular_time" timestamp DEFAULT NULL,
    "leave_time" timestamp DEFAULT NULL,
    "post_name" varchar(255) DEFAULT NULL,
    "post_level" varchar(255) DEFAULT NULL,
    "work_city" varchar(64) DEFAULT NULL,
    "work_address" varchar(255) DEFAULT NULL,
    "work_detail_address" varchar(255) DEFAULT NULL,
    "channel_id" bigint DEFAULT NULL,
    "company_age_start_time" timestamp DEFAULT NULL,
    "company_age" int DEFAULT NULL,
    "candidate_id" bigint DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);
CREATE TABLE IF NOT EXISTS "hrm_employee_education_experience" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "education" tinyint DEFAULT NULL,
    "graduate_school" varchar(255) DEFAULT NULL,
    "major" varchar(255) DEFAULT NULL,
    "admission_time" timestamp DEFAULT NULL,
    "graduation_time" timestamp DEFAULT NULL,
    "teaching_methods" tinyint DEFAULT NULL,
    "first_degree" boolean DEFAULT NULL,
    "sort" int DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_employee_work_experience" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "work_unit" varchar(255) DEFAULT NULL,
    "post_name" varchar(255) DEFAULT NULL,
    "start_time" timestamp DEFAULT NULL,
    "end_time" timestamp DEFAULT NULL,
    "reason" varchar(1024) DEFAULT NULL,
    "witness_name" varchar(255) DEFAULT NULL,
    "witness_phone" varchar(32) DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "sort" int DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_employee_training_experience" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "course" varchar(128) DEFAULT NULL,
    "organization_name" varchar(128) DEFAULT NULL,
    "start_time" timestamp DEFAULT NULL,
    "end_time" timestamp DEFAULT NULL,
    "duration" varchar(64) DEFAULT NULL,
    "result" varchar(64) DEFAULT NULL,
    "certificate_name" varchar(128) DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "sort" int DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_employee_certificate" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "name" varchar(255) DEFAULT NULL,
    "level" varchar(255) DEFAULT NULL,
    "no" varchar(255) DEFAULT NULL,
    "start_time" timestamp DEFAULT NULL,
    "end_time" timestamp DEFAULT NULL,
    "issuing_authority" varchar(255) DEFAULT NULL,
    "issuing_time" timestamp DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "sort" int DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_employee_contact" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "name" varchar(64) DEFAULT NULL,
    "relation" varchar(64) DEFAULT NULL,
    "phone" varchar(40) DEFAULT NULL,
    "work_unit" varchar(128) DEFAULT NULL,
    "post_name" varchar(128) DEFAULT NULL,
    "address" varchar(255) DEFAULT NULL,
    "sort" int DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_employee_contract" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "no" varchar(128) DEFAULT NULL,
    "type" tinyint DEFAULT NULL,
    "start_time" timestamp DEFAULT NULL,
    "end_time" timestamp DEFAULT NULL,
    "term" int DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "sign_company" varchar(255) DEFAULT NULL,
    "sign_time" timestamp DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "expire_remind" boolean DEFAULT NULL,
    "sort" int DEFAULT NULL,
    "file_urls" varchar(2048) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_employee_file" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "type" tinyint NOT NULL,
    "url" varchar(512) NOT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_employee_change_record" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "type" tinyint DEFAULT NULL,
    "reason" tinyint DEFAULT NULL,
    "old_dept_id" bigint DEFAULT NULL,
    "new_dept_id" bigint DEFAULT NULL,
    "old_post_name" varchar(255) DEFAULT NULL,
    "new_post_name" varchar(255) DEFAULT NULL,
    "old_post_level" varchar(255) DEFAULT NULL,
    "new_post_level" varchar(255) DEFAULT NULL,
    "old_work_address" varchar(255) DEFAULT NULL,
    "new_work_address" varchar(255) DEFAULT NULL,
    "old_leader_employee_id" bigint DEFAULT NULL,
    "new_leader_employee_id" bigint DEFAULT NULL,
    "probation" int DEFAULT NULL,
    "effect_time" timestamp DEFAULT NULL,
    "applied_time" timestamp DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_employee_quit_info" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "plan_quit_time" timestamp DEFAULT NULL,
    "apply_quit_time" timestamp DEFAULT NULL,
    "salary_settlement_time" timestamp DEFAULT NULL,
    "type" tinyint DEFAULT NULL,
    "reason" tinyint DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "old_employee_status" tinyint DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_attendance_leave" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "type" varchar(64) DEFAULT NULL,
    "start_time" timestamp DEFAULT NULL,
    "end_time" timestamp DEFAULT NULL,
    "day" decimal(10, 2) DEFAULT NULL,
    "reason" varchar(300) DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "approval_status" tinyint NOT NULL,
    "process_instance_id" varchar(64) DEFAULT NULL,
    "approval_time" timestamp DEFAULT NULL,
    "approval_reason" varchar(500) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id"),
    CONSTRAINT "uk_hrm_attendance_leave_process_instance_id" UNIQUE ("process_instance_id")
);

CREATE TABLE IF NOT EXISTS "hrm_config" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "type" tinyint NOT NULL,
    "value" varchar(255) NOT NULL,
    "sort" int DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);


CREATE TABLE IF NOT EXISTS "hrm_employee_personal_note" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "content" varchar(1024) NOT NULL,
    "reminder_time" timestamp NOT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_recruit_post_type" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(40) DEFAULT NULL,
    "parent_id" bigint DEFAULT NULL,
    "sort" int DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_recruit_channel" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "system_flag" bit DEFAULT FALSE,
    "status" tinyint DEFAULT NULL,
    "name" varchar(255) NOT NULL,
    "sort" int DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_recruit_post" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "post_name" varchar(255) NOT NULL,
    "dept_id" bigint DEFAULT NULL,
    "job_nature" tinyint DEFAULT NULL,
    "area_id" int DEFAULT NULL,
    "recruit_num" int DEFAULT NULL,
    "reason" varchar(255) DEFAULT NULL,
    "work_time" tinyint DEFAULT NULL,
    "education_require" tinyint DEFAULT NULL,
    "min_salary" decimal(10, 2) DEFAULT NULL,
    "max_salary" decimal(10, 2) DEFAULT NULL,
    "salary_unit" tinyint DEFAULT NULL,
    "min_age" int DEFAULT NULL,
    "max_age" int DEFAULT NULL,
    "latest_entry_time" timestamp DEFAULT NULL,
    "owner_employee_id" bigint DEFAULT NULL,
    "interview_employee_ids" varchar(255) DEFAULT NULL,
    "description" varchar(4000) DEFAULT NULL,
    "emergency_level" tinyint DEFAULT NULL,
    "post_type_id" bigint DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "stop_reason" varchar(255) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_recruit_candidate" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(255) NOT NULL,
    "mobile" varchar(255) NOT NULL,
    "sex" tinyint NOT NULL,
    "age" int DEFAULT NULL,
    "email" varchar(255) DEFAULT NULL,
    "post_id" bigint NOT NULL,
    "stage_number" int DEFAULT NULL,
    "work_time" int DEFAULT NULL,
    "education" tinyint NOT NULL,
    "graduate_school" varchar(255) DEFAULT NULL,
    "latest_work_place" varchar(255) DEFAULT NULL,
    "channel_id" bigint DEFAULT NULL,
    "remark" varchar(255) DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "eliminate" varchar(255) DEFAULT NULL,
    "status_update_time" timestamp DEFAULT NULL,
    "entry_time" timestamp DEFAULT NULL,
    "resume_urls" varchar(4000) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_recruit_interview" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "candidate_id" bigint NOT NULL,
    "type" tinyint DEFAULT NULL,
    "stage_number" int DEFAULT NULL,
    "interview_employee_id" bigint DEFAULT NULL,
    "other_interview_employee_ids" varchar(255) DEFAULT NULL,
    "interview_time" timestamp DEFAULT NULL,
    "address" varchar(255) DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "result" tinyint DEFAULT NULL,
    "evaluate" varchar(255) DEFAULT NULL,
    "cancel_reason" varchar(255) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_attendance_group" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(50) NOT NULL,
    "dept_ids" varchar(4000) DEFAULT NULL,
    "employee_ids" varchar(4000) DEFAULT NULL,
    "open_wifi_card" boolean NOT NULL DEFAULT FALSE,
    "open_point_card" boolean NOT NULL DEFAULT FALSE,
    "shifts" varchar(10000) NOT NULL,
    "rest" boolean NOT NULL DEFAULT TRUE,
    "special_dates" varchar(4000) NOT NULL,
    "points" varchar(10000) NOT NULL,
    "wifis" varchar(10000) NOT NULL,
    "deduct_rule" varchar(4000) NOT NULL,
    "default_status" boolean NOT NULL DEFAULT FALSE,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_attendance_holiday" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "date" timestamp NOT NULL,
    "type" tinyint DEFAULT 2,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_attendance_clock" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint DEFAULT NULL,
    "clock_time" timestamp NOT NULL,
    "type" tinyint NOT NULL,
    "attendance_time" timestamp NOT NULL,
    "source_type" tinyint DEFAULT 2,
    "status" tinyint DEFAULT 0,
    "stage" int DEFAULT 1,
    "address" varchar(255) DEFAULT NULL,
    "longitude" decimal(10, 6) DEFAULT NULL,
    "latitude" decimal(10, 6) DEFAULT NULL,
    "ssid" varchar(50) DEFAULT NULL,
    "mac" varchar(50) DEFAULT NULL,
    "remark" varchar(255) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_config" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "cycle_start_day" int DEFAULT NULL,
    "cycle_end_day" int DEFAULT NULL,
    "social_security_month_type" tinyint DEFAULT NULL,
    "start_year" int DEFAULT NULL,
    "start_month" int DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id"),
    CONSTRAINT "uk_hrm_salary_config_tenant_id" UNIQUE ("tenant_id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_tax_rule" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(64) NOT NULL,
    "type" tinyint DEFAULT NULL,
    "tax_enabled" bit DEFAULT NULL,
    "threshold" decimal(12, 2) DEFAULT NULL,
    "decimal_scale" int DEFAULT NULL,
    "cycle_type" tinyint DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_group" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(64) NOT NULL,
    "salary_standard" decimal(12, 2) DEFAULT NULL,
    "change_rule" varchar(255) DEFAULT NULL,
    "dept_ids" varchar(20000) DEFAULT NULL,
    "employee_ids" varchar(20000) DEFAULT NULL,
    "tax_rule_id" bigint DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_option_template" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "code" int NOT NULL,
    "parent_code" int NOT NULL DEFAULT 0,
    "name" varchar(64) NOT NULL,
    "remark" varchar(255) DEFAULT NULL,
    "system_flag" boolean NOT NULL DEFAULT FALSE,
    "type" tinyint NOT NULL DEFAULT 1,
    "tax_enabled" boolean NOT NULL DEFAULT TRUE,
    "visible" boolean NOT NULL DEFAULT TRUE,
    "calculate_enabled" boolean NOT NULL DEFAULT TRUE,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    PRIMARY KEY ("id"),
    CONSTRAINT "uk_hrm_salary_option_template_code" UNIQUE ("code")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_option" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "code" int NOT NULL,
    "parent_code" int NOT NULL DEFAULT 0,
    "name" varchar(64) NOT NULL,
    "remark" varchar(255) DEFAULT NULL,
    "system_flag" boolean NOT NULL DEFAULT FALSE,
    "template_id" bigint DEFAULT NULL,
    "type" tinyint NOT NULL DEFAULT 1,
    "tax_enabled" boolean NOT NULL DEFAULT TRUE,
    "visible" boolean NOT NULL DEFAULT TRUE,
    "calculate_enabled" boolean NOT NULL DEFAULT TRUE,
    "enabled" boolean NOT NULL DEFAULT TRUE,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id"),
    CONSTRAINT "uk_hrm_salary_option_tenant_code" UNIQUE ("tenant_id", "code")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_employee_info" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "change_reason" tinyint DEFAULT NULL,
    "effect_time" timestamp DEFAULT NULL,
    "change_type" tinyint DEFAULT NULL,
    "probation_salary" decimal(12, 2) DEFAULT NULL,
    "regular_salary" decimal(12, 2) DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "salary_options" varchar(20000) DEFAULT NULL,
    "probation_salary_options" varchar(20000) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id"),
    CONSTRAINT "uk_hrm_salary_employee_info_employee_id" UNIQUE ("employee_id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_change_record" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "type" tinyint DEFAULT NULL,
    "reason" tinyint DEFAULT NULL,
    "effect_time" timestamp DEFAULT NULL,
    "before_total" decimal(12, 2) DEFAULT NULL,
    "after_total" decimal(12, 2) DEFAULT NULL,
    "probation_before_total" decimal(12, 2) DEFAULT NULL,
    "probation_after_total" decimal(12, 2) DEFAULT NULL,
    "salary_options" varchar(4000) DEFAULT NULL,
    "probation_salary_options" varchar(4000) DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_change_template" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(64) NOT NULL,
    "default_status" boolean NOT NULL DEFAULT FALSE,
    "options" varchar(4000) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_month_record" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "title" varchar(128) DEFAULT NULL,
    "year" int NOT NULL,
    "month" int NOT NULL,
    "employee_count" int DEFAULT NULL,
    "start_time" timestamp DEFAULT NULL,
    "end_time" timestamp DEFAULT NULL,
    "expected_pay_salary" decimal(12, 2) DEFAULT NULL,
    "personal_tax" decimal(12, 2) DEFAULT NULL,
    "real_pay_salary" decimal(12, 2) DEFAULT NULL,
    "personal_insurance_amount" decimal(12, 2) DEFAULT NULL,
    "personal_provident_fund_amount" decimal(12, 2) DEFAULT NULL,
    "corporate_insurance_amount" decimal(12, 2) DEFAULT NULL,
    "corporate_provident_fund_amount" decimal(12, 2) DEFAULT NULL,
    "option_headers" varchar(20000) DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_month_employee_record" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "month_record_id" bigint NOT NULL,
    "employee_id" bigint NOT NULL,
    "actual_work_day" decimal(10, 2) DEFAULT NULL,
    "need_work_day" decimal(10, 2) DEFAULT NULL,
    "year" int NOT NULL,
    "month" int NOT NULL,
    "expected_pay_salary" decimal(12, 2) DEFAULT NULL,
    "taxable_salary" decimal(12, 2) DEFAULT NULL,
    "personal_tax" decimal(12, 2) DEFAULT NULL,
    "real_pay_salary" decimal(12, 2) DEFAULT NULL,
    "option_values" varchar(20000) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_slip_template" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(64) NOT NULL,
    "hide_empty" boolean NOT NULL DEFAULT FALSE,
    "default_status" boolean NOT NULL DEFAULT FALSE,
    "options" varchar(20000) NOT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_slip_send_record" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "month_record_id" bigint NOT NULL,
    "employee_count" int DEFAULT NULL,
    "send_employee_count" int DEFAULT NULL,
    "year" int NOT NULL,
    "month" int NOT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_salary_slip" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "send_record_id" bigint NOT NULL,
    "month_employee_record_id" bigint NOT NULL,
    "employee_id" bigint NOT NULL,
    "year" int NOT NULL,
    "month" int NOT NULL,
    "read_status" tinyint DEFAULT NULL,
    "real_pay_salary" decimal(12, 2) DEFAULT NULL,
    "remark" varchar(500) DEFAULT NULL,
    "options" varchar(20000) NOT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_insurance_scheme" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(64) NOT NULL,
    "area_id" int DEFAULT NULL,
    "household_type" varchar(64) DEFAULT NULL,
    "type" tinyint NOT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_insurance_scheme_project" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "scheme_id" bigint NOT NULL,
    "type" tinyint NOT NULL,
    "name" varchar(64) NOT NULL,
    "base_amount" decimal(12, 2) DEFAULT NULL,
    "corporate_rate" decimal(10, 2) DEFAULT NULL,
    "personal_rate" decimal(10, 2) DEFAULT NULL,
    "corporate_amount" decimal(12, 2) DEFAULT NULL,
    "personal_amount" decimal(12, 2) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_insurance_employee_info" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "first_social_security" boolean NOT NULL DEFAULT FALSE,
    "first_accumulation_fund" boolean NOT NULL DEFAULT FALSE,
    "social_security_number" varchar(64) DEFAULT NULL,
    "accumulation_fund_number" varchar(64) DEFAULT NULL,
    "social_security_start_month" timestamp DEFAULT NULL,
    "scheme_id" bigint DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_employee_salary_card" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "employee_id" bigint NOT NULL,
    "bank_card_number" varchar(64) DEFAULT NULL,
    "bank_area_id" int DEFAULT NULL,
    "bank_name" varchar(64) DEFAULT NULL,
    "bank_branch_name" varchar(128) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_insurance_month_record" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "title" varchar(128) DEFAULT NULL,
    "year" int NOT NULL,
    "month" int NOT NULL,
    "insured_employee_count" int DEFAULT NULL,
    "stopped_employee_count" int DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "personal_insurance_amount" decimal(12, 2) DEFAULT NULL,
    "personal_provident_fund_amount" decimal(12, 2) DEFAULT NULL,
    "corporate_insurance_amount" decimal(12, 2) DEFAULT NULL,
    "corporate_provident_fund_amount" decimal(12, 2) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_insurance_month_employee_record" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "month_record_id" bigint NOT NULL,
    "employee_id" bigint NOT NULL,
    "scheme_id" bigint DEFAULT NULL,
    "year" int NOT NULL,
    "month" int NOT NULL,
    "personal_insurance_amount" decimal(12, 2) DEFAULT NULL,
    "personal_provident_fund_amount" decimal(12, 2) DEFAULT NULL,
    "corporate_insurance_amount" decimal(12, 2) DEFAULT NULL,
    "corporate_provident_fund_amount" decimal(12, 2) DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "projects" varchar(10000) NOT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_assessment_template" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(500) NOT NULL,
    "illustrate" varchar(1000) DEFAULT NULL,
    "score_calculation" tinyint DEFAULT 1,
    "upper_limit_type" tinyint DEFAULT 0,
    "upper_limit_score" decimal(10, 2) DEFAULT 100.00,
    "dimension_count" int DEFAULT 0,
    "quota_count" int DEFAULT 0,
    "dimensions" varchar(20000) NOT NULL,
    "status" tinyint DEFAULT 0,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_result_template" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(255) NOT NULL,
    "levels" varchar(20000) NOT NULL,
    "status" tinyint DEFAULT 0,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_plan" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name" varchar(255) NOT NULL,
    "cycle_type" tinyint DEFAULT NULL,
    "cycle" varchar(255) DEFAULT NULL,
    "quarter" tinyint DEFAULT NULL,
    "start_time" timestamp DEFAULT NULL,
    "end_time" timestamp DEFAULT NULL,
    "description" varchar(1000) DEFAULT NULL,
    "scopes" varchar(20000) NOT NULL,
    "assessment_template_id" bigint NOT NULL,
    "assessment_config" varchar(20000) NOT NULL,
    "result_template_id" bigint NOT NULL,
    "result_config" varchar(20000) NOT NULL,
    "quota_setting_type" tinyint NOT NULL DEFAULT 1,
    "target_confirmation" bit DEFAULT FALSE NOT NULL,
    "target_confirmation_stage" varchar(20000) DEFAULT NULL,
    "review_stages" varchar(20000) NOT NULL,
    "result_audit" bit DEFAULT TRUE NOT NULL,
    "result_audit_stages" varchar(20000) DEFAULT NULL,
    "result_confirmation" bit DEFAULT TRUE NOT NULL,
    "appeal_stages" varchar(20000) DEFAULT NULL,
    "appeal_timeout_days" int DEFAULT 2 NOT NULL,
    "appeal_timeout_action" tinyint DEFAULT 1 NOT NULL,
    "sync_to_salary" bit DEFAULT FALSE,
    "paid_for_month" varchar(20) DEFAULT NULL,
    "stage_type" tinyint DEFAULT 0,
    "status" tinyint DEFAULT 2,
    "operation_type" tinyint DEFAULT NULL,
    "terminate_time" timestamp DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_assessment" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "plan_id" bigint NOT NULL,
    "employee_id" bigint NOT NULL,
    "status" tinyint DEFAULT 2,
    "process_status" tinyint DEFAULT 1,
    "stage_type" tinyint DEFAULT 0,
    "stage_sort" int DEFAULT 0,
    "score" decimal(10, 2) DEFAULT 0.00,
    "result_level" varchar(64) DEFAULT NULL,
    "coefficient" decimal(10, 2) DEFAULT 1.00,
    "target_confirmation_result" tinyint DEFAULT NULL,
    "target_confirmation_comment" varchar(1000) DEFAULT NULL,
    "target_confirmation_time" timestamp DEFAULT NULL,
    "self_comment" varchar(2000) DEFAULT NULL,
    "reviewer_comment" varchar(2000) DEFAULT NULL,
    "result_comment" varchar(2000) DEFAULT NULL,
    "result_confirmation_time" timestamp DEFAULT NULL,
    "result_audit_status" tinyint DEFAULT NULL,
    "result_audit_time" timestamp DEFAULT NULL,
    "result_audit_reason" varchar(1000) DEFAULT NULL,
    "appeal_reason" varchar(1000) DEFAULT NULL,
    "appeal_file_urls" varchar(2000) DEFAULT NULL,
    "appeal_submit_time" timestamp DEFAULT NULL,
    "appeal_status" tinyint DEFAULT 0,
    "appeal_time" timestamp DEFAULT NULL,
    "appeal_comment" varchar(1000) DEFAULT NULL,
    "archive_time" timestamp DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_assessment_appeal_record" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "assessment_id" bigint NOT NULL,
    "stage_id" bigint NOT NULL,
    "status" tinyint NOT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_assessment_action_record" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "assessment_id" bigint NOT NULL,
    "stage_id" bigint DEFAULT NULL,
    "employee_id" bigint DEFAULT NULL,
    "type" tinyint NOT NULL,
    "title" varchar(128) NOT NULL,
    "content" varchar(2000) DEFAULT NULL,
    "file_urls" varchar(2000) DEFAULT NULL,
    "status" tinyint DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_assessment_stage" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "assessment_id" bigint NOT NULL,
    "type" tinyint NOT NULL,
    "name" varchar(128) NOT NULL,
    "handler_employee_id" bigint DEFAULT NULL,
    "rater_type" tinyint DEFAULT NULL,
    "weight" decimal(10, 2) DEFAULT NULL,
    "scoring_type" tinyint DEFAULT NULL,
    "visible_content" tinyint DEFAULT NULL,
    "required_setting" bit DEFAULT NULL,
    "reject_authority" bit DEFAULT NULL,
    "sort" int NOT NULL DEFAULT 0,
    "status" tinyint NOT NULL DEFAULT 0,
    "score" decimal(10, 2) DEFAULT NULL,
    "result_level" varchar(64) DEFAULT NULL,
    "comment" varchar(2000) DEFAULT NULL,
    "reject_reason" varchar(1000) DEFAULT NULL,
    "submit_time" timestamp DEFAULT NULL,
    "deadline_time" timestamp DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_assessment_quota_score" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "assessment_stage_id" bigint NOT NULL,
    "assessment_quota_id" bigint NOT NULL,
    "score" decimal(10, 2) NOT NULL,
    "comment" varchar(1000) DEFAULT NULL,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_assessment_dimension" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "assessment_id" bigint NOT NULL,
    "name" varchar(255) NOT NULL,
    "quota_type" tinyint DEFAULT NULL,
    "weight" decimal(10, 2) DEFAULT NULL,
    "remark" varchar(255) DEFAULT NULL,
    "allow_edit" bit NOT NULL DEFAULT FALSE,
    "sort" int NOT NULL DEFAULT 0,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);

CREATE TABLE IF NOT EXISTS "hrm_performance_assessment_quota" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "assessment_id" bigint NOT NULL,
    "dimension_id" bigint NOT NULL,
    "preset" bit NOT NULL DEFAULT TRUE,
    "name" varchar(255) DEFAULT NULL,
    "description" varchar(1000) DEFAULT NULL,
    "standard" varchar(1000) DEFAULT NULL,
    "weight" decimal(10, 2) DEFAULT 100.00,
    "score_type" tinyint DEFAULT NULL,
    "target_value" varchar(1000) DEFAULT NULL,
    "actual_value" varchar(1000) DEFAULT NULL,
    "self_score" decimal(10, 2) DEFAULT 0.00,
    "reviewer_score" decimal(10, 2) DEFAULT 0.00,
    "final_score" decimal(10, 2) DEFAULT 0.00,
    "sort" int DEFAULT 0,
    "creator" varchar(64) DEFAULT '',
    "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint NOT NULL DEFAULT 0,
    PRIMARY KEY ("id")
);