DELIMITER $$

ALTER ALGORITHM=UNDEFINED DEFINER=`khanza_rsip`@`%` SQL SECURITY DEFINER VIEW `v_jasmed` AS (
SELECT `rawat_inap_dr`.`no_rawat` AS `no_rawat`,`rawat_inap_dr`.`kd_jenis_prw` AS `kd_jenis_prw`,`rawat_inap_dr`.`kd_dokter` AS `kd_dokter`,'' AS `nip`,`rawat_inap_dr`.`tgl_perawatan` AS `tgl_perawatan`,`rawat_inap_dr`.`jam_rawat` AS `jam_rawat`,`rawat_inap_dr`.`material` AS `material`,`rawat_inap_dr`.`bhp` AS `bhp`,`rawat_inap_dr`.`tarif_tindakandr` AS `tarif_tindakandr`,0 AS `tarif_tindakanpr`,`rawat_inap_dr`.`kso` AS `kso`,`rawat_inap_dr`.`menejemen` AS `menejemen`,`rawat_inap_dr`.`biaya_rawat` AS `biaya_rawat` FROM `rawat_inap_dr`) UNION (SELECT `rawat_inap_drpr`.`no_rawat` AS `no_rawat`,`rawat_inap_drpr`.`kd_jenis_prw` AS `kd_jenis_prw`,`rawat_inap_drpr`.`kd_dokter` AS `kd_dokter`,`rawat_inap_drpr`.`nip` AS `nip`,`rawat_inap_drpr`.`tgl_perawatan` AS `tgl_perawatan`,`rawat_inap_drpr`.`jam_rawat` AS `jam_rawat`,`rawat_inap_drpr`.`material` AS `material`,`rawat_inap_drpr`.`bhp` AS `bhp`,`rawat_inap_drpr`.`tarif_tindakandr` AS `tarif_tindakandr`,`rawat_inap_drpr`.`tarif_tindakanpr` AS `tarif_tindakanpr`,`rawat_inap_drpr`.`kso` AS `kso`,`rawat_inap_drpr`.`menejemen` AS `menejemen`,`rawat_inap_drpr`.`biaya_rawat` AS `biaya_rawat` FROM `rawat_inap_drpr`)$$

DELIMITER ;