̺  `abroad`
-- 

CREATE TABLE `abroad` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` varchar(10) default NULL,
  `con` varchar(10) default NULL,
  `conarea` varchar(25) default NULL,
  `skintype` varchar(25) default NULL,
  `skintype1` varchar(10) default NULL,
  `engname` varchar(30) default NULL,
  `korname` varchar(30) default NULL,
  `hanname` varchar(30) default NULL,
  `temail` varchar(35) default NULL,
  `happyday` varchar(8) default NULL,
  `twueen` varchar(4) default NULL,
  `jobs` varchar(35) default NULL,
  `passport1` char(2) default NULL,
  `passport2` varchar(7) default NULL,
  `yday1` varchar(4) default NULL,
  `yday2` char(2) default NULL,
  `yday3` char(2) default NULL,
  `yday11` varchar(4) default NULL,
  `yday22` char(2) default NULL,
  `yday33` char(2) default NULL,
  `aaddress` varchar(200) default NULL,
  `phone1` varchar(15) default NULL,
  `hphone1` varchar(15) default NULL,
  `baddress` varchar(200) default NULL,
  `phone2` varchar(15) default NULL,
  `jobname` varchar(35) default NULL,
  `guarantor` varchar(10) default NULL,
  `caddress` varchar(200) default NULL,
  `phone3` varchar(15) default NULL,
  `jobs1` varchar(25) default NULL,
  `jobs11` varchar(50) default NULL,
  `phone33` varchar(15) default NULL,
  `daddress` varchar(200) default NULL,
  `school1` varchar(30) default NULL,
  `saddress1` varchar(200) default NULL,
  `syear1` varchar(4) default NULL,
  `smone1` char(2) default NULL,
  `syear2` varchar(4) default NULL,
  `smone2` char(2) default NULL,
  `school2` varchar(30) default NULL,
  `saddress2` varchar(200) default NULL,
  `syear3` varchar(4) default NULL,
  `smone3` char(2) default NULL,
  `syear4` varchar(4) default NULL,
  `smone4` char(2) default NULL,
  `school3` varchar(30) default NULL,
  `saddress3` varchar(200) default NULL,
  `syear5` varchar(4) default NULL,
  `smone5` char(2) default NULL,
  `syear6` varchar(4) default NULL,
  `smone6` char(2) default NULL,
  `school4` varchar(30) default NULL,
  `saddress4` varchar(200) default NULL,
  `syear7` varchar(4) default NULL,
  `smone7` char(2) default NULL,
  `syear8` varchar(4) default NULL,
  `smone8` char(2) default NULL,
  `school5` varchar(30) default NULL,
  `saddress5` varchar(200) default NULL,
  `syear9` varchar(4) default NULL,
  `smone9` char(2) default NULL,
  `syear10` varchar(4) default NULL,
  `smone10` char(2) default NULL,
  `school6` varchar(30) default NULL,
  `saddress6` varchar(200) default NULL,
  `syear11` varchar(4) default NULL,
  `smone11` char(2) default NULL,
  `syear12` varchar(4) default NULL,
  `smone12` char(2) default NULL,
  `eschool1` varchar(30) default NULL,
  `esaddress1` varchar(200) default NULL,
  `esyear1` varchar(4) default NULL,
  `esmone1` varchar(4) default NULL,
  `esyear2` varchar(4) default NULL,
  `esmone2` varchar(4) default NULL,
  `eschool2` varchar(30) default NULL,
  `esaddress2` varchar(200) default NULL,
  `esyear3` varchar(4) default NULL,
  `esmone3` varchar(4) default NULL,
  `esyear4` varchar(4) default NULL,
  `esmone4` varchar(4) default NULL,
  `eschool3` varchar(30) default NULL,
  `esaddress3` varchar(200) default NULL,
  `esyear5` varchar(4) default NULL,
  `esmone5` varchar(4) default NULL,
  `esyear6` varchar(4) default NULL,
  `esmone6` varchar(4) default NULL,
  `hschool1` varchar(35) default NULL,
  `hsaddress1` varchar(200) default NULL,
  `hsyear1` varchar(4) default NULL,
  `hsmone1` varchar(4) default NULL,
  `hsyear2` varchar(4) default NULL,
  `hsmone2` varchar(4) default NULL,
  `hschool2` varchar(35) default NULL,
  `hsaddress2` varchar(200) default NULL,
  `hsyear3` varchar(4) default NULL,
  `hsmone3` varchar(4) default NULL,
  `hsyear4` varchar(4) default NULL,
  `hsmone4` varchar(4) default NULL,
  `hschool3` varchar(35) default NULL,
  `hsaddress3` varchar(200) default NULL,
  `hsyear5` varchar(4) default NULL,
  `hsmone5` varchar(4) default NULL,
  `hsyear6` varchar(4) default NULL,
  `hsmone6` varchar(4) default NULL,
  `entry` varchar(10) default NULL,
  `eyear1` varchar(4) default NULL,
  `emon1` char(2) default NULL,
  `eday1` char(2) default NULL,
  `eyear1-1` varchar(4) default NULL,
  `emon1-1` char(2) default NULL,
  `eday1-1` char(2) default NULL,
  `reson1` varchar(50) default NULL,
  `reson1-1` varchar(50) default NULL,
  `eyear2` varchar(4) default NULL,
  `emon2` char(2) default NULL,
  `eday2` char(2) default NULL,
  `eyear1-2` varchar(4) default NULL,
  `emon1-2` char(2) default NULL,
  `eday1-2` char(2) default NULL,
  `reson2` varchar(50) default NULL,
  `reson1-2` varchar(50) default NULL,
  `eyear3` varchar(4) default NULL,
  `emon3` char(2) default NULL,
  `eday3` char(2) default NULL,
  `eyear1-3` varchar(4) default NULL,
  `emon1-3` char(2) default NULL,
  `eday1-3` char(2) default NULL,
  `reson3` varchar(50) default NULL,
  `reson1-3` varchar(50) default NULL,
  `eyear4` varchar(4) default NULL,
  `emon4` char(2) default NULL,
  `eday4` char(2) default NULL,
  `eyear1-4` varchar(4) default NULL,
  `emon1-4` char(2) default NULL,
  `eday1-4` char(2) default NULL,
  `reson4` varchar(50) default NULL,
  `reson1-4` varchar(50) default NULL,
  `resons` varchar(200) default NULL,
  `balance` varchar(5) default NULL,
  `balance1` varchar(25) default NULL,
  `getdates` datetime default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- ̺   `abroad`
-- 
