database_assignment

Tables (9)

BOOKMARK

  • bookmark_id — BIGINT
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • recipe_id — BIGINT — Foreign key → RECIPE.recipe_id — NOT NULL
  • created_at — DATETIME — NOT NULL

COMMENT

  • comment_id — BIGINT
  • post_id — BIGINT — Foreign key → COOK_POST.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL

COOK_POST

  • post_id — BIGINT
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • recipe_id — BIGINT — Foreign key → RECIPE.recipe_id
  • img_url — VARCHAR(500)
  • content — TEXT
  • like_count — INT
  • created_at — DATETIME — NOT NULL

FOLLOW

  • follow_id — BIGINT
  • follower_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • following_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

INGREDIENT

  • ingredient_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • unit — VARCHAR(20)

RECIPE

  • recipe_id — BIGINT
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • category — VARCHAR(50)
  • difficulty — VARCHAR(20)
  • cook_time — INT
  • description — TEXT
  • created_at — DATETIME — NOT NULL

RECIPE_INGREDIENT

  • ri_id — BIGINT
  • recipe_id — BIGINT — Foreign key → RECIPE.recipe_id — NOT NULL
  • ingredient_id — BIGINT — Foreign key → INGREDIENT.ingredient_id — NOT NULL
  • amount — VARCHAR(50)

REVIEW

  • review_id — BIGINT
  • recipe_id — BIGINT — Foreign key → RECIPE.recipe_id — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • rating — TINYINT
  • content — TEXT
  • created_at — DATETIME — NOT NULL

USER

  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • profile_img — VARCHAR(500)
  • bio — TEXT
  • created_at — DATETIME — NOT NULL