create table homes ( id int primary key AUTO_INCREMENT, type_e tinytext, type_f tinytext, short_description_e tinytext, short_description_f tinytext, description_e text, description_f text, location_e tinytext, location_f tinytext, address_e tinytext, address_f tinytext, postal_code tinytext ) create table market ( id int primary key AUTO_INCREMENT, home_id int not null, date_posted date, date_available date, rented tinyint not null, sold tinyint not null, price float(255, 2) unsigned, rent_furnished float(255, 2) unsigned, rent_unfurnished float(255, 2) unsigned, condo_fees float(255, 2) unsigned, municipal_taxes float(255, 2) unsigned, school_taxes float(255, 2) unsigned ) create table images ( id int primary key AUTO_INCREMENT, home_id int not null, description_e tinytext, description_f tinytext )