· 9 years ago · Oct 15, 2016, 02:48 AM
1-- phpMyAdmin SQL Dump
2-- version 3.1.3.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 15, 2016 at 10:33 AM
7-- Server version: 5.1.33
8-- PHP Version: 5.2.9
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `rs`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Table structure for table `gejala`
26--
27
28CREATE TABLE IF NOT EXISTS `gejala` (
29 `kd_gejala` varchar(6) NOT NULL,
30 `nm_gejala` varchar(50) NOT NULL,
31 PRIMARY KEY (`kd_gejala`)
32) ENGINE=MyISAM DEFAULT CHARSET=latin1;
33
34--
35-- Dumping data for table `gejala`
36--
37
38INSERT INTO `gejala` (`kd_gejala`, `nm_gejala`) VALUES
39('KG_001', 'Gejala 1'),
40('KG_002', 'Gejala 2'),
41('KG_003', 'Gejala 3'),
42('KG_004', 'Gejala 4'),
43('KG_005', 'Gejala 5');
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `kasus`
49--
50
51CREATE TABLE IF NOT EXISTS `kasus` (
52 `kd_kasus` varchar(6) NOT NULL,
53 `kd_penyakit` varchar(6) NOT NULL,
54 `kd_gejala` varchar(6) NOT NULL,
55 KEY `kd_penyakit` (`kd_penyakit`),
56 KEY `kd_gejala` (`kd_gejala`),
57 KEY `kd_penyakit_2` (`kd_penyakit`),
58 KEY `kd_gejala_2` (`kd_gejala`)
59) ENGINE=MyISAM DEFAULT CHARSET=latin1;
60
61--
62-- Dumping data for table `kasus`
63--
64
65INSERT INTO `kasus` (`kd_kasus`, `kd_penyakit`, `kd_gejala`) VALUES
66('KS_001', 'KP_001', 'KG_002'),
67('KS_001', 'KP_001', 'KG_004'),
68('KS_001', 'KP_001', 'KG_005'),
69('KS_002', 'KP_002', 'KG_001'),
70('KS_002', 'KP_002', 'KG_004'),
71('KS_002', 'KP_002', 'KG_003'),
72('KS_002', 'KP_002', 'KG_005'),
73('KS_003', 'KP_001', 'KG_004'),
74('KS_003', 'KP_001', 'KG_005'),
75('KS_004', 'KP_003', 'KG_001'),
76('KS_004', 'KP_003', 'KG_002'),
77('KS_004', 'KP_003', 'KG_003'),
78('KS_005', 'KP_003', 'KG_001'),
79('KS_005', 'KP_003', 'KG_003'),
80('KS_005', 'KP_003', 'KG_004'),
81('KS_006', 'KP_001', 'KG_002'),
82('KS_006', 'KP_001', 'KG_004'),
83('KS_006', 'KP_001', 'KG_005'),
84('KS_007', 'KP_001', 'KG_002'),
85('KS_007', 'KP_001', 'KG_005');
86
87-- --------------------------------------------------------
88
89--
90-- Table structure for table `penyakit`
91--
92
93CREATE TABLE IF NOT EXISTS `penyakit` (
94 `kd_penyakit` varchar(6) NOT NULL,
95 `nm_penyakit` varchar(50) NOT NULL,
96 PRIMARY KEY (`kd_penyakit`)
97) ENGINE=MyISAM DEFAULT CHARSET=latin1;
98
99--
100-- Dumping data for table `penyakit`
101--
102
103INSERT INTO `penyakit` (`kd_penyakit`, `nm_penyakit`) VALUES
104('KP_001', 'Penyakit 1'),
105('KP_002', 'Penyakit 2'),
106('KP_003', 'Penyakit 3'),
107('KP_004', 'Penyakit 4'),
108('KP_005', 'Penyakit 5');