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

START TRANSACTION;



--
-- Database: `mchn`
--

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

--
-- Table structure for table `children`
--

CREATE TABLE `children` (
  `id` int(100) NOT NULL,
  `mchn` varchar(100) NOT NULL,
  `dateadmission` varchar(100) NOT NULL,
  `benname` varchar(100) NOT NULL,
  `kin` varchar(100) NOT NULL,
  `sex` varchar(10) NOT NULL,
  `address` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `numid` varchar(100) NOT NULL,
  `datebirth` varchar(100) NOT NULL,
  `realdate` datetime(6) NOT NULL,
  `det` varchar(100) NOT NULL,
  `mis` varchar(100) NOT NULL,
  `weight` int(100) NOT NULL,
  `height` int(100) NOT NULL,
  `muac` varchar(100) NOT NULL,
  `nationality` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `children`
--

INSERT INTO `children` (`id`, `mchn`, `dateadmission`, `benname`, `kin`, `sex`, `address`, `status`, `numid`, `datebirth`, `realdate`, `det`, `mis`, `weight`, `height`, `muac`, `nationality`) VALUES
(8, '1212', '2020-7-31', 'ttghhhh', 'hyyy', '2020/7/25', 'tttt', 'bggg', '4544', '2020/7/25', '2020-08-03 05:25:50.000000', '', 'bggg', 25, 69, '255', ''),
(9, '5552', '2020-7-30', '', 'ffdd77u', '2020/7/31', 'yhyh', 'vggg', '5555', '2020/7/31', '2020-08-10 03:15:03.000000', '', 'vggg', 85, 555, '555', ''),
(10, '5552', '2020-7-30', '', 'ffdd77u', '2020/7/31', 'yhyh', 'vggg', '5555', '2020/7/31', '2020-08-10 03:15:45.000000', '', 'vggg', 85, 555, '555', ''),
(11, 'ss', '2019-07-08', 'jj', 'ss', '2019-09-09', 'sss', '899', 'ss', '2019-09-09', '2020-08-10 03:18:02.000000', '', '899', 45, 34, '45', ''),
(12, '5552', '2020-7-30', '', 'ffdd77u', '2020/7/31', 'yhyh', 'vggg', '5555', '2020/7/31', '2020-08-10 03:18:58.000000', '', 'vggg', 85, 555, '555', ''),
(13, '5552', '2020-7-30', 'opio', 'ffdd77u', '2020/7/31', 'juru', 'yyyyuuh', '5555', '2020/7/31', '2020-08-10 03:20:16.000000', '', 'yyyyuuh', 60, 12, '56', ''),
(14, '227', '2020-7-15', 'gdyd', 'txtxt', 'Female', 'tdtdy', '', '5727', '2020/7/30', '2020-08-10 03:44:43.000000', '', '', 56, 46, '16', 'Female'),
(15, '566', '2020-7-31', 'ghh5555', 'yyy', 'Male', 'ggyg', '', '555', '2020/7/31', '2020-08-10 03:51:02.000000', '', '', 23, 22, '12', 'Foreigner'),
(16, '565656', '2020-7-30', 'Okello Timothy', 'Bein John', 'Female', 'Kizungu', '', '42688888', '2020/7/1', '2020-08-10 05:16:33.000000', '', '', 12, 5, '13', 'National'),
(17, '525252', '2020-7-1', 'HAMZA JEAN', 'Opio Jean', 'Male', 'Nakivale ', '', '565688', '2020/7/1', '2020-08-13 05:39:38.000000', '', '', 56, 29, '16', 'National');

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(100) NOT NULL,
  `mchn` int(100) NOT NULL,
  `date` varchar(100) NOT NULL,
  `weight` int(100) NOT NULL,
  `muac` int(100) NOT NULL,
  `heigt` int(100) NOT NULL,
  `det` int(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `mchn`, `date`, `weight`, `muac`, `heigt`, `det`) VALUES
(1, 56666, '2020-07-16', 56, 18, 23, 666);

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

--
-- Table structure for table `lactating`
--

CREATE TABLE `lactating` (
  `id` int(100) NOT NULL,
  `pnc` varchar(100) NOT NULL,
  `mchn` varchar(100) NOT NULL,
  `dateadmission` varchar(100) NOT NULL,
  `benname` varchar(8) NOT NULL,
  `kin` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `numid` varchar(100) NOT NULL,
  `datedelivery` varchar(100) NOT NULL,
  `det` varchar(100) NOT NULL,
  `realdate` date NOT NULL,
  `status` varchar(100) NOT NULL,
  `mis` varchar(100) NOT NULL,
  `height` varchar(100) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `muac` varchar(100) NOT NULL,
  `nationality` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lactating`
--

INSERT INTO `lactating` (`id`, `pnc`, `mchn`, `dateadmission`, `benname`, `kin`, `address`, `numid`, `datedelivery`, `det`, `realdate`, `status`, `mis`, `height`, `weight`, `muac`, `nationality`) VALUES
(35, '222', '888', '2020-7-23', 'hhh', 'hhh', 'hhh', '999', '2020-7-23', 'hhh', '2020-08-10', 'hhh', '2020-7-23', '57', '45', '15', 'National');

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

--
-- Table structure for table `pregnant`
--

CREATE TABLE `pregnant` (
  `id` int(100) NOT NULL,
  `anc` varchar(100) NOT NULL,
  `mchn` varchar(100) NOT NULL,
  `dateadmission` varchar(100) NOT NULL,
  `benname` varchar(100) NOT NULL,
  `kin` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `numid` varchar(100) NOT NULL,
  `det` varchar(100) NOT NULL,
  `realdate` datetime(6) NOT NULL,
  `misc` varchar(100) NOT NULL,
  `muac` varchar(100) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `height` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pregnant`
--

INSERT INTO `pregnant` (`id`, `anc`, `mchn`, `dateadmission`, `benname`, `kin`, `address`, `status`, `numid`, `det`, `realdate`, `misc`, `muac`, `weight`, `height`) VALUES
(1, '', '', '', '', '', '', '', '', '', '2020-07-19 00:00:00.000000', '', '', '', ''),
(2, '788', '56666', '6777', 'gzhzhz', 'dddd', 'zss', 'dddd', 'ddss', 'eeds', '2020-07-19 00:00:00.000000', '6777', '19', '56', '25'),
(15, '3662', '555', '2020-7-30', 'hhhhhhh', 'ppppppp', 'kitovu', 'ppppppp', '4545', 'bgg', '2020-08-10 02:12:07.000000', '2020-7-30', '96', '25', '78'),
(14, '3662', '555', '2020-7-30', 'hhhhhhh', 'ppppppp', 'kitovu', 'ppppppp', '4545', 'bgg', '2020-08-10 02:09:54.000000', '2020-7-30', '96', '25', '78'),
(13, '1222', '2322', '2019-09-21', 'Aber Akoso', 'Akol Boniface', 'Kabingo', 'Akol Boniface', '429-3636363', 'Poor', '2020-08-10 02:05:05.000000', '2019-09-21', '19', '78', '35'),
(12, '1222', '2322', '2019-09-21', 'Aber Akoso', 'Akol Boniface', 'Kabingo', 'Akol Boniface', '429-3636363', 'Poor', '2020-08-10 01:38:56.000000', '2019-09-21', '35', '19', '78'),
(11, '1222', '2322', '2019-09-21', 'Aber Akoso', 'Akol Boniface', 'Kabingo', 'Akol Boniface', '429-3636363', 'Poor', '2020-08-10 00:54:24.000000', '2019-09-21', '35', '19', '78');

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

--
-- Table structure for table `updates`
--

CREATE TABLE `updates` (
  `id` int(100) NOT NULL,
  `mchn` int(100) NOT NULL,
  `muac` int(100) NOT NULL,
  `height` int(100) NOT NULL,
  `weight` int(100) NOT NULL,
  `date` datetime(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `updates`
--

INSERT INTO `updates` (`id`, `mchn`, `muac`, `height`, `weight`, `date`) VALUES
(1, 3434, 21, 89, 45, '2020-08-04 22:59:51.000000'),
(2, 2322, 35, 78, 19, '2020-08-10 00:18:41.000000'),
(3, 2322, 19, 78, 35, '2020-08-10 00:25:14.000000'),
(4, 2322, 78, 19, 35, '2020-08-10 00:27:09.000000'),
(24, 5552, 555, 555, 85, '2020-08-10 03:15:45.000000'),
(23, 5552, 555, 555, 85, '2020-08-10 03:15:03.000000'),
(22, 888, 15, 57, 45, '2020-08-10 02:55:34.000000'),
(21, 888, 15, 57, 45, '2020-08-10 02:55:12.000000'),
(20, 888, 15, 57, 45, '2020-08-10 02:54:40.000000'),
(10, 2322, 19, 35, 78, '2020-08-10 02:01:38.000000'),
(16, 6666, 22, 75, 56, '2020-08-10 02:47:05.000000'),
(15, 6666, 22, 75, 56, '2020-08-10 02:46:24.000000'),
(13, 555, 96, 78, 25, '2020-08-10 02:09:54.000000'),
(14, 555, 96, 78, 25, '2020-08-10 02:12:07.000000'),
(25, 5552, 555, 555, 85, '2020-08-10 03:18:58.000000'),
(26, 5552, 56, 12, 60, '2020-08-10 03:20:16.000000'),
(27, 227, 16, 46, 56, '2020-08-10 03:42:18.000000'),
(28, 227, 16, 46, 56, '2020-08-10 03:44:42.000000'),
(29, 566, 12, 22, 23, '2020-08-10 03:51:02.000000'),
(30, 565656, 13, 5, 12, '2020-08-10 05:16:33.000000'),
(31, 565656, 16, 6, 15, '2020-08-10 05:22:34.000000'),
(32, 565656, 16, 6, 15, '2020-08-10 05:22:56.000000'),
(33, 565656, 20, 13, 26, '2020-08-10 05:23:01.000000'),
(34, 565656, 20, 13, 26, '2020-08-10 05:23:16.000000'),
(35, 565656, 25, 12, 24, '2020-08-10 05:24:04.000000'),
(36, 565656, 25, 12, 24, '2020-08-10 05:25:16.000000'),
(37, 525252, 16, 29, 56, '2020-08-13 05:39:38.000000');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `children`
--
ALTER TABLE `children`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lactating`
--
ALTER TABLE `lactating`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `pregnant`
--
ALTER TABLE `pregnant`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `updates`
--
ALTER TABLE `updates`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
COMMIT;

