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

START TRANSACTION;



--
-- Database: `penilaian`
--

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

--
-- Table structure for table `jawaban`
--

CREATE TABLE `jawaban` (
  `kd_jawab` varchar(10) NOT NULL,
  `kd_tanya` varchar(10) NOT NULL,
  `no_responden` varchar(10) NOT NULL,
  `isi_jawab` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `jawaban`
--

INSERT INTO `jawaban` (`kd_jawab`, `kd_tanya`, `no_responden`, `isi_jawab`) VALUES
('PR001', 'TN0001', 'RSP010', 'Tidak Puas'),
('PR002', 'TN0002', 'RSP011', 'Tidak Puas'),
('PR003', 'TN0002', 'RSP011', 'Tidak Puas'),
('PR004', 'TN0002', 'RSP011', 'Tidak Puas'),
('PR005', 'TN0002', 'RSP012', 'Puas'),
('PR006', 'TN0002', 'RSP013', 'Puas'),
('PR007', 'TN0002', 'RSP013', 'Puas'),
('PR008', 'TN0002', 'RSP013', 'Puas'),
('PR009', 'TN0003', 'RSP014', 'Puas');

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

--
-- Table structure for table `layanan`
--

CREATE TABLE `layanan` (
  `kd_layanan` varchar(10) NOT NULL,
  `nm_layanan` varchar(20) NOT NULL,
  `nm_petugas` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `layanan`
--

INSERT INTO `layanan` (`kd_layanan`, `nm_layanan`, `nm_petugas`) VALUES
('KL001', 'Layanan Rekomendasi', 'Herdiansyah'),
('KL002', 'Layanan Magang/PKL/P', 'Saiful Hadi'),
('KL003', 'Layanan Legalisir', 'Endika');

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

--
-- Table structure for table `pertanyaan`
--

CREATE TABLE `pertanyaan` (
  `kd_tanya` varchar(10) NOT NULL,
  `kd_layanan` varchar(10) NOT NULL,
  `isi_tanya` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `pertanyaan`
--

INSERT INTO `pertanyaan` (`kd_tanya`, `kd_layanan`, `isi_tanya`) VALUES
('TN0001', 'KL001', 'Apakah ruangan bagus?'),
('TN0002', 'KL002', 'Apakah layanan bagus?'),
('TN0003', 'KL003', 'Penyampaian informasi dari staff?');

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

--
-- Table structure for table `responden`
--

CREATE TABLE `responden` (
  `no_responden` varchar(10) NOT NULL,
  `nm_responden` varchar(30) NOT NULL,
  `kd_layanan` varchar(10) NOT NULL,
  `telp_responden` int(13) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `responden`
--

INSERT INTO `responden` (`no_responden`, `nm_responden`, `kd_layanan`, `telp_responden`) VALUES
('RSP001', 'shevaputriaulia', 'KL02', 2147483647),
('RSP002', 'ohsehuuuun', 'KL01', 2147483647),
('RSP003', 'selaluu', 'KL03', 9878890),
('RSP004', 'anda', 'KL01', 988766543),
('RSP005', 'finaaaaa', 'KL02', 987765),
('RSP006', 'sephaaa', 'KL03', 97878889),
('RSP007', 'sepaaa', 'KL02', 9877),
('RSP008', 'shevaaa', 'KL02', 9876),
('RSP009', 'nnnnnnnnnnnnnn', 'KL001', 12),
('RSP010', 'jjj', 'KL001', 78),
('RSP011', 'sepaaa', 'KL002', 56789),
('RSP012', 'jajja', 'KL002', 90),
('RSP013', 'shevaputriaulia', 'KL002', 8989),
('RSP014', 'sephaaa', 'KL003', 98765);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `jawaban`
--
ALTER TABLE `jawaban`
  ADD PRIMARY KEY (`kd_jawab`);

--
-- Indexes for table `layanan`
--
ALTER TABLE `layanan`
  ADD PRIMARY KEY (`kd_layanan`);

--
-- Indexes for table `pertanyaan`
--
ALTER TABLE `pertanyaan`
  ADD PRIMARY KEY (`kd_tanya`);

--
-- Indexes for table `responden`
--
ALTER TABLE `responden`
  ADD PRIMARY KEY (`no_responden`);
COMMIT;

