576 lines
16 KiB
SQL
576 lines
16 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 5.2.1
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: 127.0.0.1
|
|
-- Waktu pembuatan: 27 Apr 2025 pada 17.34
|
|
-- Versi server: 10.4.28-MariaDB
|
|
-- Versi PHP: 8.0.28
|
|
|
|
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: `instalasi-simrs`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `billing`
|
|
--
|
|
|
|
CREATE TABLE `billing` (
|
|
`IdBilling` bigint(20) UNSIGNED NOT NULL,
|
|
`IdRegistrasi` bigint(20) UNSIGNED NOT NULL,
|
|
`TanggalBilling` date NOT NULL,
|
|
`TotalBiaya` decimal(12,2) NOT NULL,
|
|
`Dibayar` decimal(12,2) NOT NULL DEFAULT 0.00,
|
|
`Sisa` decimal(12,2) NOT NULL DEFAULT 0.00,
|
|
`StatusPembayaran` enum('Belum Lunas','Lunas') NOT NULL DEFAULT 'Belum Lunas',
|
|
`Keterangan` text DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `cache`
|
|
--
|
|
|
|
CREATE TABLE `cache` (
|
|
`key` varchar(255) NOT NULL,
|
|
`value` mediumtext NOT NULL,
|
|
`expiration` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `cache_locks`
|
|
--
|
|
|
|
CREATE TABLE `cache_locks` (
|
|
`key` varchar(255) NOT NULL,
|
|
`owner` varchar(255) NOT NULL,
|
|
`expiration` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `failed_jobs`
|
|
--
|
|
|
|
CREATE TABLE `failed_jobs` (
|
|
`id` bigint(20) UNSIGNED NOT NULL,
|
|
`uuid` varchar(255) NOT NULL,
|
|
`connection` text NOT NULL,
|
|
`queue` text NOT NULL,
|
|
`payload` longtext NOT NULL,
|
|
`exception` longtext NOT NULL,
|
|
`failed_at` timestamp NOT NULL DEFAULT current_timestamp()
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `jobs`
|
|
--
|
|
|
|
CREATE TABLE `jobs` (
|
|
`id` bigint(20) UNSIGNED NOT NULL,
|
|
`queue` varchar(255) NOT NULL,
|
|
`payload` longtext NOT NULL,
|
|
`attempts` tinyint(3) UNSIGNED NOT NULL,
|
|
`reserved_at` int(10) UNSIGNED DEFAULT NULL,
|
|
`available_at` int(10) UNSIGNED NOT NULL,
|
|
`created_at` int(10) UNSIGNED NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `job_batches`
|
|
--
|
|
|
|
CREATE TABLE `job_batches` (
|
|
`id` varchar(255) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`total_jobs` int(11) NOT NULL,
|
|
`pending_jobs` int(11) NOT NULL,
|
|
`failed_jobs` int(11) NOT NULL,
|
|
`failed_job_ids` longtext NOT NULL,
|
|
`options` mediumtext DEFAULT NULL,
|
|
`cancelled_at` int(11) DEFAULT NULL,
|
|
`created_at` int(11) NOT NULL,
|
|
`finished_at` int(11) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `migrations`
|
|
--
|
|
|
|
CREATE TABLE `migrations` (
|
|
`id` int(10) UNSIGNED NOT NULL,
|
|
`migration` varchar(255) NOT NULL,
|
|
`batch` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `migrations`
|
|
--
|
|
|
|
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
|
|
(1, '0001_01_01_000000_create_users_table', 1),
|
|
(2, '0001_01_01_000001_create_cache_table', 1),
|
|
(3, '0001_01_01_000002_create_jobs_table', 1),
|
|
(4, '2025_04_25_162039_create_ms_pasien_table', 1),
|
|
(5, '2025_04_25_162239_create_ms_asuransi_table', 1),
|
|
(6, '2025_04_25_162500_create_ms_pegawai_table', 1),
|
|
(7, '2025_04_25_162626_create_ms_ruang_pelayanan_table', 1),
|
|
(8, '2025_04_25_162751_create_tr_registrasi_table', 1),
|
|
(9, '2025_04_25_162848_create_ms_tindakan_table', 1),
|
|
(10, '2025_04_25_163033_create_tr_transaksi_table', 1),
|
|
(11, '2025_04_25_163200_create_billing_table', 1),
|
|
(12, '2025_04_26_003154_password_resets', 1),
|
|
(13, '2025_04_27_220814_create_tr_tindakan_table', 1);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `ms_asuransi`
|
|
--
|
|
|
|
CREATE TABLE `ms_asuransi` (
|
|
`IdAsuransi` bigint(20) UNSIGNED NOT NULL,
|
|
`NamaAsuransi` varchar(255) NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `ms_pasien`
|
|
--
|
|
|
|
CREATE TABLE `ms_pasien` (
|
|
`MRPasien` bigint(20) UNSIGNED NOT NULL,
|
|
`NamaPasien` varchar(255) NOT NULL,
|
|
`TanggalLahir` date NOT NULL,
|
|
`JenisKelamin` varchar(255) NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `ms_pegawai`
|
|
--
|
|
|
|
CREATE TABLE `ms_pegawai` (
|
|
`IdPegawai` bigint(20) UNSIGNED NOT NULL,
|
|
`NamaPegawai` varchar(255) NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `ms_ruang_pelayanan`
|
|
--
|
|
|
|
CREATE TABLE `ms_ruang_pelayanan` (
|
|
`IdRuangPelayanan` bigint(20) UNSIGNED NOT NULL,
|
|
`NamaRuangPelayanan` varchar(255) NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `ms_tindakan`
|
|
--
|
|
|
|
CREATE TABLE `ms_tindakan` (
|
|
`IdTindakan` bigint(20) UNSIGNED NOT NULL,
|
|
`NamaTindakan` varchar(255) NOT NULL,
|
|
`TarifTindakan` decimal(12,2) NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `password_resets`
|
|
--
|
|
|
|
CREATE TABLE `password_resets` (
|
|
`email` varchar(255) NOT NULL,
|
|
`token` varchar(255) NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `password_reset_tokens`
|
|
--
|
|
|
|
CREATE TABLE `password_reset_tokens` (
|
|
`email` varchar(255) NOT NULL,
|
|
`token` varchar(255) NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `sessions`
|
|
--
|
|
|
|
CREATE TABLE `sessions` (
|
|
`id` varchar(255) NOT NULL,
|
|
`user_id` bigint(20) UNSIGNED DEFAULT NULL,
|
|
`ip_address` varchar(45) DEFAULT NULL,
|
|
`user_agent` text DEFAULT NULL,
|
|
`payload` longtext NOT NULL,
|
|
`last_activity` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `tr_registrasi`
|
|
--
|
|
|
|
CREATE TABLE `tr_registrasi` (
|
|
`IdRegistrasi` bigint(20) UNSIGNED NOT NULL,
|
|
`TanggalRegistrasi` date NOT NULL,
|
|
`MRPasien` bigint(20) UNSIGNED NOT NULL,
|
|
`NomorKartuAsuransi` varchar(255) DEFAULT NULL,
|
|
`IdAsuransi` bigint(20) UNSIGNED DEFAULT NULL,
|
|
`IdPegawai` bigint(20) UNSIGNED NOT NULL,
|
|
`IdRuangPelayanan` bigint(20) UNSIGNED NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `tr_tindakan`
|
|
--
|
|
|
|
CREATE TABLE `tr_tindakan` (
|
|
`IdTransaksi` bigint(20) UNSIGNED NOT NULL,
|
|
`MRPasien` bigint(20) UNSIGNED NOT NULL,
|
|
`IdTindakan` bigint(20) UNSIGNED NOT NULL,
|
|
`TanggalTindakan` date NOT NULL,
|
|
`Keterangan` text DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `tr_transaksi`
|
|
--
|
|
|
|
CREATE TABLE `tr_transaksi` (
|
|
`IdTransaksi` bigint(20) UNSIGNED NOT NULL,
|
|
`IdRegistrasi` bigint(20) UNSIGNED NOT NULL,
|
|
`IdTindakan` bigint(20) UNSIGNED NOT NULL,
|
|
`JmlTindakan` int(11) NOT NULL DEFAULT 1,
|
|
`IdPegawai` bigint(20) UNSIGNED NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `users`
|
|
--
|
|
|
|
CREATE TABLE `users` (
|
|
`id` bigint(20) UNSIGNED NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`email` varchar(255) NOT NULL,
|
|
`email_verified_at` timestamp NULL DEFAULT NULL,
|
|
`password` varchar(255) NOT NULL,
|
|
`remember_token` varchar(100) DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indeks untuk tabel `billing`
|
|
--
|
|
ALTER TABLE `billing`
|
|
ADD PRIMARY KEY (`IdBilling`),
|
|
ADD KEY `billing_idregistrasi_foreign` (`IdRegistrasi`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `cache`
|
|
--
|
|
ALTER TABLE `cache`
|
|
ADD PRIMARY KEY (`key`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `cache_locks`
|
|
--
|
|
ALTER TABLE `cache_locks`
|
|
ADD PRIMARY KEY (`key`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `failed_jobs`
|
|
--
|
|
ALTER TABLE `failed_jobs`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `jobs`
|
|
--
|
|
ALTER TABLE `jobs`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `jobs_queue_index` (`queue`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `job_batches`
|
|
--
|
|
ALTER TABLE `job_batches`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `migrations`
|
|
--
|
|
ALTER TABLE `migrations`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `ms_asuransi`
|
|
--
|
|
ALTER TABLE `ms_asuransi`
|
|
ADD PRIMARY KEY (`IdAsuransi`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `ms_pasien`
|
|
--
|
|
ALTER TABLE `ms_pasien`
|
|
ADD PRIMARY KEY (`MRPasien`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `ms_pegawai`
|
|
--
|
|
ALTER TABLE `ms_pegawai`
|
|
ADD PRIMARY KEY (`IdPegawai`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `ms_ruang_pelayanan`
|
|
--
|
|
ALTER TABLE `ms_ruang_pelayanan`
|
|
ADD PRIMARY KEY (`IdRuangPelayanan`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `ms_tindakan`
|
|
--
|
|
ALTER TABLE `ms_tindakan`
|
|
ADD PRIMARY KEY (`IdTindakan`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `password_resets`
|
|
--
|
|
ALTER TABLE `password_resets`
|
|
ADD KEY `password_resets_email_index` (`email`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `password_reset_tokens`
|
|
--
|
|
ALTER TABLE `password_reset_tokens`
|
|
ADD PRIMARY KEY (`email`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `sessions`
|
|
--
|
|
ALTER TABLE `sessions`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `sessions_user_id_index` (`user_id`),
|
|
ADD KEY `sessions_last_activity_index` (`last_activity`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `tr_registrasi`
|
|
--
|
|
ALTER TABLE `tr_registrasi`
|
|
ADD PRIMARY KEY (`IdRegistrasi`),
|
|
ADD KEY `tr_registrasi_mrpasien_foreign` (`MRPasien`),
|
|
ADD KEY `tr_registrasi_idasuransi_foreign` (`IdAsuransi`),
|
|
ADD KEY `tr_registrasi_idpegawai_foreign` (`IdPegawai`),
|
|
ADD KEY `tr_registrasi_idruangpelayanan_foreign` (`IdRuangPelayanan`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `tr_tindakan`
|
|
--
|
|
ALTER TABLE `tr_tindakan`
|
|
ADD PRIMARY KEY (`IdTransaksi`),
|
|
ADD KEY `tr_tindakan_mrpasien_foreign` (`MRPasien`),
|
|
ADD KEY `tr_tindakan_idtindakan_foreign` (`IdTindakan`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `tr_transaksi`
|
|
--
|
|
ALTER TABLE `tr_transaksi`
|
|
ADD PRIMARY KEY (`IdTransaksi`),
|
|
ADD KEY `tr_transaksi_idregistrasi_foreign` (`IdRegistrasi`),
|
|
ADD KEY `tr_transaksi_idtindakan_foreign` (`IdTindakan`),
|
|
ADD KEY `tr_transaksi_idpegawai_foreign` (`IdPegawai`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `users`
|
|
--
|
|
ALTER TABLE `users`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD UNIQUE KEY `users_email_unique` (`email`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel yang dibuang
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `billing`
|
|
--
|
|
ALTER TABLE `billing`
|
|
MODIFY `IdBilling` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `failed_jobs`
|
|
--
|
|
ALTER TABLE `failed_jobs`
|
|
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `jobs`
|
|
--
|
|
ALTER TABLE `jobs`
|
|
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `migrations`
|
|
--
|
|
ALTER TABLE `migrations`
|
|
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `ms_asuransi`
|
|
--
|
|
ALTER TABLE `ms_asuransi`
|
|
MODIFY `IdAsuransi` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `ms_pasien`
|
|
--
|
|
ALTER TABLE `ms_pasien`
|
|
MODIFY `MRPasien` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `ms_pegawai`
|
|
--
|
|
ALTER TABLE `ms_pegawai`
|
|
MODIFY `IdPegawai` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `ms_ruang_pelayanan`
|
|
--
|
|
ALTER TABLE `ms_ruang_pelayanan`
|
|
MODIFY `IdRuangPelayanan` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `ms_tindakan`
|
|
--
|
|
ALTER TABLE `ms_tindakan`
|
|
MODIFY `IdTindakan` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `tr_registrasi`
|
|
--
|
|
ALTER TABLE `tr_registrasi`
|
|
MODIFY `IdRegistrasi` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `tr_tindakan`
|
|
--
|
|
ALTER TABLE `tr_tindakan`
|
|
MODIFY `IdTransaksi` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `tr_transaksi`
|
|
--
|
|
ALTER TABLE `tr_transaksi`
|
|
MODIFY `IdTransaksi` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `users`
|
|
--
|
|
ALTER TABLE `users`
|
|
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
|
|
--
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel `billing`
|
|
--
|
|
ALTER TABLE `billing`
|
|
ADD CONSTRAINT `billing_idregistrasi_foreign` FOREIGN KEY (`IdRegistrasi`) REFERENCES `tr_registrasi` (`IdRegistrasi`);
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel `tr_registrasi`
|
|
--
|
|
ALTER TABLE `tr_registrasi`
|
|
ADD CONSTRAINT `tr_registrasi_idasuransi_foreign` FOREIGN KEY (`IdAsuransi`) REFERENCES `ms_asuransi` (`IdAsuransi`),
|
|
ADD CONSTRAINT `tr_registrasi_idpegawai_foreign` FOREIGN KEY (`IdPegawai`) REFERENCES `ms_pegawai` (`IdPegawai`),
|
|
ADD CONSTRAINT `tr_registrasi_idruangpelayanan_foreign` FOREIGN KEY (`IdRuangPelayanan`) REFERENCES `ms_ruang_pelayanan` (`IdRuangPelayanan`),
|
|
ADD CONSTRAINT `tr_registrasi_mrpasien_foreign` FOREIGN KEY (`MRPasien`) REFERENCES `ms_pasien` (`MRPasien`);
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel `tr_tindakan`
|
|
--
|
|
ALTER TABLE `tr_tindakan`
|
|
ADD CONSTRAINT `tr_tindakan_idtindakan_foreign` FOREIGN KEY (`IdTindakan`) REFERENCES `ms_tindakan` (`IdTindakan`),
|
|
ADD CONSTRAINT `tr_tindakan_mrpasien_foreign` FOREIGN KEY (`MRPasien`) REFERENCES `ms_pasien` (`MRPasien`);
|
|
|
|
--
|
|
-- Ketidakleluasaan untuk tabel `tr_transaksi`
|
|
--
|
|
ALTER TABLE `tr_transaksi`
|
|
ADD CONSTRAINT `tr_transaksi_idpegawai_foreign` FOREIGN KEY (`IdPegawai`) REFERENCES `ms_pegawai` (`IdPegawai`),
|
|
ADD CONSTRAINT `tr_transaksi_idregistrasi_foreign` FOREIGN KEY (`IdRegistrasi`) REFERENCES `tr_registrasi` (`IdRegistrasi`),
|
|
ADD CONSTRAINT `tr_transaksi_idtindakan_foreign` FOREIGN KEY (`IdTindakan`) REFERENCES `ms_tindakan` (`IdTindakan`);
|
|
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 */;
|