-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Nov 15, 2013 at 10:55 AM
-- Server version: 5.5.25
-- PHP Version: 5.3.13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `cityraven`
--

-- --------------------------------------------------------

--
-- Table structure for table `rentals`
--

CREATE TABLE IF NOT EXISTS `rentals` (
  `rental_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `broker_id` int(11) DEFAULT NULL,
  `neighborhood_id` int(11) DEFAULT NULL,
  `building_id` int(11) DEFAULT NULL,
  `listing_type` enum('nofee','exclusive') NOT NULL,
  `address` varchar(255) NOT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(2) NOT NULL,
  `zipcode` varchar(12) NOT NULL,
  `intersection` varchar(255) DEFAULT NULL,
  `display_address` tinyint(1) NOT NULL,
  `property_type` enum('SingleFamily','Condo','Townhouse','Coop','MultiFamily','Manufactured','VacantLand','Other','Apartment') NOT NULL,
  `total_floors` tinyint(4) DEFAULT NULL,
  `floor` tinyint(4) DEFAULT NULL,
  `total_rooms` double DEFAULT NULL,
  `beds` tinyint(4) NOT NULL,
  `baths` tinyint(4) NOT NULL,
  `year_built` varchar(12) DEFAULT NULL,
  `price` double NOT NULL,
  `tax` double DEFAULT NULL,
  `available_from` datetime DEFAULT NULL,
  `mls_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `utilities` varchar(255) DEFAULT NULL,
  `pets` varchar(255) DEFAULT NULL,
  `features` text,
  `appliances` text,
  `floor_cover` text,
  `rooms` text,
  `views` text,
  `is_laundry` tinyint(1) NOT NULL,
  `is_furnished` tinyint(1) NOT NULL,
  `is_doorman` tinyint(1) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `listed_at` date NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`rental_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- Table structure for table `rentals_pictures`
--

CREATE TABLE IF NOT EXISTS `rentals_pictures` (
  `picture_id` int(11) NOT NULL AUTO_INCREMENT,
  `rental_id` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`picture_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ;