recipe

Tables (3)

recipe_reply (Untitled2)

  • id (reply_id) — auto_increment — Primary key — NOT NULL
  • id (recipe_id) — auto_increment — Foreign key → recipe_table.id — NOT NULL
  • author (reply_author) — varchar(30)
  • content (reply_content) — varchar(300)
  • date (reply_created_date) — timestamp

recipe_table (Untitled)

  • id (recipe_id) — auto_increment — Primary key — NOT NULL
  • title (recipe_title) — varchar(125)
  • author (recipe_author) — varchar(30)
  • content (recipe_content) — varchar(300)
  • date (recipe_created_date) — timestamp
  • date (recipe_last_update_date) — timestamp

user_table (Untitled3)

  • id (user_id) — auto_increment — Primary key — NOT NULL
  • nickname (user_nickname) — varchar(125)
  • password (user_password) — varchar(300)