create properties ( listing     longinteger not null,
           age          integer,
           trans        float,
           date_listed  date( 5 ),
	   time_listed  time( 5 ),
           area_id      decimal( 6, 3 ),
           price        dollar( 6, 2 ),
	   description  char( 12, 1 ),
           address      text( 10, 10, 20 ),
           prop_id      bulk( 10, 10, 10 )
      );

create "prop owner"
       ( 
           "area_id"      decimal( 6, 3),
           trans        float,
           date_listed  date( 2 ),
	   time_listed  time( 2 ),
	   prop_id      bulk( 10, 10, 10 )
      );

create table "index"
       ( 
           "create table"    bulk( 10, 10, 10 ),
           "date listed"     date( 0 ),
	   "select"          char( 1,2) not null 
      );
