-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Apr 11, 2025 at 09:07 AM -- Server version: 8.0.30 -- PHP Version: 8.1.10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `qris_template` -- -- -------------------------------------------------------- -- -- Table structure for table `bypass_records` -- CREATE TABLE `bypass_records` ( `id` bigint UNSIGNED NOT NULL, `device_id` bigint UNSIGNED NOT NULL, `bypass_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `devices` -- CREATE TABLE `devices` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `outlet_id` bigint UNSIGNED NOT NULL, `device_status` enum('off','washer','dryer') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `devices` -- INSERT INTO `devices` (`id`, `name`, `code`, `outlet_id`, `device_status`, `created_at`, `updated_at`) VALUES (1, 'Device Testing', 'DEV-WHNTZR', 1, 'off', '2025-04-11 09:00:30', '2025-04-11 09:00:30'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `manual_transaction_details` -- CREATE TABLE `manual_transaction_details` ( `id` bigint UNSIGNED NOT NULL, `transaction_id` bigint UNSIGNED NOT NULL, `cashier_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE `members` ( `id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `is_verify` tinyint(1) NOT NULL DEFAULT '0', `user_id` bigint UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `member_transaction_details` -- CREATE TABLE `member_transaction_details` ( `id` bigint UNSIGNED NOT NULL, `transaction_id` bigint UNSIGNED NOT NULL, `member_id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (354, '2014_10_12_000000_create_users_table', 1), (355, '2014_10_12_100000_create_password_reset_tokens_table', 1), (356, '2014_10_12_100000_create_password_resets_table', 1), (357, '2019_08_19_000000_create_failed_jobs_table', 1), (358, '2019_12_14_000001_create_personal_access_tokens_table', 1), (359, '2023_10_21_155446_create_owners_table', 1), (360, '2023_10_21_155449_create_outlets_table', 1), (361, '2025_03_04_140228_add_role_and_permissions_to_users_table', 1), (362, '2025_03_05_131814_create_devices_table', 1), (363, '2025_03_05_151019_create_members_table', 1), (364, '2025_03_05_161928_create_transactions_table', 1), (365, '2025_03_05_161929_create_manual_transaction_details_table', 1), (366, '2025_03_05_161929_create_member_transaction_details_table', 1), (367, '2025_03_05_161929_create_qris_transaction_details_table', 1), (368, '2025_03_07_113846_create_topup_histories_table', 1), (369, '2025_03_19_111118_create_subscription_table', 1), (370, '2025_03_26_142514_create_bypass_records_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `outlets` -- CREATE TABLE `outlets` ( `id` bigint UNSIGNED NOT NULL, `owner_id` bigint UNSIGNED DEFAULT NULL, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `timezone` enum('WIB','WITA','WIT') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'WIB' COMMENT 'Indonesian Time Zones: WIB (Western Indonesian Time), WITA (Central Indonesian Time), WIT (Eastern Indonesian Time)', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `outlets` -- INSERT INTO `outlets` (`id`, `owner_id`, `code`, `address`, `username`, `password`, `status`, `timezone`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 'OUT-CAA6D1', 'Jl. Padalarang', 'uniguard_main', '$2y$10$0exbEb2fqvelDYlOgiQ5Ceo0CZeyF5c5kAeJVnY9AHSweKY9ChkyO', 1, 'WIB', '2025-04-11 08:54:11', '2025-04-11 08:54:11', NULL); -- -------------------------------------------------------- -- -- Table structure for table `owners` -- CREATE TABLE `owners` ( `id` bigint UNSIGNED NOT NULL, `brand_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `brand_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `brand_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `owners` -- INSERT INTO `owners` (`id`, `brand_name`, `brand_logo`, `brand_email`, `address`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'UNIGUARD INDONESIA', NULL, 'info@uniguard.co.id', 'Jl. Padalarang - Cisarua', 3, '2025-04-11 08:41:29', '2025-04-11 08:41:29', NULL); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `qris_transaction_details` -- CREATE TABLE `qris_transaction_details` ( `id` bigint UNSIGNED NOT NULL, `transaction_id` bigint UNSIGNED NOT NULL, `payment_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `qr_code_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `channel_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `receipt_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `subscription` -- CREATE TABLE `subscription` ( `member_id` bigint UNSIGNED NOT NULL, `owner_id` bigint UNSIGNED NOT NULL, `is_verified` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `amount` int NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `topup_histories` -- CREATE TABLE `topup_histories` ( `id` bigint UNSIGNED NOT NULL, `member_id` bigint UNSIGNED NOT NULL, `outlet_id` bigint UNSIGNED DEFAULT NULL, `owner_id` bigint UNSIGNED NOT NULL, `amount` int NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `timezone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `cashier_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` bigint UNSIGNED NOT NULL, `owner_id` bigint UNSIGNED NOT NULL, `outlet_id` bigint UNSIGNED DEFAULT NULL, `device_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `order_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` int NOT NULL, `timezone` enum('wib','wita','wit') COLLATE utf8mb4_unicode_ci NOT NULL, `date` date NOT NULL DEFAULT '2025-04-11', `time` time NOT NULL DEFAULT '15:30:17', `type` enum('manual','qris','member') COLLATE utf8mb4_unicode_ci NOT NULL, `service_type` enum('washer','dryer') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Service type: washer atau dryer', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role` enum('admin','owner','member') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'member', `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `image`, `email`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'admin', NULL, 'admin@mail.com', NULL, '$2a$12$tKUsCYxyKlu3vUOZ82furut2yGSQRlTNm.65BxYFOkRLDHxtghAv2', 'admin', NULL, '2025-04-11 08:30:18', '2025-04-11 08:30:18'), (3, 'Tyto Mulyono', NULL, 'tyto@uniguard.co.id', NULL, '$2y$10$JpW/86vCjhkJ8..8sZ6tpuAaSZGVT.ryJqM0FiMuC/VUCr87t3TKy', 'owner', NULL, '2025-04-11 08:41:29', '2025-04-11 08:41:29'); -- -- Indexes for dumped tables -- -- -- Indexes for table `bypass_records` -- ALTER TABLE `bypass_records` ADD PRIMARY KEY (`id`), ADD KEY `bypass_records_device_id_foreign` (`device_id`); -- -- Indexes for table `devices` -- ALTER TABLE `devices` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `devices_code_unique` (`code`), ADD KEY `devices_outlet_id_foreign` (`outlet_id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `manual_transaction_details` -- ALTER TABLE `manual_transaction_details` ADD PRIMARY KEY (`id`), ADD KEY `manual_transaction_details_transaction_id_foreign` (`transaction_id`); -- -- Indexes for table `members` -- ALTER TABLE `members` ADD PRIMARY KEY (`id`), ADD KEY `members_user_id_foreign` (`user_id`); -- -- Indexes for table `member_transaction_details` -- ALTER TABLE `member_transaction_details` ADD PRIMARY KEY (`id`), ADD KEY `member_transaction_details_transaction_id_foreign` (`transaction_id`), ADD KEY `member_transaction_details_member_id_foreign` (`member_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `outlets` -- ALTER TABLE `outlets` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `outlets_code_unique` (`code`), ADD UNIQUE KEY `outlets_username_unique` (`username`), ADD KEY `outlets_owner_id_foreign` (`owner_id`); -- -- Indexes for table `owners` -- ALTER TABLE `owners` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `owners_brand_email_unique` (`brand_email`), ADD KEY `owners_user_id_foreign` (`user_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `qris_transaction_details` -- ALTER TABLE `qris_transaction_details` ADD PRIMARY KEY (`id`), ADD KEY `qris_transaction_details_transaction_id_foreign` (`transaction_id`); -- -- Indexes for table `subscription` -- ALTER TABLE `subscription` ADD PRIMARY KEY (`member_id`,`owner_id`), ADD KEY `subscription_owner_id_foreign` (`owner_id`); -- -- Indexes for table `topup_histories` -- ALTER TABLE `topup_histories` ADD PRIMARY KEY (`id`), ADD KEY `topup_histories_member_id_foreign` (`member_id`), ADD KEY `topup_histories_outlet_id_foreign` (`outlet_id`), ADD KEY `topup_histories_owner_id_foreign` (`owner_id`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`), ADD KEY `transactions_owner_id_foreign` (`owner_id`), ADD KEY `transactions_outlet_id_foreign` (`outlet_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `bypass_records` -- ALTER TABLE `bypass_records` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `devices` -- ALTER TABLE `devices` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `manual_transaction_details` -- ALTER TABLE `manual_transaction_details` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `members` -- ALTER TABLE `members` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `member_transaction_details` -- ALTER TABLE `member_transaction_details` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=371; -- -- AUTO_INCREMENT for table `outlets` -- ALTER TABLE `outlets` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `owners` -- ALTER TABLE `owners` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `qris_transaction_details` -- ALTER TABLE `qris_transaction_details` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `topup_histories` -- ALTER TABLE `topup_histories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- Constraints for dumped tables -- -- -- Constraints for table `bypass_records` -- ALTER TABLE `bypass_records` ADD CONSTRAINT `bypass_records_device_id_foreign` FOREIGN KEY (`device_id`) REFERENCES `devices` (`id`) ON DELETE CASCADE; -- -- Constraints for table `devices` -- ALTER TABLE `devices` ADD CONSTRAINT `devices_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `outlets` (`id`) ON DELETE CASCADE; -- -- Constraints for table `manual_transaction_details` -- ALTER TABLE `manual_transaction_details` ADD CONSTRAINT `manual_transaction_details_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `members` -- ALTER TABLE `members` ADD CONSTRAINT `members_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `member_transaction_details` -- ALTER TABLE `member_transaction_details` ADD CONSTRAINT `member_transaction_details_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `member_transaction_details_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `outlets` -- ALTER TABLE `outlets` ADD CONSTRAINT `outlets_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `owners` (`id`) ON DELETE CASCADE; -- -- Constraints for table `owners` -- ALTER TABLE `owners` ADD CONSTRAINT `owners_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `qris_transaction_details` -- ALTER TABLE `qris_transaction_details` ADD CONSTRAINT `qris_transaction_details_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `subscription` -- ALTER TABLE `subscription` ADD CONSTRAINT `subscription_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `subscription_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `owners` (`id`) ON DELETE CASCADE; -- -- Constraints for table `topup_histories` -- ALTER TABLE `topup_histories` ADD CONSTRAINT `topup_histories_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `topup_histories_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `outlets` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `topup_histories_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `owners` (`id`) ON DELETE CASCADE; -- -- Constraints for table `transactions` -- ALTER TABLE `transactions` ADD CONSTRAINT `transactions_outlet_id_foreign` FOREIGN KEY (`outlet_id`) REFERENCES `outlets` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `transactions_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `owners` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;