Skip to content

Resume Pasien
Compare
Choose a tag to compare
@mas-elkhanza mas-elkhanza released this 24 Sep 14:48
24.10.2019
5fd3973

menu baru untuk pembuatan resume pasien, resume bisa mengambil dari histori pemeriksaan sebelumnya

penambahan tabel :

CREATE TABLE resume_pasien (
no_rawat varchar(17) NOT NULL,
kd_dokter varchar(20) NOT NULL,
keluhan_utama text NOT NULL,
jalannya_penyakit text NOT NULL,
pemeriksaan_penunjang text NOT NULL,
hasil_laborat text NOT NULL,
diagnosa_utama varchar(80) NOT NULL,
kd_diagnosa_utama varchar(10) NOT NULL,
diagnosa_sekunder varchar(80) NOT NULL,
kd_diagnosa_sekunder varchar(10) NOT NULL,
diagnosa_sekunder2 varchar(80) NOT NULL,
kd_diagnosa_sekunder2 varchar(10) NOT NULL,
diagnosa_sekunder3 varchar(80) NOT NULL,
kd_diagnosa_sekunder3 varchar(10) NOT NULL,
diagnosa_sekunder4 varchar(80) NOT NULL,
kd_diagnosa_sekunder4 varchar(10) NOT NULL,
prosedur_utama varchar(80) NOT NULL,
kd_prosedur_utama varchar(8) NOT NULL,
prosedur_sekunder varchar(80) NOT NULL,
kd_prosedur_sekunder varchar(8) NOT NULL,
prosedur_sekunder2 varchar(80) NOT NULL,
kd_prosedur_sekunder2 varchar(8) NOT NULL,
prosedur_sekunder3 varchar(80) NOT NULL,
kd_prosedur_sekunder3 varchar(8) NOT NULL,
kondisi_pulang enum('Hidup','Meninggal') NOT NULL,
obat_pulang text NOT NULL,
PRIMARY KEY (no_rawat),
KEY kd_dokter (kd_dokter),
CONSTRAINT resume_pasien_ibfk_1 FOREIGN KEY (no_rawat) REFERENCES reg_periksa (no_rawat) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT resume_pasien_ibfk_2 FOREIGN KEY (kd_dokter) REFERENCES dokter (kd_dokter) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

hasil build rilis terakhir bisa dilihat di https://drive.google.com/drive/u/0/folders/1J8casyHvUVEY6Fgu8qWU5dvSC1cUT-Uc

Assets 2
Loading