-
Notifications
You must be signed in to change notification settings - Fork 0
Schema
Benny Zhao edited this page Oct 22, 2017
·
3 revisions
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
username |
string | not null, indexed |
email |
string | not null, indexed, unique |
img_url |
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 |
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
body |
text | not null |
rating |
integer | not null, indexed, unique |
biz_id |
integer | not null, foreign key |
user_id |
integer | not null, foreign key |
user_img |
string | |
created_at |
datetime | not null |
updated_at |
datetime | not null |
| column name | data type | details |
|---|---|---|
id |
integer | not null, primary key |
biz_name |
string | not null, indexed |
address |
string | not null, indexed, unique |
img_url |
string | not null |
city |
string | not null |
neighborhood |
string | not null, indexed, unique |
created_at |
datetime | not null |
updated_at |
datetime | not null |