t_person_cid

``` sql
SET @b_year:='2017';

DROP TABLE IF EXISTS t_person_cid;
CREATE TABLE IF NOT EXISTS `t_person_cid` (
`HOSPCODE` varchar(5) NOT NULL,
`CID` varchar(13) DEFAULT NULL,
`PID` varchar(15) NOT NULL,
`HID` varchar(14) DEFAULT NULL,
`PRENAME` varchar(3) NOT NULL,
`NAME` varchar(50) NOT NULL,
`LNAME` varchar(50) NOT NULL,
`HN` varchar(15) DEFAULT NULL,
`SEX` varchar(1) NOT NULL,
`BIRTH` date NOT NULL,
`MSTATUS` char(1) DEFAULT NULL,
`OCCUPATION_OLD` varchar(3) DEFAULT NULL,
`OCCUPATION_NEW` varchar(4) DEFAULT NULL,
`RACE` varchar(3) DEFAULT NULL,
`NATION` varchar(3) NOT NULL,
`RELIGION` varchar(2) DEFAULT NULL,
`EDUCATION` varchar(2) DEFAULT NULL,
`FSTATUS` varchar(1) DEFAULT NULL,
`FATHER` varchar(13) DEFAULT NULL,
`MOTHER` varchar(13) DEFAULT NULL,
`COUPLE` varchar(13) DEFAULT NULL,
`VSTATUS` varchar(1) DEFAULT NULL,
`MOVEIN` date DEFAULT NULL,
`DISCHARGE` varchar(1) DEFAULT NULL,
`DDISCHARGE` date DEFAULT NULL,
`ABOGROUP` varchar(1) DEFAULT NULL,
`RHGROUP` varchar(1) DEFAULT NULL,
`LABOR` varchar(2) DEFAULT NULL,
`PASSPORT` varchar(8) DEFAULT NULL,
`TYPEAREA` varchar(1) NOT NULL,
`D_UPDATE` datetime NOT NULL,
vhid VARCHAR(8) DEFAULT NULL,
age_y VARCHAR(3) DEFAULT 0,
PRIMARY KEY (`CID`),
KEY `idx1` (`CID`),
KEY `idx2` (`HOSPCODE`,`CID`),
KEY `idx3` (`NAME`),
KEY `idx4` (`LNAME`),
KEY `idx5` (`TYPEAREA`),
KEY `idx6` (`HOSPCODE`,`PID`),
KEY `idx7` (`BIRTH`),
KEY `idx8` (`DISCHARGE`),
KEY `idx9` (`LABOR`),
KEY `idx10` (`HOSPCODE`,`HID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT IGNORE INTO t_person_cid (
select *,null,TIMESTAMPDIFF(YEAR,BIRTH,concat(@b_year,'0101')) age_y
from person where TYPEAREA in (1,3) ORDER BY D_UPDATE DESC
);

INSERT IGNORE INTO t_person_cid (
select *,null,TIMESTAMPDIFF(YEAR,BIRTH,concat(@b_year,'0101')) age_y
from person where TYPEAREA in (2) ORDER BY D_UPDATE DESC
);

INSERT IGNORE INTO t_person_cid (
select *,null,TIMESTAMPDIFF(YEAR,BIRTH,concat(@b_year,'0101')) age_y
from person where TYPEAREA in (4,5) ORDER BY D_UPDATE DESC
);

The issue only provides a MySQL script for creating and populating t_person_cid; start by reviewing that script and the referenced person table. No tests, requested behavior, or completion criteria are stated, so clarify the intended change and how success should be verified before making changes.

Written by the indexing model from the issue text.