SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `ncd_person_ncd_screen_b4edit_ncd`;
CREATE TABLE `ncd_person_ncd_screen_b4edit_ncd` (
`pcucode` char(5) NOT NULL DEFAULT '',
`pid` varchar(13) NOT NULL,
`no` int(6) NOT NULL,
`age_year` int(6) NOT NULL,
`screen_date` date NOT NULL,
`height` decimal(6,2) NOT NULL,
`weight` decimal(6,2) NOT NULL,
`waist` int(3) NOT NULL,
`hbp_s1` int(3) NOT NULL,
`hbp_d1` int(3) NOT NULL,
`screen_q1` varchar(1) NOT NULL,
`screen_q2` varchar(1) NOT NULL,
`screen_q3` varchar(1) NOT NULL,
`screen_q4` varchar(1) NOT NULL,
`screen_q5` varchar(1) NOT NULL,
`screen_q6` varchar(1) NOT NULL,
`do_measure` varchar(1) DEFAULT NULL,
`hbp_s2` int(3) DEFAULT NULL,
`hbp_d2` int(3) DEFAULT NULL,
`bsl` decimal(6,2) DEFAULT NULL,
`bmi` double NOT NULL,
`result_new_dm` varchar(1) NOT NULL,
`result_new_hbp` varchar(1) NOT NULL,
`result_new_waist` varchar(1) NOT NULL,
`result_new_obesity` varchar(1) NOT NULL,
`d_update` date NOT NULL,
`user_update` varchar(45) NOT NULL,
`visitno` int(11) DEFAULT NULL,
`smoke` char(1) DEFAULT NULL,
`alcohol` char(1) DEFAULT NULL,
`htfamily` char(1) DEFAULT NULL,
`bstest` char(1) DEFAULT NULL,
`dateupdate` datetime DEFAULT NULL,
`servplace` char(1) DEFAULT NULL,
`flag18fileexpo` char(1) DEFAULT NULL,
`blackarmpit` char(1) DEFAULT NULL,
`flagoffline` char(1) DEFAULT NULL,
PRIMARY KEY (`pcucode`,`pid`,`no`)
) ENGINE=FEDERATED
DEFAULT CHARSET=utf8
CONNECTION='mysql://root:123456@127.0.0.1:3333/jhcisdbb4ncdedit/ncd_person_ncd_screen';
