DROP TABLE IF EXISTS `person_FEDERATED`;
CREATE TABLE `person_FEDERATED` (
`pcucodeperson` char(5) NOT NULL default '',
`pid` int(11) NOT NULL,
`hcode` int(11) NOT NULL,
`prename` varchar(20) default NULL,
`fname` varchar(25) NOT NULL,
`lname` varchar(35) default NULL,
`birth` date default NULL,
`sex` varchar(1) NOT NULL,
`idcard` varchar(13) default NULL,
`bloodgroup` varchar(2) default NULL,
`bloodrh` varchar(1) default NULL,
`allergic` varchar(100) default NULL,
`marystatus` varchar(1) default NULL,
`educate` char(2) default NULL,
`occupa` char(4) default NULL,
`nation` varchar(3) default NULL,
`origin` varchar(3) default NULL,
`intercode` varchar(2) default NULL,
`religion` char(2) default NULL,
`familyno` tinyint(4) default NULL,
`familyposition` varchar(1) default NULL,
`income` double default NULL,
`typelive` varchar(1) default NULL,
`datein` date default NULL,
`dischargetype` varchar(1) default NULL,
`dischargedate` date default NULL,
`father` varchar(257) default NULL,
`fatherid` varchar(13) default NULL,
`mother` varchar(257) default NULL,
`motherid` varchar(13) default NULL,
`mate` varchar(257) default NULL,
`mateid` varchar(13) default NULL,
`privatedoc` varchar(255) default NULL,
`rightcode` char(4) default NULL,
`rightno` varchar(18) default NULL,
`hosmain` char(9) default NULL,
`hossub` char(9) default NULL,
`dateregis` date default NULL,
`datestart` date default NULL,
`dateexpire` date default NULL,
`officework` char(254) default NULL,
`hnomoi` varchar(75) default NULL,
`roadmoi` varchar(50) default NULL,
`mumoi` char(2) default NULL,
`subdistcodemoi` char(2) default NULL,
`distcodemoi` char(2) default NULL,
`provcodemoi` char(2) default NULL,
`postcodemoi` char(5) default NULL,
`telephoneperson` varchar(35) default NULL,
`hcodeoldin` int(11) default NULL,
`dateupdate` datetime default NULL,
`flag18fileexpo` varchar(1) default NULL,
`messengername` varchar(255) default NULL,
`messengeraddr` varchar(255) default NULL,
`messengertel` varchar(55) default NULL,
`patientrelate` varchar(255) default NULL,
`mommilk` int(11) default NULL,
`persondisease` varchar(350) default NULL,
`flagoffline` char(1) default NULL,
`nickname` varchar(25) default NULL,
`prenameeng` varchar(25) default NULL,
`fnameeng` varchar(35) default NULL,
`lnameeng` varchar(45) default NULL,
`person_house_position_id_from_hosxp` int(11) default NULL,
`Address from antidrug` text,
`Update Date antidrug` date default NULL,
`passpotnumber` varchar(37) default NULL,
`workpermitnumber` varchar(37) default NULL,
`hidmoi11` char(11) default NULL,
`housetype` char(1) default NULL,
`roomno` varchar(10) default NULL,
`condo` varchar(75) default NULL,
`soisub` varchar(255) default NULL,
`soimain` varchar(255) default NULL,
`dateupdateaddressout` datetime default NULL,
`candobedhomesocial` char(1) default NULL,
`beastprojectout` char(1) default NULL,
PRIMARY KEY (`pcucodeperson`,`pid`),
UNIQUE KEY `id_Card` (`pcucodeperson`,`idcard`),
UNIQUE KEY `RN` (`pcucodeperson`,`rightno`),
KEY `house_pers` (`pcucodeperson`,`hcode`),
KEY `per_educate` (`educate`),
KEY `per_nation` (`nation`),
KEY `per_race` (`origin`),
KEY `per_occupa` (`occupa`),
KEY `per_relig` (`religion`),
KEY `per_right` (`rightcode`),
KEY `per_status` (`marystatus`),
KEY `per_hosmain` (`hosmain`),
KEY `chos_pshs1` (`hossub`),
CONSTRAINT `person_ibfk_1` FOREIGN KEY (`hossub`) REFERENCES `chospital` (`hoscode`) ON UPDATE CASCADE,
CONSTRAINT `person_ibfk_10` FOREIGN KEY (`occupa`) REFERENCES `coccupa` (`occupacode`) ON UPDATE CASCADE,
CONSTRAINT `person_ibfk_2` FOREIGN KEY (`origin`) REFERENCES `cnation` (`nationcode`) ON UPDATE CASCADE,
CONSTRAINT `person_ibfk_3` FOREIGN KEY (`religion`) REFERENCES `creligion` (`religioncode`) ON UPDATE CASCADE,
CONSTRAINT `person_ibfk_4` FOREIGN KEY (`rightcode`) REFERENCES `cright` (`rightcode`) ON UPDATE CASCADE,
CONSTRAINT `person_ibfk_5` FOREIGN KEY (`marystatus`) REFERENCES `cstatus` (`statuscode`) ON UPDATE CASCADE,
CONSTRAINT `person_ibfk_6` FOREIGN KEY (`pcucodeperson`, `hcode`) REFERENCES `house` (`pcucode`, `hcode`) ON UPDATE CASCADE,
CONSTRAINT `person_ibfk_7` FOREIGN KEY (`educate`) REFERENCES `ceducation` (`educationcode`) ON UPDATE CASCADE,
CONSTRAINT `person_ibfk_8` FOREIGN KEY (`hosmain`) REFERENCES `chospital` (`hoscode`) ON UPDATE CASCADE,
CONSTRAINT `person_ibfk_9` FOREIGN KEY (`nation`) REFERENCES `cnation` (`nationcode`) ON UPDATE CASCADE
)
ENGINE=FEDERATED
DEFAULT CHARSET=utf8
CONNECTION='mysql://root:123456@127.0.0.1:3333/jhcisdb/person';
