Lewati ke konten utama

Database Full Catalog

Total table terdeteksi dari migration: 56.

Alter-Migration Impact Matrix

TableOperation type (ringkas)Last changeRisk note
account_notification_preferenceadd-index:1, column-change:4, create-table:12024_09_11_165723_create_table_account_notification_preferences.php:19 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
accountsadd-index:1, add-or-modify-column:4, column-change:7, create-table:1, drop-column:1, drop-index:12024_10_19_073627_set_password_column_to_nullable.php:25 (add-or-modify-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
bannersadd-index:1, add-or-modify-column:4, column-change:4, create-table:1, drop-column:3, drop-index:12025_05_02_164222_add_deleted_at_at_banners_table.php:25 (column-change)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
card_expiration_datesadd-index:3, add-or-modify-column:4, column-change:4, create-table:12025_07_03_164613_create_card_expiration_dates_table.php:26 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
chatsadd-or-modify-column:5, column-change:5, create-table:12024_08_09_000002_create_chats_table.php:27 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
countersadd-or-modify-column:1, column-change:3, create-table:12025_07_21_181111_create_counters_table.php:18 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
coupon_claimsadd-index:4, add-or-modify-column:1, column-change:7, create-table:1, drop-column:2, drop-index:22025_08_29_155102_add_soft_delete_to_coupon_claims_table.php:25 (column-change)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
coupon_failed_logsadd-foreign:1, add-index:1, add-or-modify-column:3, column-change:3, create-table:12025_11_25_154905_create_failed_logs_table.php:23 (add-foreign)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
coupon_informationadd-or-modify-column:1, column-change:4, create-table:12025_08_29_155208_add_soft_delete_to_coupon_informations_table.php:25 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
coupon_logsadd-or-modify-column:2, column-change:2, create-table:12025_09_09_155516_create_coupon_logs_table.php:18 (add-or-modify-column)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
coupon_storecolumn-change:3, create-table:12024_07_22_073918_create_coupon_stores_table.php:17 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
couponsadd-index:6, add-or-modify-column:13, column-change:5, create-table:1, drop-column:7, drop-index:42025_08_29_155040_add_soft_delete_to_coupons_table.php:25 (column-change)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
course_slotsadd-or-modify-column:2, column-change:6, create-table:12024_08_15_083213_create_course_slots_table.php:22 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
coursesadd-index:5, add-or-modify-column:5, column-change:5, create-table:12024_09_26_101716_change_price_column_type_in_courses_table.php:25 (add-or-modify-column)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
dialogsadd-or-modify-column:4, column-change:4, create-table:1, drop-column:12025_03_07_093543_add_position_column_to_dialogs_table.php:25 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
facilitiesadd-index:1, add-or-modify-column:1, column-change:2, create-table:12024_06_25_035015_create_facilities_table.php:18 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
failed_jobsadd-or-modify-column:6, column-change:1, create-table:12019_08_19_000000_create_failed_jobs_table.php:23 (add-or-modify-column)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
favorite_storescolumn-change:3, create-table:12024_07_16_072654_create_favorite_store_table.php:17 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
identificationsadd-or-modify-column:1, column-change:1, create-table:12024_07_29_062838_create_identifications_table.php:16 (add-or-modify-column)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
imagesadd-index:1, add-or-modify-column:2, column-change:3, create-table:1, drop-column:1, drop-index:12024_09_02_033823_add_type_to_images_table.php:26 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
job_batchesadd-or-modify-column:10, create-table:12025_07_21_213100_create_job_batches_table.php:24 (add-or-modify-column)LOW — Perubahan stabil.
jobsadd-index:1, add-or-modify-column:1, column-change:5, create-table:12024_06_26_014840_create_jobs_table.php:21 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
membership_addressesadd-index:1, add-or-modify-column:14, column-change:10, create-table:1, drop-column:12024_12_02_172100_add_pos_columns_to_membership_addresses_table.php:32 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
membership_detailsadd-index:3, add-or-modify-column:32, column-change:6, create-table:1, drop-column:3, drop-foreign:22024_12_02_172409_add_pos_columns_to_membership_details_table.php:32 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
membership_newscolumn-change:4, create-table:12024_12_19_104532_create_table_membership_news_table.php:18 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
membership_notificationscolumn-change:3, create-table:12024_08_13_065520_create_membership_notifications.php:17 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
membershipsadd-index:4, add-or-modify-column:26, column-change:13, create-table:1, drop-column:9, drop-index:42026_02_10_070825_change_points_columns_for_memberships.php:27 (column-change)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
national_holidaysadd-or-modify-column:2, column-change:3, create-table:12025_10_21_100855_create_national_holidays_table.php:21 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
navigate_dialogsadd-or-modify-column:1, column-change:5, create-table:1, drop-column:12025_02_12_172600_add_position_to_navigate_dialogs_table.php:25 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
newsadd-index:3, add-or-modify-column:8, column-change:5, create-table:1, drop-column:5, drop-foreign:1, drop-index:22025_06_03_184350_add_memo_column_to_news_table.php:25 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
notification_preferencesadd-index:1, add-or-modify-column:3, column-change:2, create-table:1, drop-column:12024_09_29_154830_add_topic_subscription_to_notification_preferences_table.php:25 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
notificationsadd-or-modify-column:5, column-change:2, create-table:12024_06_20_054502_create_notifications_table.php:23 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
occupationsadd-or-modify-column:1, column-change:1, create-table:12024_06_25_062457_create_occupations_table.php:16 (add-or-modify-column)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
otpsadd-or-modify-column:7, column-change:2, create-table:12024_06_20_054502_create_otps_table.php:26 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
password_resetsadd-index:1, add-or-modify-column:2, create-table:12014_10_12_100000_create_password_resets_table.php:19 (add-or-modify-column)LOW — Perubahan stabil.
personal_access_tokensadd-or-modify-column:5, column-change:3, create-table:12019_12_14_000001_create_personal_access_tokens_table.php:24 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
pos_membershipsadd-index:4, add-or-modify-column:53, column-change:4, create-table:12025_08_07_150912_drop_unique_index_in_pos_memberships.php:26 (alter)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
push_notification_tokensadd-index:1, add-or-modify-column:2, column-change:3, create-table:1, drop-column:1, drop-index:12024_10_23_085110_add_type_to_push_notification_tokens_table.php:27 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
push_notificationsadd-index:2, add-or-modify-column:3, column-change:5, create-table:1, drop-column:2, drop-index:22024_10_24_105133_add_is_segmented_to_push_notifications_table.php:26 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
qr_codesadd-or-modify-column:3, column-change:4, create-table:12025_03_06_112820_create_qr_codes_table.php:21 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
region_addressesadd-index:2, add-or-modify-column:5, column-change:3, create-table:12024_06_26_022410_create_addresses_table.php:24 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
region_citiesadd-or-modify-column:3, column-change:3, create-table:12024_06_26_022325_create_cities_table.php:20 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
region_districtsadd-or-modify-column:4, column-change:3, create-table:12024_06_26_022346_create_districts_table.php:21 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
region_prefecturesadd-or-modify-column:3, column-change:2, create-table:12024_06_26_022308_create_prefectures_table.php:19 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
remote_configsadd-index:3, column-change:2, create-table:12025_06_09_124625_create_remote_configs_table.php:19 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
reservationsadd-index:4, add-or-modify-column:6, column-change:7, create-table:1, drop-column:3, drop-index:22025_06_03_185230_add_memo_column_to_reservations_table.php:25 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
reserved_coursesadd-index:3, add-or-modify-column:4, column-change:5, create-table:1, drop-column:1, drop-index:12024_12_12_193430_add_day_type_to_reserved_courses_table.php:26 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
room_chatsadd-index:2, add-or-modify-column:2, column-change:3, create-table:1, drop-column:2, drop-index:22025_01_02_142109_add_last_activity_date_to_room_chats_table.php:26 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
social_mediaadd-index:1, add-or-modify-column:1, column-change:7, create-table:1, drop-column:12024_09_19_110600_add_new_columns_to_social_medias_table.php:29 (column-change)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
stamp_campaignsadd-or-modify-column:2, column-change:5, create-table:12024_11_06_093605_create_stamp_campaigns_table.php:21 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
stampsadd-index:5, add-or-modify-column:1, column-change:5, create-table:1, drop-column:5, drop-index:42025_04_29_161904_add_column_used_as_visit_history_in_stamps_table.php:26 (drop-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
store_facilitiescolumn-change:3, create-table:12024_07_15_061209_create_store_facilities_table.php:17 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
store_locationsadd-or-modify-column:3, column-change:3, create-table:12024_07_09_031646_create_store_locations_table.php:20 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
storesadd-index:2, add-or-modify-column:7, column-change:7, create-table:1, drop-column:12025_01_03_101526_add_code_to_stores_table.php:27 (column-change)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.
topic_subscriptionsadd-or-modify-column:1, column-change:4, create-table:12024_10_17_170645_create_topic_subscriptions_table.php:19 (column-change)MEDIUM — Ada perubahan relasi/struktur; validasi query & integritas data.
usersadd-index:1, add-or-modify-column:7, column-change:8, create-table:1, drop-column:4, drop-index:12024_10_29_095647_remove_username_from_users_table.php:26 (add-or-modify-column)HIGH — Ada operasi drop/rename; cek backward compatibility + data safety.

Alter-impact completeness checklist (Cycle 3)

ScopeCoverage statusNotes
All detected table names in migration history✅ Complete (56/56)Setiap table sudah punya operasi + migration pointer.
drop-column / drop-index / drop-foreign high-risk tagging✅ CompleteSemua operasi drop ditandai HIGH di risk note.
Last-touched migration pointer per table✅ CompleteDipakai untuk trace rollback/forward paling dekat.
Critical business tables (memberships, coupons, reservations, news)✅ CompleteSudah punya ringkasan operasi + risk tinggi.

Source pointers

TableCreated inLast touched migration
account_notification_preference2024_09_11_165723_create_table_account_notification_preferences.php:142024_09_11_165723_create_table_account_notification_preferences.php:19
accounts2024_06_19_053937_create_accounts_table.php:142024_10_19_073627_set_password_column_to_nullable.php:25
banners2024_09_20_113500_create_banners_table.php:142025_05_02_164222_add_deleted_at_at_banners_table.php:25
card_expiration_dates2025_07_03_164613_create_card_expiration_dates_table.php:142025_07_03_164613_create_card_expiration_dates_table.php:26
chats2024_08_09_000002_create_chats_table.php:142024_08_09_000002_create_chats_table.php:27
counters2025_07_21_181111_create_counters_table.php:142025_07_21_181111_create_counters_table.php:18
coupon_claims2024_07_22_090050_create_coupon_claims_table.php:142025_08_29_155102_add_soft_delete_to_coupon_claims_table.php:25
coupon_failed_logs2025_11_25_154905_create_failed_logs_table.php:142025_11_25_154905_create_failed_logs_table.php:23
coupon_information2024_07_22_073909_create_coupon_information_table.php:142025_08_29_155208_add_soft_delete_to_coupon_informations_table.php:25
coupon_logs2025_09_09_155516_create_coupon_logs_table.php:142025_09_09_155516_create_coupon_logs_table.php:18
coupon_store2024_07_22_073918_create_coupon_stores_table.php:142024_07_22_073918_create_coupon_stores_table.php:17
coupons2024_07_22_073128_create_coupons_table.php:142025_08_29_155040_add_soft_delete_to_coupons_table.php:25
course_slots2024_08_15_083213_create_course_slots_table.php:142024_08_15_083213_create_course_slots_table.php:22
courses2024_08_15_071304_create_courses_table.php:142024_09_26_101716_change_price_column_type_in_courses_table.php:25
dialogs2024_08_22_053835_create_dialogs_table.php:142025_03_07_093543_add_position_column_to_dialogs_table.php:25
facilities2024_06_25_035015_create_facilities_table.php:142024_06_25_035015_create_facilities_table.php:18
failed_jobs2019_08_19_000000_create_failed_jobs_table.php:162019_08_19_000000_create_failed_jobs_table.php:23
favorite_stores2024_07_16_072654_create_favorite_store_table.php:142024_07_16_072654_create_favorite_store_table.php:17
identifications2024_07_29_062838_create_identifications_table.php:142024_07_29_062838_create_identifications_table.php:16
images2024_07_16_013341_create_images_table.php:142024_09_02_033823_add_type_to_images_table.php:26
job_batches2025_07_21_213100_create_job_batches_table.php:142025_07_21_213100_create_job_batches_table.php:24
jobs2024_06_26_014840_create_jobs_table.php:142024_06_26_014840_create_jobs_table.php:21
membership_addresses2024_07_22_060923_create_membership_addresses_table.php:142024_12_02_172100_add_pos_columns_to_membership_addresses_table.php:32
membership_details2024_07_22_055610_create_membership_details_table.php:142024_12_02_172409_add_pos_columns_to_membership_details_table.php:32
membership_news2024_12_19_104532_create_table_membership_news_table.php:142024_12_19_104532_create_table_membership_news_table.php:18
membership_notifications2024_08_13_065520_create_membership_notifications.php:142024_08_13_065520_create_membership_notifications.php:17
memberships2024_07_22_052918_create_memberships_table.php:142026_02_10_070825_change_points_columns_for_memberships.php:27
national_holidays2025_10_21_100855_create_national_holidays_table.php:142025_10_21_100855_create_national_holidays_table.php:21
navigate_dialogs2024_08_22_053844_create_navigate_dialogs_table.php:142025_02_12_172600_add_position_to_navigate_dialogs_table.php:25
news2024_07_31_082151_create_news_table.php:142025_06_03_184350_add_memo_column_to_news_table.php:25
notification_preferences2024_09_11_165226_create_notification_preferences_table.php:142024_09_29_154830_add_topic_subscription_to_notification_preferences_table.php:25
notifications2024_06_20_054502_create_notifications_table.php:162024_06_20_054502_create_notifications_table.php:23
occupations2024_06_25_062457_create_occupations_table.php:142024_06_25_062457_create_occupations_table.php:16
otps2024_06_20_054502_create_otps_table.php:162024_06_20_054502_create_otps_table.php:26
password_resets2014_10_12_100000_create_password_resets_table.php:162014_10_12_100000_create_password_resets_table.php:19
personal_access_tokens2019_12_14_000001_create_personal_access_tokens_table.php:162019_12_14_000001_create_personal_access_tokens_table.php:24
pos_memberships2025_07_14_124031_create_pos_memberships_table.php:142025_08_07_150912_drop_unique_index_in_pos_memberships.php:26
push_notification_tokens2024_08_12_053242_create_push_notification_tokens_table.php:142024_10_23_085110_add_type_to_push_notification_tokens_table.php:27
push_notifications2024_08_12_085713_create_push_notifications_table.php:142024_10_24_105133_add_is_segmented_to_push_notifications_table.php:26
qr_codes2025_03_06_112820_create_qr_codes_table.php:142025_03_06_112820_create_qr_codes_table.php:21
region_addresses2024_06_26_022410_create_addresses_table.php:142024_06_26_022410_create_addresses_table.php:24
region_cities2024_06_26_022325_create_cities_table.php:142024_06_26_022325_create_cities_table.php:20
region_districts2024_06_26_022346_create_districts_table.php:142024_06_26_022346_create_districts_table.php:21
region_prefectures2024_06_26_022308_create_prefectures_table.php:142024_06_26_022308_create_prefectures_table.php:19
remote_configs2025_06_09_124625_create_remote_configs_table.php:142025_06_09_124625_create_remote_configs_table.php:19
reservations2024_08_22_063155_create_reservations_table.php:142025_06_03_185230_add_memo_column_to_reservations_table.php:25
reserved_courses2024_08_22_065803_create_reserved_courses_table.php:142024_12_12_193430_add_day_type_to_reserved_courses_table.php:26
room_chats2024_08_09_000001_create_room_chats_table.php:142025_01_02_142109_add_last_activity_date_to_room_chats_table.php:26
social_media2024_09_09_034957_create_social_media_table.php:142024_09_19_110600_add_new_columns_to_social_medias_table.php:29
stamp_campaigns2024_11_06_093605_create_stamp_campaigns_table.php:142024_11_06_093605_create_stamp_campaigns_table.php:21
stamps2024_09_02_035407_create_stamps_table.php:142025_04_29_161904_add_column_used_as_visit_history_in_stamps_table.php:26
store_facilities2024_07_15_061209_create_store_facilities_table.php:142024_07_15_061209_create_store_facilities_table.php:17
store_locations2024_07_09_031646_create_store_locations_table.php:142024_07_09_031646_create_store_locations_table.php:20
stores2024_07_09_031217_create_stores_table.php:142025_01_03_101526_add_code_to_stores_table.php:27
topic_subscriptions2024_10_17_170645_create_topic_subscriptions_table.php:142024_10_17_170645_create_topic_subscriptions_table.php:19
users2014_10_12_000000_create_users_table.php:162024_10_29_095647_remove_username_from_users_table.php:26