262 lines
6.3 KiB
Plaintext
262 lines
6.3 KiB
Plaintext
CREATE TABLE `rule_age_range` (
|
|
`rule_age_range_id` int(10) NOT NULL,
|
|
`age_batch_id` int(10) NOT NULL,
|
|
`rule_age_start` int(10) NOT NULL,
|
|
`rule_age_end` int(10) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `rule_age_range`
|
|
--
|
|
|
|
INSERT INTO `rule_age_range` (`rule_age_range_id`, `age_batch_id`, `rule_age_start`, `rule_age_end`) VALUES
|
|
(1, 1, 18, 25),
|
|
(2, 1, 26, 30),
|
|
(3, 1, 31, 40),
|
|
(4, 1, 41, 50),
|
|
(5, 1, 51, 100);
|
|
|
|
|
|
|
|
CREATE TABLE `rule_chart` (
|
|
`chart_id` int(10) NOT NULL,
|
|
`chart_name` varchar(20) NOT NULL,
|
|
`rule_equation_ids` varchar(30) NOT NULL,
|
|
`parameter_id` int(10) NOT NULL,
|
|
`checkup_section` int(10) NOT NULL,
|
|
`age_batch_id` int(10) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `rule_chart`
|
|
--
|
|
|
|
INSERT INTO `rule_chart` (`chart_id`, `chart_name`, `rule_equation_ids`, `parameter_id`, `checkup_section`, `age_batch_id`) VALUES
|
|
(1, 'BMI', '7,8,9,10', 21, 2, 1),
|
|
(2, 'Hyper Tension', '11,12,13,14,15', 22, 2, 1);
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `rule_chart`
|
|
--
|
|
ALTER TABLE `rule_chart`
|
|
ADD PRIMARY KEY (`chart_id`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `rule_chart`
|
|
--
|
|
ALTER TABLE `rule_chart`
|
|
MODIFY `chart_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
|
|
|
|
|
|
|
|
|
|
|
|
CREATE TABLE `rule_equation` (
|
|
`rule_eq_id` int(10) NOT NULL,
|
|
`rule_equation` varchar(100) NOT NULL,
|
|
`checkup_form_section_id` int(10) NOT NULL,
|
|
`rule_gender` varchar(10) NOT NULL,
|
|
`rule_age_start` int(10) NOT NULL,
|
|
`rule_age_end` int(10) NOT NULL,
|
|
`cout` int(10) NOT NULL,
|
|
`result` int(10) NOT NULL,
|
|
`result_disp` varchar(30) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `rule_equation`
|
|
--
|
|
|
|
INSERT INTO `rule_equation` (`rule_eq_id`, `rule_equation`, `checkup_form_section_id`, `rule_gender`, `rule_age_start`, `rule_age_end`, `cout`, `result`, `result_disp`) VALUES
|
|
(1, '((Test1<50)&&(Test2>60))||(Test3<150)', 16, 'M', 0, 0, 3, 0, ''),
|
|
(2, 'Platelet<50', 5, '', 0, 0, 1, 0, ''),
|
|
(3, '((BMI<10)||(Pulse>80))', 2, '', 0, 0, 2, 0, ''),
|
|
(5, '(Sph>50)&&(Cyl>60)', 3, '', 0, 0, 2, 40, ''),
|
|
(7, 'BMI<18.5', 2, '', 0, 0, 1, 94, 'UNDER WEIGHT'),
|
|
(8, '(BMI>18.5)&&(BMI<24.9)', 2, '', 0, 0, 2, 94, 'HEALTHY WEIGHT'),
|
|
(9, '((BMI>25)&&(BMI<30))', 2, '', 0, 0, 2, 94, 'OVER WEIGHT'),
|
|
(10, 'BMI>39.9', 2, '', 0, 0, 1, 94, 'OBESE'),
|
|
(11, '(SBP<120)&&(DBP<80)', 2, '', 0, 0, 2, 94, 'NORMAL'),
|
|
(12, '((SBP>119)&&(SBP<130))&&(DBP<80)', 2, '', 0, 0, 3, 94, 'ELEVATED HYPERTENSION'),
|
|
(13, '((SBP>129)&&(SBP<140))||((DBP>79)&&(DBP<90))', 2, '', 0, 0, 4, 94, 'HYPERTENSION STAGE 1'),
|
|
(14, '((SBP>139)&&(SBP<180))||((DBP>89)&&(DBP<120))', 2, '', 0, 0, 4, 94, 'HYPERTENSION STAGE 2'),
|
|
(15, '((SBP>139)||(DBP>119)', 2, '', 0, 0, 2, 94, 'HYPERTENSION CRISIS');
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `rule_equation`
|
|
--
|
|
ALTER TABLE `rule_equation`
|
|
ADD PRIMARY KEY (`rule_eq_id`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `rule_equation`
|
|
--
|
|
ALTER TABLE `rule_equation`
|
|
MODIFY `rule_eq_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
|
|
|
|
|
|
CREATE TABLE `rule_joiner` (
|
|
`rule_joiner_id` int(10) NOT NULL,
|
|
`joiner_name` varchar(20) NOT NULL,
|
|
`joiner_sy` varchar(10) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `rule_joiner`
|
|
--
|
|
|
|
INSERT INTO `rule_joiner` (`rule_joiner_id`, `joiner_name`, `joiner_sy`) VALUES
|
|
(1, 'and', '&&'),
|
|
(2, 'or', '||');
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `rule_joiner`
|
|
--
|
|
ALTER TABLE `rule_joiner`
|
|
ADD PRIMARY KEY (`rule_joiner_id`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `rule_joiner`
|
|
--
|
|
ALTER TABLE `rule_joiner`
|
|
MODIFY `rule_joiner_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
|
|
|
|
CREATE TABLE `rule_save` (
|
|
`rule_s_id` int(10) NOT NULL,
|
|
`op_br` varchar(20) NOT NULL,
|
|
`checkup_parameter` int(10) NOT NULL,
|
|
`condition_id` int(10) NOT NULL,
|
|
`rule_s_val` int(20) NOT NULL,
|
|
`cl_br` varchar(20) NOT NULL,
|
|
`joiner_id` int(10) NOT NULL,
|
|
`equation_rule_id` int(10) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `rule_save`
|
|
--
|
|
|
|
INSERT INTO `rule_save` (`rule_s_id`, `op_br`, `checkup_parameter`, `condition_id`, `rule_s_val`, `cl_br`, `joiner_id`, `equation_rule_id`) VALUES
|
|
(1, '((', 186, 2, 50, ')', 0, 1),
|
|
(2, '(', 187, 1, 60, '))', 1, 1),
|
|
(3, '(', 188, 2, 150, ')', 2, 1),
|
|
(4, '', 56, 2, 50, '', 0, 2),
|
|
(5, '((', 21, 2, 10, ')', 0, 3),
|
|
(6, '(', 24, 1, 80, '))', 2, 3),
|
|
(8, '(', 37, 1, 50, ')', 0, 5),
|
|
(9, '(', 38, 1, 60, ')', 1, 5),
|
|
(12, '', 21, 2, 19, '', 0, 7),
|
|
(13, '(', 21, 1, 19, ')', 0, 8),
|
|
(14, '(', 21, 2, 25, ')', 1, 8),
|
|
(15, '((', 21, 1, 25, ')', 0, 9),
|
|
(16, '(', 21, 2, 30, '))', 1, 9),
|
|
(17, '', 21, 1, 40, '', 0, 10),
|
|
(18, '(', 22, 2, 120, ')', 0, 11),
|
|
(19, '(', 23, 2, 80, ')', 1, 11),
|
|
(20, '((', 22, 1, 119, ')', 0, 12),
|
|
(21, '(', 22, 2, 130, '))', 1, 12),
|
|
(22, '(', 23, 2, 80, ')', 1, 12),
|
|
(23, '((', 22, 1, 129, ')', 0, 13),
|
|
(24, '(', 22, 2, 140, '))', 1, 13),
|
|
(25, '((', 23, 1, 79, ')', 2, 13),
|
|
(26, '(', 23, 2, 90, '))', 1, 13),
|
|
(27, '((', 22, 1, 139, ')', 0, 14),
|
|
(28, '(', 22, 2, 180, '))', 1, 14),
|
|
(29, '((', 23, 1, 89, ')', 2, 14),
|
|
(30, '(', 23, 2, 120, '))', 1, 14),
|
|
(31, '(', 22, 1, 139, ')', 0, 15),
|
|
(32, '(', 23, 1, 119, ')', 2, 15);
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `rule_save`
|
|
--
|
|
ALTER TABLE `rule_save`
|
|
ADD PRIMARY KEY (`rule_s_id`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `rule_save`
|
|
--
|
|
ALTER TABLE `rule_save`
|
|
MODIFY `rule_s_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
|
|
|
|
|
|
|
|
|
|
CREATE TABLE `rule_condition` (
|
|
`rule_condition_id` int(10) NOT NULL,
|
|
`condition_name` varchar(20) NOT NULL,
|
|
`condition_sy` varchar(10) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `rule_condition`
|
|
--
|
|
|
|
INSERT INTO `rule_condition` (`rule_condition_id`, `condition_name`, `condition_sy`) VALUES
|
|
(1, 'greater than', '>'),
|
|
(2, 'less than', '<');
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `rule_condition`
|
|
--
|
|
ALTER TABLE `rule_condition`
|
|
ADD PRIMARY KEY (`rule_condition_id`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `rule_condition`
|
|
--
|
|
ALTER TABLE `rule_condition`
|
|
MODIFY `rule_condition_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|