Home

User

Column	Data Type	Details
id	integer	not null, primary key, indexed
username	string	not null, unique, indexed
email	string	not null, unique, indexed
password_digest	string	not null
session_token	string	not null, unique, indexed
created_at	datetime	not null
updated_at	datetime	not null
credit card hash	string	unique

Listings

Column	Data Type	Details
id	integer	not null, primary key, indexed
description	string	not null
features	string	not null
guidelines	string
created_at	datetime	not null
updated_at	datetime	not null
user_id	integer	not null, indexed, foreign key

| | trips_counter | integer | not null | | price | integer | not null | | car | string | not null, indexed |

Reviews

Column	Data Type	Details
id	integer	not null, primary key, indexed
rating	float	not null
body	string	not null
author_id	integer	not null, foreign key
listing_id	integer	optional, only listing/user_id
created_at	datetime	not null
updated_at	datetime	not null