-
Notifications
You must be signed in to change notification settings - Fork 0
Recipe Schema
Fran Varney edited this page Jan 31, 2016
·
5 revisions
| Field Name | Type | Primary Key | Unique | Index | Required | Default | Min/Max | References |
|---|---|---|---|---|---|---|---|---|
| id | integer | ✔️ | - | ✔️ | ✔️ | - | - | - |
| user_id | integer | - | - | ✔️ | ✔️ | - | - | Users |
| title | string | - | - | ✔️ | ✔️ | - | 5/255 | - |
| prep_time | integer | - | - | - | ✔️ | - | - | - |
| cook_time | integer | - | - | - | ✔️ | - | - | - |
| yields_amount | decimal | - | - | - | ✔️ | - | - | - |
| yields_unit_id | integer | - | - | ✔️ | ✔️ | - | - | Units |
| source_type | enum [manual, fork, url] | - | - | - | ✔️ | - | ||
| source_value | string/integer | - | - | - | ✔️ | |||
| description | string | - | - | - | - | - | 0/500 | - |
| is_private | boolean | - | - | - | - | false | - | - |
| created_at | timestamp | - | - | - | ✔️ | date.now | - | - |
| updated_at | timestamp | - | - | - | ✔️ | - | - | |
| deleted_at | timestamp | - | - | - | - | null | - | - |