| column name | data types | details |
|---|
| id | integer | not null, primary key |
| username | string | not null, indexed, unique |
| password_digest | string | not null |
| session_token | string | not null, indexed, unique |
| fname | string | |
| lname | string | |
| profile_url | string | default: (some picture) |
| interests | text | |
| column name | data types | details |
|---|
| id | integer | not null, primary key |
| user_id | integer | not null, indexed, foreign key (references users) |
| title | string | not null |
| image_url | string | default: (some picture) |
| average_rating | integer | |
| category | string | not null |
| description | text | not null |
| ingredients | array | not null |
| directions | array | not null |
| column name | data types | details |
|---|
| id | integer | not null, primary key |
| user_id | integer | not null, indexed, foreign key (references users) |
| recipe_id | integer | not null, indexed, foreign key (references recipes) |
| rating | integer | not null |
| review | text | |
| column name | data types | details |
|---|
| id | integer | not null, primary key |
| user_id | integer | not null, indexed, foreign key (references users), unique [recipe_id] |
| recipe_id | integer | not null, indexed, foreign key (references recipes) |