{ TABLE stf1_house1 row size = 1852 number of columns = 198 index size = 37 
              }
create table stf1_house1 
  (
    fileid char(8),
    logrecnu integer,
    tractbna char(6),
    blckgr char(1),
    h0010001 char(9),
    h0020001 char(9),
    h0020002 char(9),
    h0030001 char(9),
    h0030002 char(9),
    h0040001 char(9),
    h0040002 char(9),
    h0040003 char(9),
    h0040004 char(9),
    h0050001 char(9),
    h0050002 char(9),
    h0050003 char(9),
    h0050004 char(9),
    h0050005 char(9),
    h0050006 char(9),
    h0060001 char(9),
    h0060002 char(9),
    h0070001 char(9),
    h0070002 char(9),
    h0080001 char(9),
    h0080002 char(9),
    h0080003 char(9),
    h0080004 char(9),
    h0080005 char(9),
    h0090001 char(9),
    h0090002 char(9),
    h0090003 char(9),
    h0090004 char(9),
    h0090005 char(9),
    h0090006 char(9),
    h0090007 char(9),
    h0090008 char(9),
    h0090009 char(9),
    h0090010 char(9),
    h0100001 char(9),
    h0100002 char(9),
    h0100003 char(9),
    h0100004 char(9),
    h0100005 char(9),
    h0100006 char(9),
    h0100007 char(9),
    h0100008 char(9),
    h0100009 char(9),
    h0100010 char(9),
    h0110001 char(9),
    h0110002 char(9),
    h0110003 char(9),
    h0110004 char(9),
    h0110005 char(9),
    h0110006 char(9),
    h0110007 char(9),
    h0110008 char(9),
    h0110009 char(9),
    h0110010 char(9),
    h0120001 char(9),
    h0120002 char(9),
    h0120003 char(9),
    h0120004 char(9),
    h0120005 char(9),
    h0120006 char(9),
    h0120007 char(9),
    h0120008 char(9),
    h0120009 char(9),
    h0120010 char(9),
    h0120011 char(9),
    h0120012 char(9),
    h0120013 char(9),
    h0120014 char(9),
    h0130001 char(9),
    h0130002 char(9),
    h0130003 char(9),
    h0130004 char(9),
    h0130005 char(9),
    h0130006 char(9),
    h0130007 char(9),
    h0130008 char(9),
    h0130009 char(9),
    h0140001 char(9),
    h0150001 char(9),
    h0150002 char(9),
    h0160001 char(9),
    h0160002 char(9),
    h0160003 char(9),
    h0160004 char(9),
    h0160005 char(9),
    h0160006 char(9),
    h0170001 char(9),
    h0170002 char(9),
    h0170003 char(9),
    h0170004 char(9),
    h0170005 char(9),
    h0170006 char(9),
    h0170007 char(9),
    h17a0001 char(9),
    h0180001 char(9),
    h0180002 char(9),
    h0180003 char(9),
    h0180004 char(9),
    h0180005 char(9),
    h0180006 char(9),
    h0180007 char(9),
    h0180008 char(9),
    h0180009 char(9),
    h0180010 char(9),
    h0180011 char(9),
    h0180012 char(9),
    h0180013 char(9),
    h0180014 char(9),
    h18a0001 char(9),
    h18a0002 char(9),
    h0190001 char(9),
    h0200001 char(9),
    h0200002 char(9),
    h0210001 char(9),
    h0210002 char(9),
    h0210003 char(9),
    h0210004 char(9),
    h0210005 char(9),
    h0220001 char(9),
    h0220002 char(9),
    h0220003 char(9),
    h0220004 char(9),
    h0220005 char(9),
    h0220006 char(9),
    h0220007 char(9),
    h0220008 char(9),
    h0220009 char(9),
    h0220010 char(9),
    h0230001 char(9),
    h0230002 char(9),
    h0230003 char(9),
    h0230004 char(9),
    h0230005 char(9),
    h0230006 char(9),
    h0230007 char(9),
    h0230008 char(9),
    h0230009 char(9),
    h0230010 char(9),
    h0230011 char(9),
    h0230012 char(9),
    h0230013 char(9),
    h0230014 char(9),
    h0230015 char(9),
    h0230016 char(9),
    h0230017 char(9),
    h0230018 char(9),
    h0230019 char(9),
    h0230020 char(9),
    h23a0001 char(9),
    h23b0001 char(9),
    h23c0001 char(9),
    h0240001 char(15),
    h0250001 char(9),
    h0250002 char(9),
    h0250003 char(9),
    h0250004 char(9),
    h0250005 char(9),
    h0260001 char(15),
    h0260002 char(15),
    h0260003 char(15),
    h0260004 char(15),
    h0260005 char(15),
    h0270001 char(9),
    h0270002 char(9),
    h0280001 char(15),
    h0280002 char(15),
    h0290001 char(15),
    h0290002 char(15),
    h0290003 char(15),
    h0290004 char(15),
    h0290005 char(15),
    h0290006 char(15),
    h0300001 char(9),
    h0300002 char(9),
    h0300003 char(9),
    h0310001 char(15),
    h0320001 char(9),
    h0320002 char(9),
    h0320003 char(9),
    h0320004 char(9),
    h0320005 char(9),
    h0320006 char(9),
    h0320007 char(9),
    h0320008 char(9),
    h0320009 char(9),
    h0320010 char(9),
    h0320011 char(9),
    h0320012 char(9),
    h0320013 char(9),
    h0320014 char(9),
    h0320015 char(9),
    h0320016 char(9),
    h0320017 char(9),
    tract_blck char(6)
  );
revoke all on stf1_house1 from "public";

create index ix162_3 on stf1_house1 (tractbna);
create index ix162_4 on stf1_house1 (blckgr);
create unique index ix162_198 on stf1_house1 (tract_blck);



