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

START TRANSACTION;



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

--
-- Table structure for table `detail_skor_pertanyaan`
--

CREATE TABLE `detail_skor_pertanyaan` (
  `id` int(11) NOT NULL,
  `respons_id` varchar(50) NOT NULL,
  `nomor_pertanyaan` int(11) NOT NULL,
  `skor` int(11) NOT NULL CHECK (`skor` between 1 and 5)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `kuesioner_aspek`
--

CREATE TABLE `kuesioner_aspek` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kuesioner_aspek`
--

INSERT INTO `kuesioner_aspek` (`id`, `title`, `description`) VALUES
(1, 'Aspek Kepemimpinan Visioner', 'Menilai kemampuan pimpinan dalam menetapkan visi yang jelas, menerjemahkan menjadi aksi nyata, serta mengambil keputusan strategis.'),
(2, 'Aspek Komunikasi dan Keterbukaan', 'Menilai keterbukaan pimpinan, kemampuan menerima umpan balik/kritik, serta membangun hubungan komunikasi yang sehat.'),
(3, 'Aspek Tata Kelola dan Manajerial', 'Menilai kompetensi profesional dalam mengelola jalannya organisasi, efisiensi sumber daya, serta penyelesaian konflik.'),
(4, 'Aspek Pelayanan dan Relasi', 'Menilai orientasi melayani kepada seluruh civitas akademika, tenggang rasa, dan kemampuan menciptakan suasana kerja kondusif.'),
(5, 'Aspek Integritas dan Keteladanan', 'Menilai kejujuran, keadilan dalam bersikap, penerapan etika, disiplin, dan kemampuan pimpinan menjaga nama baik institusi.'),
(6, 'Aspek Pengembangan Institusi', 'Menilai komitmen pimpinan terhadap penjaminan mutu, inovasi program baru, kolaborasi eksternal, dan keberlanjutan institusi.');

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

--
-- Table structure for table `kuesioner_pertanyaan`
--

CREATE TABLE `kuesioner_pertanyaan` (
  `id` int(11) NOT NULL,
  `aspect_id` int(11) NOT NULL,
  `text` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kuesioner_pertanyaan`
--

INSERT INTO `kuesioner_pertanyaan` (`id`, `aspect_id`, `text`) VALUES
(1, 1, 'Pimpinan memiliki visi yang jelas bagi pengembangan institusi/fakultas.'),
(2, 1, 'Pimpinan mampu menerjemahkan visi menjadi program kerja yang nyata.'),
(3, 1, 'Pimpinan menunjukkan arah kebijakan yang konsisten.'),
(4, 1, 'Pimpinan mampu mengambil keputusan strategis secara tepat.'),
(5, 2, 'Pimpinan menyampaikan informasi secara jelas dan terbuka.'),
(6, 2, 'Pimpinan terbuka terhadap kritik dan saran.'),
(7, 2, 'Pimpinan membangun komunikasi yang baik dengan civitas akademika.'),
(8, 2, 'Pimpinan responsif terhadap persoalan yang disampaikan.'),
(9, 3, 'Pimpinan menjalankan tata kelola yang profesional.'),
(10, 3, 'Pimpinan mampu mengelola sumber daya secara efektif.'),
(11, 3, 'Kebijakan yang dibuat pimpinan dilaksanakan secara konsisten.'),
(12, 3, 'Pimpinan mampu menyelesaikan masalah organisasi dengan baik.'),
(13, 4, 'Pimpinan menunjukkan sikap melayani kepada civitas akademika.'),
(14, 4, 'Pimpinan memperhatikan kebutuhan dosen dan tenaga kependidikan.'),
(15, 4, 'Pimpinan membangun suasana kerja yang kondusif.'),
(16, 4, 'Pimpinan menghargai perbedaan pendapat.'),
(17, 5, 'Pimpinan menunjukkan integritas dalam menjalankan tugas.'),
(18, 5, 'Pimpinan menjadi teladan dalam etika dan disiplin kerja.'),
(19, 5, 'Pimpinan bersikap adil dalam pengambilan keputusan.'),
(20, 5, 'Pimpinan menjaga nama baik institusi.'),
(21, 6, 'Pimpinan mendukung peningkatan mutu akademik.'),
(22, 6, 'Pimpinan mendorong inovasi dan pengembangan program.'),
(23, 6, 'Pimpinan mendukung kerja sama eksternal institusi.'),
(24, 6, 'Pimpinan memiliki perhatian terhadap keberlanjutan institusi.');

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

--
-- Table structure for table `pimpinan`
--

CREATE TABLE `pimpinan` (
  `id` varchar(50) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `jabatan` varchar(255) NOT NULL,
  `department` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pimpinan`
--

INSERT INTO `pimpinan` (`id`, `nama`, `jabatan`, `department`, `created_at`, `updated_at`) VALUES
('L1', 'Rektor', 'Rektor', 'Rektorat', '2026-05-29 09:33:29', '2026-05-29 09:33:29'),
('L2', 'Wakil Rektor I', 'Wakil Rektor I', 'Akademik', '2026-05-29 09:33:29', '2026-05-29 09:33:29'),
('L3', 'Wakil Rektor II', 'Wakil Rektor II', 'Administrasi Umum & Keuangan', '2026-05-29 09:33:29', '2026-05-30 08:01:06'),
('L4', 'Wakil Rektor III', 'Wakil Rektor III', 'Kemahasiswaan, Alumnni, Pemasaran & Kerjasama', '2026-05-29 09:33:29', '2026-05-30 08:01:21'),
('L5', 'Pendeta Kampus', 'Pendeta Kampus', 'UPKK', '2026-05-29 09:33:29', '2026-05-30 08:00:53');

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

--
-- Table structure for table `respons_evaluasi`
--

CREATE TABLE `respons_evaluasi` (
  `id` varchar(50) NOT NULL,
  `timestamp` datetime NOT NULL,
  `status` enum('Dosen','Tenaga Kependidikan') NOT NULL,
  `unit` varchar(255) NOT NULL,
  `pimpinan_id` varchar(50) NOT NULL,
  `skor_rata_rata` decimal(3,2) NOT NULL,
  `aspek_kekuatan` text DEFAULT NULL,
  `aspek_perbaikan` text DEFAULT NULL,
  `rekomendasi_saran` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `respondent_id` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `undangan_wa`
--

CREATE TABLE `undangan_wa` (
  `id` varchar(50) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `no_hp` varchar(50) NOT NULL,
  `role` enum('Dosen','Tenaga Kependidikan') NOT NULL,
  `unit` varchar(255) NOT NULL,
  `sent_count` int(11) DEFAULT 0,
  `last_sent_at` datetime DEFAULT NULL,
  `is_completed` tinyint(1) DEFAULT 0,
  `completed_at` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `draft_data` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `undangan_wa`
--

INSERT INTO `undangan_wa` (`id`, `nama`, `no_hp`, `role`, `unit`, `sent_count`, `last_sent_at`, `is_completed`, `completed_at`, `created_at`, `updated_at`, `draft_data`) VALUES
('INV-1772763830755', 'Sari Sarce Andriana', '6281313513727', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772763885650', 'Iriyanti Harun', '628114190183', 'Dosen', 'S1 Gizi', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772763911676', 'Imelda MG Sianipar', '6285220881004', 'Dosen', 'S1 Kebidanan,Profesi Bidan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772763957384', 'Juliyanti', '6285221440085', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772763988400', 'Berlyn D. Saragih', '6281394399919', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764084281', 'Ira Ocktavia Siagian', '6285317286118', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764118167', 'Ria Angelina', '6281394100097', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764203494', 'Widawati', '6281318671200', 'Dosen', 'S1 Ilmu Kesehatan Masyarakat', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764236090', 'Yuliati Widiastuti', '6281323909985', 'Dosen', 'S1 Gizi', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764265359', 'Asysyfa Riana', '628112342986', 'Dosen', 'S1 Gizi', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764317901', 'Widyadari Prasetyaningrum', '6282260246602', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 10:50:51', NULL),
('INV-1772764345877', 'Tri Ardayani', '6281312914013', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764391734', 'Yuliani', '6281312914013', 'Tenaga Kependidikan', 'Lembaga Penjaminan Mutu', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764456769', 'Stephanie Melia', '6281296290231', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764498174', 'Dian Ekawati', '6282118211309', 'Tenaga Kependidikan', 'Lembaga Penjaminan Mutu', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772764525807', 'Sundariningsih', '6282117333890', 'Dosen', 'S1 Kebidanan,Profesi Bidan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772765288023', 'Srihesty Manan', '6285213545977', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772765347316', 'Hani Triana', '6281809389359', 'Dosen', 'S1 Kebidanan,Profesi Bidan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772765393404', 'Galuh Chandra Irawan', '6285156367253', 'Dosen', 'S1 Gizi', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772765424154', 'Neti Sitorus', '6282219320841', 'Dosen', 'S1 Ilmu Kesehatan Masyarakat', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772765544843', 'Kristin Sihombing', '6281322610227', 'Dosen', 'D3 Manajemen Pelayanan Rumah Sakit', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772766205516', 'Fahmi Fuadah', '6285222608180', 'Tenaga Kependidikan', 'UPT Perpustakaan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772766299339', 'Yuli Yulianti', '6283839364939', 'Tenaga Kependidikan', 'Bagian Keuangan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772766341098', 'Gurdani Yogisutanti', '6281395461573', 'Tenaga Kependidikan', 'Lembaga Penelitian & Pengabdian Masyarakat', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772766386952', 'Antonius Ngadiran', '6282117337439', 'Tenaga Kependidikan', 'Wakil Rektor II', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772766417697', 'Yunus Adhy Prasetyo', '6281290044813', 'Tenaga Kependidikan', 'Wakil Rektor III', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772858643903', 'Bagus Taryana', '6285156194701', 'Tenaga Kependidikan', 'Bagian Sumber Daya Manusia', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 10:50:51', NULL),
('INV-1772858735848', 'Reynaldi Tresnajaya', '62817264763', 'Tenaga Kependidikan', 'Lembaga Penjaminan Mutu', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772868283118', 'Lidya Maryani', '6285793005055', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772868326548', 'Liliek Fauziah', '628996881248', 'Dosen', 'D3 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1772889399068', 'Monika Ginting', '6282211116201', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1773031904100', 'Ardhini Dwi Utari', '6281312808787', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1773052848512', 'Henni Purnasari', '6285720333672', 'Dosen', 'D3 Kebidanan', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1773371674531', 'Lidya Natalia', '628122515600', 'Dosen', 'Program Profesi Ners', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1773372880333', 'Lia Dahlia Yuliana', '6289508405986', 'Tenaga Kependidikan', 'Sarana Prasarana', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-1773567421844', 'Anni Sinaga', '6281394350894', 'Tenaga Kependidikan', 'Wakil Rektor I', 0, NULL, 0, NULL, '2026-05-29 23:46:49', '2026-05-30 09:16:18', NULL),
('INV-204455001061', 'OD Sariningsih', '628000000001', 'Dosen', 'D3 Kebidanan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204457002401', 'Sri Rejeki', '628000000002', 'Dosen', 'D3 Kebidanan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204458003691', 'Berlyna D.Saragih', '628000000003', 'Dosen', 'D3 Keperawatan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204459004480', 'Sari Sarce', '628000000004', 'Dosen', 'D3 Keperawatan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204460005770', 'Kristin', '628000000005', 'Dosen', 'D3 MPRS', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204461006367', 'Herwinda', '628000000006', 'Dosen', 'PPN', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204463007528', 'Ira Octavia Siagian', '628000000007', 'Dosen', 'PPN', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204464008992', 'Roselina Tambunan', '628000000008', 'Dosen', 'PPN', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204464009692', 'Saurmian Sinaga', '628000000009', 'Dosen', 'PPN', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204465010145', 'Yeni Komala', '628000000010', 'Dosen', 'S1 / Profesi Kebidanan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204467011316', 'Elisa Situmorang', '628000000011', 'Dosen', 'S1 / Profesi Kebidanan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204469012455', 'Syifa Nurfauziah', '628000000012', 'Dosen', 'S1 / Profesi Kebidanan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204470013766', 'Rezka Zahra Humaira', '628000000013', 'Dosen', 'S1 / Profesi Kebidanan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204471014242', 'Mayang Januarti Permatasari', '628000000014', 'Dosen', 'S1 Gizi', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204472016797', 'Treesia Sujana', '628000000016', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204473017451', 'Susanti Niman', '628000000017', 'Dosen', 'S1 Keperawatan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204474018474', 'Linda Hotmaida', '628000000018', 'Dosen', 'S1 Kesmas', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204476019289', 'Siska Vitrisia', '628000000019', 'Tenaga Kependidikan', 'BAAK', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204478020888', 'Rocky Parsaoran', '628000000020', 'Tenaga Kependidikan', 'Keuangan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204479021434', 'Hermanto Suryadi', '628000000021', 'Tenaga Kependidikan', 'LP2M', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204479022197', 'Dinni Dwi Asih Marsali', '628000000022', 'Tenaga Kependidikan', 'UPKK', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204480023311', 'Agus Antonius', '628000000023', 'Tenaga Kependidikan', 'Keuangan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204481024338', 'Komarudin Saleh', '628000000024', 'Tenaga Kependidikan', 'SDM', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204482025116', 'Jojo Jubaedi', '628000000025', 'Tenaga Kependidikan', 'TU & RT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204487026093', 'Rahmadi', '628000000026', 'Tenaga Kependidikan', 'Sarpras', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204491027679', 'Ojin', '628000000027', 'Tenaga Kependidikan', 'SPM', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204492028731', 'Titin Libertin Paembonan', '628000000028', 'Tenaga Kependidikan', 'TU & RT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204493029587', 'Iwan Yohanes Simon', '628000000029', 'Tenaga Kependidikan', 'Sarpras', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204493030345', 'Badru Bin Manan', '628000000030', 'Tenaga Kependidikan', 'TU & RT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204494031101', 'Sukanto', '628000000031', 'Tenaga Kependidikan', 'TIK', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204495032228', 'Robi Iskanda', '628000000032', 'Tenaga Kependidikan', 'UPT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204496033775', 'Ardianto Cayadi', '628000000033', 'Tenaga Kependidikan', 'UPT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204497034221', 'Ivana', '628000000034', 'Tenaga Kependidikan', 'TU & RT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204497035622', 'Asep Riyanto', '628000000035', 'Tenaga Kependidikan', 'Sarpras', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204498036938', 'Noviana Puspitasari', '628000000036', 'Tenaga Kependidikan', 'UPT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204500037029', 'Kurnia H. Latifah', '628000000037', 'Tenaga Kependidikan', 'UPT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204502038066', 'Nessa A. Kanikir', '6285156919055', 'Tenaga Kependidikan', 'Bagian Sumber Daya Manusia', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 10:50:51', NULL),
('INV-204503039973', 'Piernes Jose Valerian', '628000000039', 'Tenaga Kependidikan', 'TIK', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204504040858', 'Sardiaman Saragih', '628000000040', 'Tenaga Kependidikan', 'TIK', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204504041113', 'Dicky Rammes Tupalessy', '628000000041', 'Tenaga Kependidikan', 'Keuangan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204505042945', 'Debbie Ramschie', '628000000042', 'Tenaga Kependidikan', 'Kemahasiswaan & Alumni', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204506043351', 'Monika Anggelia Tumbol', '628000000043', 'Tenaga Kependidikan', 'SPM', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204507044664', 'Timotheus Adriel Valerian', '628000000044', 'Tenaga Kependidikan', 'Pemasaran & Kerjasama', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204508045029', 'Immanuela Danawati', '628000000045', 'Tenaga Kependidikan', 'Keuangan', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204508046474', 'Detri Iriyanti', '628000000046', 'Tenaga Kependidikan', 'YPT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204509047778', 'Fanny Yudhiastari', '628000000047', 'Tenaga Kependidikan', 'YPT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204510048777', 'Rocky Agusta Rionaldo P', '628000000048', 'Tenaga Kependidikan', 'YPT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-204511049238', 'Titin Meryati Gultom', '628000000049', 'Tenaga Kependidikan', 'YPT', 0, NULL, 0, NULL, '2026-05-30 09:26:44', '2026-05-30 09:26:44', NULL),
('INV-65050', 'Nesa A. Kanikir', '6285156919055', 'Tenaga Kependidikan', 'Bagian Sumber Daya Manusia', 0, NULL, 0, NULL, '2026-05-30 07:39:25', '2026-05-30 10:50:51', NULL);

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

--
-- Table structure for table `unit_prodi`
--

CREATE TABLE `unit_prodi` (
  `id` varchar(50) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `unit_prodi`
--

INSERT INTO `unit_prodi` (`id`, `nama`, `created_at`) VALUES
('U-1', 'S1 Keperawatan', '2026-05-29 23:46:49'),
('U-10', 'Wakil Rektor II', '2026-05-29 23:46:49'),
('U-11', 'Wakil Rektor III', '2026-05-29 23:46:49'),
('U-12', 'Bagian Sumber Daya Manusia', '2026-05-29 23:46:49'),
('U-13', 'D3 Keperawatan', '2026-05-29 23:46:49'),
('U-14', 'D3 Kebidanan', '2026-05-29 23:46:49'),
('U-15', 'Program Profesi Ners', '2026-05-29 23:46:49'),
('U-16', 'Sarana Prasarana', '2026-05-29 23:46:49'),
('U-17', 'Wakil Rektor I', '2026-05-29 23:46:49'),
('U-2', 'S1 Gizi', '2026-05-29 23:46:49'),
('U-3', 'S1 Kebidanan,Profesi Bidan', '2026-05-29 23:46:49'),
('U-4', 'S1 Ilmu Kesehatan Masyarakat', '2026-05-29 23:46:49'),
('U-5', 'Lembaga Penjaminan Mutu', '2026-05-29 23:46:49'),
('U-6', 'D3 Manajemen Pelayanan Rumah Sakit', '2026-05-29 23:46:49'),
('U-7', 'UPT Perpustakaan', '2026-05-29 23:46:49'),
('U-8', 'Bagian Keuangan', '2026-05-29 23:46:49'),
('U-9', 'Lembaga Penelitian & Pengabdian Masyarakat', '2026-05-29 23:46:49');

--
-- Indexes for table `detail_skor_pertanyaan`
--
ALTER TABLE `detail_skor_pertanyaan`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_respons_pertanyaan` (`respons_id`,`nomor_pertanyaan`);

--
-- Indexes for table `kuesioner_aspek`
--
ALTER TABLE `kuesioner_aspek`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kuesioner_pertanyaan`
--
ALTER TABLE `kuesioner_pertanyaan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `aspect_id` (`aspect_id`);

--
-- Indexes for table `pimpinan`
--
ALTER TABLE `pimpinan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `respons_evaluasi`
--
ALTER TABLE `respons_evaluasi`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_respondent_pimpinan` (`respondent_id`,`pimpinan_id`),
  ADD KEY `pimpinan_id` (`pimpinan_id`);

--
-- Indexes for table `undangan_wa`
--
ALTER TABLE `undangan_wa`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `unit_prodi`
--
ALTER TABLE `unit_prodi`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nama` (`nama`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `detail_skor_pertanyaan`
--
ALTER TABLE `detail_skor_pertanyaan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kuesioner_aspek`
--
ALTER TABLE `kuesioner_aspek`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `kuesioner_pertanyaan`
--
ALTER TABLE `kuesioner_pertanyaan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `detail_skor_pertanyaan`
--
ALTER TABLE `detail_skor_pertanyaan`
  ADD CONSTRAINT `detail_skor_pertanyaan_ibfk_1` FOREIGN KEY (`respons_id`) REFERENCES `respons_evaluasi` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `kuesioner_pertanyaan`
--
ALTER TABLE `kuesioner_pertanyaan`
  ADD CONSTRAINT `kuesioner_pertanyaan_ibfk_1` FOREIGN KEY (`aspect_id`) REFERENCES `kuesioner_aspek` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `respons_evaluasi`
--
ALTER TABLE `respons_evaluasi`
  ADD CONSTRAINT `respons_evaluasi_ibfk_1` FOREIGN KEY (`pimpinan_id`) REFERENCES `pimpinan` (`id`) ON UPDATE CASCADE;
COMMIT;

