sql

sql

lemsmatchcode VARCHAR(18) NOT NULL,
firstname VARCHAR(15),
middleinitial VARCHAR(1),
lastname VARCHAR(20),
lastnamesuffix VARCHAR(2),
titlecode VARCHAR(1),
gender VARCHAR(1),
birthdate VARCHAR(6),
housenumber VARCHAR(10),
streetpredirectional VARCHAR(2),
streetname VARCHAR(28),
streetsuffix VARCHAR(4),
streetpostdirectional VARCHAR(2),
unittype VARCHAR(4),
unitnumber VARCHAR(8),
routetype VARCHAR(1),
routenumber VARCHAR(3),
addresstype VARCHAR(1),
city VARCHAR(13),
state VARCHAR(2),
zipcode VARCHAR(5),
zipfour VARCHAR(4),
deliverypoint VARCHAR(2),
deliverypointcheckdigit VARCHAR(1),
homeage VARCHAR(3),
carrierroute VARCHAR(4),
nielsencountyrank VARCHAR(1),
nielsencountyregion VARCHAR(1),
marketarea VARCHAR(3),
census_state_code_2010 VARCHAR(2),
census_county_code_2010 VARCHAR(3),
census_tract_code_2010 VARCHAR(6),
census_block_group_code_2010 VARCHAR(1),
demographicindicator VARCHAR(1),
uspsdeliveryservicetype VARCHAR(1),
lengthofresidence VARCHAR(2),
locationtype VARCHAR(1),
occupancycount VARCHAR(2),
deliveryunitsizeraw VARCHAR(2),
householdarrivaldate VARCHAR(4),
areacode VARCHAR(3),
phonenumber VARCHAR(7),
phonenumbertype VARCHAR(1),
secondaryphone VARCHAR(10),
secondaryphonetype VARCHAR(1),
timezone VARCHAR(1),
age0_3 VARCHAR(1),
age4_7 VARCHAR(1),
age8_12 VARCHAR(1),
age13_17 VARCHAR(1),
markettargetage0_5 VARCHAR(1),
markettargetage0_11 VARCHAR(1),
markettargetage0_17 VARCHAR(1),
markettargetage6_11 VARCHAR(1),
markettargetage12_17female VARCHAR(1),
markettargetage12_17male VARCHAR(1),
markettargetage12_17 VARCHAR(1),
markettargetage18_24female VARCHAR(1),
markettargetage18_24male VARCHAR(1),
markettargetage18_34female VARCHAR(1),
markettargetage18_34male VARCHAR(1),
markettargetage18_44female VARCHAR(1),
markettargetage25_34female VARCHAR(1),
markettargetage25_34male VARCHAR(1),
markettargetage35_44female VARCHAR(1),
markettargetage35_44male VARCHAR(1),
markettargetage35_54female VARCHAR(1),
markettargetage35_54male VARCHAR(1),
markettargetage45_54female VARCHAR(1),
markettargetage45_54male VARCHAR(1),
markettargetage50plus VARCHAR(1),
markettargetage55_64female VARCHAR(1),
markettargetage55_64male VARCHAR(1),
markettargetage65plus VARCHAR(1),
householdsize1_2 VARCHAR(1),
householdsize3plus VARCHAR(1),
spouseindicator VARCHAR(1),
individualid VARCHAR(12),
refreshdate VARCHAR(6),
age VARCHAR(2),
nameaddresssource VARCHAR(1),
numberoftradelines VARCHAR(1),
creditcard_travel_and_entertainment VARCHAR(1),
creditcard_bank VARCHAR(1),
creditcard_premium_bank VARCHAR(1),
creditcard_retail VARCHAR(1),
creditcard_oil VARCHAR(1),
creditcard_specialy_retail VARCHAR(1),
creditcard_upscale_retail VARCHAR(1),
creditcard_finance VARCHAR(1),
creditcard_holder VARCHAR(1),
bank_card_recency_date VARCHAR(6),
politicalparty VARCHAR(1),
mortgagepresent VARCHAR(1),
maritalstatus VARCHAR(1),
donotmailflag VARCHAR(1),
donotcallflag VARCHAR(1),
workathomeflag VARCHAR(1),
businessfilehitflag VARCHAR(1),
deceasedflag VARCHAR(1),
fulfillmentflag VARCHAR(1),
member_2_firstname VARCHAR(15),
member_2_middleinitial VARCHAR(1),
member_2_lastname VARCHAR(20),
member_2_lastnamesuffix VARCHAR(2),
member_2_titlecode VARCHAR(1),
member_2_gender VARCHAR(1),
member_2_birthdate VARCHAR(6),
member_2_spouseindicator VARCHAR(1),
member_2_individualid VARCHAR(12),
member_2_refreshdate VARCHAR(6),
member_2_age VARCHAR(2),
member_2_nameaddresssource VARCHAR(1),
member_2_numberoftradelines VARCHAR(1),
member_2_creditcard_travel_and_entertainment VARCHAR(1),
member_2_creditcard_bank VARCHAR(1),
member_2_creditcard_premium_bank VARCHAR(1),
member_2_creditcard_retail VARCHAR(1),
member_2_creditcard_oil VARCHAR(1),
member_2_creditcard_specialy_retail VARCHAR(1),
member_2_creditcard_upscale_retail VARCHAR(1),
member_2_creditcard_finance VARCHAR(1),
member_2_creditcard_holder VARCHAR(1),
member_2_bank_card_recency_date VARCHAR(6),
member_2_politicalparty VARCHAR(1),
member_2_mortgagepresent VARCHAR(1),
member_2_maritalstatus VARCHAR(1),
member_2_donotmailflag VARCHAR(1),
member_2_donotcallflag VARCHAR(1),
member_2_workathomeflag VARCHAR(1),
member_2_businessfilehitflag VARCHAR(1),
member_2_deceasedflag VARCHAR(1),
member_2_fulfillmentflag VARCHAR(1),
member_3_firstname VARCHAR(15),
member_3_middleinitial VARCHAR(1),
member_3_lastname VARCHAR(20),
member_3_lastnamesuffix VARCHAR(2),
member_3_titlecode VARCHAR(1),
member_3_gender VARCHAR(1),
member_3_birthdate VARCHAR(6),
member_3_spouseindicator VARCHAR(1),
member_3_individualid VARCHAR(12),
member_3_refreshdate VARCHAR(6),
member_3_age VARCHAR(2),
member_3_nameaddresssource VARCHAR(1),
member_3_numberoftradelines VARCHAR(1),
member_3_creditcard_travel_and_entertainment VARCHAR(1),
member_3_creditcard_bank VARCHAR(1),
member_3_creditcard_premium_bank VARCHAR(1),
member_3_creditcard_retail VARCHAR(1),
member_3_creditcard_oil VARCHAR(1),
member_3_creditcard_specialy_retail VARCHAR(1),
member_3_creditcard_upscale_retail VARCHAR(1),
member_3_creditcard_finance VARCHAR(1),
member_3_creditcard_holder VARCHAR(1),
member_3_bank_card_recency_date VARCHAR(6),
member_3_politicalparty VARCHAR(1),
member_3_mortgagepresent VARCHAR(1),
member_3_maritalstatus VARCHAR(1),
member_3_donotmailflag VARCHAR(1),
member_3_donotcallflag VARCHAR(1),
member_3_workathomeflag VARCHAR(1),
member_3_businessfilehitflag VARCHAR(1),
member_3_deceasedflag VARCHAR(1),
member_3_fulfillmentflag VARCHAR(1),
member_4_firstname VARCHAR(15),
member_4_middleinitial VARCHAR(1),
member_4_lastname VARCHAR(20),
member_4_lastnamesuffix VARCHAR(2),
member_4_titlecode VARCHAR(1),
member_4_gender VARCHAR(1),
member_4_birthdate VARCHAR(6),
member_4_spouseindicator VARCHAR(1),
member_4_individualid VARCHAR(12),
member_4_refreshdate VARCHAR(6),
member_4_age VARCHAR(2),
member_4_nameaddresssource VARCHAR(1),
member_4_numberoftradelines VARCHAR(1),
member_4_creditcard_travel_and_entertainment VARCHAR(1),
member_4_creditcard_bank VARCHAR(1),
member_4_creditcard_premium_bank VARCHAR(1),
member_4_creditcard_retail VARCHAR(1),
member_4_creditcard_oil VARCHAR(1),
member_4_creditcard_specialy_retail VARCHAR(1),
member_4_creditcard_upscale_retail VARCHAR(1),
member_4_creditcard_finance VARCHAR(1),
member_4_creditcard_holder VARCHAR(1),
member_4_bank_card_recency_date VARCHAR(6),
member_4_politicalparty VARCHAR(1),
member_4_mortgagepresent VARCHAR(1),
member_4_maritalstatus VARCHAR(1),
member_4_donotmailflag VARCHAR(1),
member_4_donotcallflag VARCHAR(1),
member_4_workathomeflag VARCHAR(1),
member_4_businessfilehitflag VARCHAR(1),
member_4_deceasedflag VARCHAR(1),
member_4_fulfillmentflag VARCHAR(1),
householdmembercount VARCHAR(1),
numberofadults VARCHAR(1),
presenceofchildren VARCHAR(1),
numberofchildren VARCHAR(1),
childrenbygender VARCHAR(18),
childrenbymonth VARCHAR(18),
numberofsurnames VARCHAR(1),
income VARCHAR(1),
purchasingpowerincome VARCHAR(1),
mailabilityscorebyte1 VARCHAR(1),
mailabilityscorebyte2 VARCHAR(1),
heavy_internet_user VARCHAR(2),
findincome VARCHAR(6),
sesi VARCHAR(2),
wealthfinder VARCHAR(1),
dmhightechhousehold VARCHAR(1),
findr VARCHAR(1),
heatingtype_code VARCHAR(1),
expendableincomerank VARCHAR(1),
loantovalue VARCHAR(1),
hohagecode VARCHAR(1),
agedatasource VARCHAR(1),
phhchild VARCHAR(6),
phhw65p VARCHAR(6),
pop05 VARCHAR(8),
medag18p VARCHAR(6),
phhsz3p VARCHAR(6),
phhmarrd VARCHAR(6),
phhspchld VARCHAR(6),
phhd25km VARCHAR(6),
phhd50kp VARCHAR(6),
phhd150k VARCHAR(6),
medhhd VARCHAR(10),
ppoverty VARCHAR(6),
p2auto VARCHAR(6),
pcolgrad VARCHAR(6),
meanschlraw VARCHAR(10),
psuis VARCHAR(6),
medvalue VARCHAR(9),
phv300kp VARCHAR(6),
phv75km VARCHAR(6),
medrentp VARCHAR(9),
mdoicost VARCHAR(10),
pownrocc VARCHAR(6),
pprofsnl VARCHAR(6),
pwhitcol VARCHAR(6),
pbluecol VARCHAR(6),
punemply VARCHAR(6),
phhblack VARCHAR(6),
phhasian VARCHAR(6),
phhspnsh VARCHAR(6),
ownrent VARCHAR(1),
homeownersource VARCHAR(1),
findc VARCHAR(1),
mortgageloantype VARCHAR(1),
mortgagetypesource VARCHAR(1),
recencydate VARCHAR(6),
mortgageamount VARCHAR(1),
mortgageamountsource VARCHAR(1),
homebuiltyear VARCHAR(4),
homeagesource VARCHAR(1),
pool VARCHAR(1),
bathroomcount VARCHAR(3),
bedroomcount VARCHAR(2),
homeequityestimate VARCHAR(1),
garagetype VARCHAR(1),
homevalue VARCHAR(1),
homevaluesource VARCHAR(1),
homesize VARCHAR(5),
lotsize VARCHAR(5),
roomcount VARCHAR(2),
femaleoccupation VARCHAR(2),
maleoccupation VARCHAR(2),
grandparentinhouse VARCHAR(1),
mailresponsivecurrent VARCHAR(1),
mailresponsiveever VARCHAR(1),
mailresponsiverecent VARCHAR(1),
catowner VARCHAR(1),
dogowner VARCHAR(1),
mailorderbuyerflag VARCHAR(1),
donorcode VARCHAR(1),
donor_health VARCHAR(1),
donor_political VARCHAR(1),
donor_religious VARCHAR(1),
donor_environmental VARCHAR(1),
stocksorbonds VARCHAR(1),
books_music_interest VARCHAR(1),
car_buff VARCHAR(1),
childrens_products_interest VARCHAR(1),
collectibles_interest VARCHAR(1),
computer_owner VARCHAR(1),
electronics_interest VARCHAR(1),
fashion_jewelry_interest VARCHAR(1),
gardening_horticulture_interest VARCHAR(1),
golfer VARCHAR(1),
gourmet_food_wine_interest VARCHAR(1),
handcrafts_sewing_interest VARCHAR(1),
health_fitness_interest VARCHAR(1),
high_ticket_mail_order_buyer VARCHAR(1),
home_decorating_interest VARCHAR(1),
home_workshop_interest VARCHAR(1),
investments_interest VARCHAR(1),
opportunist VARCHAR(1),
outdoor_enthusiast VARCHAR(1),
pet_owner VARCHAR(1),
photography_enthusiast VARCHAR(1),
stamps_coins_collector VARCHAR(1),
travel_entertainment_interest VARCHAR(1),
hunting VARCHAR(1),
fishing VARCHAR(1),
boatingsailing VARCHAR(1),
foreigntravel VARCHAR(1),
gambling VARCHAR(1),
dietingweightloss VARCHAR(1),
cooking VARCHAR(1),
camping VARCHAR(1),
diabetes VARCHAR(1),
asthma VARCHAR(1),
arthritisrheumatism VARCHAR(1),
anginaheartdisease VARCHAR(1),
emphysema VARCHAR(1),
osteoporosis VARCHAR(1),
highbloodpressure VARCHAR(1),
highcholesterol VARCHAR(1),
physicalhandicap VARCHAR(1),
allergies VARCHAR(1),
hearingdifficulty VARCHAR(1),
migraines VARCHAR(1),
alzheimers VARCHAR(1),
bladdercontroldifficulty VARCHAR(1),
frequentheadaches VARCHAR(1),
magazine_subscriber VARCHAR(1),
mortgageintrestratesource VARCHAR(1),
mortgageintrestrate VARCHAR(4),
standardizedname VARCHAR(30),
standardizedaddress VARCHAR(30),
standardizedcitystzip VARCHAR(30),
familyid VARCHAR(12),
locationid VARCHAR(12),
phonesourcecat VARCHAR(1),
buyer_behavior_cluster_2004 VARCHAR(2),
ppir VARCHAR(1),
member_1_countryoforigin VARCHAR(2),
member_2_countryoforigin VARCHAR(2),
member_3_countryoforigin VARCHAR(2),
member_4_countryoforigin VARCHAR(2),
internetusage VARCHAR(2),
potentialinvestorconsumer VARCHAR(2),
subfamilyindicator VARCHAR(1),
activeconsumer VARCHAR(1),
lor_mid VARCHAR(7),
find_mid VARCHAR(7),
member_1_vendorethnicity VARCHAR(2),
member_1_vendorethnicgroup VARCHAR(1),
member_1_vendorlanguage VARCHAR(2),
member_1_vendorreligion VARCHAR(1),
member_2_vendorethnicity VARCHAR(2),
member_2_vendorethnicgroup VARCHAR(1),
member_2_vendorlanguage VARCHAR(2),
member_2_vendorreligion VARCHAR(1),
member_3_vendorethnicity VARCHAR(2),
member_3_vendorethnicgroup VARCHAR(1),
member_3_vendorlanguage VARCHAR(2),
member_3_vendorreligion VARCHAR(1),
member_4_vendorethnicity VARCHAR(2),
member_4_vendorethnicgroup VARCHAR(1),
member_4_vendorlanguage VARCHAR(2),
member_4_vendorreligion VARCHAR(1),
congressionaldistrict VARCHAR(2),
msacode2000 VARCHAR(5),
micrometroindicators VARCHAR(1),
csacode VARCHAR(3),
effective_phone_date VARCHAR(6),
telephone_acquisition_date VARCHAR(6),
multi_source_indicator VARCHAR(1),
lhi_general_apparel VARCHAR(1),
lhi_apparel_accessories VARCHAR(1),
lhi_apparel_kids VARCHAR(1),
lhi_apparel_mens VARCHAR(1),
lhi_apparel_mens_fashions VARCHAR(1),
lhi_apparel_womens VARCHAR(1),
lhi_apparel_womens_fashions VARCHAR(1),
lhi_automotive VARCHAR(1),
lhi_auto_racing VARCHAR(1),
lhi_trucks VARCHAR(1),
lhi_aviation VARCHAR(1),
lhi_bargain_seekers VARCHAR(1),
lhi_beauty_cosmetic VARCHAR(1),
lhi_bible VARCHAR(1),
lhi_birds VARCHAR(1),
lhi_business_items VARCHAR(1),
lhi_home_office_products VARCHAR(1),
lhi_internet_buying VARCHAR(1),
lhi_catalogs VARCHAR(1),
lhi_collectibles VARCHAR(1),
lhi_stamps_coins VARCHAR(1),
lhi_college VARCHAR(1),
lhi_computers VARCHAR(1),
lhi_cooking VARCHAR(1),
lhi_gormet VARCHAR(1),
lhi_general_crafts VARCHAR(1),
lhi_crocheting VARCHAR(1),
lhi_knitting VARCHAR(1),
lhi_needlepoint VARCHAR(1),
lhi_quilting VARCHAR(1),
lhi_sewing VARCHAR(1),
lhi_culture_arts VARCHAR(1),
lhi_current_events VARCHAR(1),
lhi_do_it_yourselfer VARCHAR(1),
lhi_charitable_donor VARCHAR(1),
lhi_ego_personalized_products VARCHAR(1),
lhi_electionics VARCHAR(1),
lhi_horses VARCHAR(1),
lhi_african_american_ethnic_products VARCHAR(1),
lhi_asian_ethnic_products VARCHAR(1),
lhi_hispanic_ethnic_products VARCHAR(1),
lhi_children_family VARCHAR(1),
lhi_credit_card_user VARCHAR(1),
lhi_money_making VARCHAR(1),
lhi_personal_finance VARCHAR(1),
lhi_stocks_bonds VARCHAR(1),
lhi_foreign_travel VARCHAR(1),
lhi_gambling VARCHAR(1),
lhi_games VARCHAR(1),
lhi_gardening VARCHAR(1),
lhi_gift_giver VARCHAR(1),
lhi_general_health VARCHAR(1),
lhi_dieting VARCHAR(1),
lhi_fitness_exercise VARCHAR(1),
lhi_high_ticket VARCHAR(1),
lhi_history VARCHAR(1),
lhi_american_history VARCHAR(1),
lhi_hobbies VARCHAR(1),
lhi_home_decorating VARCHAR(1),
lhi_humor VARCHAR(1),
lhi_inspirational VARCHAR(1),
lhi_internet VARCHAR(1),
lhi_internet_access VARCHAR(1),
lhi_hightech VARCHAR(1),
lhi_motorcycles VARCHAR(1),
lhi_music VARCHAR(1),
lhi_ocean VARCHAR(1),
lhi_outdoors VARCHAR(1),
lhi_boating_sailing VARCHAR(1),
lhi_camping_hiking VARCHAR(1),
lhi_fishing VARCHAR(1),
lhi_hunting_fishing VARCHAR(1),
lhi_hunting VARCHAR(1),
lhi_pets VARCHAR(1),
lhi_cats VARCHAR(1),
lhi_dogs VARCHAR(1),
lhi_photography VARCHAR(1),
lhi_photo_processing VARCHAR(1),
lhi_politically_conservative VARCHAR(1),
lhi_liberal VARCHAR(1),
lhi_publications VARCHAR(1),
lhi_publish_books VARCHAR(1),
lhi_magazine_subscriber VARCHAR(1),
lhi_books_nonfiction VARCHAR(1),
lhi_books_science_fiction VARCHAR(1),
lhi_rural_farming VARCHAR(1),
lhi_science VARCHAR(1),
lhi_seniors VARCHAR(1),
lhi_general_sports VARCHAR(1),
lhi_baseball VARCHAR(1),
lhi_basketball VARCHAR(1),
lhi_football VARCHAR(1),
lhi_golf VARCHAR(1),
lhi_hockey VARCHAR(1),
lhi_skiing VARCHAR(1),
lhi_soccer VARCHAR(1),
lhi_tennis VARCHAR(1),
lhi_stationery VARCHAR(1),
lhi_sweepstakes VARCHAR(1),
lhi_tobacco VARCHAR(1),
lhi_general_travel VARCHAR(1),
lhi_travel_cruises VARCHAR(1),
lhi_travel_rv VARCHAR(1),
lhi_travel_us VARCHAR(1),
lhi_movies VARCHAR(1),
lhi_wildlife VARCHAR(1),
csi_raw_score VARCHAR(3),
ppi VARCHAR(6),
income_public_assistance VARCHAR(6),
household_with_retirement_income VARCHAR(6),
population_density VARCHAR(9),
high_school_graduate_only_age_25_plus VARCHAR(6),
self_employed VARCHAR(6),
seasonal_vacant_hu VARCHAR(6),
total_work_16_plus_use_public_trans VARCHAR(6),
work_private_vehicle VARCHAR(6),
mortgagefinancetype VARCHAR(1),
homesaledate VARCHAR(8),
homesaledatesourcecode VARCHAR(1),
emailpresenceflag VARCHAR(1),
vacation_expense_category VARCHAR(1),
second_property_ind VARCHAR(1),
second_property_total_value VARCHAR(5),
actualhomevalue VARCHAR(5),
tw_greenmodel VARCHAR(1),
tw_highvaluesecurityinvestor VARCHAR(1),
tw_highereducation VARCHAR(1),
tw_highvaluestockinvestor VARCHAR(1),
tw_heavyinvestmenttraders VARCHAR(1),
tw_physicalfitnessclubs VARCHAR(1),
tw_highriskinvestor VARCHAR(1),
tw_lowriskinvestor VARCHAR(1),
tw_frequentflyer VARCHAR(1),
tw_annuities VARCHAR(1),
tw_lifeinsurance VARCHAR(1),
tw_luxurycarbuyer VARCHAR(1),
tw_cruise VARCHAR(1),
tw_timeshareowner VARCHAR(1),
tw_impulsebuyer VARCHAR(1),
tw_luxuryhotel VARCHAR(1),
tw_pbsdonor VARCHAR(1),
tw_safetysecurityconscious VARCHAR(1),
tw_shopaholics VARCHAR(1),
tw_conservative VARCHAR(1),
tw_leaningconservative VARCHAR(1),
tw_religiousdonor VARCHAR(1),
tw_gardenmaintenance VARCHAR(1),
tw_heavyfamilyrestaurantvisitor VARCHAR(1),
tw_heavypayperviewsports VARCHAR(1),
nid VARCHAR(6),
nid_description VARCHAR(50),
tw_catproducts VARCHAR(1),
tw_creditcardrewards VARCHAR(1),
tw_highendsportingequipment VARCHAR(1),
tw_homeimprovement VARCHAR(1),
tw_highendelectronicsbuyer VARCHAR(1),
tw_avidgamer VARCHAR(1),
tw_rentalcar VARCHAR(1),
tw_avidcellphoneuser VARCHAR(1),
tw_countryclubmember VARCHAR(1),
tw_professionaltaxpreparation VARCHAR(1),
tw_onsitetaxpreparationservice VARCHAR(1),
tw_classicalmusicconcerts VARCHAR(1),
tw_rockmusicconcerts VARCHAR(1),
tw_countrymusicconcerts VARCHAR(1),
tw_livetheater VARCHAR(1),
tw_heavybookbuyer VARCHAR(1),
tw_freshwaterfishing VARCHAR(1),
tw_saltwaterfishing VARCHAR(1),
tw_hunting VARCHAR(1),
tw_allterrainvehicle VARCHAR(1),
tw_powerboating VARCHAR(1),
tw_outdooractivities VARCHAR(1),
tw_adventureseekers VARCHAR(1),
tw_lowendsportingequipment VARCHAR(1),
tw_professionalbaseballsportsfans VARCHAR(1),
tw_professionalbasketballsportsfans VARCHAR(1),
tw_professionalfootballsportsfans VARCHAR(1),
tw_soccersportsfans VARCHAR(1),
tw_collegebasketballsportsfans VARCHAR(1),
tw_collegefootballsportsfans VARCHAR(1),
tw_golfsportsfans VARCHAR(1),
tw_tennissportsfans VARCHAR(1),
tw_professionalwrestlingsportsfans VARCHAR(1),
tw_internationallongdistance VARCHAR(1),
tw_heavyfrozendinner VARCHAR(1),
tw_cookfromscratch VARCHAR(1),
tw_cookforfun VARCHAR(1),
tw_winelover VARCHAR(1),
censushomevalue VARCHAR(1),
veteranflag VARCHAR(1),
boat_hull_type VARCHAR(1),
boat_length VARCHAR(2),
boat_propulsion_code VARCHAR(1),
boxnumber VARCHAR(6),
boxtype VARCHAR(1),
pensionflag VARCHAR(1),
household_status_code VARCHAR(1),
tw_online_purchase_personal_model VARCHAR(1),
tw_online_purchase_business_model VARCHAR(1),
tw_online_travel_plan_model VARCHAR(1),
tw_blog_writing_model VARCHAR(1),
tw_voice_over_internet_model VARCHAR(1),
tw_wifi_outside_of_home_model VARCHAR(1),
tw_wifi_in_home_model VARCHAR(1),
tw_wholesale_club_model VARCHAR(1),
tw_auto_club_model VARCHAR(1),
tw_diy_auto_maintenance_model VARCHAR(1),
tw_online_gaming_activity_model VARCHAR(1),
tw_online_investment_trading_model VARCHAR(1),
tw_online_bill_payment_model VARCHAR(1),
tw_online_tv_download_model VARCHAR(1),
tw_mobile_internet_access_model VARCHAR(1),
tw_social_media_network_model VARCHAR(1),
tw_specialty_organic_food_store_model VARCHAR(1),
member_1_vendorassimilationcode VARCHAR(1),
member_2_vendorassimilationcode VARCHAR(1),
member_3_vendorassimilationcode VARCHAR(1),
member_4_vendorassimilationcode VARCHAR(1),
tw_home_office_model VARCHAR(1),
tw_business_banking_model VARCHAR(1),
tw_moderate_economy_hotel_model VARCHAR(1),
tw_ereader_model VARCHAR(1),
tw_cell_phone_only_model VARCHAR(1),
tw_alternative_medicine_model VARCHAR(1),
tw_non_religious_donor_model VARCHAR(1),
tw_major_home_remodeling_model VARCHAR(1),
tw_avid_smart_phone_users VARCHAR(1),
tw_health_insurance VARCHAR(1),
tw_satellite_tv VARCHAR(1),
tw_on_line_music_download VARCHAR(1),
tw_adult_education VARCHAR(1),
tw_pilates_yoga VARCHAR(1),
tw_fast_food VARCHAR(1),
tw_hybrid_cars VARCHAR(1),
postalstate VARCHAR(2)