#ComeLeak Table Structure - doctableNAOV

comweb-doctableNAOV.sql

CREATE TABLE `doctableNAOV` (
  `ID` varchar(40) NOT NULL,
  `APPLICATION_ID` varchar(11) DEFAULT NULL,
  `FORM_ID` varchar(16) DEFAULT NULL,
  `APP_TYPE` varchar(1) DEFAULT NULL,
  `ABSENTEE` varchar(1) DEFAULT NULL,
  `REGISTRATION` varchar(1) DEFAULT NULL,
  `LASTNAME` varchar(100) DEFAULT NULL,
  `FIRSTNAME` varchar(100) DEFAULT NULL,
  `MATERNALNAME` varchar(100) DEFAULT NULL,
  `SEX` varchar(1) DEFAULT NULL,
  `CIVILSTATUS` varchar(1) DEFAULT NULL,
  `SPOUSENAME` varchar(25) DEFAULT NULL,
  `RESSTREET` varchar(60) DEFAULT NULL,
  `RESPRECINCT` varchar(4) DEFAULT NULL,
  `RESPRECINCTCODE` varchar(1) DEFAULT NULL,
  `RESBARANGAY` varchar(3) DEFAULT NULL,
  `RESCITY` varchar(2) DEFAULT NULL,
  `RESPROVINCE` varchar(2) DEFAULT NULL,
  `ABROADSTREET` varchar(80) DEFAULT NULL,
  `ABROADZIP` varchar(10) DEFAULT NULL,
  `ABSENTIA` varchar(1) DEFAULT NULL,
  `ABROADCITY` varchar(20) DEFAULT NULL,
  `ABROADCOUNTRY` varchar(2) DEFAULT NULL,
  `ABROADPERIOD` varchar(2) DEFAULT NULL,
  `ABROADRESCONT` varchar(1) DEFAULT NULL,
  `REGCOUNTRY` varchar(2) DEFAULT NULL,
  `REGEMBASSY` varchar(2) DEFAULT NULL,
  `MAILSTREET` varchar(80) DEFAULT NULL,
  `MAILZIP` varchar(10) DEFAULT NULL,
  `MAILCITY` varchar(20) DEFAULT NULL,
  `MAILCOUNTRY` varchar(2) DEFAULT NULL,
  `MAILEMBASSY` varchar(2) DEFAULT NULL,
  `REPSTREET` varchar(60) DEFAULT NULL,
  `REPBARANGAY` varchar(3) DEFAULT NULL,
  `REPCITY` varchar(2) DEFAULT NULL,
  `REPPROVINCE` varchar(2) DEFAULT NULL,
  `EMAIL` varchar(40) DEFAULT NULL,
  `ABROADSTATUS` varchar(1) DEFAULT NULL,
  `ABROADSTATUSSPECIF` varchar(30) DEFAULT NULL,
  `LASTENTRYDATE` datetime DEFAULT NULL,
  `ABSREGISTERED` varchar(1) DEFAULT NULL,
  `OLDPRECINCT` varchar(5) DEFAULT NULL,
  `OLDREGBARANGAY` varchar(3) DEFAULT NULL,
  `OLDREGCITY` varchar(2) DEFAULT NULL,
  `OLDREGPROVINCE` varchar(2) DEFAULT NULL,
  `OLDREGDATE` datetime DEFAULT NULL,
  `FLASTNAME` varchar(25) DEFAULT NULL,
  `FFIRSTNAME` varchar(25) DEFAULT NULL,
  `FMATERNALNAME` varchar(25) DEFAULT NULL,
  `MLASTNAME` varchar(25) DEFAULT NULL,
  `MFIRSTNAME` varchar(25) DEFAULT NULL,
  `MMATERNALNAME` varchar(25) DEFAULT NULL,
  `REPLASTNAME` varchar(25) DEFAULT NULL,
  `REPFIRSTNAME` varchar(25) DEFAULT NULL,
  `REPMATERNALNAME` varchar(25) DEFAULT NULL,
  `DOBYEAR` varchar(100) DEFAULT NULL,
  `DOBMONTH` varchar(100) DEFAULT NULL,
  `DOBDAY` varchar(100) DEFAULT NULL,
  `BIRTHCITY` varchar(2) DEFAULT NULL,
  `BIRTHPROVINCE` varchar(2) DEFAULT NULL,
  `CITIZENSHIP` varchar(1) DEFAULT NULL,
  `NATURALIZATIONDATE` datetime DEFAULT NULL,
  `CERTIFICATENB` varchar(10) DEFAULT NULL,
  `COUNTRYRES` varchar(2) DEFAULT NULL,
  `CITYRESYEAR` varchar(2) DEFAULT NULL,
  `CITYRESMONTH` varchar(2) DEFAULT NULL,
  `PROFESSION` varchar(3) DEFAULT NULL,
  `SECTOR` varchar(3) DEFAULT NULL,
  `HEIGHT` varchar(4) DEFAULT NULL,
  `WEIGHT` varchar(3) DEFAULT NULL,
  `MARKS` varchar(2) DEFAULT NULL,
  `DISABLED` varchar(1) DEFAULT NULL,
  `ASSISTEDBY` varchar(40) DEFAULT NULL,
  `OLD_VIN` varchar(21) DEFAULT NULL,
  `VINP1` varchar(100) DEFAULT NULL,
  `VINP2` varchar(100) DEFAULT NULL,
  `VINP3` varchar(100) DEFAULT NULL,
  `VINCONTROLCODE` varchar(1) DEFAULT NULL,
  `TIN` varchar(20) DEFAULT NULL,
  `PASSPORTLOST` varchar(1) DEFAULT NULL,
  `PASSPORTNB` varchar(10) DEFAULT NULL,
  `PASSPORTPLACE` varchar(20) DEFAULT NULL,
  `PASSYEAR` varchar(4) DEFAULT NULL,
  `PASSMONTH` varchar(2) DEFAULT NULL,
  `PASSMONTH` varchar(2) DEFAULT NULL,
  `PASSDAY` varchar(2) DEFAULT NULL,
  `REGBARANGAY` varchar(3) DEFAULT NULL,
  `REGCITY` varchar(2) DEFAULT NULL,
  `REGPROVINCE` varchar(2) DEFAULT NULL,
  `REG_DATE` datetime DEFAULT NULL,
  `INTERNAME` varchar(40) DEFAULT NULL,
  `OFFICERNAME` varchar(40) DEFAULT NULL,
  `OPERNAME` varchar(20) DEFAULT NULL,
  `STATIONID` varchar(5) DEFAULT NULL,
  `CDID` varchar(15) DEFAULT NULL,
  `SETID` varchar(20) DEFAULT NULL,
  `PRINT_FLAG` varchar(19) DEFAULT NULL,
  `FINGER_INFO` varchar(19) DEFAULT NULL,
  `FINGER_TOPO_COORD` varchar(73) DEFAULT NULL,
  `QUALITY` varchar(21) DEFAULT NULL,
  `MATCHING_FINGER` varchar(1) DEFAULT NULL,
  `TRANSFER_STATUS` varchar(50) DEFAULT NULL,
  `TRANSFER_UPDATE_TIME` datetime DEFAULT NULL,
  `PAGES_DESCR` varchar(50) DEFAULT NULL,
  `LOCAL_ID` varchar(50) DEFAULT NULL,
  `CREATE_TIME` datetime DEFAULT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `LOCK_USER` varchar(22) DEFAULT NULL,
  `LOCK_TIME` datetime DEFAULT NULL,
  `PROCESSING` smallint(5) DEFAULT NULL,
  `IS_CURRENT` smallint(5) DEFAULT NULL,
  `DOC_VERSION` int(10) DEFAULT NULL,
  `CD_STAT_ENTY` varchar(3) DEFAULT NULL,
  `DISAPPROVED` varchar(1) DEFAULT NULL,
  `VOTING_HIST1` varchar(20) DEFAULT NULL,
  `VOTING_HIST2` varchar(25) DEFAULT NULL,
  `OP_CODE` varchar(3) DEFAULT NULL,
  `OP_DATE` datetime DEFAULT NULL,
  `COUNTRY` varchar(45) DEFAULT NULL,
  `POST` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;