Index of /isha_security/database/migrations

• Parent Directory
• 2014_10_12_000000_create_users_table.php
• 2014_10_12_100000_create_password_resets_table.php
• 2019_08_19_000000_create_failed_jobs_table.php
• 2021_03_10_084242_create_factories_table.php
• 2021_03_10_084406_create_tw_city_table.php
• 2021_03_10_084425_create_tw_cityarea_table.php
• 2021_03_10_084448_create_industry_parent_table.php
• 2021_03_10_084509_create_industry_cate_table.php
• 2021_03_22_061634_create_chemical_label_table.php
• 2021_03_22_061733_create_chemical_label_sub_table.php
• 2021_03_22_062352_create_chemicals_table.php
• 2021_03_22_062718_create_factory_chemical_table.php
• 2021_03_24_140135_create_machine_parent_table.php
• 2021_03_24_140201_create_machine_table.php
• 2021_03_24_140225_create_factory_machine_table.php
• 2021_03_25_153955_create_employees_table.php
• 2021_03_29_180544_add_certificate_subtype_table.php
• 2021_03_29_180659_add_certificate_table.php
• 2021_03_30_141649_create_employee_certificate_table.php
• 2021_04_16_104014_rm__col__profitid_in__factory.php
• 2021_04_16_143258_revise_users_column_table.php
• 2021_04_19_164800_add_token_to_users_table.php
• 2021_04_20_175754_add_machine_to_factories.php
• 2021_04_22_152815_remove_process_in_factories.php
• 2021_04_22_153231_create_factory_uploads_table.php
• 2021_04_23_095256_add_mach_to_factories_table_2.php
• 2021_04_23_162200_create_employee_harms_table.php
• 2021_04_26_101402_rm_chems_in_employees.php
• 2021_04_26_123414_add_nums_in_factories.php
• 2021_04_26_134957_add_checks_in_machine.php
• 2021_06_07_162609_create_sheet_chemicals_table.php
• 2021_06_08_122005_add_cas_and_accept_in_chemicals_table.php
• 2021_06_08_163414_create_sheet_physics_table.php
• 2021_06_16_170200_change_cat_type_sheet_chemicals_table.php
• 2021_06_16_170715_change_types_sheet_physics_table.php
• 2021_06_18_153052_add_state_in_factory_chemical_table.php
• 2021_06_18_153533_create_exam_state_table.php
• 2021_06_18_153740_add_period_in_chemicals_table.php
• 2021_07_09_140948_create_health_exams_table.php
• 2021_07_09_142022_create_health_examitems_table.php
• 2021_07_09_142112_create_health_itemdetails_table.php
• 2021_07_09_142431_create_health_ex_ques_table.php
• 2021_07_09_143307_create_health_employee_sheet_table.php
• 2021_07_09_144135_create_health_sheet_answer_table.php
• 2021_07_23_144250_create_license_type_table.php
• 2021_07_23_164716_create_licenses_table.php
• 2021_07_23_164845_create_license_uploads_table.php
• 2021_08_02_114241_factory_certificates.php
• 2021_08_04_140045_add_harms_in_employee_health.php
• 2021_08_04_155612_create_employee_harms_history_table.php
• 2021_08_05_115607_create_harms_and_certificate_table.php
• 2021_08_26_154521_add_role_in_users_table.php
• 2021_08_27_135805_create_training_table.php
• 2021_08_27_135913_create_training_status_table.php
• 2021_08_27_135940_create_employee_training_table.php
• 2021_08_27_140103_create_employee_training_uploads_table.php
• 2021_08_27_140154_create_employee_training_hour_table.php
• 2021_08_27_140210_create_employee_training_status_table.php
• 2021_08_31_091852_add_realname_in_employee_training_uploads_table.php
• 2021_09_06_163022_add_realname_in_license_uploads.php
• 2021_09_08_155417_add_year_created_to_factory_machine_table.php
• 2021_09_10_151015_create_factory_machine_exam.php
• 2021_09_14_162521_create_machine_checkitems_table.php
• 2021_09_14_170600_create_factory_machine_item_ans_table.php
• 2021_09_15_101209_add_foreign_key_in_machine_checkitems.php
• 2021_09_15_101545_add_foreign_key_in_factory_machine_exam.php
• 2021_09_15_101847_add_foreign_key_in_factory_machine_item_ans.php
• 2021_09_15_102511_add_foreign_key_in_factory_machine.php
• 2021_09_23_122133_add_rule_check_in_factory_machine_exam.php
• 2021_09_28_172734_create_machine_files_table.php
• 2021_10_06_160217_add_custom_name_in_factory_machine.php
• 2021_10_06_160307_add_pass_in_factory_machine.php
• 2021_10_07_102704_create_employee_machines_table.php
• 2021_10_25_102858_create_news_type_table.php
• 2021_10_25_102910_create_news_table.php
• 2021_11_05_115957_add_soft_delete_to_users_table.php
• 2021_11_09_152631_add_personal_details_in_users_table.php
• 2021_11_09_155517_add_state_in_users_table.php
• 2021_11_09_161232_add_ask_delete_in_users_table.php
• 2021_11_11_143248_add_state_to_employees.php
• 2021_11_15_170037_create_notification_health_table.php
• 2021_11_15_170206_create_notification_monitor_table.php
• 2021_11_15_170425_create_notification_machine_table.php
• 2021_11_15_170506_create_notification_certificate_table.php
• 2021_11_17_114935_create_law_table.php
• 2021_11_17_120934_create_law_chapter_table.php
• 2021_11_17_121216_create_law_rules_table.php
• 2021_11_23_151635_change_condition_id_in_law_rules.php
• 2021_12_07_141528_create_certificate_hours.php
• 2021_12_07_153516_rename_training_id_in_employee_training.php
• 2022_01_12_122438_create_machine_certificate_table.php
• 2022_02_07_142905_add_month_exam_in_factory_machine_table.php
• 2022_02_07_152632_create_factory_machine_exam_month_table.php
• 2022_02_07_155245_create_factory_machine_month_item_ans_table.php
• 2022_02_08_150947_add_nullable_in_employee_health_table.php
• 2022_02_09_121135_add_soft_delete_in_employee_health_table.php
• 2022_02_09_122807_add_soft_delete_in_licenses_table.php
• 2022_02_09_123212_add_soft_delete_in_employee_training_table.php
• 2022_02_16_140748_create_machine_checkitems_month_table.php
• 2022_02_16_141648_modify_factory_machine_month_item_ans_table.php
• 2022_03_01_113458_create_monitor_sheet.php
• 2022_03_01_160641_create_monitor_uploads_table.php
• 2022_04_12_104936_change_revenue_to_bigint_in_factories_table.php
• 2022_04_12_111152_add_foreign_key_to_employee_and_factories_in_employees_table.php
• 2022_04_18_150349_add_deleted_at_in_law_rules_table.php
• 2022_04_21_160804_add_foreign_key_in_factory_chemical_table.php
• 2022_04_27_093822_create_messages_table.php
• 2022_04_27_094002_create_message_reply_table.php
• 2022_05_22_095225_create_ir_roles_table.php
• 2022_05_23_095518_create_subusers_table.php
• 2022_05_23_153611_create_ir_projects_table.php
• 2022_05_24_114301_create_ir_areas_table.php
• 2022_05_31_122615_add_main_account_id_in_subusers_table.php
• 2022_05_31_154440_add_api_token_in_subusers_table.php
• 2022_06_01_093926_create_ir_factory_regions_table.php
• 2022_06_01_112704_create_ir_sections_table.php
• 2022_06_02_113111_create_ir_boxes_table.php
• 2022_06_06_140221_create_ir_project_sections_table.php
• 2022_06_06_175307_create_ir_results_table.php
• 2022_06_08_140853_create_ir_result_boxes_table.php
• 2022_06_09_154036_add_month_year_check_in_machine_table.php
• 2022_06_14_140155_add_month_fields_in_machine_files_table.php
• 2022_06_14_140615_add_nullable_fields_in_machine_files_table.php
• 2022_06_15_155139_create_user_valid_emails_table.php
• 2022_07_08_093834_add_soft_delete_in_employee_certificate_table.php
• 2022_07_14_150439_add_columns_in_ir_result_boxes_table.php
• 2022_07_14_152022_create_ir_result_box_high_temps_table.php
• 2022_07_22_135026_change_box_img_to_nullable_in_ir_result_boxes_table.php
• 2022_07_22_163806_add_csv_in_ir_result_boxes_table.php
• 2022_08_15_171839_create_ir_init_box_types_table.php
• 2022_08_15_172104_create_ir_init_boxes_table.php
• 2022_08_22_175154_add_max_in_ir_init_box_types_table.php
• 2022_09_06_170220_add_box_img_ai_in_ir_result_boxes_table.php
• 2022_09_13_104254_add_project_date_to_nullable_in_ir_projects_table.php
• 2022_09_13_104911_create_ir_project_dates_table.php
• 2022_09_14_101115_create_ir_result_box_partials_table.php
• 2022_09_14_101212_add_ir_project_date_id_in_ir_results_table.php
• 2022_09_14_180529_add_nullable_in_ir_boxes_table.php
• 2022_09_15_144842_add_csv_field_in_ir_result_box_partials_table.php
• 2022_09_29_151135_add_examiner_id_in_ir_project_dates_table.php
• 2022_10_07_173113_add_image_rects_in_ir_result_boxes_table.php
• 2022_10_07_173434_add_image_rects_in_ir_result_box_partials_table.php
• 2022_10_24_144245_create_ir_devices_table.php
• 2022_10_24_144512_create_ir_device_analyses_table.php
• 2022_10_31_164054_add_soft_delete_in_factory_chemical_table.php
• 2022_10_31_165001_add_soft_delete_in_employees_table.php
• 2022_10_31_165117_add_soft_delete_in_factory_machine_table.php
• 2022_11_23_100829_create_factory_alerms_table.php
• 2022_11_25_144721_add_factory_id_nullable_in_licenses_table.php
• 2022_12_01_153237_create_factory_alerm_messages_table.php
• 2022_12_05_151436_add_soft_delete_in_license_uploads_table.php
• 2022_12_05_181556_add_default_value_in_licenses_table.php
• 2022_12_06_162621_add_soft_delete_in_employee_harms_table.php
• 2022_12_07_141808_add_soft_delete_in_employee_machines_table.php
• 2022_12_16_165031_add_priority_in_ir_device_analyses_table.php
• 2023_01_05_170240_create_health_normal_exams_table.php
• 2023_01_05_170340_create_employee_health_normal_exams_table.php
• 2023_01_05_170403_create_employee_health_normal_details_table.php
• 2023_01_05_180748_create_employee_health_normal_uploads_table.php
• 2023_01_06_123350_add_health_normal_state_in_employees.php
• 2023_01_06_135935_create_health_states_table.php
• 2023_01_07_155409_add_result_in_health_states_table.php
• 2023_01_13_123044_add_sub_account_columns_in_users_table.php
• 2023_01_13_140038_create_permissions_table.php
• 2023_01_13_140812_create_user_permissions_table.php
• 2023_01_17_102718_create_ir_report_records_table.php
• 2023_01_17_102739_create_ir_report_record_detects_table.php
• 2023_01_17_141717_add_sub_account_attributes_in_subusers_table.php
• 2023_01_30_094745_add_name_zh_in_permissions_table.php
• 2023_01_30_153451_add_fk_in_ir_roles_table.php
• 2023_01_30_153549_create_ir_permissions_table.php
• 2023_01_30_153601_create_ir_role_permissions_table.php
• 2023_02_01_150157_add_is_admin_in_subusers_table.php
• 2023_02_02_120727_insert_ir_default_roles_for_existed_subusers.php
• 2023_02_14_104200_add_box_img_thermal_to_ir_report_records.php
• 2023_02_14_104248_add_box_img_thermal_to_ir_report_record_detects.php
• 2023_02_16_104121_add_date_range_and_type_to_ir_projects.php
• 2023_02_16_122143_create_ir_project_boxes_table.php
• 2023_02_18_150329_add_has_second_to_ir_report_records.php
• 2023_03_01_173305_add_not_unique_on_email_in_users_table.php
• 2023_03_07_114431_create_user_login_logs_table.php
• 2023_03_08_142237_change_harms_length_in_employee_health_table.php
• 2023_03_14_140640_add_second_columns_to_ir_results.php
• 2023_03_14_141156_add_second_columns_to_ir_result_box_partials.php
• 2023_03_14_141413_add_second_columns_to_ir_report_record_detects.php
• 2023_03_16_121436_add_priority_to_ir_report_records.php
• 2023_04_11_181601_add_state_to_ir_results.php
• 2023_04_17_144621_add_is_teacher_to_subusers.php
• 2023_05_02_165018_add_ir_use_to_users.php
• 2023_05_03_132411_add_is_counselor_to_subusers.php
• 2023_05_03_141406_add_teacher_counselor_to_subusers.php
• 2023_05_31_182631_create_factory_machine_checkitems.php
• 2023_06_29_171700_add_sheet_flag_to_factory_machine.php
• 2023_06_29_171819_add_sheet_flag_to_factory_machine_exam.php
• 2023_06_29_174451_create_factory_machine_check_ans.php
• 2023_06_29_183650_create_factory_machine_check_month_ans.php
• 2023_07_11_161332_add_must_note_str_to_factory_machine_check_item.php
• 2023_07_14_103221_add_check_sheet_to_factory_machine_check_ans.php
• 2023_07_25_154614_add_angle_to_ir_result_boxes.php
• 2023_07_25_154802_add_angle_to_ir_result_box_partials.php
• 2023_08_09_124038_change_hour_type_to_employee_training_hour.php
• 2023_08_16_134907_add_second_feedback_to_ir_results.php
• 2023_08_21_134936_create_factory_alerms_list.php
• 2023_09_01_161116_add_lock_to_factory_machine_check_class.php
• 2023_09_27_162521_add_second_feedback_to_ir_report_record_detects.php
• 2023_09_28_170212_add_counselor_to_ir_results.php
• 2023_10_19_182909_create_quest_and_answer.php
• 2023_10_30_112351_create_chemical_hazard.php
• 2023_10_31_121033_add_field_to_chemicals.php
• 2023_10_31_123400_create_chemical_details.php
• 2023_10_31_141938_create_chemical_mixture.php
• 2023_10_31_143108_add_field_to_factory_chemical.php
• 2023_11_28_095106_add_field_to_monitor_sheet.php
• 2023_11_28_111422_add_field_to_factory_chemical_workspaces.php
• 2023_12_01_102427_add_field_to_chemicals_and_factory_chemical.php
• 2023_12_01_103140_add_field_to_factory_chemical_mixtures.php
• 2023_12_05_114610_create_chemical_risk.php
• 2023_12_26_120637_add_cert_no_to_chemical.php
• 2024_01_03_154942_create_jobs_table.php
• 2024_01_22_100951_add_box_img_to_ir_report_records.php
• 2024_06_07_162341_add_manager_sex_to_factories.php
• 2025_08_13_094118_add_notify_field.php
• 2025_10_07_143131_add_industrial_park_name_to_factories_table.php
• 2025_10_08_152645_create_report_table.php
• 2025_10_17_153200_add_report_date_to_report_table.php
• 2026_05_06_093957_create_user_system_roles_table.php
• 2026_05_06_100536_create_sub_systems_table.php
• 2026_05_07_174446_add_uuid_to_users_table.php
• 2026_06_11_000001_create_cb_monitor_table.php
• 2026_07_24_144634_create_sub_systems_web_counter_table.php
• 2026_08_06_105131_create_sub_systems_web_daily_stats_table.php
• 2026_08_18_000001_sync_factory_chemical_certificates_from_master.php
• 2026_08_20_105203_create_cm_factory_table.php
• 2026_08_24_000001_add_gender_employee_breakdown_to_factories_table.php
• 2026_09_04_000001_add_contact_to_cm_factory_table.php