-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `k2177113_dokumen`
--

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

--
-- Table structure for table `ms_dokumen`
--

CREATE TABLE `ms_dokumen` (
  `Dok_id` varchar(25) NOT NULL,
  `Nama_Dokumen` varchar(200) DEFAULT NULL,
  `Jenis_Dokumen` varchar(50) DEFAULT NULL,
  `User_id` varchar(50) DEFAULT NULL,
  `Last_edit` datetime DEFAULT NULL,
  `Status` int(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ms_dokumen`
--

INSERT INTO `ms_dokumen` (`Dok_id`, `Nama_Dokumen`, `Jenis_Dokumen`, `User_id`, `Last_edit`, `Status`) VALUES
('HSSE-FR-001', 'PEMENUHAN DAN EVALUASI PERATURAN PERUNDANGAN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-002', 'REKAPITULASI REGULASI K3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-003', 'Identifikasi Bahaya, Penilaian Risiko dan Penentuan Kontrol HIRADC (Hazardous Identification, Risk Assestment, And Determining Control)', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-004', 'TUJUAN, SASARAN, DAN PROGRAM K3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-005', 'Monitoring Sasaran K3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-006', 'Manajemen perubahan', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-007', 'Daftar induk dokumen internal - SMK3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-008', 'Daftar induk dokumen eksternal - SMK3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-009', 'DAFTAR DISTRIBUSI DOKUMEN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-010', 'BERITA ACARA PEMUSNAHAN DOKUMEN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-011', 'RIWAYAT PERUBAHAN DOKUMEN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-012', 'DAFTAR INDUK REKAMAN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-013', 'MATRIKS KOMPETENSI DAN IDENTIFIKASI KEBUTUHAN PELATIHAN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-014', 'ANALISIS KEBUTUHAN PELATIHAN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-015', 'PROGRAM PELATIHAN INTERNAL-SMK3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-016', 'EVALUASI PELAKSANAAN DAN EFEKTIVITAS PELATIHAN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-017', 'DAFTAR RIWAYAT PESERTA PELATIHAN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-018', 'KOMUNIKASI K3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-019', 'STATISTIK K3- FREQUENCY RATE AND SEVERITY RATE WORKSHEET', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-020', 'CHECKLIST KEADAAN DARURAT', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-021', 'BERITA ACARA KEJADIAN KEADAAN DARURAT', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-022', 'LAPORAN PENYELIDIKAN KECELAKAAN KEJADIAN K3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-023', 'FORMULIR PEMERIKSAAN ISI TAS P3K', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-024', 'FORMULIR PEMAKAIAN ISI TAS P3K SEBAGAN TINDAKAN P3K', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-025', 'ITEM INSPEKSI RUTIN OPERASIONAL K3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-026', 'PANDUAN SAFETY BRIEFING K3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-027', 'SAFETY INDUCTION', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-028', 'Surat Ijin Kerja Aman', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-029', 'JADWAL PEMANTAUAN DAN PENGUKURAN K3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-030', 'DAFTAR ITEM INSPEKSI SMK3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-031', 'Jadwal Inspeksi SMK3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-032', 'laporan Inspeksi SMK3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-033', 'PRA-KUALIFIKASI', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-034', 'SELEKSI CALON PEMASOK', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-035', 'REKAP PENILAIAN PRA-KUALIFIKASI', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-036', 'DAFTAR PEMASOK TERPILIH', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-037', 'EVALUASI KINERJA PEMASOK', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-038', 'DAFTAR TIM AUDIT SMK3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-039', 'JADWAL AUDIT INTERNAL SMK3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-040', 'DAFTAR PERIKSA AUDIT INTERNAL K3', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-041', 'REKAPITULASI TEMUAN AUDIT INTERNAL', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-042', 'PERMINTAAN TINDAKAN PERBAIKAN DAN PENCEGAHAN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-043', 'LOGBOOK PTPP', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-044', 'RENCANA & UNDANGAN RAPAT TINJAUAN MANAJEMEN', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-045', 'PENYERAHAN ALAT PELINDUNG DIRI', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-046', 'LAPORAN KEJADIAN KEADAAN DARURAT', 'Formulir', 'achmad', NULL, 1),
('HSSE-FR-047', 'HSSE PLAN SPBU MAJALENGKA-JAWA BARAT 34-45413 F0123', 'Formulir', 'achmad', '2022-11-01 14:26:25', 0),
('HSSE-FR-048', 'JHSEA SPBU MAJALENGKA-JAWA BARAT 34-45413 F0124', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-049', 'HIRADC SPBU MAJALENGKA-JAWA BARAT 34-45413 F0125', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-050', 'METODOLOGI PLTS SPBU MAJALENGKA-JAWA BARAT 34-45413 F0126', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-051', 'HSSE PLAN SPBU KERTAJATI,MAJALENGKA-JAWA BARAT 34-45419 F0127', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-052', 'JHSEA SPBU KERTAJATI,MAJALENGKA-JAWA BARAT 34-45419 F0128', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-053', 'HIRADC KERTAJATI,MAJALENGKA-JAWABARAT 34-45419 F0129', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-054', 'METODOLOGI PLTS SPBU KERTAJATI, MAJALENGKA-JAWA BARAT 34-45419 F0130', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-055', 'HSSE PLAN SPBU BANTARUJEG, MAJALENGKA-JAWA BARAT 34-45426 F0131', 'Formulir', 'achmad', '2022-11-01 14:40:23', 0),
('HSSE-FR-056', 'JHSEA SPBU BANTARUJEG, MAJALENGKA-JAWA BARAT 34-45426 F0132', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-057', 'HIRADC SPBU BANTARUJEG, MAJALENGKA-JAWA BARAT 34-45426 F0133', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-058', 'METODOLOGI PLTS SPBU BANTARUJEG, MAJALENGKA-JAWA BARAT 34-45426 F0134', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-059', 'HSSE PLAN SPBU LEBAKSIU-TEGAL 44-52402 F0135', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-060', 'JHSEA SPBU LEBAKSIU-TEGAL 44-52402 F0136', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-061', 'HIRADC SPBU LEBAKSIU-TEGAL 44-52402 F0137', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-062', 'METODOLOGI PLTS SPBU LEBAKSIU-TEGAL 44-52402 F0138', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-063', 'HSSE PLAN SPBU SURABAYA-JAWA TIMUR 54-60257 F0139', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-064', 'JHSEA SPBU SURABAYA-JAWA TIMUR 54-60257 F0140', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-065', 'HIRADC SPBU SURABAYA-JAWA TIMUR 54-60257 F0141', 'Formulir', 'achmad', NULL, 0),
('HSSE-FR-066', 'METODOLOGI PLTS SPBU SURABAYA-JAWA TIMUR 54-60257 F0142', 'Formulir', 'achmad', NULL, 0),
('HSSE-M-001', 'Pedoman Sistem Manajemen Keselamatan Kesehatan Kerja (SMK3)', 'Manual', 'achmad', NULL, 1),
('HSSE-P-001', 'IDENTIFIKASI PERATURAN PERUNDANG-UNDANGAN DAN PERSYARATAN K3', 'Prosedur', 'achmad', '2022-12-14 14:05:38', 1),
('HSSE-P-002', 'IDENTIFIKASI BAHAYA, PENILAIAN DAN PENGENDALIAN RESIKO', 'Prosedur', 'achmad', '2022-12-14 14:06:41', 1),
('HSSE-P-003', 'TUJUAN, SASARAN DAN PROGRAM KESELAMATAN KESEHATAN (K3)', 'Prosedur', 'achmad', '2022-12-14 14:07:36', 1),
('HSSE-P-004', 'MANAJEMEN PERUBAHAN', 'Prosedur', 'achmad', '2022-12-14 14:08:09', 1),
('HSSE-P-005', 'PENGENDALIAN DOKUMEN', 'Prosedur', 'achmad', '2022-12-14 14:08:40', 1),
('HSSE-P-006', 'PENGENDALIAN REKAMAN', 'Prosedur', 'achmad', '2022-09-13 14:23:07', 1),
('HSSE-P-007', 'PELATIHAN K3 DAN EVALUASI', 'Prosedur', 'achmad', '2022-09-13 14:23:54', 1),
('HSSE-P-008', 'KOMUNIKASI K3', 'Prosedur', 'achmad', '2022-09-13 14:24:40', 1),
('HSSE-P-009', 'ALAT PELINDUNG DIRI', 'Prosedur', 'achmad', '2022-09-13 14:36:23', 1),
('HSSE-P-010', 'PENANGGULANGAN KEADAAN DARURAT', 'Prosedur', 'achmad', '2022-09-13 14:38:39', 1),
('HSSE-P-011', 'TINJAUAN MANAJEMEN-SMK3', 'Prosedur', 'achmad', '2022-09-13 14:42:52', 1),
('HSSE-P-012', 'PENANGANAN INSIDEN K3', 'Prosedur', 'achmad', '2022-09-13 14:44:26', 1),
('HSSE-P-013', 'PENGENDALIAN OPERASIONAL K3', 'Prosedur', 'achmad', '2022-09-13 14:45:21', 1),
('HSSE-P-014', 'PROSEDUR PELAPORAN BAHAYA DAN MASALAH K3', 'Prosedur', 'achmad', '2022-09-13 14:47:48', 1),
('HSSE-P-015', 'PROGRAM REWARD DAN PUNISHMENT', 'Prosedur', 'achmad', '2022-09-13 14:48:36', 1),
('HSSE-P-016', 'IJIN KERJA AMAN', 'Prosedur', 'achmad', '2022-09-13 15:09:13', 1),
('HSSE-P-017', 'PENGUKURAN DAN INSPEKSI', 'Prosedur', 'achmad', '2022-09-13 15:10:19', 1),
('HSSE-P-018', 'PENGENDALIAN K3 SUBCONT & PEMASOK', 'Prosedur', 'achmad', '2022-09-13 15:11:04', 1),
('HSSE-P-019', 'PEMERIKSAAN KESEHATAN', 'Prosedur', 'achmad', '2022-09-13 15:11:44', 1),
('HSSE-P-020', 'PENGELOLAAN LIMBAH', 'Prosedur', 'achmad', '2022-09-13 15:12:17', 1),
('HSSE-P-021', 'PROSEDUR AUDIT INTERNAL K3', 'Prosedur', 'achmad', '2022-09-13 15:14:35', 1),
('HSSE-P-022', 'Tinjauan Manajemen - SMK3', 'Prosedur', 'achmad', NULL, 1),
('HSSE-P-023', 'Pengendalian rekaman', 'Prosedur', 'achmad', NULL, 0),
('PLTSSPBU-HSSE-F-001', 'HSSE PLAN PLTS SPBU MAJALENGKA F0123', 'CSMS', 'achmad', NULL, 0),
('PLTSSPBU-HSSE-F-002', 'JHSEA PLTS SPBU MAJALENGKA 34-45413 F0124', 'CSMS', 'achmad', NULL, 0),
('PLTSSPBU-HSSE-F-003', 'HIRADC SPBU MAJALENGKA-JAWA BARAT 34-45413 F0125', 'CSMS', 'achmad', NULL, 0),
('PLTSSPBU-HSSE-F-004', 'METODOLOGI PLTS SPBU MAJALENGKA-JAWA BARAT 34-45413 F0126', 'CSMS', 'achmad', NULL, 0),
('PLTSSPBU-HSSE-F-005', 'HSSE PLAN PLTS SPBU MAJALENGKA 34-45413 F0123', 'CSMS', 'achmad', NULL, 0),
('PLTSSPBU-HSSE-F-006', 'HSSE PLAN PLTS GRHA PERTAMINA - PPI JAKARTA PUSAT, JAKARTA PLTSK-EV-HSSE-F001', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-007', 'JHSEA PLTS GRHA PERTAMINA - PPI JAKARTA PUSAT, JAKARTA PLTSK-EV-HSSE-F002', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-008', 'HIRADC PLTD GRHS PERTAMINA - PPI JAKARTA PUSAT, JAKARTA PLTSK-EV-HSSE-F003', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-009', 'METODOLOGI PLTS GRHA PERTAMINA - JAKARTA PUSAT, JAKARTA PLTSK-EV-HSSE-F004', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-010', 'HSSE PLAN PLTS SPBU BALI 51-80130 PLTSSPBU-HSSE-F010', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-011', 'METODOLOGI PLTS SPBU BALI 51-80130 PLTSSPBU-HSSE-F011', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-012', 'HIRADC SPBU BALI 51-80130 PLTSSPBU-HSSE-F012', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-013', 'JHSEA SPBU BALI 51-80130 PLTSSPBU-HSSE-F013', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-014', 'HSSE PLAN SPBU SURABAYA, JAWA TIMUR 54-60116 PLTSSPBU-HSSE-F018', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-015', 'HIRADC SPBU SURABAYA, JAWA TIMUR  54-60116 F019', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-016', 'JHSEA SPBU SURABAYA, JAWA TIMUR 54-60116 F020', 'CSMS', 'achmad', NULL, 1),
('PLTSSPBU-HSSE-F-017', 'METODOLOGI SPBU SURABAYA, JAWA TIMUR 54-60116 F021', 'CSMS', 'achmad', NULL, 1);

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

--
-- Table structure for table `ms_log`
--

CREATE TABLE `ms_log` (
  `User_id` varchar(50) NOT NULL,
  `Tanggal` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ms_log`
--

INSERT INTO `ms_log` (`User_id`, `Tanggal`) VALUES
('achmad', '2022-09-12 07:13:17'),
('admin', '2022-09-12 07:11:35'),
('achmad', '2022-09-12 08:04:46'),
('achmad', '2022-09-12 10:00:36'),
('achmad', '2022-09-12 10:29:24'),
('achmad', '2022-09-13 06:47:28'),
('achmad', '2022-09-13 10:12:56'),
('achmad', '2022-09-14 06:43:10'),
('achmad', '2022-09-15 06:17:23'),
('achmad', '2022-09-15 09:23:33'),
('achmad', '2022-09-19 07:38:20'),
('achmad', '2022-11-01 07:20:03'),
('achmad', '2022-11-17 07:25:35'),
('achmad', '2022-12-14 04:40:12'),
('admin', '2022-12-14 04:43:29'),
('achmad', '2022-12-14 07:04:21'),
('achmad', '2022-12-15 09:36:19'),
('achmad', '2023-01-13 07:15:07'),
('achmad', '2023-01-16 09:43:08'),
('achmad', '2023-01-26 08:37:01'),
('achmad', '2023-02-08 06:30:00'),
('achmad', '2023-02-09 09:11:44'),
('achmad', '2023-03-07 06:29:10'),
('achmad', '2023-03-07 08:29:48');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ms_dokumen`
--
ALTER TABLE `ms_dokumen`
  ADD PRIMARY KEY (`Dok_id`);
COMMIT;

