Script DB Pasien

--
-- Database: `db_pasien`
--

-- --------------------------------------------------------

--
-- Table structure for table `dokter`
--

CREATE TABLE `dokter` (
  `Id_dokter` int(10) NOT NULL,
  `Nama_dokter` varchar(50) NOT NULL,
  `Alamat_dokter` text NOT NULL,
  `Jenis_kelamin_dokter` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `dokter_spesialis`
--

CREATE TABLE `dokter_spesialis` (
  `Id_dokter` int(10) NOT NULL,
  `Kode_spesialis` varchar(10) NOT NULL,
  `Tgl_lulus` date NOT NULL DEFAULT '0000-00-00',
  `Kampus_asal` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `jabatan_spesialis`
--

CREATE TABLE `jabatan_spesialis` (
  `Kode_spesialis` varchar(8) NOT NULL,
  `Nama_spesialis` varchar(70) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jabatan_spesialis`
--

INSERT INTO `jabatan_spesialis` (`Kode_spesialis`, `Nama_spesialis`) VALUES
('SPJP', 'Spesialis Jantung');

-- --------------------------------------------------------

--
-- Table structure for table `pasien`
--

CREATE TABLE `pasien` (
  `Id_pasien` varchar(15) NOT NULL,
  `Nama_pasien` varchar(50) NOT NULL,
  `Alamat_pasien` text NOT NULL,
  `Jenis_kelamin_pasien` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `rekam_medik`
--

CREATE TABLE `rekam_medik` (
  `Id_rekam_medik` int(11) NOT NULL,
  `Id_pasien` varchar(15) NOT NULL,
  `Id_dokter` int(10) NOT NULL,
  `Tgl_diagnosa` date NOT NULL DEFAULT '0000-00-00',
  `Keluhan` text NOT NULL,
  `Hasil_diagnosa` text NOT NULL,
  `Tindakan_diberikan` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `dokter`
--
ALTER TABLE `dokter`
  ADD PRIMARY KEY (`Id_dokter`);

--
-- Indexes for table `dokter_spesialis`
--
ALTER TABLE `dokter_spesialis`
  ADD PRIMARY KEY (`Id_dokter`,`Kode_spesialis`);

--
-- Indexes for table `jabatan_spesialis`
--
ALTER TABLE `jabatan_spesialis`
  ADD PRIMARY KEY (`Kode_spesialis`);

--
-- Indexes for table `pasien`
--
ALTER TABLE `pasien`
  ADD PRIMARY KEY (`Id_pasien`);

--
-- Indexes for table `rekam_medik`
--
ALTER TABLE `rekam_medik`
  ADD PRIMARY KEY (`Id_rekam_medik`),
  ADD KEY `Id_pasien` (`Id_pasien`,`Id_dokter`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `dokter`
--
ALTER TABLE `dokter`
  MODIFY `Id_dokter` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rekam_medik`
--
ALTER TABLE `rekam_medik`
  MODIFY `Id_rekam_medik` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;