Database Schema

users

column name	datatype	details
id	integer	not null, primary key
name	string	not null, indexed
email	string	not null, indexed, unique
phone	string	not null
password_digest	string	not null
session_token	string	not null, indexed, unique
created_at	datetime	not null
updated_at	datetime	not null

• indexed on name, email, and session_token
• foreign key: has_many listings
• foreign key: has_many saved_listings
• foreign key: has_many appointments
• foreign key: has_many notes

listings

column name	datatype	details
id	integer	not null, primary key
name	string	not null, indexed, unique
location	string	not null, indexed, unique
neighborhood	string	not null, indexed
zip	integer	not null, indexed
rent?	boolean	default false
own?	boolean	default false
type	string	indexed
realtor_id	integer	not null, indexed
price	integer	not null
beds	integer	indexed
bath	integer	indexed
created_at	datetime	not null
updated_at	datetime	not null

• indexed on location, neighborhood, zip, type, beds, bath
• realtor_id references user
• has_many appointments
• belongs_to realtor

saved_listings

column name	datatype	details
id	integer	not null, primary key
listing_id	string	not null, indexed
user_id	string	not null, indexed
created_at	datetime	not null
updated_at	datetime	not null

• indexed on listing id and user_id
• foreign key: belongs_to listing
• foreign key: belongs_to user

appointments

column name	datatype	details
id	integer	not null, primary key
listing_id	string	not null, indexed
realtor_id	string	not null, indexed
created_at	datetime	not null
updated_at	datetime	not null

• indexed on listing id and user_id
• realtor_id references user
• foreign key: belongs_to listing
• foreign key: belongs_to user