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