fever
Tables (9)
Untitled (ingredient)
- Key (id) — LONG — Primary key — NOT NULL
- Key (ingredient_category_id) — LONG — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR
Untitled (recipe)
- Key (id) — LONG — Primary key — NOT NULL
- Field (title) — VARCHAR
- Field (content) — TEXT
- Field (image_url) — VARCHAR
- id (member_id) — LONG — Foreign key → member.id — NOT NULL
- Field (created_at) — DATETIME
- Field (updated_at) — DATETIME
Untitled (member_ingredient)
- Key (id) — LONG — Primary key — NOT NULL
- id (member_id) — LONG — Foreign key → member.id — NOT NULL
- Key (ingredient_id) — LONG — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — DATETIME
- Field (updated_at) — DATETIME
Untitled (recipe_ingredient)
- Key (id) — LONG — Primary key — NOT NULL
- Key (recipe_id) — LONG — Foreign key → Untitled.Key — NOT NULL
- Key (ingredient_id) — LONG — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — DATETIME
- Field (updated_at) — DATETIME
Untitled (ingredient_category)
- Key (id) — LONG — Primary key — NOT NULL
- Field (name) — VARCHAR
Untitled (hashtag)
- Key (id) — LONG — Primary key — NOT NULL
- Field (tag) — VARCHAR
Untitled (recipe_hashtag)
- Key (id) — LONG — Primary key — NOT NULL
- Key (recipe_id) — LONG — Foreign key → Untitled.Key — NOT NULL
- Key (hashtag_id) — LONG — Foreign key → Untitled.Key — NOT NULL
Untitled (member_hashtag)
- Key (id) — LONG — Primary key — NOT NULL
- id (member_id) — LONG — Foreign key → member.id — NOT NULL
- Key (hashtag_id) — LONG — Foreign key → Untitled.Key — NOT NULL
member
- id — LONG — Primary key — NOT NULL
- Field (email) — VARCHAR
- Field (nickname) — VARCHAR
- Field (created_at) — DATETIME
- Field (updated_at) — VARCHAR